배민2

테이블 (24)

category

  • id — TINYINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • icon_url — varchar — NOT NULL

delivery_address

  • id — BIGINT — 기본 키 — NOT NULL
  • detail — varchar
  • type — varchar — NOT NULL
  • user_id — BIGINT — NOT NULL
  • postal_id — BIGINT — NOT NULL

do

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL

dong

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • si_id — BIGINT — NOT NULL

like

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

menu

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • photo_url — varchar
  • explanation — varchar
  • is_popular — boolean — NOT NULL
  • is_recommended — boolean — NOT NULL
  • price — DECIMAL — NOT NULL
  • store_id — BIGINT — NOT NULL

multiple_select

  • id — BIGINT — 기본 키 — NOT NULL
  • menu_id — BIGINT — 외래 키 → menu.id — NOT NULL
  • name — varchar — NOT NULL
  • max — TINYINT — NOT NULL

multiple_select_value

  • id — BIGINT — 기본 키 — NOT NULL
  • multiple_select_id — BIGINT — 외래 키 → multiple_select.id — NOT NULL
  • menu_id — BIGINT — 외래 키 → multiple_select.menu_id — NOT NULL
  • price — DECIMAL — NOT NULL
  • name — varchar — NOT NULL

order

  • id — BIGINT — 기본 키 — NOT NULL
  • status — varchar — NOT NULL
  • user_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL

ordered_menu

  • id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → order.id — NOT NULL
  • menu_id — BIGINT — NOT NULL

ordered_multiple_select

  • id — BIGINT — 기본 키 — NOT NULL
  • ordered_menu_id — BIGINT — 외래 키 → ordered_menu.id — NOT NULL
  • order_id — BIGINT — 외래 키 → ordered_menu.order_id — NOT NULL
  • value_id — BIGINT — NOT NULL
  • multiple_select_id — BIGINT — NOT NULL
  • menu_id — BIGINT — NOT NULL

ordered_single_select

  • id — BIGINT — 기본 키 — NOT NULL
  • ordered_menu_id — BIGINT — 외래 키 → ordered_menu.id — NOT NULL
  • order_id — BIGINT — 외래 키 → ordered_menu.order_id — NOT NULL
  • value_id — BIGINT — NOT NULL
  • single_select_id — BIGINT — NOT NULL
  • menu_id — BIGINT — NOT NULL

payment

  • id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → order.id — NOT NULL

postal

  • id — BIGINT — 기본 키 — NOT NULL
  • latitude — DECIMAL — NOT NULL
  • longtitude — DECIMAL — NOT NULL

postal_street

  • id — BIGINT — 기본 키 — NOT NULL
  • postal_id — BIGINT — 외래 키 → postal.id — NOT NULL
  • street_id — BIGINT — 외래 키 → street.id — NOT NULL

review

  • id — BIGINT — 기본 키 — NOT NULL
  • conent — varchar
  • star — TINYINT — NOT NULL
  • order_id — BIGINT — NOT NULL

review_photo

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → review.id — NOT NULL
  • photo_url — varchar — NOT NULL

si

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • do_id — BIGINT — NOT NULL

single_select

  • id — BIGINT — 기본 키 — NOT NULL
  • menu_id — BIGINT — 외래 키 → menu.id — NOT NULL
  • name — varchar — NOT NULL

single_select_value

  • id — BIGINT — 기본 키 — NOT NULL
  • single_select_id — BIGINT — 외래 키 → single_select.id — NOT NULL
  • menu_id — BIGINT — 외래 키 → single_select.menu_id — NOT NULL
  • price — DECIMAL — NOT NULL
  • name — varchar — NOT NULL

store

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • photo_url — varchar
  • notice — varchar
  • min_order_price — DECIMAL — NOT NULL
  • status — varchar — NOT NULL
  • category_id — TINYINT — NOT NULL

store_address

  • id — BIGINT — 기본 키 — NOT NULL
  • detail — varchar
  • store_id — BIGINT — NOT NULL
  • postal_id — BIGINT — NOT NULL

street

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • dong_id — BIGINT — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • pw — varchar — NOT NULL
  • status — varchar