우테코 방탈출

테이블 (6)

member (CopyOfCopyOfUntitled22)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • name (Field) — NOT NULL
  • email (Field6) — NOT NULL
  • password (Field4) — NOT NULL
  • role (Field5) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL

payment (CopyOfCopyOfUntitled2)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • payment_key (Field) — NOT NULL
  • order_id (Field4) — NOT NULL
  • total_amount (Field5) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL

reservation (Untitled)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • member_id (Key5) — NOT NULL — 외래 키 → member.id — NOT NULL
  • reservation_time_id (Key2) — NOT NULL — 외래 키 → reservation_time.id — NOT NULL
  • theme_id (Key3) — NOT NULL — 외래 키 → theme.id — NOT NULL
  • payment_id (Key4) — NULL — 외래 키 → payment.id — NOT NULL
  • date (Field2) — NOT NULL
  • created_at (Field6) — NOT NULL
  • modified_at (Field7) — NOT NULL

reservation_time (Untitled2)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • start_at (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL

theme (CopyOfUntitled2)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • name (Field) — NOT NULL
  • description (Field4) — NOT NULL
  • thumbnail (Field5) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL

waiting (CopyOfUntitled22)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • reservation_id (Key2) — NOT NULL — 외래 키 → reservation.id — NOT NULL
  • member_id (Key3) — NOT NULL — 외래 키 → member.id — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL