SeatRush
Tables (9)
concert_schedules
- schedule_id — BIGINT — Primary key
- concert_id — BIGINT — Foreign key → concerts.concert_id — NOT NULL
- started_at — TIMESTAMPTZ — NOT NULL
- ended_at — TIMESTAMPTZ — NOT NULL
- ticket_opened_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
concerts
- concert_id — BIGINT — Primary key
- title — VARCHAR(100) — NOT NULL
- artist_name — VARCHAR(100) — NOT NULL
- venue_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
notifications
- notification_id — BIGSERIAL — Primary key
- user_id — BIGINT — NOT NULL
- type — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- sent_at — TIMESTAMPTZ
- failed_at — TIMESTAMPTZ
payments
- payment_id — BIGSERIAL
- reservation_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- payment_method — VARCHAR(30)
- failure_reason — VARCHAR(255)
- requested_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
- failed_at — TIMESTAMPTZ
- canceled_at — TIMESTAMPTZ
reservation_seats
- reservation_seat_id — BIGSERIAL — Primary key
- reservation_id — BIGINT — Foreign key → reservations.reservation_id — NOT NULL
- seat_id — BIGINT — NOT NULL
- price — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
reservations
- reservation_id — BIGSERIAL — Primary key
- user_id — BIGINT — NOT NULL
- schedule_id — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- total_price — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- confirmed_at — TIMESTAMPTZ
- canceled_at — TIMESTAMPTZ
- expired_at — TIMESTAMPTZ
seat_sections
- section_id — BIGINT — Primary key
- schedule_id — BIGINT — Foreign key → concert_schedules.schedule_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- floor — INT — NOT NULL
- total_seats — INT — NOT NULL
seat_statuses
- seat_status_id — BIGSERIAL — Primary key
- seat_id — BIGSERIAL — Foreign key → seats.seat_id
- schedule_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- reservation_id — BIGINT
- user_id — BIGINT
- held_at — TIMESTAMPTZ
- sold_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ — NOT NULL
seats
- seat_id — BIGINT — Primary key
- schedule_id — BIGINT — NOT NULL
- section_id — BIGINT — NOT NULL
- row_name — VARCHAR(10) — NOT NULL
- seat_number — INT — NOT NULL
- price — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL