goti-test

Tables (23)

escrow_accounts

  • id — BIGSERIAL
  • payment_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • hold_until — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • released_at — TIMESTAMPTZ

game_seat_inventory

  • id — BIGSERIAL
  • game_id — BIGINT — NOT NULL
  • seat_grade_id — BIGINT — NOT NULL
  • total_count — INT — NOT NULL
  • available_count — INT — NOT NULL
  • held_count — INT — NOT NULL
  • sold_count — INT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

game_seats

  • id — BIGSERIAL
  • game_id — BIGINT — NOT NULL
  • seat_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • held_by — BIGINT
  • held_until — TIMESTAMPTZ
  • version — BIGINT — NOT NULL — 낙관적

games

  • id — BIGSERIAL
  • stadium_id — BIGINT — Foreign key → stadiums.id — NOT NULL
  • home_team_id — BIGINT — NOT NULL
  • away_team_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • game_date — TIMESTAMPTZ — NOT NULL
  • gate_open_at — TIMESTAMPTZ
  • ticket_open_at — TIMESTAMPTZ — NOT NULL — 티켓
  • ticket_close_at — TIMESTAMPTZ
  • status — VARCHAR(20) — NOT NULL
  • total_seats — INT — NOT NULL
  • available_seats — INT — NOT NULL — 잔여
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

order_items

  • id — BIGSERIAL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • game_seat_id — BIGINT — NOT NULL
  • seat_info — VARCHAR(100) — NOT NULL
  • unit_price — INT — NOT NULL
  • discount_amount — INT — NOT NULL
  • final_price — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

order_limit_counter

  • game_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • order_count — INT — NOT NULL
  • max_allowed — INT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

orders

  • id — BIGSERIAL
  • order_number — VARCHAR(30) — NOT NULL
  • idempotency_key — VARCHAR(64) — NOT NULL — 중복
  • user_id — BIGINT — NOT NULL
  • game_id — BIGINT — NOT NULL
  • user_nickname — VARCHAR(50)
  • user_email — VARCHAR(100)
  • user_phone — VARCHAR(20)
  • game_title — VARCHAR(200)
  • game_date — TIMESTAMPTZ
  • queue_token_jti — VARCHAR(64)
  • total_amount — INT — NOT NULL
  • discount_amount — INT — NOT NULL
  • final_amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • confirmed_at — TIMESTAMPTZ
  • cancelled_at — TIMESTAMPTZ

payment_events

  • id — BIGSERIAL
  • event_type — VARCHAR(50) — NOT NULL
  • aggregate_id — BIGINT — NOT NULL
  • aggregate_type — VARCHAR(30) — NOT NULL — PAYMENT
  • payload — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING
  • created_at — TIMESTAMPTZ — NOT NULL
  • published_at — TIMESTAMPTZ

queue_entries

  • id — BIGSERIAL
  • game_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • user_nickname — VARCHAR(50)
  • is_verified — BOOLEAN — NOT NULL
  • position — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • entered_at — TIMESTAMPTZ — NOT NULL
  • activated_at — TIMESTAMPTZ
  • expired_at — TIMESTAMPTZ

queue_tokens

  • id — BIGSERIAL
  • jti — VARCHAR(64) — NOT NULL
  • game_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • issued_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • used_at — TIMESTAMPTZ

queue_user_snapshots

  • user_id — BIGINT
  • nickname — VARCHAR(50)
  • is_verified — BOOLEAN — NOT NULL
  • member_grade — VARCHAR(20) — NORMAL
  • ban_status — VARCHAR(20) — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

quiz_challenges

  • id — BIGSERIAL
  • game_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • question_type — VARCHAR(30) — NOT NULL
  • question_data — TEXT — NOT NULL
  • answer_hash — VARCHAR(64) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING
  • attempts — INT — NOT NULL
  • max_attempts — INT — NOT NULL
  • issued_at — TIMESTAMPTZ — NOT NULL
  • answered_at — TIMESTAMPTZ
  • expires_at — TIMESTAMPTZ — NOT NULL

refunds

  • id — BIGSERIAL
  • payment_id — BIGINT — NOT NULL
  • refund_number — VARCHAR(30) — NOT NULL
  • amount — INT — NOT NULL
  • reason — VARCHAR(500)
  • refund_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUESTED
  • requested_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

resale_listings

  • id — BIGSERIAL
  • ticket_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • game_id — BIGINT — NOT NULL
  • seat_info — VARCHAR(100) — NOT NULL
  • asking_price — INT — NOT NULL
  • min_price — INT — 최소
  • status — VARCHAR(20) — NOT NULL
  • listed_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL

resale_price_history

  • id — BIGSERIAL
  • game_id — BIGINT — NOT NULL
  • seat_grade_id — BIGINT — NOT NULL
  • avg_price — INT — NOT NULL
  • min_price — INT — NOT NULL
  • max_price — INT — NOT NULL
  • trade_count — INT — NOT NULL
  • recorded_date — DATE — NOT NULL

resale_transactions

  • id — BIGSERIAL
  • listing_id — BIGINT — Foreign key → resale_listings.id — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • trade_price — INT — NOT NULL
  • fee — INT — NOT NULL
  • payment_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

seat_holds

  • id — BIGSERIAL
  • game_seat_id — BIGINT — Foreign key → game_seats.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • queue_token_jti — VARCHAR(64) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • released_at — TIMESTAMPTZ

seat_sections

  • id — BIGSERIAL
  • seat_grade_id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • capacity — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

settlements

  • id — BIGSERIAL
  • escrow_id — BIGINT — Foreign key → escrow_accounts.id — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • fee — INT — NOT NULL
  • net_amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING
  • settled_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

stadiums

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • total_capacity — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

team_stadiums

  • id — BIGSERIAL
  • team_id — BIGINT — NOT NULL
  • stadium_id — BIGINT — Foreign key → stadiums.id — NOT NULL
  • is_home — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ticketing_user_cache

  • user_id — BIGINT
  • nickname — VARCHAR(50)
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • member_grade — VARCHAR(20)
  • updated_at — TIMESTAMPTZ — NOT NULL

tickets

  • id — BIGSERIAL
  • ticket_number — VARCHAR(30) — NOT NULL
  • order_item_id — BIGINT — Foreign key → order_items.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • game_id — BIGINT — NOT NULL
  • user_nickname — VARCHAR(50)
  • user_email — VARCHAR(100)
  • user_phone — VARCHAR(20)
  • game_title — VARCHAR(200)
  • game_date — TIMESTAMPTZ
  • seat_info — VARCHAR(100) — NOT NULL
  • qr_code — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • issued_at — TIMESTAMPTZ — NOT NULL
  • used_at — TIMESTAMPTZ