test

Tables (50)

api_client

  • id — BIGINT
  • client_name — VARCHAR(100) — NOT NULL
  • client_key — VARCHAR(255) — NOT NULL
  • secret_key — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

cdn_resource

  • id — BIGINT
  • resource_name — VARCHAR(255) — NOT NULL
  • resource_url — VARCHAR(500) — NOT NULL
  • resource_type — VARCHAR(50)
  • file_size — BIGINT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

launch_apk_download

  • id — BIGINT
  • version — VARCHAR(20) — NOT NULL
  • download_url — VARCHAR(500) — NOT NULL
  • file_size — BIGINT
  • release_notes — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

launch_app_data

  • id — BIGINT
  • app_version — VARCHAR(20)
  • config_data — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

launch_data

  • id — BIGINT
  • preset_id — BIGINT
  • data_key — VARCHAR(255) — NOT NULL
  • data_value — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

launch_help_data

  • id — BIGINT
  • category — VARCHAR(100)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • order_num — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

launch_preset

  • id — BIGINT
  • preset_name — VARCHAR(100) — NOT NULL
  • preset_type — VARCHAR(50)
  • config_data — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

launch_preset_data

  • id — BIGINT
  • preset_id — BIGINT — NOT NULL
  • data_type — VARCHAR(50)
  • data_content — JSON
  • order_num — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

maintenance_configs

  • id — BIGINT
  • config_name — VARCHAR(100) — NOT NULL
  • config_value — TEXT
  • config_type — VARCHAR(50)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

maintenance_features

  • id — BIGINT
  • feature_name — VARCHAR(100) — NOT NULL
  • feature_status — ENUM('active','disabled','maintenance') — NOT NULL
  • maintenance_message — TEXT
  • start_time — DATETIME
  • end_time — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

maintenance_schedules

  • id — BIGINT
  • schedule_name — VARCHAR(100) — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • description — TEXT
  • status — ENUM('scheduled','in_progress','done','cancelled') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

member_notification_config

  • id — BIGINT
  • notification_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255)
  • message — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mold_tnmt

  • id — BIGINT
  • mold_name — VARCHAR(100) — NOT NULL
  • mold_type — VARCHAR(50)
  • config_data — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mold_tnmt_config

  • id — BIGINT
  • mold_id — BIGINT — NOT NULL
  • config_name — VARCHAR(100)
  • config_value — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mold_tnmt_level

  • id — BIGINT
  • mold_id — BIGINT — NOT NULL
  • level_number — INT — NOT NULL
  • level_name — VARCHAR(100)
  • requirements — JSON
  • rewards — JSON
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mold_tnmt_level_config

  • id — BIGINT
  • mold_level_id — BIGINT — NOT NULL
  • config_name — VARCHAR(100)
  • config_value — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mold_tnmt_prize

  • id — BIGINT
  • mold_id — BIGINT — NOT NULL
  • prize_type — VARCHAR(50)
  • prize_value — DECIMAL(15,2)
  • prize_description — TEXT
  • rank_from — INT
  • rank_to — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

multi_currency_value

  • id — BIGINT
  • currency_code — VARCHAR(10) — NOT NULL
  • base_value — DECIMAL(15,4)
  • exchange_rate — DECIMAL(10,6)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

multi_lang_resource

  • id — BIGINT
  • resource_key — VARCHAR(255) — NOT NULL
  • language_code — VARCHAR(10) — NOT NULL
  • resource_value — TEXT
  • category — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

player

  • player_id — VARCHAR(100)
  • player_name — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

prize_ticket

  • id — BIGINT
  • ticket_code — VARCHAR(100) — NOT NULL
  • prize_type — VARCHAR(50)
  • prize_value — DECIMAL(15,2)
  • status — ENUM('active','used','expired','void') — NOT NULL
  • issued_at — DATETIME
  • used_at — DATETIME
  • expires_at — DATETIME

template_tnmt_config

  • id — BIGINT
  • template_name — VARCHAR(100) — NOT NULL
  • config_data — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

template_tnmt_level_config

  • id — BIGINT
  • template_id — BIGINT — NOT NULL
  • level_number — INT — NOT NULL
  • config_data — JSON
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt

  • id — BIGINT
  • series_id — BIGINT
  • mold_id — BIGINT
  • tnmt_name — VARCHAR(255) — NOT NULL
  • tnmt_type — VARCHAR(50)
  • status — ENUM('pending','active','paused','completed','cancelled') — NOT NULL
  • start_time — DATETIME
  • end_time — DATETIME
  • buy_in_amount — DECIMAL(15,2)
  • prize_pool — DECIMAL(15,2)
  • max_players — INT
  • current_players — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_buy_in

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • player_id — VARCHAR(100)
  • buy_in_amount — DECIMAL(15,2)
  • transaction_id — VARCHAR(255)
  • status — ENUM('completed','pending','failed','refunded') — NOT NULL
  • created_at — DATETIME

tnmt_buy_in_refund

  • id — BIGINT
  • buy_in_id — BIGINT — NOT NULL
  • refund_amount — DECIMAL(15,2)
  • refund_reason — TEXT
  • transaction_id — VARCHAR(255)
  • status — ENUM('pending','processed','failed') — NOT NULL
  • processed_at — DATETIME
  • created_at — DATETIME

tnmt_config

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • config_name — VARCHAR(100)
  • config_value — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_cp_tx_failed

  • id — BIGINT
  • tnmt_id — BIGINT
  • player_id — VARCHAR(100)
  • transaction_data — JSON
  • error_message — TEXT
  • retry_count — INT
  • failed_at — DATETIME
  • last_retry_at — DATETIME

