| 1234567891011121314151617 |
- -- 表 kku_item_recipe_materials 的创建SQL
- DROP TABLE IF EXISTS `kku_item_recipe_materials`;
- CREATE TABLE `kku_item_recipe_materials` (
- `id` int NOT NULL AUTO_INCREMENT COMMENT '记录ID，主键',
- `recipe_id` int NOT NULL COMMENT '配方ID，外键关联kku_item_recipes表',
- `item_id` int NOT NULL COMMENT '材料物品ID，外键关联kku_item_items表',
- `quantity` int NOT NULL COMMENT '所需数量',
- `is_consumed` tinyint DEFAULT '1' COMMENT '是否消耗（0:不消耗, 1:消耗）',
- `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
- `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
- PRIMARY KEY (`id`),
- KEY `idx_recipe_id` (`recipe_id`),
- KEY `idx_item_id` (`item_id`),
- CONSTRAINT `fk_material_item` FOREIGN KEY (`item_id`) REFERENCES `kku_item_items` (`id`) ON DELETE CASCADE,
- CONSTRAINT `fk_material_recipe` FOREIGN KEY (`recipe_id`) REFERENCES `kku_item_recipes` (`id`) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='配方材料需求表';
|
