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')