1
테이블 (13)
Address
- address_id — INT — 기본 키 — NOT NULL
- address_name — VARCHAR(10)
- address — VARCHAR(80) — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- isCurrentAddress — TINYINT(1) — NOT NULL
- address_code — INT — NOT NULL
Category
- category_id — INT — 기본 키 — NOT NULL
- category_name — VARCHAR(20) — NOT NULL
- category_image — TEXT — NOT NULL
Delivery
- delivery_id — INT — 기본 키 — NOT NULL
- delivery_start_time — TIMESTAMP — NOT NULL
- delivery_end_time — TIMESTAMP
- store_id — INT — 외래 키 → 배달팁.store_id — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- order_id — INT — 외래 키 → 주문.order_id — NOT NULL
Like
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
- date — TIMESTAMP — NOT NULL
Menu
- menu_id — INT — 기본 키 — NOT NULL
- menu_name — VARCHAR(20) — NOT NULL
- price — INT — NOT NULL
- menu_picture_url — TEXT
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
Review
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
- rating — INT — NOT NULL
- review — TEXT
- review_picture_url — TEXT
- review_datetime — TIMESTAMP — NOT NULL
- isLocked — TINYINT(1) — NOT NULL
- menu_id — INT — 외래 키 → Menu.menu_id — NOT NULL
Store
- store_id — INT — 기본 키 — NOT NULL
- store_name — VARCHAR(20) — NOT NULL
- store_address — VARCHAR(50) — NOT NULL
- store_picture_url — TEXT
- address_code — INT — NOT NULL
StoreCategory
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
- category_id — INT — 외래 키 → Category.category_id — NOT NULL
User
- user_id — INT — 기본 키 — NOT NULL
- user_name — VARCHAR(10) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- review_num — INT — NOT NULL
- rating_average — DOUBLE — NOT NULL
배달팁 (DeliveryTip)
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
- delievery_tip — INT — NOT NULL
- minimum_order — INT — NOT NULL
- maximum_order — INT
주문 (Order)
- order_id — INT — 기본 키 — NOT NULL
- order_datetime — TIMESTAMP — NOT NULL
- order_status — VARCHAR(20) — NOT NULL
- payment_info — VARCHAR(80) — NOT NULL
- request_notes — VARCHAR(50)
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
주문에 담긴 메뉴 (OrderMenu)
- order_id — INT — 외래 키 → 주문.order_id — NOT NULL
- menu_id — INT — 외래 키 → Menu.menu_id — NOT NULL
- quantity — INT — NOT NULL
쿠폰 (Coupon)
- coupon_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- store_id — INT — 외래 키 → Store.store_id — NOT NULL
- coupon_name — VARCHAR(50) — NOT NULL
- discount — INT — NOT NULL
- isRatio — TINYINT(1) — NOT NULL
- order_id — INT — 외래 키 → 주문.order_id