GOTI
Tables (33)
baseball_teams
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- ceo — varchar(255)
- director — varchar(255) — NOT NULL
- founded_year — integer — NOT NULL
- general_manager — varchar(255) — NOT NULL
- home_ground — varchar(255) — NOT NULL
- logo_url — varchar(255)
- office_address — varchar(255) — NOT NULL
- owner — varchar(255) — NOT NULL
- owner_agency — varchar(255)
- site_address — varchar(255) — NOT NULL
- sponsor — varchar(255) — NOT NULL
- team_code — varchar(255) — NOT NULL
- DO::character — varying
- KIW::character — varying
- HH::character — varying
- KT::character — varying
- SSG::character — varying
- KIA::character — varying
- LOT::character — varying
- NC::character — varying
- SS::character — varying)::text))
- team_name — varchar(255) — NOT NULL
- team_name_en — varchar(255) — NOT NULL
- zip_code — varchar(255) — NOT NULL
baseball_winner_histories
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- winning_year — integer — NOT NULL
- baseball_team_id — uuid — NOT NULL
escrow_accounts
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- buyer_id — uuid — NOT NULL
- escrow_amount — integer — NOT NULL
- escrow_status — varchar(255) — NOT NULL
- RELEASED::character — varying)::text))
- released_at — timestamp(6)
- seller_id — uuid — NOT NULL
- transaction_id — uuid — NOT NULL
game_schedules
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- away_team_id — uuid — NOT NULL
- home_team_id — uuid — NOT NULL
- league_type — varchar(255) — NOT NULL
- REGULAR::character — varying
- POSTSEASON::character — varying)::text))
- stadium_id — uuid — NOT NULL
- start_at — timestamp(6) — NOT NULL
game_seat_inventories
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- available_count — integer — NOT NULL
- blocked_count — integer — NOT NULL
- game_id — uuid — NOT NULL
- held_count — integer — NOT NULL
- seat_grade_id — uuid — NOT NULL
- sold_count — integer — NOT NULL
- total_count — integer — NOT NULL
game_statuses
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- away_team_score — integer — NOT NULL
- game_result — varchar(255) — NOT NULL
- HOME_WIN::character — varying
- AWAY_WIN::character — varying
- DRAW::character — varying
- CANCELLED::character — varying)::text))
- game_status — varchar(255) — NOT NULL
- IN_PROGRESS::character — varying
- SUSPENDED::character — varying
- RAIN_DELAY::character — varying
- RAIN_CANCELLED::character — varying
- CANCELLED::character — varying
- FINISHED::character — varying)::text))
- home_team_score — integer — NOT NULL
- game_schedule_id — uuid — NOT NULL
game_ticketing_statuses
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- status — varchar(255) — NOT NULL
- AVAILABLE::character — varying
- EXHAUSTED::character — varying
- TERMINATED::character — varying
- CANCELED::character — varying
- PAUSED::character — varying)::text))
- ticketing_end_at — timestamp(6) — NOT NULL
- ticketing_opened_at — timestamp(6) — NOT NULL
- game_schedule_id — uuid — NOT NULL
home_stadiums
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- type — varchar(255) — NOT NULL
- SECONDARY::character — varying)::text))
- baseball_team_id — uuid — NOT NULL
- stadium_id — uuid — NOT NULL
members
- id — uuid — NOT NULL
order_cancellation_items
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- cancelled_at — timestamp(6)
- fee_amount — integer — NOT NULL
- refund_amount — integer — NOT NULL
- cancellation_id — uuid — NOT NULL
- item_id — uuid — NOT NULL
order_cancellations
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- approved_at — timestamp(6)
- approved_by — uuid
- completed_at — timestamp(6)
- deny_reason_code — varchar(255)
- EXPIRED::character — varying
- NOT_REFUNDABLE::character — varying)::text))
- fee_amount_total — integer — NOT NULL
- idempotency_key — varchar(255) — NOT NULL
- refund_amount_total — integer — NOT NULL
- request_type — varchar(255) — NOT NULL
- USER_FULL::character — varying
- GAME_CANCELED::character — varying
- SCHEDULE_CHANGED::character — varying)::text))
- requested_by — uuid — NOT NULL
- status — varchar(255) — NOT NULL
- VALIDATED::character — varying
- APPROVAL_PENDING::character — varying
- REFUNDING::character — varying
- COMPLETED::character — varying
- FAILED::character — varying)::text))
- order_id — uuid — NOT NULL
order_items
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- item_status — varchar(255) — NOT NULL
- PAID::character — varying
- CANCELED::character — varying
- CANCEL_FAILED::character — varying)::text))
- ticket_price — integer — NOT NULL
- ticket_type — varchar(255) — NOT NULL
- order_id — uuid — NOT NULL
- seat_id — uuid — NOT NULL
orderers
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- email — varchar(255) — NOT NULL
- mobile — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- order_id — uuid — NOT NULL
orders
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- canceled_at — timestamp(6)
- confirmed_at — timestamp(6)
- member_id — uuid — NOT NULL
- order_number — varchar(255) — NOT NULL
- order_status — varchar(255) — NOT NULL
- CONFIRMED::character — varying
- CANCELED::character — varying
- PARTIALLY_CANCELED::character — varying)::text))
- total_amount — integer — NOT NULL
- total_quantity — integer — NOT NULL
- game_schedule_id — uuid — NOT NULL
payment_ledgers
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- buyer_fee — integer — NOT NULL
- net_profit — integer — NOT NULL
- order_id — uuid — NOT NULL
- payment_id — uuid — NOT NULL
- seller_fee — integer — NOT NULL
- settlement_amount — integer — NOT NULL
- total_amount — integer — NOT NULL
- vat — integer — NOT NULL
payments
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- cancellation_id — uuid
- failed_reason — text
- idempotency_key — varchar(255) — NOT NULL
- order_id — uuid — NOT NULL
- paid_at — timestamp(6)
- payment_amount — integer — NOT NULL
- payment_method — varchar(255)
- ACCOUNT_TRANSFER::character — varying)::text))
- payment_status — varchar(255) — NOT NULL
- SUCCESS::character — varying
- FAILED::character — varying
- CANCELED::character — varying)::text))
- payment_type — varchar(255) — NOT NULL
- REFUND::character — varying)::text))
- pg_provider — varchar(255)
- pg_tid — varchar(255)
resale_holds
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- expired_at — timestamp(6) — NOT NULL
- queue_token_jti — varchar(255) — NOT NULL
- released_at — timestamp(6)
- status — varchar(255) — NOT NULL
- RELEASED::character — varying)::text))
- user_id — uuid — NOT NULL
- listing_id — uuid — NOT NULL
resale_listings
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- available_status — varchar(255) — NOT NULL
- DISABLED::character — varying)::text))
- canceled_at — timestamp(6)
- daily_base_price — integer — NOT NULL
- game_id — uuid — NOT NULL
- grade_id — uuid — NOT NULL
- last_transaction_price — integer
- listed_at — timestamp(6) — NOT NULL
- listing_price — integer — NOT NULL
- listing_status — varchar(255) — NOT NULL
- HOLD::character — varying
- SOLD::character — varying
- SETTLED::character — varying
- CANCELED::character — varying)::text))
- seat_id — uuid — NOT NULL
- seat_info — varchar(255) — NOT NULL
- section_id — uuid — NOT NULL
- seller_id — uuid — NOT NULL
- sold_at — timestamp(6)
- ticket_id — uuid — NOT NULL
resale_orders
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- buyer_id — uuid — NOT NULL
- order_number — varchar(255) — NOT NULL
- order_status — varchar(255) — NOT NULL
- COMPLETED::character — varying)::text))
- total_amount — integer — NOT NULL
resale_price_histories
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- game_id — uuid — NOT NULL
- grade_id — uuid — NOT NULL
- seat_id — uuid — NOT NULL
- section_id — uuid — NOT NULL
- transaction_price — integer — NOT NULL
resale_restrictions
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- buy_blocked_until — timestamp(6)
- cancel_blocked_until — timestamp(6)
- daily_buy_count — integer — NOT NULL
- daily_cancel_count — integer — NOT NULL
- daily_sell_count — integer — NOT NULL
- game_buy_counts — jsonb
- game_cancel_counts — jsonb
- game_sell_counts — jsonb
- last_buy_at — timestamp(6)
- last_cancel_at — timestamp(6)
- last_sell_at — timestamp(6)
- resale_blocked_until — timestamp(6)
- user_id — uuid — NOT NULL
- version — bigint
resale_transactions
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- buyer_fee — integer — NOT NULL
- buyer_id — uuid — NOT NULL
- buyer_total — integer — NOT NULL
- confirmed_at — timestamp(6)
- escrow_id — uuid
- seller_fee — integer — NOT NULL
- seller_id — uuid — NOT NULL
- seller_total — integer — NOT NULL
- transaction_price — integer — NOT NULL
- transaction_status — varchar(255) — NOT NULL
- COMPLETED::character — varying)::text))
- listing_id — uuid — NOT NULL
- resale_order_id — uuid — NOT NULL
seat_grades
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- display_color_hex — varchar(255)
- name — varchar(255) — NOT NULL
- stadium_id — uuid — NOT NULL
seat_holds
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- expired_at — timestamp(6) — NOT NULL
- queue_token_jti — varchar(255) — NOT NULL
- released_at — timestamp(6)
- status — varchar(255) — NOT NULL
- RELEASED::character — varying)::text))
- user_id — uuid — NOT NULL
- game_schedule_id — uuid — NOT NULL
- seat_id — uuid — NOT NULL
seat_sections
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- capacity — integer — NOT NULL
- section_code — varchar(255) — NOT NULL
- stadium_id — uuid — NOT NULL
- grade_id — uuid — NOT NULL
seat_statuses
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- status — varchar(255) — NOT NULL
- HELD::character — varying
- SOLD::character — varying
- BLOCKED::character — varying)::text))
- game_schedule_id — uuid — NOT NULL
- seat_id — uuid — NOT NULL
seats
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- is_available — boolean — NOT NULL
- row_name — varchar(255) — NOT NULL
- seat_num — integer — NOT NULL
- section_id — uuid — NOT NULL
social_providers
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- email — varchar(255) — NOT NULL
- provider — varchar(255) — NOT NULL
- KAKAO::character — varying
- GOOGLE::character — varying)::text))
- provider_id — varchar(255) — NOT NULL
- member_id — uuid — NOT NULL
stadiums
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- city — varchar(255) — NOT NULL
- district — varchar(255) — NOT NULL
- latitude — numeric(10, 8) — NOT NULL
- location — varchar(255) — NOT NULL
- longitude — numeric(11, 8) — NOT NULL
- road_address — varchar(255) — NOT NULL
- seat_map_config — jsonb
- stadium_name — varchar(255) — NOT NULL
- total_seats — integer — NOT NULL
ticket_prices
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- day_type — varchar(255) — NOT NULL
- WEEKEND::character — varying)::text))
- match_type — varchar(255) — NOT NULL
- REGULAR::character — varying
- POST_SEASON::character — varying)::text))
- price — integer — NOT NULL
- ticket_type — varchar(255) — NOT NULL
- grade_id — uuid — NOT NULL
- policy_id — uuid — NOT NULL
ticket_pricing_policies
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- is_active — boolean — NOT NULL
- policy_end_at — date — NOT NULL
- policy_start_at — date — NOT NULL
- team_id — uuid — NOT NULL
tickets
- id — uuid — NOT NULL
- issued_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- game_date — timestamp(6)
- game_id — uuid — NOT NULL
- game_title — varchar(255)
- order_item_id — uuid — NOT NULL
- resale_enabled_status — varchar(255) — NOT NULL
- DISABLED::character — varying)::text))
- resale_price — integer
- resale_transaction_id — uuid
- seat_info — varchar(255) — NOT NULL
- ticket_number — varchar(255) — NOT NULL
- ticket_price — integer
- ticket_status — varchar(255) — NOT NULL
- USED::character — varying
- INVALID::character — varying
- RESALE_ISSUED::character — varying)::text))
- used_at — timestamp(6)
- user_email — varchar(255)
- user_id — uuid — NOT NULL
- user_nickname — varchar(255)
- user_phone — varchar(255)
users
- id — uuid — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- birth_date — date — NOT NULL
- gender — varchar(255) — NOT NULL
- FEMALE::character — varying
- UNKNOWN::character — varying)::text))
- mobile — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- role — varchar(255) — NOT NULL
- MEMBER::character — varying)::text))
- status — varchar(255) — NOT NULL
- SUSPENDED::character — varying
- DELETED::character — varying)::text))