AC

Tables (5)

cafe_menu (Untitled2)

  • menu_name (메뉴명) — VARCHAR(30) — Primary key — NOT NULL
  • menu_price (메뉴가격) — INTEGER
  • category_name (카테고리이름) — VARCHAR(30) — Foreign key → category.category_name — NOT NULL

category (Untitled3)

  • category_name (카테고리이름) — VARCHAR(30) — Primary key — NOT NULL

customer_info (고객정보)

  • customer_id (고객ID) — VARCHAR(30) — Primary key — NOT NULL
  • customer_pw (고객PW) — VARCHAR(10)
  • customer_name (고객이름) — VARCHAR(50)
  • customer_phone (고객 휴대폰) — VARCHAR(30)
  • mileage (마일리지) — INTEGER

ordered (주문)

  • order_time (주문시간) — DATETIME — Primary key — NOT NULL
  • total_price (주문가격) — INTEGER — Primary key — NOT NULL
  • customer_id (고객ID) — VARCHAR(30) — Foreign key → customer_info.customer_id — NOT NULL

orderlist (주문내역)

  • order_num (주문번호) — INTEGER — Primary key — NOT NULL
  • customer_id (고객ID) — VARCHAR(30) — Foreign key → customer_info.customer_id — NOT NULL
  • menu_name (메뉴명) — VARCHAR(30) — Foreign key → cafe_menu.menu_name — NOT NULL
  • menu_quantity (메뉴수량) — INTEGER
  • hot_ice_none (HOT/ICE/NONE) — SET('hot','ice','none')
  • menu_size (메뉴 사이즈) — SET('S','M',"L','only')