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