방탈출
테이블 (6)
member
- id — BIGINT — 기본 키 — NOT NULL
- name — BIGINT — NOT NULL
- email — BIGINT — NOT NULL
- password — BIGINT — NOT NULL
- role — BIGINT
- created_at — BIGINT
- modified_at — BIGINT
- deleted_at — BIGINT
payment
- id — BIGINT — 기본 키 — NOT NULL
- payment_key — VARCHAR(255)
- order_id — VARCHAR(255)
- amount — INTEGER
- payment_type — VARCHAR(255)
- status — VARCHAR(10)
- created_at — TIMESTAMP(6)
- modified_at — TIMESTAMP(6)
- deleted_at — TIMESTAMP(6)
reservation
- id (reservation_id) — BIGINT — 기본 키 — NOT NULL
- date — DATE — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- payment_id — BIGINT — 외래 키 → payment.id — NOT NULL
- reservation_time_id — BIGINT — 외래 키 → reservation_time.id — NOT NULL
- theme_id — BIGINT — 외래 키 → theme.id — NOT NULL
- created_at — TIMESTAMP(6)
- modified_at — TIMESTAMP(6)
- deleted_at — TIMESTAMP(6)
reservation_time
- id — BIGINT — 기본 키 — NOT NULL
- start_at — BIGINT — NOT NULL
- created_at — BIGINT
- modified_at — BIGINT
- deleted_at — BIGINT
theme
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- thumbnail — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP(6)
- modified_at — TIMESTAMP(6)
- deleted_at — TIMESTAMP(6)
waiting
- id — BIGINT — 기본 키 — NOT NULL
- date — BIGINT — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- reservation_time_id — BIGINT — 외래 키 → reservation_time.id — NOT NULL
- theme_id — BIGINT — 외래 키 → theme.id — NOT NULL
- created_at — BIGINT
- modified_at — BIGINT
- deleted_at — BIGINT