performance

Tables (4)

book (예약)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → user.id — NOT NULL
  • seat_id (Key3) — number — Foreign key → seat.id — NOT NULL
  • show_id (Key4) — number — Foreign key → show.id — NOT NULL

seat (좌석)

  • id (Key) — number — Primary key — NOT NULL
  • show_id (Key2) — number — Foreign key → show.id — NOT NULL
  • seatNumber (Field) — number

show (공연)

  • id (Key) — number — Primary key — NOT NULL

user (유저)

  • id (Key) — number — Primary key — NOT NULL