ConcertRservationScenario
Tables (5)
Concert_TBL (Untitled2)
- concertId (Key) — NOT NULL — Primary key — NOT NULL
- title (Field) — NOT NULL
- artist (Field2) — NOT NULL
- ticketPrice (Field4) — NOT NULL
- description (Field3) — NOT NULL
Member (Untitled)
- member_id (memberId) — NOT NULL — Primary key — NOT NULL
- member_name (memberName) — NOT NULL
- password — NOT NULL
- point — NOT NULL
- role — NOT NULL
Reservation (Untitled3)
- Key — NOT NULL — Primary key — NOT NULL
- reservedSeat (Field) — NOT NULL
- totalPrice (Field3) — NOT NULL
- reservationDate (Field2) — NOT NULL
- seat_num (Field4) — NOT NULL
- schedule_id (Key2) — NOT NULL — Foreign key → Concert_TBL.concertId — NOT NULL
- member_id (memberId) — NOT NULL — Foreign key → Member.member_id — NOT NULL
Schedule (Untitled5)
- schedule_id (Key) — NOT NULL — Primary key — NOT NULL
- concert_date (Field) — NOT NULL
- place (Field2) — NOT NULL
- seat_count (Field3) — NOT NULL
- extra_seat_count (Field4) — NOT NULL
- concert_id (Key3) — NOT NULL — Foreign key → Concert_TBL.concertId — NOT NULL
Seat (Untitled6)
- seat_id (Key) — NOT NULL — Primary key — NOT NULL
- seat_num (Field) — NOT NULL
- is_booked (Field2) — NOT NULL
- schedule_id (Key3) — NOT NULL — Foreign key → Schedule.schedule_id — NOT NULL