roomescape
Tables (7)
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- store_id — BIGINT — Foreign key → store.id
reservation
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- date — VARCHAR(255) — NOT NULL
- time_id — BIGINT — Foreign key → reservation_time.id — NOT NULL
- theme_id — BIGINT — Foreign key → theme.id — NOT NULL
- store_id — BIGINT — Foreign key → store.id — NOT NULL
reservation_history
- id — BIGINT — Primary key — NOT NULL
- reservation_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- date — VARCHAR(255) — NOT NULL
- time_id — BIGINT — NOT NULL
- theme_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- actor_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
reservation_time
- id — BIGINT — Primary key — NOT NULL
- start_at — VARCHAR(255) — NOT NULL
reservation_wait
- id — BIGINT — Primary key — NOT NULL
- reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- created_at — TIMESTAMP
store
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
theme
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- img_url — VARCHAR(255) — NOT NULL