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)