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}