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)