seminar
Tables (5)
menus (메뉴)
- menu_id (메뉴ID) — INTEGER — Primary key — NOT NULL
- name (메뉴이름) — VARCHAR
- price (메뉴가격) — INTEGER
- store_id (가게pk) — INTEGER — Foreign key → stores.store_id — NOT NULL
- menu_img (메뉴사진) — VARCHAR
order_menus (주문메뉴)
- order_id (주문ID) — INTEGER — Foreign key → orders.order_id — NOT NULL
- menu_id (메뉴ID) — INTEGER — Foreign key → menus.menu_id — NOT NULL
orders (주문)
- order_id (주문ID) — INTEGER — Primary key — NOT NULL
- store_id (가게ID) — INTEGER — Foreign key → stores.store_id — NOT NULL
- user_id (회원ID) — VAR — Foreign key → users.user_id — NOT NULL
- price (가격) — INTEGER
- pay_way (결제수단) — VARCHAR
- status (주문상태) — VARCHAR
- requests (요청사항) — VARCHAR
stores (가게)
- store_id (가게pk) — INTEGER — Primary key — NOT NULL
- name (매장이름) — VARCHAR
- star_rating (별점) — FLOAT
- address (매장주소) — CHAR(30)
- time (운영시간) — VARCHAR
- review_cnt (리뷰수) — INTEGER
- phone (매장번호) — INTEGER
- delivery_tip (배달팁) — INTEGER
- delivery_time (배달시간) — INTEGER
- dibs_cnt (찜수) — INTEGER
users (사용자)
- user_id (회원ID) — VAR — Primary key — NOT NULL
- login_id (로그인ID) — VARCHAR
- password (비밀번호) — VARCHAR
- phonenumber (휴대폰번호) — INTEGER
- adress (배달주소) — VARCHAR
- Field