escaperoom
Tables (6)
member (Untitled)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- email (Field2)
- password (Field3)
- role (Field4)
payment (Untitled7)
- payment_id (Key) — Primary key — NOT NULL
- reservation_id (Key3) — Foreign key → reservation.reservation_id — NOT NULL
- amount (Field)
- order_id (Field2)
- payment_key (Field3)
- payment_gateway (Field4)
reservation (Untitled2)
- reservation_id (Key) — Primary key — NOT NULL
- member_id (Key3) — Foreign key → member.member_id — NOT NULL
- theme_id (Key2) — Foreign key → theme.theme_id — NOT NULL
- time_id (Key4) — Foreign key → time.time_id — NOT NULL
- date (Field)
- created_at (Field2)
- payment_success (Field3)
theme (Untitled3)
- theme_id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- thumbnail (Field3)
time (Untitled4)
- time_id (Key) — Primary key — NOT NULL
- start_at (Field)
waiting (Untitled6)
- waiting_id (Key) — Primary key — NOT NULL
- time_id (Key2) — Foreign key → time.time_id — NOT NULL
- member_id (Key3) — Foreign key → member.member_id — NOT NULL
- theme_id (Key4) — Foreign key → theme.theme_id — NOT NULL
- date (Field)