배민3
테이블 (14)
address
- address_id — bigint(20) — 기본 키 — NOT NULL
- address_category — varchar(100) — NOT NULL
- is_default — boolean — NOT NULL
- entrance_password — varchar(100)
- user_latitude — decimal(18,10) — NOT NULL
- user_longitude — decimal(18,10) — NOT NULL
- user_id — bigint(20) — 외래 키 → user.user_id — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
coupon
- coupon_id — bigint(20) — 기본 키 — NOT NULL
- coupon_name — varchar(100) — NOT NULL
- min_order_price — decimal(10,2)
- discount_price — decimal(10,2) — NOT NULL
- store_id — bigint(20) — 외래 키 → store.store_id
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
favorite
- favorite_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → user.user_id — NOT NULL
- store_id — bigint(20) — 외래 키 → store.store_id — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
image
- image_id — bigint(20) — 기본 키 — NOT NULL
- target_type — varchar(20) — NOT NULL
- target_id — bigint(20) — NOT NULL
- image_url — varchar(2000) — NOT NULL
- display_order — int — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
menu
- menu_id — bigint(20) — 기본 키 — NOT NULL
- category — varchar(100) — NOT NULL
- menu_name — varchar(200) — NOT NULL
- price — decimal(10,2) — NOT NULL
- store_id — bigint(20) — 외래 키 → store.store_id — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
option_group
- option_group_id — bigint(20) — 기본 키 — NOT NULL
- option_name — varchar(200) — NOT NULL
- is_required — boolean — NOT NULL
- option_type — varchar(20) — NOT NULL
- menu_id — bigint(20) — 외래 키 → menu.menu_id — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
option_item
- option_item_id — bigint(20) — 기본 키 — NOT NULL
- option_item_name — varchar(200) — NOT NULL
- option_item_price — decimal(10,2) — NOT NULL
- option_group_id — bigint(20) — 외래 키 → option_group.option_group_id — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
order_detail
- detail_id — bigint(20) — 기본 키 — NOT NULL
- unit_price — decimal(10,2) — NOT NULL
- numberof_menu — int(10) — NOT NULL
- order_id — bigint(20) — 외래 키 → orders.order_id — NOT NULL
- menu_id — bigint(20) — 외래 키 → menu.menu_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
order_option
- order_option_id — bigint(20) — 기본 키 — NOT NULL
- detail_id — bigint(20) — 외래 키 → order_detail.detail_id — NOT NULL
- option_item_id — bigint(20) — 외래 키 → option_item.option_item_id — NOT NULL
- history_name — varchar(200) — NOT NULL
- history_price — decimal(10,2) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
orders
- order_id — bigint(20) — 기본 키 — NOT NULL
- order_time — DATETIME — NOT NULL
- total_price — decimal(10,2) — NOT NULL
- order_status — varchar(20) — NOT NULL
- user_id — bigint(20) — 외래 키 → user.user_id — NOT NULL
- store_id — bigint(20) — 외래 키 → store.store_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
review
- review_id — bigint(20) — 기본 키 — NOT NULL
- rating — int(10) — NOT NULL
- review_content — varchar(500) — NOT NULL
- user_id — bigint(20) — 외래 키 → user.user_id — NOT NULL
- order_id — bigint(20) — 외래 키 → orders.order_id — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
store
- store_id — bigint(20) — 기본 키 — NOT NULL
- store_name — varchar(100) — NOT NULL
- store_address — varchar(200) — NOT NULL
- category — varchar(100) — NOT NULL
- store_number — varchar(11) — NOT NULL
- favorite_count — int(10) — NOT NULL
- operation_hour — varchar(100) — NOT NULL
- delivery_area — varchar(200)
- store_latitude — decimal(18,10) — NOT NULL
- store_longitude — decimal(18,10) — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user
- user_id — bigint(20) — 기본 키 — NOT NULL
- userpassword — varchar(200) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- phonenumber — varchar(11) — NOT NULL
- email — varchar(100) — NOT NULL
- user_point — bigint(20) — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_coupon
- user_coupon_id — bigint(20) — 기본 키 — NOT NULL
- coupon_id — bigint(20) — 외래 키 → coupon.coupon_id — NOT NULL
- user_id — bigint(20) — 외래 키 → user.user_id — NOT NULL
- expire_day — DATETIME — NOT NULL
- is_used — boolean — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL