소웨공
테이블 (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