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