배달의민족

테이블 (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