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