room-escape
Tables (5)
member
- member_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL
payment
- payment_id — BIGINT
- order_id — VARCHAR(255) — NOT NULL
- amount — INT — NOT NULL
- payment_key — VARCHAR(255) — NOT NULL
- payment_type — VARCHAR(20) — NOT NULL
- reservation_id — BIGINT — NOT NULL
reservation
- reservation_id — BIGINT
- member_id — BIGINT — NOT NULL
- date — DATE — NOT NULL
- time_id — BIGINT — NOT NULL
- theme_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- create_at — DATETIME — NOT NULL
reservation_time
- time_id — BIGINT
- start_at — TIME — NOT NULL
theme
- theme_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- thumbnail — VARCHAR(255) — NOT NULL