food_ERD
Tables (4)
MART_A (Untitled)
- M_name (가게이름) — varchar(40) — Primary key — NOT NULL
MENU (Untitled3)
- menu_name (메뉴이름) — varchar(40) — Primary key — NOT NULL
- M_name (가게이름) — varchar(40) — Foreign key → MART_A.M_name — NOT NULL
- price (가격) — integer
cust (Untitled2)
- C_num (주문자번호) — integer — Primary key — NOT NULL
- C_name (주문자이름) — varchar(20)
- menu_name (메뉴이름) — varchar(40) — Foreign key → MENU.menu_name — NOT NULL
- M_name (가게이름) — varchar(40) — Foreign key → MENU.M_name — NOT NULL
- C_count (주문수량) — integer
order (Untitled5)
- O_num (Key) — integer — Primary key — NOT NULL
- C_num (주문자번호) — integer — Foreign key → cust.C_num — NOT NULL
- O_date (주문날짜) — date
- menu_name (메뉴이름) — varchar(40) — Foreign key → MENU.menu_name — NOT NULL
- M_name (가게이름) — varchar(40) — Foreign key → MENU.M_name — NOT NULL