subject

Tables (6)

tbl_ingredients (상품재료)

  • IngredId (상품재료아이디) — int — Primary key — NOT NULL
  • IngredNm (상품재료명) — varchar

tbl_menu (상품메뉴)

  • MenuId (상품메뉴아이디) — int — Primary key
  • MenuGroupId (상품메뉴그룹아이디) — int — Foreign key → tbl_menugroup.MenuGroupId
  • MenuNm (상품메뉴명) — varchar
  • MenuImg (상품메뉴이미지) — blob
  • MenuPrice (상품가격) — float
  • MenuKcal (상품칼로리) — float
  • MenuSalesTm (상품판매가능시간)

tbl_menugroup (상품메뉴그룹)

  • MenuGroupId (상품메뉴그룹아이디) — int — Primary key
  • MenuGroupNm (상품메뉴그룹명) — varchar

tbl_menuingred (상품메뉴재료)

  • MenuIngredId (상품메뉴재료아이디) — int — Primary key — NOT NULL
  • MenuId (상품메뉴아이디) — int — Foreign key → tbl_menu.MenuId
  • IngredId (상품재료아이디) — int — Foreign key → tbl_ingredients.IngredId — NOT NULL

tbl_set (상품세트)

  • SetId (상품세트아이디) — int — Primary key — NOT NULL
  • MenuGroupId (상품메뉴그룹아이디) — int — Foreign key → tbl_menugroup.MenuGroupId
  • SetNm (상품세트명) — varchar
  • SetSalesTm (상품세트판매가능시간) — time

tbl_setmenu (상품세트메뉴)

  • SetMenuId (상품세트메뉴아이디) — int — Primary key — NOT NULL
  • SetId (상품세트아이디) — int — Foreign key → tbl_set.SetId — NOT NULL
  • MenuId (상품메뉴아이디) — int — Foreign key → tbl_menu.MenuId