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