everyticket

Tables (6)

Bookings

  • BIGINT (id) — Primary key — NOT NULL
  • BIGINT (user_id)
  • BIGINT (schedule_id)
  • VARCHAR (booking_number)
  • VARCHAR (status)
  • DATETIME (created_at)
  • DATETIME (updated_at)

Payments

  • BIGINT (id) — Primary key — NOT NULL
  • BIGINT (booking_id)
  • VARCHAR (payment_method)
  • INT (amount)
  • VARCHAR (status)
  • DATETIME (created_at)
  • DATETIME (updated_at)
  • VARCHAR (pg_transaction_id)

Performances

  • BIGINT (id) — Primary key — NOT NULL
  • VARCHAR (title)
  • VARCHAR (venue)
  • VARCHAR (description)
  • VARCHAR (category)
  • DATETIME (created_at)
  • DATETIME (updated_at)

Schedules

  • BIGINT (id) — Primary key — NOT NULL
  • BIGINT (performance_id)
  • DATETIME (show_date)
  • DATETIME (show_time)
  • DATETIME (created_at)
  • DATETIME (updated_at)

Seats

  • BIGINT (id) — Primary key — NOT NULL
  • BIGINT (schedule_id)
  • VARCHAR (seat_grade)
  • VARCHAR (seat_number)
  • INT (price)
  • DATETIME (created_at)
  • DATETIME (updated_at)
  • VARCHAR (status)

User

  • BIGINT (id) — Primary key — NOT NULL
  • VARCHAR (email)
  • VARCHAR (name)
  • VARCHAR (phone)
  • VARCHAR (password)
  • DATETIME (created_at)
  • DATETIME (updated_at)