xonecas.io
556
Bn

bees-nest / files

bees-nest / drizzle / meta / 0000_snapshot.json

9.0 KB
1{
2  "id": "3c5d1393-19ae-467d-959d-4a735c12491a",
3  "prevId": "00000000-0000-0000-0000-000000000000",
4  "version": "7",
5  "dialect": "postgresql",
6  "tables": {
7    "public.domains": {
8      "name": "domains",
9      "schema": "",
10      "columns": {
11        "id": {
12          "name": "id",
13          "type": "serial",
14          "primaryKey": true,
15          "notNull": true
16        },
17        "domain": {
18          "name": "domain",
19          "type": "text",
20          "primaryKey": false,
21          "notNull": true
22        },
23        "robots_txt": {
24          "name": "robots_txt",
25          "type": "text",
26          "primaryKey": false,
27          "notNull": false
28        },
29        "last_crawled_at": {
30          "name": "last_crawled_at",
31          "type": "timestamp",
32          "primaryKey": false,
33          "notNull": false
34        },
35        "created_at": {
36          "name": "created_at",
37          "type": "timestamp",
38          "primaryKey": false,
39          "notNull": false,
40          "default": "now()"
41        }
42      },
43      "indexes": {},
44      "foreignKeys": {},
45      "compositePrimaryKeys": {},
46      "uniqueConstraints": {
47        "domains_domain_unique": {
48          "name": "domains_domain_unique",
49          "nullsNotDistinct": false,
50          "columns": ["domain"]
51        }
52      },
53      "policies": {},
54      "checkConstraints": {},
55      "isRLSEnabled": false
56    },
57    "public.links": {
58      "name": "links",
59      "schema": "",
60      "columns": {
61        "id": {
62          "name": "id",
63          "type": "serial",
64          "primaryKey": true,
65          "notNull": true
66        },
67        "source_url_id": {
68          "name": "source_url_id",
69          "type": "integer",
70          "primaryKey": false,
71          "notNull": true
72        },
73        "target_url_id": {
74          "name": "target_url_id",
75          "type": "integer",
76          "primaryKey": false,
77          "notNull": true
78        },
79        "created_at": {
80          "name": "created_at",
81          "type": "timestamp",
82          "primaryKey": false,
83          "notNull": false,
84          "default": "now()"
85        }
86      },
87      "indexes": {
88        "source_target_idx": {
89          "name": "source_target_idx",
90          "columns": [
91            {
92              "expression": "source_url_id",
93              "isExpression": false,
94              "asc": true,
95              "nulls": "last"
96            },
97            {
98              "expression": "target_url_id",
99              "isExpression": false,
100              "asc": true,
101              "nulls": "last"
102            }
103          ],
104          "isUnique": true,
105          "concurrently": false,
106          "method": "btree",
107          "with": {}
108        }
109      },
110      "foreignKeys": {
111        "links_source_url_id_urls_id_fk": {
112          "name": "links_source_url_id_urls_id_fk",
113          "tableFrom": "links",
114          "tableTo": "urls",
115          "columnsFrom": ["source_url_id"],
116          "columnsTo": ["id"],
117          "onDelete": "no action",
118          "onUpdate": "no action"
119        },
120        "links_target_url_id_urls_id_fk": {
121          "name": "links_target_url_id_urls_id_fk",
122          "tableFrom": "links",
123          "tableTo": "urls",
124          "columnsFrom": ["target_url_id"],
125          "columnsTo": ["id"],
126          "onDelete": "no action",
127          "onUpdate": "no action"
128        }
129      },
130      "compositePrimaryKeys": {},
131      "uniqueConstraints": {},
132      "policies": {},
133      "checkConstraints": {},
134      "isRLSEnabled": false
135    },
136    "public.pages": {
137      "name": "pages",
138      "schema": "",
139      "columns": {
140        "id": {
141          "name": "id",
142          "type": "serial",
143          "primaryKey": true,
144          "notNull": true
145        },
146        "url_id": {
147          "name": "url_id",
148          "type": "integer",
149          "primaryKey": false,
150          "notNull": true
151        },
152        "title": {
153          "name": "title",
154          "type": "text",
155          "primaryKey": false,
156          "notNull": false
157        },
158        "description": {
159          "name": "description",
160          "type": "text",
161          "primaryKey": false,
162          "notNull": false
163        },
164        "site_name": {
165          "name": "site_name",
166          "type": "text",
167          "primaryKey": false,
168          "notNull": false
169        },
170        "image": {
171          "name": "image",
172          "type": "text",
173          "primaryKey": false,
174          "notNull": false
175        },
176        "content": {
177          "name": "content",
178          "type": "text",
179          "primaryKey": false,
180          "notNull": false
181        },
182        "created_at": {
183          "name": "created_at",
184          "type": "timestamp",
185          "primaryKey": false,
186          "notNull": false,
187          "default": "now()"
188        }
189      },
190      "indexes": {
191        "url_id_idx": {
192          "name": "url_id_idx",
193          "columns": [
194            {
195              "expression": "url_id",
196              "isExpression": false,
197              "asc": true,
198              "nulls": "last"
199            }
200          ],
201          "isUnique": false,
202          "concurrently": false,
203          "method": "btree",
204          "with": {}
205        }
206      },
207      "foreignKeys": {
208        "pages_url_id_urls_id_fk": {
209          "name": "pages_url_id_urls_id_fk",
210          "tableFrom": "pages",
211          "tableTo": "urls",
212          "columnsFrom": ["url_id"],
213          "columnsTo": ["id"],
214          "onDelete": "no action",
215          "onUpdate": "no action"
216        }
217      },
218      "compositePrimaryKeys": {},
219      "uniqueConstraints": {},
220      "policies": {},
221      "checkConstraints": {},
222      "isRLSEnabled": false
223    },
224    "public.urls": {
225      "name": "urls",
226      "schema": "",
227      "columns": {
228        "id": {
229          "name": "id",
230          "type": "serial",
231          "primaryKey": true,
232          "notNull": true
233        },
234        "url": {
235          "name": "url",
236          "type": "text",
237          "primaryKey": false,
238          "notNull": true
239        },
240        "domain_id": {
241          "name": "domain_id",
242          "type": "integer",
243          "primaryKey": false,
244          "notNull": false
245        },
246        "status": {
247          "name": "status",
248          "type": "url_status",
249          "typeSchema": "public",
250          "primaryKey": false,
251          "notNull": true,
252          "default": "'pending'"
253        },
254        "priority": {
255          "name": "priority",
256          "type": "integer",
257          "primaryKey": false,
258          "notNull": true,
259          "default": 10
260        },
261        "depth": {
262          "name": "depth",
263          "type": "integer",
264          "primaryKey": false,
265          "notNull": true,
266          "default": 0
267        },
268        "error_message": {
269          "name": "error_message",
270          "type": "text",
271          "primaryKey": false,
272          "notNull": false
273        },
274        "next_retry_at": {
275          "name": "next_retry_at",
276          "type": "timestamp",
277          "primaryKey": false,
278          "notNull": false
279        },
280        "created_at": {
281          "name": "created_at",
282          "type": "timestamp",
283          "primaryKey": false,
284          "notNull": false,
285          "default": "now()"
286        },
287        "updated_at": {
288          "name": "updated_at",
289          "type": "timestamp",
290          "primaryKey": false,
291          "notNull": false,
292          "default": "now()"
293        }
294      },
295      "indexes": {
296        "status_idx": {
297          "name": "status_idx",
298          "columns": [
299            {
300              "expression": "status",
301              "isExpression": false,
302              "asc": true,
303              "nulls": "last"
304            }
305          ],
306          "isUnique": false,
307          "concurrently": false,
308          "method": "btree",
309          "with": {}
310        },
311        "priority_idx": {
312          "name": "priority_idx",
313          "columns": [
314            {
315              "expression": "priority",
316              "isExpression": false,
317              "asc": true,
318              "nulls": "last"
319            }
320          ],
321          "isUnique": false,
322          "concurrently": false,
323          "method": "btree",
324          "with": {}
325        }
326      },
327      "foreignKeys": {
328        "urls_domain_id_domains_id_fk": {
329          "name": "urls_domain_id_domains_id_fk",
330          "tableFrom": "urls",
331          "tableTo": "domains",
332          "columnsFrom": ["domain_id"],
333          "columnsTo": ["id"],
334          "onDelete": "no action",
335          "onUpdate": "no action"
336        }
337      },
338      "compositePrimaryKeys": {},
339      "uniqueConstraints": {
340        "urls_url_unique": {
341          "name": "urls_url_unique",
342          "nullsNotDistinct": false,
343          "columns": ["url"]
344        }
345      },
346      "policies": {},
347      "checkConstraints": {},
348      "isRLSEnabled": false
349    }
350  },
351  "enums": {
352    "public.url_status": {
353      "name": "url_status",
354      "schema": "public",
355      "values": ["pending", "processing", "completed", "failed"]
356    }
357  },
358  "schemas": {},
359  "sequences": {},
360  "roles": {},
361  "policies": {},
362  "views": {},
363  "_meta": {
364    "columns": {},
365    "schemas": {},
366    "tables": {}
367  }
368}