Roomescape

Tables (7)

ADMIN (CopyOfUntitled2)

  • id (Key) — Bigint — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • name (Field2) — VARCHAR(255)
  • password (Field3) — VARCHAR(255)

MEMBER (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • name (Field2) — VARCHAR(255)
  • password (Field3) — VARCHAR(255)

PAYMENT (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • reservation_id (Key2) — BIGINT — Foreign key → RESERVATION.id — NOT NULL
  • order_id (Field2) — VARCHAR(255)
  • pament_key (Field3) — VARCHAR(255)
  • amount (Field4) — INTEGER

RESERVATION (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • theme_id (Key2) — BIGINT — Foreign key → THEME.id — NOT NULL
  • time_id (Key3) — BIGINT — Foreign key → RESERVATION_TIME.id — NOT NULL
  • member_id (Key4) — Bigint — Foreign key → MEMBER.id — NOT NULL
  • date (Field) — DATE
  • status (Field5) — VARCHAR(255)

RESERVATION_TIME (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • start_at (Field) — TIME(6)

THEME (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • description (Field) — VARCHAR(255)
  • name (Field2) — VARCHAR(255)
  • thumbnail (Field3) — VARCHAR(255)

WAITING (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • reservation_id (Key2) — BIGINT — Foreign key → RESERVATION.id — NOT NULL
  • member_id (Key3) — Bigint — Foreign key → MEMBER.id — NOT NULL