interpark2

Tables (8)

Category (6)

  • categoryID (PK) — Primary key — NOT NULL
  • category (Field)

Draw (8)

  • drawID (PK) — Primary key — NOT NULL
  • ticketID (FK) — Foreign key → Ticket.ticketID — NOT NULL

Event (3)

  • eventID (PK) — Primary key — NOT NULL
  • casting (Field)
  • min_age (Field2)
  • categoryID (FK) — Foreign key → Category.categoryID — NOT NULL
  • placeID (FK2) — Foreign key → Place.placeID — NOT NULL

Place (4)

  • placeID (PK) — Primary key — NOT NULL
  • address (Field)
  • # of seats (Field2)

Reservation (2)

  • reservationID (PK) — Primary key — NOT NULL
  • userID (FK) — Foreign key → User.userID — NOT NULL
  • seatID (FK2) — Foreign key → Seat.seatID — NOT NULL
  • placeID (FK3) — Foreign key → Place.placeID — NOT NULL
  • eventID (FK4) — Foreign key → Event.eventID — NOT NULL
  • ticketID (FK5) — Foreign key → Ticket.ticketID — NOT NULL
  • reservationID (FK6) — Foreign key → Reservation.reservationID — NOT NULL

Seat (5)

  • seatID (PK) — Primary key — NOT NULL
  • grade (Field)
  • placeID (FK) — Foreign key → Place.placeID — NOT NULL

Ticket (7)

  • ticketID (PK) — Primary key — NOT NULL
  • reservationID (FK) — Foreign key → Reservation.reservationID — NOT NULL

User (1)

  • userID (PK) — Primary key — NOT NULL
  • name (Field)
  • birth (Field2)
  • phone (Field3)
  • email (Field4)
  • gender (Field5)
  • password (Field6)