asdf
Tables (7)
Ingredient (재료)
- IngredientId — bigint — Primary key — NOT NULL
- IngredientName — varchar(100)
- Quantity — int
Product (상품(단품메뉴))
- ProductId — bigint — Primary key — NOT NULL
- ProductName — varchar(100)
- ProductPrice — int
- Calories — decimal(12, 2)
- AvailableTime — varchar(20)
ProductGroup (상품그룹)
- ProductGroupId — bigint — Primary key — NOT NULL
- GroupName — varchar(30)
ProductGroupMapping (상품-그룹 매핑)
- ProductGroupMappingId — bigint — Primary key — NOT NULL
- ProductGroupId — bigint — Foreign key → ProductGroup.ProductGroupId — NOT NULL
- ProductId — bigint — Foreign key → Product.ProductId — NOT NULL
ProductIngredientMapping (상품-재료 매핑)
- ProductIngredientMappingId — bigint — Primary key — NOT NULL
- ProductId — bigint — Foreign key → Product.ProductId — NOT NULL
- IngredientId — bigint — Foreign key → Ingredient.IngredientId — NOT NULL
SetMenu (세트메뉴)
- SetMenuId — bigint — Primary key — NOT NULL
- SetMenuName — varchar(100)
- SetMenuPrice — int
- Field
SetMenuProductGroupMapping (세트메뉴-상품그룹 매핑)
- SetMenuProductGroupMappingId — bigint — Primary key — NOT NULL
- SetMenuId — bigint — Foreign key → SetMenu.SetMenuId — NOT NULL
- ProductGroupId — bigint — Foreign key → ProductGroup.ProductGroupId — NOT NULL