배달의민족
테이블 (13)
Favorite
- favorite_id — LONG — 기본 키 — NOT NULL
- store_id — LONG — 외래 키 → Store.store_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Store.shop_owner_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE, DELETED
Location
- location_id — LONG — 기본 키 — NOT NULL
- location_name — VARCHAR(45) — NOT NULL
- address — VARCHAR(45) — NOT NULL
- address_detail — VARCHAR(45)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- is_selected — TINYINT — NOT NULL — 현재 선택한 주소
- status — VARCHAR(20) — NOT NULL — ACTIVE, DELETED
Menu
- menu_id — LONG — 기본 키 — NOT NULL
- store_id — LONG — 외래 키 → Store.store_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Store.shop_owner_id — NOT NULL
- menu_name — VARCHAR(45) — NOT NULL
- price — DECIMAL — NOT NULL
MenuImage
- menu_image_id — LONG — 기본 키 — NOT NULL
- menu_id — LONG — 외래 키 → Menu.menu_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Menu.shop_owner_id — NOT NULL
- image_url — TEXT — NOT NULL
MenuOption
- menu_option_id — LONG — 기본 키 — NOT NULL
- menu_id — LONG — 외래 키 → Menu.menu_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Menu.shop_owner_id — NOT NULL
- option_name — VARCHAR(45) — NOT NULL
- is_essential — TINYINT — NOT NULL
Order
- order_id — LONG — 기본 키 — NOT NULL
- store_id — LONG — 외래 키 → Store.store_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Store.shop_owner_id — NOT NULL
- total_price — DECIMAL — NOT NULL
- delivery_address — VARCHAR(45) — NOT NULL
- request_disposable — TINYINT — NOT NULL — 일회용품
- request_message_for_owner — VARCHAR(200)
- request_message_for_rider — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE, COMPLETED, CANCELED
- payment_type — ENUM — NOT NULL — BMPAY, OTHER, FAMILY
OrderMenu
- order_menu_id — LONG — 기본 키 — NOT NULL
- order_id — LONG — 외래 키 → Order.order_id — NOT NULL
- menu_id — LONG — 외래 키 → Menu.menu_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Menu.shop_owner_id — NOT NULL
- price — DECIMAL — NOT NULL
- count — INT — NOT NULL
OrderMenuOption
- order_menu_option_id — Long — 기본 키 — NOT NULL
- order_menu_id — LONG — 외래 키 → OrderMenu.order_menu_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → OrderMenu.shop_owner_id — NOT NULL
- option_name — VARCHAR(45) — NOT NULL
- price — INT — NOT NULL
Review
- review_id — LONG — 기본 키 — NOT NULL
- order_id — LONG — 외래 키 → Order.order_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → Order.shop_owner_id — NOT NULL
- review_score — INT — NOT NULL
- coment — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE, DELETED
ReviewComment
- review_comment_id — LONG — 기본 키 — NOT NULL
- review_id — LONG — 외래 키 → Review.review_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → ShopOwner.shop_owner_id — NOT NULL
- content — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE, DELETED
ShopOwner
- shop_owner_id — LONG — 기본 키 — NOT NULL
- email — 추가적인 정보는 나중에 업데이트
Store
- store_id — LONG — 기본 키 — NOT NULL
- shop_owner_id — LONG — 외래 키 → ShopOwner.shop_owner_id — NOT NULL
- store_name — VARCHAR(45) — NOT NULL
- category — ENUM — NOT NULL
- minumum_price — DECIMAL
- address — VARCHAR(45) — NOT NULL
- infomation — TEXT
이건옵션의옵션이다 (MenuOptionOption)
- opop_id — LONG — 기본 키 — NOT NULL
- menu_option_id — LONG — 외래 키 → MenuOption.menu_option_id — NOT NULL
- menu_id — LONG — 외래 키 → MenuOption.menu_id — NOT NULL
- shop_owner_id — LONG — 외래 키 → MenuOption.shop_owner_id — NOT NULL
- opop_name — VARCHAR(45) — NOT NULL
- price — DECIMAL — NOT NULL
- is_selected — TINYINT — NOT NULL