RoomEscape
Tables (3)
Member (Untitled2)
- pk (id) — BIG INT — Primary key — NOT NULL
- email — VARCHAR
- name — VARCHAR
- role — VARCHAR
Payment (Untitled3)
- pk (id) — BIG INT — Primary key — NOT NULL
- pk (id2) — BIG INT — Primary key — NOT NULL
- amount — INT
- order id (order_id) — VARCHAR
- payment key (payment_key) — VARCHAR
Reservation (Untitled)
- pk (id) — BIG INT — Primary key — NOT NULL
- date — DATE
- theme (theme_id) — BIG INT
- time (time_id) — BIG INT
- member (member_id) — BIG INT — Foreign key → Member.pk — NOT NULL