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