interpark
Tables (8)
Category (5)
- PK (categoryId) — Primary key — NOT NULL
- Field (category)
Draw (8)
- PK (drawId) — Primary key — NOT NULL
- FK (userId) — Foreign key → User.PK — NOT NULL
- FK (seatId) — Foreign key → Seat.PK — NOT NULL
- FK (reservaitionId) — Foreign key → Rerservation.PK — NOT NULL
- FK (ticketId) — Foreign key → Reservation.PK — NOT NULL
Event (4)
- PK (eventId) — Primary key — NOT NULL
- FK (placeId) — Foreign key → Place.PK — NOT NULL
- FK (categoryId) — Foreign key → Category.PK — NOT NULL
- Field (casting)
- Field (min_age)
- Field (period)
Place (3)
- PK (placeId) — Primary key — NOT NULL
- Field (address)
- #of seats
Rerservation (2)
- PK (reservaitionId) — Primary key — NOT NULL
- FK (userId) — Foreign key → User.PK — NOT NULL
- FK (eventId) — Foreign key → Event.PK — NOT NULL
- FK (placeId) — Foreign key → Place.PK — NOT NULL
- Field (time)
- Field (date)
Reservation (6)
- PK (reservationId) — Primary key — NOT NULL
- FK (userId) — Foreign key → User.PK — NOT NULL
- FK (seatId) — Foreign key → Seat.PK — NOT NULL
- FK (categoryId) — Foreign key → Category.PK — NOT NULL
- FK (eventId) — Foreign key → Event.PK — NOT NULL
- FK (placeId) — Foreign key → Place.PK — NOT NULL
- FK (reservaitionId) — Foreign key → Rerservation.PK — NOT NULL
Seat (7)
- PK (seatId) — Primary key — NOT NULL
- Field (grade)
- Field (price)
User (1)
- PK (userId) — Primary key — NOT NULL
- Field (name)
- Field (birth)
- Field (phone)
- Field (email)
- Field (gender)
- Field (password)