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