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))