예약

테이블 (9)

PRODUCT (PRODUCT (MENU?))

  • id — Long — 기본 키 — NOT NULL
  • business_profile_id (store_id) — Long — 외래 키 → RESERVATION_STORE(SETTING).business_profile_id — NOT NULL
  • name — String — NOT NULL
  • price — Int — 가격이 추후 결정되는 상품들도 존재하니 nullable
  • descirption (description) — String
  • image_ids — String — NOT NULL
  • Field

RESERVATED_PRODUCT

  • reservation_id — Long — 외래 키 → RESERVATION(TIME_TABLE).id — NOT NULL
  • product_id — Long — 외래 키 → PRODUCT.id — NOT NULL
  • quantity — int — NOT NULL

RESERVATION(TIME_TABLE) (RESERVATION (TIME_TABLE?))

  • id — Long — 기본 키 — NOT NULL
  • Key (user_id) — Long — 외래 키 → Untitled.Key — NOT NULL
  • store_id — Long — 외래 키 → RESERVATION_STORE(SETTING).business_profile_id — NOT NULL
  • start_time — DateTime — NOT NULL
  • finish_time — DateTIme — NOT NULL — time_unit을 기록하는 건 어떨지?
  • Field (status) — Enum — NOT NULL
  • before_reservation_id (before_time_table_id) — Long — 외래 키 → RESERVATION(TIME_TABLE).id — NOT NULL

RESERVATION_REVIEW

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

RESERVATION_STORE(SETTING) (RESERVATION_STORE. (SETTING?))

  • business_profile_id — Long — 외래 키 → business_profile.id — NOT NULL
  • time_unit — NOT NULL
  • reservation_type — Enum — NOT NULL
  • start_time (store_start_time) — DateTime — NOT NULL
  • finish_time (store_finish_time) — DateTime — NOT NULL

Untitled (DESIGNER)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Untitled (RESERVATION_USER)

  • Key (id) — Long — 기본 키 — NOT NULL
  • id (user_id) — Long — 외래 키 → user.id — NOT NULL
  • Field (address) — String
  • Field2 (request) — String

business_profile (BUSINESS_PROFILE)

  • id — 기본 키 — NOT NULL

user (USER)

  • id — 기본 키 — NOT NULL