소웨공

테이블 (4)

Customers

  • CustomerID — INT — 기본 키
  • Name — VARCHAR(255) — NOT NULL
  • ContactInfo — VARCHAR(255)

Payments

  • PaymentID — INT — 기본 키
  • ReservationID — INT — 외래 키 → Reservations.ReservationID
  • Amount — DECIMAL(10, 2)
  • PaymentMethod — VARCHAR(50)
  • PaymentStatus — VARCHAR(100)

Reservations

  • ReservationID — INT — 기본 키
  • ThemeID — INT — 외래 키 → Themes.ThemeID
  • CustomerID — INT — 외래 키 → Customers.CustomerID
  • ReservationDate — DATE — NOT NULL
  • NumberOfPeople — INT
  • Status — VARCHAR(100)
  • ConfirmationNumber — VARCHAR(255)
  • totalPrice — INT

Themes

  • ThemeID — INT — 기본 키
  • Name — VARCHAR(255) — NOT NULL
  • Story — TEXT
  • Difficulty — VARCHAR(50)
  • Review — TEXT
  • price — INT
  • imageUrl — VARCHAR(255)
  • playtime — INT