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