{
	"version": "6",
	"dialect": "sqlite",
	"id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
	"prevId": "78e5f5c8-f8f0-43f4-93f8-5ef68154ed17",
	"tables": {
		"categories": {
			"name": "categories",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"icon": {
					"name": "icon",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "'package'"
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {
				"categories_name_unique": {
					"name": "categories_name_unique",
					"columns": ["name"],
					"isUnique": true
				}
			},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"items": {
			"name": "items",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"weight_grams": {
					"name": "weight_grams",
					"type": "real",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"price_cents": {
					"name": "price_cents",
					"type": "integer",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"category_id": {
					"name": "category_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"notes": {
					"name": "notes",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"product_url": {
					"name": "product_url",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"image_filename": {
					"name": "image_filename",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {},
			"foreignKeys": {
				"items_category_id_categories_id_fk": {
					"name": "items_category_id_categories_id_fk",
					"tableFrom": "items",
					"tableTo": "categories",
					"columnsFrom": ["category_id"],
					"columnsTo": ["id"],
					"onDelete": "no action",
					"onUpdate": "no action"
				}
			},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"settings": {
			"name": "settings",
			"columns": {
				"key": {
					"name": "key",
					"type": "text",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": false
				},
				"value": {
					"name": "value",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"setup_items": {
			"name": "setup_items",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"setup_id": {
					"name": "setup_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"item_id": {
					"name": "item_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {},
			"foreignKeys": {
				"setup_items_setup_id_setups_id_fk": {
					"name": "setup_items_setup_id_setups_id_fk",
					"tableFrom": "setup_items",
					"tableTo": "setups",
					"columnsFrom": ["setup_id"],
					"columnsTo": ["id"],
					"onDelete": "cascade",
					"onUpdate": "no action"
				},
				"setup_items_item_id_items_id_fk": {
					"name": "setup_items_item_id_items_id_fk",
					"tableFrom": "setup_items",
					"tableTo": "items",
					"columnsFrom": ["item_id"],
					"columnsTo": ["id"],
					"onDelete": "cascade",
					"onUpdate": "no action"
				}
			},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"setups": {
			"name": "setups",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {},
			"foreignKeys": {},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"thread_candidates": {
			"name": "thread_candidates",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"thread_id": {
					"name": "thread_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"weight_grams": {
					"name": "weight_grams",
					"type": "real",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"price_cents": {
					"name": "price_cents",
					"type": "integer",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"category_id": {
					"name": "category_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"notes": {
					"name": "notes",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"product_url": {
					"name": "product_url",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"image_filename": {
					"name": "image_filename",
					"type": "text",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {},
			"foreignKeys": {
				"thread_candidates_thread_id_threads_id_fk": {
					"name": "thread_candidates_thread_id_threads_id_fk",
					"tableFrom": "thread_candidates",
					"tableTo": "threads",
					"columnsFrom": ["thread_id"],
					"columnsTo": ["id"],
					"onDelete": "cascade",
					"onUpdate": "no action"
				},
				"thread_candidates_category_id_categories_id_fk": {
					"name": "thread_candidates_category_id_categories_id_fk",
					"tableFrom": "thread_candidates",
					"tableTo": "categories",
					"columnsFrom": ["category_id"],
					"columnsTo": ["id"],
					"onDelete": "no action",
					"onUpdate": "no action"
				}
			},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		},
		"threads": {
			"name": "threads",
			"columns": {
				"id": {
					"name": "id",
					"type": "integer",
					"primaryKey": true,
					"notNull": true,
					"autoincrement": true
				},
				"name": {
					"name": "name",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"status": {
					"name": "status",
					"type": "text",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false,
					"default": "'active'"
				},
				"resolved_candidate_id": {
					"name": "resolved_candidate_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": false,
					"autoincrement": false
				},
				"category_id": {
					"name": "category_id",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"created_at": {
					"name": "created_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				},
				"updated_at": {
					"name": "updated_at",
					"type": "integer",
					"primaryKey": false,
					"notNull": true,
					"autoincrement": false
				}
			},
			"indexes": {},
			"foreignKeys": {
				"threads_category_id_categories_id_fk": {
					"name": "threads_category_id_categories_id_fk",
					"tableFrom": "threads",
					"tableTo": "categories",
					"columnsFrom": ["category_id"],
					"columnsTo": ["id"],
					"onDelete": "no action",
					"onUpdate": "no action"
				}
			},
			"compositePrimaryKeys": {},
			"uniqueConstraints": {},
			"checkConstraints": {}
		}
	},
	"views": {},
	"enums": {},
	"_meta": {
		"schemas": {},
		"tables": {},
		"columns": {}
	},
	"internal": {
		"indexes": {}
	}
}
