wooteco-roomescape
Tables (5)
Member (member)
- pk (id) — BIG INT — Primary key — NOT NULL
- email — VARCHAR
- password — VARCHAR
- name — VARCHAR
- role — VARCHAR
Payment (payment)
- pk (id) — BIG INT — Primary key — NOT NULL
- paymentKey (payment_key) — VARCHAR
- orderId (order_id) — VARCHAR
- totalAmount (total_amount) — BIG INT
- reservation (reservation_id) — BIG INT — Foreign key → Reservation.pk — NOT NULL
- company — VARCHAR
Reservation (reservation)
- pk (id) — BIG INT — Primary key — NOT NULL
- date — DATE
- status — VARCHAR
- theme (theme_id) — BIG INT — Foreign key → Theme.pk — NOT NULL
- time (time_id) — BIG INT — Foreign key → ReservationTime.pk — NOT NULL
- member (member_id) — BIG INT — Foreign key → Member.pk — NOT NULL
ReservationTime (reservation_time)
- pk (id) — BIG INT — Primary key — NOT NULL
- startAt (start_at) — TIME
Theme (theme)
- pk (id) — BIG INT — Primary key — NOT NULL
- name — VARCHAR