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