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