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