wooteco-lv2-roomescape
Tables (7)
account
- id — BIGINT — Primary key
- password — VARCHAR(255)
- member_id — BIGINT — Foreign key → member.id
member
- id — BIGINT — Primary key
- email — VARCHAR(255)
- name — VARCHAR(255)
- role — ENUM
payment_history
- id — BIGINT — Primary key
- amount — INTEGER — NOT NULL
- order_id — VARCHAR(255)
- payment_key — VARCHAR(255)
- status — ENUM
- reservation_id — BIGINT — Foreign key → reservation.id
reservation
- id — BIGINT — Primary key
- reservation_date — DATE
- time_id — BIGINT — Foreign key → reservation_time.id
- theme_id — BIGINT — Foreign key → theme.id
- member_id — BIGINT — Foreign key → member.id
reservation_time
- id — BIGINT — Primary key
- start_at — TIME(6)
reservation_wait
- id — BIGINT — Primary key
- reservation_date — DATE
- time_id — BIGINT — Foreign key → reservation_time.id
- member_id — BIGINT — Foreign key → member.id
- theme_id — BIGINT — Foreign key → theme.id
theme
- id — BIGINT — Primary key
- name — VARCHAR(255)
- description — VARCHAR(255)
- thumbnail — VARCHAR(255)