roomescape
Tables (6)
member
- id — BIGINT — Primary key
- email — VARCHAR(320) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- session_id — VARCHAR(255)
- role — ENUM('ADMIN', 'USER') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payment
- id — BIGINT — Primary key
- id (reservation_id) — BIGINT — Foreign key → reservation.id
- payment_key — VARCHAR(255) — NOT NULL
- amount — INTEGER — NOT NULL
reservation
- id — BIGINT — Primary key
- reservation_status — ENUM('PENDING', 'ACCEPTED', 'DENIED') — NOT NULL
- id (reservation_item_id) — BIGINT — Foreign key → reservation_item.id
- id (member_id) — BIGINT — Foreign key → member.id
reservation_item
- id — BIGINT — Primary key
- Key (reservation_theme_id) — BIGINT — Foreign key → reservation_theme.Key — NOT NULL
- id (reservation_time_id) — BIGINT — Foreign key → reservation_time.id
- date — DATE — NOT NULL
reservation_theme
- Key (id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- thumbnail — VARCHAR(255)
reservation_time
- id — BIGINT — Primary key
- start_at — TIME(6) — NOT NULL