xonecas.io
556
Bn

bees-nest / files

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

9.5 KB
1{
2  "id": "435008fe-3ac1-4eab-87c6-1f9d4c5466d1",
3  "prevId": "3c5d1393-19ae-467d-959d-4a735c12491a",
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        "search_idx": {
207          "name": "search_idx",
208          "columns": [
209            {
210              "expression": "to_tsvector('english', coalesce(\"title\", '') || ' ' || coalesce(\"description\", '') || ' ' || coalesce(\"content\", ''))",
211              "asc": true,
212              "isExpression": true,
213              "nulls": "last"
214            }
215          ],
216          "isUnique": false,
217          "concurrently": false,
218          "method": "gin",
219          "with": {}
220        }
221      },
222      "foreignKeys": {
223        "pages_url_id_urls_id_fk": {
224          "name": "pages_url_id_urls_id_fk",
225          "tableFrom": "pages",
226          "tableTo": "urls",
227          "columnsFrom": ["url_id"],
228          "columnsTo": ["id"],
229          "onDelete": "no action",
230          "onUpdate": "no action"
231        }
232      },
233      "compositePrimaryKeys": {},
234      "uniqueConstraints": {},
235      "policies": {},
236      "checkConstraints": {},
237      "isRLSEnabled": false
238    },
239    "public.urls": {
240      "name": "urls",
241      "schema": "",
242      "columns": {
243        "id": {
244          "name": "id",
245          "type": "serial",
246          "primaryKey": true,
247          "notNull": true
248        },
249        "url": {
250          "name": "url",
251          "type": "text",
252          "primaryKey": false,
253          "notNull": true
254        },
255        "domain_id": {
256          "name": "domain_id",
257          "type": "integer",
258          "primaryKey": false,
259          "notNull": false
260        },
261        "status": {
262          "name": "status",
263          "type": "url_status",
264          "typeSchema": "public",
265          "primaryKey": false,
266          "notNull": true,
267          "default": "'pending'"
268        },
269        "priority": {
270          "name": "priority",
271          "type": "integer",
272          "primaryKey": false,
273          "notNull": true,
274          "default": 10
275        },
276        "depth": {
277          "name": "depth",
278          "type": "integer",
279          "primaryKey": false,
280          "notNull": true,
281          "default": 0
282        },
283        "error_message": {
284          "name": "error_message",
285          "type": "text",
286          "primaryKey": false,
287          "notNull": false
288        },
289        "next_retry_at": {
290          "name": "next_retry_at",
291          "type": "timestamp",
292          "primaryKey": false,
293          "notNull": false
294        },
295        "created_at": {
296          "name": "created_at",
297          "type": "timestamp",
298          "primaryKey": false,
299          "notNull": false,
300          "default": "now()"
301        },
302        "updated_at": {
303          "name": "updated_at",
304          "type": "timestamp",
305          "primaryKey": false,
306          "notNull": false,
307          "default": "now()"
308        }
309      },
310      "indexes": {
311        "status_idx": {
312          "name": "status_idx",
313          "columns": [
314            {
315              "expression": "status",
316              "isExpression": false,
317              "asc": true,
318              "nulls": "last"
319            }
320          ],
321          "isUnique": false,
322          "concurrently": false,
323          "method": "btree",
324          "with": {}
325        },
326        "priority_idx": {
327          "name": "priority_idx",
328          "columns": [
329            {
330              "expression": "priority",
331              "isExpression": false,
332              "asc": true,
333              "nulls": "last"
334            }
335          ],
336          "isUnique": false,
337          "concurrently": false,
338          "method": "btree",
339          "with": {}
340        }
341      },
342      "foreignKeys": {
343        "urls_domain_id_domains_id_fk": {
344          "name": "urls_domain_id_domains_id_fk",
345          "tableFrom": "urls",
346          "tableTo": "domains",
347          "columnsFrom": ["domain_id"],
348          "columnsTo": ["id"],
349          "onDelete": "no action",
350          "onUpdate": "no action"
351        }
352      },
353      "compositePrimaryKeys": {},
354      "uniqueConstraints": {
355        "urls_url_unique": {
356          "name": "urls_url_unique",
357          "nullsNotDistinct": false,
358          "columns": ["url"]
359        }
360      },
361      "policies": {},
362      "checkConstraints": {},
363      "isRLSEnabled": false
364    }
365  },
366  "enums": {
367    "public.url_status": {
368      "name": "url_status",
369      "schema": "public",
370      "values": ["pending", "processing", "completed", "failed"]
371    }
372  },
373  "schemas": {},
374  "sequences": {},
375  "roles": {},
376  "policies": {},
377  "views": {},
378  "_meta": {
379    "columns": {},
380    "schemas": {},
381    "tables": {}
382  }
383}