배민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