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)