BookingMusicalTicket
Tables (8)
Musical (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (id) — BIGINT — Foreign key → User.id — NOT NULL
- title (Field) — varchar
- genre (Field2) — varchar
- releaseDate (Field11) — DATETIME
- runningTime (Field9) — DATETIME
- info (Field3) — varchar
- poster (Field4) — varchar
- rating (Field6) — varchar
- role (Field5) — varchar
- director (Field7) — varchar
- createdAt (Field8) — DATETIME
- updateAt (Field10) — DATETIME
Payment (Untitled6)
- pay_id (Key) — BIGINT — Primary key — NOT NULL
- ticket_id (Key2) — BIGINT — Foreign key → Ticket.ticket_id — NOT NULL
- price (Field2) — double
- status (Field3) — varchar
- shutdown (Field6) — varchar
- createdAt (Field4) — DATETIME
- updatedAt (Field5) — DATETIME
- paymentTime (Field) — TIMESTAMP
Review (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (id) — BIGINT — Foreign key → User.id — NOT NULL
- musical_id (Key2) — BIGINT — Foreign key → Musical.id — NOT NULL
- rating (Field3) — varchar
- content (Field4) — varchar
- photo_url (Field) — varchar
- createdAt (Field5) — DATETIME
- updatedAt (Field6) — DATETIME
Schedule (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- theater_id (Key3) — BIGINT — Foreign key → Theater.theater_id — NOT NULL
- musical_id (Key2) — BIGINT — Foreign key → Musical.id — NOT NULL
- startTime (Field) — DATETIME
- ticketOpen (Field2) — DATETIME
- createdAt (Field3) — DATETIME
- updatedAt (Field4) — DATETIME
- discount (Field5) — varchar
Seat (Untitled5)
- seat_id (Key) — BIGINT — Primary key — NOT NULL
- theater_id (Key2) — BIGINT — Foreign key → Theater.theater_id — NOT NULL
- column (Field2) — int
- row (Field3) — varchar
- createdAt (Field4) — DATETIME
- updatedAt (Field5) — DATETIME
- price (Field) — varchar
Theater (Untitled7)
- theater_id (Key) — BIGINT — Primary key — NOT NULL
- theater_name (Field) — varchar
- address (Field2) — varchar
- createdAt (Field4) — DATETIME
- updatedAt (Field5) — DATETIME
- floor (Field3) — varchar
Ticket (Untitled9)
- ticket_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (id) — BIGINT — Foreign key → User.id — NOT NULL
- schedule_id (Key2) — BIGINT — Foreign key → Schedule.id — NOT NULL
- seat_id (Key3) — BIGINT — Foreign key → Seat.seat_id — NOT NULL
- cancel (Field4) — varchar
- booked (Field5) — varchar
- createdAt (Field6) — DATETIME
- updatedAt (Field7) — DATETIME
- ticketTime (Field2) — TIMESTAMP
User (Untitled2)
- id — BIGINT — Primary key — NOT NULL
- loginId (Field10) — varchar
- password (Field) — varchar
- nickName (nickname) — varchar
- birthdate (Field2) — DATETIME
- phoneNo (Field3) — varchar
- role (Field6) — varchar
- createdAt (Field4) — DATETIME
- updatedAt (Field5) — DATETIME
- gender (Field7) — varchar
- email (Field8) — varchar
- point (Field9) — varchar