tnmt_create_schedule

  • id — BIGINT
  • schedule_name — VARCHAR(100)
  • tnmt_template_id — BIGINT
  • cron_expression — VARCHAR(100)
  • next_run_time — DATETIME
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_game_config

  • id — BIGINT
  • provider_id — BIGINT
  • game_id — VARCHAR(100)
  • config_data — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_game_provider

  • id — BIGINT
  • provider_name — VARCHAR(100) — NOT NULL
  • provider_code — VARCHAR(50)
  • api_endpoint — VARCHAR(500)
  • api_key — VARCHAR(255)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_game_session

  • id — BIGINT
  • tnmt_id — BIGINT
  • player_id — VARCHAR(100)
  • session_id — VARCHAR(255)
  • provider_id — BIGINT
  • game_id — VARCHAR(100)
  • start_time — DATETIME
  • end_time — DATETIME
  • status — ENUM('active','ended','error') — NOT NULL

tnmt_instant_player

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • player_id — VARCHAR(100) — NOT NULL
  • player_name — VARCHAR(255)
  • join_time — DATETIME
  • status — ENUM('active','left') — NOT NULL

tnmt_level

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • level_number — INT — NOT NULL
  • level_name — VARCHAR(100)
  • start_time — DATETIME
  • end_time — DATETIME
  • status — ENUM('pending','active','completed','cancelled') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_level_config

  • id — BIGINT
  • tnmt_level_id — BIGINT — NOT NULL
  • config_name — VARCHAR(100)
  • config_value — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_level_detail

  • id — BIGINT
  • tnmt_level_id — BIGINT — NOT NULL
  • detail_type — VARCHAR(50)
  • detail_data — JSON
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_player

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • player_id — VARCHAR(100) — NOT NULL
  • player_name — VARCHAR(255)
  • current_score — DECIMAL(15,2)
  • current_rank — INT
  • status — ENUM('active','eliminated','disqualified','completed') — NOT NULL
  • joined_at — DATETIME
  • eliminated_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL

tnmt_player_complete

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • player_id — VARCHAR(100) — NOT NULL
  • final_score — DECIMAL(15,2)
  • final_rank — INT
  • prize_won — DECIMAL(15,2)
  • completed_at — DATETIME

tnmt_player_prize

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • player_id — VARCHAR(100) — NOT NULL
  • prize_type — VARCHAR(50)
  • prize_value — DECIMAL(15,2)
  • rank_achieved — INT
  • awarded_at — DATETIME
  • status — ENUM('pending','approved','rejected','paid') — NOT NULL

tnmt_prize_table

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • rank_from — INT — NOT NULL
  • rank_to — INT — NOT NULL
  • prize_type — VARCHAR(50)
  • prize_value — DECIMAL(15,2)
  • percentage_of_pool — DECIMAL(5,2)
  • created_at — TIMESTAMP — NOT NULL

tnmt_provider_tx

  • id — BIGINT
  • tnmt_id — BIGINT
  • player_id — VARCHAR(100)
  • provider_id — BIGINT
  • transaction_id — VARCHAR(255)
  • tx_type — VARCHAR(50)
  • amount — DECIMAL(15,2)
  • status — ENUM('pending','processed','failed') — NOT NULL
  • created_at — DATETIME
  • processed_at — DATETIME

tnmt_provider_tx_error

  • id — BIGINT
  • provider_tx_id — BIGINT — NOT NULL
  • error_code — VARCHAR(50)
  • error_message — TEXT
  • retry_count — INT
  • created_at — DATETIME
  • last_retry_at — DATETIME

tnmt_provider_tx_ggvt

  • id — BIGINT
  • tnmt_id — BIGINT
  • transaction_id — VARCHAR(255)
  • tx_data — JSON
  • status — ENUM('pending','processed','failed') — NOT NULL
  • created_at — DATETIME
  • processed_at — DATETIME

tnmt_provider_tx_ggvt_player

  • id — BIGINT
  • ggvt_tx_id — BIGINT — NOT NULL
  • player_id — VARCHAR(100) — NOT NULL
  • player_data — JSON
  • created_at — TIMESTAMP — NOT NULL

tnmt_search_info

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • search_keywords — TEXT
  • category — VARCHAR(100)
  • tags — JSON
  • updated_at — TIMESTAMP — NOT NULL

tnmt_series

  • id — BIGINT
  • series_name — VARCHAR(255) — NOT NULL
  • series_type — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • total_events — INT
  • status — ENUM('active','inactive','archived') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_series_cm_line

  • id — BIGINT
  • tnmt_series_id — BIGINT — NOT NULL
  • line_number — INT — NOT NULL
  • line_content — TEXT
  • line_type — VARCHAR(50)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tnmt_settle

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • settlement_data — JSON
  • total_prize_distributed — DECIMAL(15,2)
  • settled_at — DATETIME
  • status — ENUM('pending','processing','completed','failed') — NOT NULL

tnmt_status_history

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • old_status — VARCHAR(20)
  • new_status — VARCHAR(20)
  • changed_by — VARCHAR(100)
  • change_reason — TEXT
  • changed_at — DATETIME

tnmt_wait_settle

  • id — BIGINT
  • tnmt_id — BIGINT — NOT NULL
  • settlement_type — VARCHAR(50)
  • priority — INT
  • scheduled_at — DATETIME
  • created_at — DATETIME
  • status — ENUM('waiting','processing','done','cancelled') — NOT NULL