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)