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}