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