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