concert

Tables (8)

balance

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • amount — int
  • last_updated_at — datetime

concert

  • id — int — Primary key — NOT NULL
  • title — string
  • description — string

concert_schedule

  • id — int — Primary key — NOT NULL
  • concert_id — int — Foreign key → concert.id — NOT NULL
  • reservation_avilable_at — datetime
  • concert_at — datetime

payment

  • id — int — Primary key — NOT NULL
  • reservation_id — int — Foreign key → reservation.id — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • amount — int
  • payment_at — datetime

queue

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • waiting_id — int
  • status — string
  • created_at — datetime
  • entered_at — datetime
  • last_updated_at — datetime
  • token — string

reservation

  • id — int — Primary key — NOT NULL
  • seat_id — int — Foreign key → seat.id — NOT NULL
  • user_id — int
  • status — string
  • reservation_at — datetime

seat

  • id — int — Primary key — NOT NULL
  • concert_schedule_id — int — Foreign key → concert_schedule.id — NOT NULL
  • seat_number — int
  • status — string
  • seat_price — int

user

  • id — int — Primary key — NOT NULL
  • name — string