배민2

테이블 (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) — 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) — NULL이면 배민 전체 쿠폰
  • 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) — NOT NULL
  • store_id — bigint(20) — 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 — REVIEW, STORE 등
  • target_id — bigint(20) — NOT NULL — 대상 테이블의 PK
  • 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) — 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 — RADIO, CHECK
  • menu_id — bigint(20) — 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) — 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) — NOT NULL
  • menu_id — bigint(20) — 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) — NOT NULL
  • option_item_id — bigint(20) — 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) — NOT NULL
  • store_id — bigint(20) — 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) — NOT NULL
  • order_id — bigint(20) — 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 — ACTIVE, DELETED
  • 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 — ACTIVE, DELETED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_coupon

  • user_coupon_id — bigint(20) — 기본 키 — NOT NULL
  • coupon_id — bigint(20) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • expire_day — DATETIME — NOT NULL
  • is_used — boolean — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL