将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
未命名 *
v 显示/隐藏表格列表 全屏查看 从其他数据库中添加表 新页面 打开页面 保存页面 保存页面为 删除页 新建数据表 创建关系 选择要显示的字段 重新载入 帮助 折角连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 显示/隐藏关系线 导出架构 > 移动菜单 > 固定文字
v v
数据表数量： 0
v mybill_v2 btw_astech_games
* game_id : varchar(120)
* title : varchar(255)
* provider : varchar(160)
* category : varchar(40)
* product : enum('baccarat','slots','sports','lottery')
* active : tinyint(1)
* updated_at : datetime
v mybill_v2 btw_astech_game_images
* game_id : varchar(120)
* image_url : varchar(2048)
* updated_at : datetime
v mybill_v2 btw_astech_sessions
* session_id : varchar(190)
* member_id : bigint(20) unsigned
* game_id : varchar(120)
* product : enum('baccarat','slots','sports','lottery')
* created_at : datetime
v mybill_v2 btw_astech_transactions
* transaction_id : varchar(190)
* member_id : bigint(20) unsigned
* product : enum('baccarat','slots','sports','lottery')
* game_id : varchar(120)
* round_id : varchar(190)
* status : enum('settled','rolled_back','cancelled_unknown')
* bet : decimal(14,2)
* win : decimal(14,2)
* balance_before : decimal(14,2)
* balance_after : decimal(14,2)
* rollback_balance : decimal(14,2)
* created_at : datetime
* rolled_back_at : datetime
v mybill_v2 btw_balance_mismatches
* id : bigint(20) unsigned
* current_transaction_id : varchar(190)
* previous_transaction_id : varchar(190)
* member_id : bigint(20) unsigned
* product : varchar(32)
* game_id : varchar(120)
* previous_balance : decimal(14,2)
* current_balance_before : decimal(14,2)
* raw_gap : decimal(14,2)
* transfer_delta : decimal(14,2)
* rollback_delta : decimal(14,2)
* unexplained_delta : decimal(14,2)
* previous_at : datetime
* current_at : datetime
* first_seen_at : datetime
* last_seen_at : datetime
v mybill_v2 btw_bonus_awards
* id : bigint(20) unsigned
* rule_id : bigint(20) unsigned
* beneficiary_id : bigint(20) unsigned
* source_member_id : bigint(20) unsigned
* deposit_ledger_id : bigint(20) unsigned
* base_amount : decimal(14,2)
* bonus_amount : decimal(14,2)
* balance_before : decimal(14,2)
* balance_after : decimal(14,2)
* approved_by : bigint(20) unsigned
* approved_at : datetime
v mybill_v2 btw_bonus_locked_awards
* id : bigint(20) unsigned
* rule_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* source_member_id : bigint(20) unsigned
* deposit_ledger_id : bigint(20) unsigned
* base_amount : decimal(14,2)
* bonus_amount : decimal(14,2)
* approved_by : bigint(20) unsigned
* created_at : datetime
* expires_at : datetime
v mybill_v2 btw_bonus_milestone_state
* rule_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* paid_cycles : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 btw_bonus_rules
* id : bigint(20) unsigned
* name : varchar(120)
* kind : enum('referral_first','referral_every_deposit','first_deposit','deposit_milestone')
* mode : enum('percent','fixed')
* value : decimal(12,2)
* minimum_deposit : decimal(12,2)
* threshold_amount : decimal(14,2)
* max_bonus : decimal(12,2)
* is_active : tinyint(1)
* starts_at : datetime
* ends_at : datetime
* deleted_at : datetime
* created_by : bigint(20)
* updated_by : bigint(20)
* created_at : datetime
* updated_at : datetime
* auto_enabled : tinyint(1)
* no_end : tinyint(1)
v mybill_v2 btw_bonus_wallets
* member_id : bigint(20) unsigned
* balance : decimal(14,2)
v mybill_v2 btw_callback_events
* id : bigint(20) unsigned
* game_id : varchar(120)
* member_id : bigint(20) unsigned
* cmd : varchar(32)
* callback_status : varchar(16)
* round_id : varchar(190)
* transaction_id : varchar(190)
* bet : decimal(18,2)
* win : decimal(18,2)
* response_cash : decimal(18,2)
* created_at : datetime
v mybill_v2 btw_casino_transfers
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* direction : enum('main_to_casino','casino_to_main')
* amount : decimal(14,2)
* main_before : decimal(14,2)
* main_after : decimal(14,2)
* casino_before : decimal(14,2)
* casino_after : decimal(14,2)
* client_nonce : char(32)
* created_at : datetime
v mybill_v2 btw_casino_wallets
* member_id : bigint(20) unsigned
* balance : decimal(14,2)
* updated_at : datetime
v mybill_v2 btw_deposit_accounts
* id : bigint(20) unsigned
* bank_name : varchar(100)
* bank_account : varchar(60)
* account_holder : varchar(150)
* active : tinyint(1)
* sort_order : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v mybill_v2 btw_deposit_attempts
* id : bigint(20) unsigned
* request_id : bigint(20) unsigned
* upload_nonce : varchar(64)
* storage_name : varchar(90)
* mime_type : varchar(30)
* sha256 : char(64)
* ai_status : enum('pending','matches','attention','unavailable')
* ai_result : longtext
* ai_checked_at : datetime
* created_at : datetime
v mybill_v2 btw_deposit_rotation
* id : tinyint(3) unsigned
* last_account_id : bigint(20) unsigned
v mybill_v2 btw_deposit_slips
* request_id : bigint(20) unsigned
* storage_name : varchar(90)
* mime_type : varchar(30)
* sha256 : char(64)
* ai_status : enum('pending','matches','attention','unavailable')
* ai_result : text
* ai_checked_at : datetime
* created_at : datetime
v mybill_v2 btw_finance_admins
* id : bigint(20) unsigned
* username : varchar(80)
* password_hash : varchar(255)
* active : tinyint(1)
* created_at : datetime
* role : enum('owner','staff')
v mybill_v2 btw_finance_admin_sessions
* id : bigint(20) unsigned
* admin_id : bigint(20) unsigned
* signed_in_at : datetime
* last_seen_at : datetime
* signed_out_at : datetime
* end_reason : varchar(30)
v mybill_v2 btw_finance_audit
* id : bigint(20) unsigned
* admin_id : bigint(20) unsigned
* session_id : bigint(20) unsigned
* action : varchar(60)
* target_type : varchar(40)
* target_id : bigint(20) unsigned
* details : longtext
* created_at : datetime
v mybill_v2 btw_finance_migrations
* name : varchar(80)
* applied_at : datetime
v mybill_v2 btw_finance_settings
* id : tinyint(3) unsigned
* deposit_enabled : tinyint(1)
* deposit_auto_credit : tinyint(1)
* bank_name : varchar(100)
* bank_account : varchar(60)
* account_holder : varchar(150)
* updated_at : datetime
v mybill_v2 btw_football_matches
* id : bigint(20) unsigned
* external_id : varchar(120)
* source_system : varchar(80)
* sport_id : varchar(32)
* league_id : varchar(120)
* league_name : varchar(255)
* region_code : varchar(32)
* region_name : varchar(255)
* home_id : varchar(120)
* home_name : varchar(255)
* away_id : varchar(120)
* away_name : varchar(255)
* kickoff_at : datetime
* status : varchar(40)
* minute_label : varchar(80)
* home_score : int(11)
* away_score : int(11)
* first_half_home : int(11)
* first_half_away : int(11)
* last_seen_live_at : datetime
* finished_at : datetime
* raw_updated_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_football_thai_aliases
* id : bigint(20) unsigned
* alias_type : varchar(30)
* source_text : varchar(255)
* context_text : varchar(255)
* thai_text : varchar(255)
* is_active : tinyint(1)
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_fund_ledger
* id : bigint(20) unsigned
* request_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* kind : enum('deposit','withdraw')
* amount : decimal(14,2)
* balance_before : decimal(14,2)
* balance_after : decimal(14,2)
* admin_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 btw_fund_requests
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* kind : enum('deposit','withdraw')
* wallet_source : enum('main','referral_commission')
* amount : decimal(14,2)
* status : enum('awaiting_payment','pending','approved','rejected','expired')
* reference_code : varchar(100)
* bank_name : varchar(100)
* bank_account : varchar(60)
* account_holder : varchar(150)
* member_note : varchar(500)
* admin_note : varchar(500)
* client_nonce : char(32)
* reviewed_by : bigint(20) unsigned
* reviewed_at : datetime
* created_at : datetime
* deposit_expires_at : datetime
v mybill_v2 btw_game_health
* game_id : varchar(120)
* provider : varchar(60)
* health_status : enum('online','maintenance','checking')
* consecutive_failures : int(10) unsigned
* consecutive_successes : int(10) unsigned
* last_http_code : int(11)
* last_error_code : varchar(120)
* last_error_message : varchar(500)
* last_failure_at : datetime
* last_success_at : datetime
* last_check_at : datetime
* maintenance_since : datetime
* next_check_at : datetime
* updated_at : datetime
v mybill_v2 btw_game_health_alert_queue
* id : bigint(20) unsigned
* game_id : varchar(120)
* event_type : enum('maintenance','recovered')
* event_sequence : bigint(20) unsigned
* recipient : varchar(64)
* payload : longtext
* retry_key : varchar(36)
* status : enum('pending','processing','retry','sent','blocked')
* attempts : int(10) unsigned
* first_attempt_at : datetime
* next_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* error_message : varchar(500)
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_game_health_alert_state
* game_id : varchar(120)
* observed_state : enum('online','maintenance')
* event_sequence : bigint(20) unsigned
* changed_at : datetime
* updated_at : datetime
v mybill_v2 btw_game_terms_acceptances
* id : bigint(20) unsigned
* member_id : bigint(20)
* terms_version_id : bigint(20) unsigned
* category_at_acceptance : varchar(20)
* accepted_at : datetime
v mybill_v2 btw_game_terms_draft
* id : tinyint(3) unsigned
* title : varchar(160)
* body : mediumtext
* updated_by : bigint(20)
* updated_at : datetime
v mybill_v2 btw_game_terms_entry_acceptances
* id : bigint(20) unsigned
* member_id : bigint(20)
* terms_version_id : bigint(20) unsigned
* category : varchar(20)
* accepted_at : datetime
v mybill_v2 btw_game_terms_versions
* id : bigint(20) unsigned
* version : int(10) unsigned
* title : varchar(160)
* body : mediumtext
* content_sha256 : char(64)
* is_active : tinyint(1)
* published_by : bigint(20)
* published_at : datetime
v mybill_v2 btw_game_transfers
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* product : enum('slots','sports','lottery')
* direction : enum('main_to_game','game_to_main')
* amount : decimal(14,2)
* main_before : decimal(14,2)
* main_after : decimal(14,2)
* game_before : decimal(14,2)
* game_after : decimal(14,2)
* client_nonce : char(32)
* created_at : datetime
v mybill_v2 btw_game_wallets
* member_id : bigint(20) unsigned
* product : enum('slots','sports','lottery')
* balance : decimal(14,2)
* updated_at : datetime
v mybill_v2 btw_health_alerts
* id : bigint(20) unsigned
* alert_key : varchar(190)
* severity : enum('warning','error')
* title : varchar(255)
* details : text
* first_seen_at : datetime
* last_seen_at : datetime
* occurrence_count : int(10) unsigned
* resolved_at : datetime
v mybill_v2 btw_health_runs
* id : bigint(20) unsigned
* checked_at : datetime
* overall_status : enum('healthy','warning','error')
* apache_status : varchar(16)
* mysql_status : varchar(16)
* astech_status : varchar(16)
* callback_status : varchar(16)
* db_error_status : varchar(16)
* pending_round_status : varchar(16)
* details_json : longtext
v mybill_v2 btw_lottery_customer_notifications
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* slip_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* event_type : varchar(50)
* title : varchar(200)
* message : varchar(500)
* payout_cents : bigint(20) unsigned
* target_url : varchar(255)
* seen_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_lottery_health_alert_queue
* id : bigint(20) unsigned
* issue_key : varchar(100)
* event_type : enum('problem','recovered')
* event_sequence : bigint(20) unsigned
* recipient : varchar(64)
* payload : longtext
* retry_key : char(36)
* status : enum('pending','processing','retry','sent','blocked')
* attempts : int(10) unsigned
* first_attempt_at : datetime
* next_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* error_message : varchar(500)
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_lottery_health_alert_state
* issue_key : varchar(100)
* issue_title : varchar(150)
* active : tinyint(1)
* event_sequence : bigint(20) unsigned
* last_detail : text
* changed_at : datetime
* updated_at : datetime
v mybill_v2 btw_lottery_notice_config
* id : tinyint(3) unsigned
* historical_max_id : bigint(20) unsigned
v mybill_v2 btw_lottery_notice_receipts
* admin_id : bigint(20) unsigned
* evidence_id : bigint(20) unsigned
* read_at : datetime
* sound_at : datetime
v mybill_v2 btw_lottery_notification_queue
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* event_type : varchar(100)
* channel : enum('admin_event','admin')
* recipient : varchar(100)
* payload : text
* retry_key : char(36)
* status : enum('pending','processing','retry','sent','blocked')
* attempts : int(10) unsigned
* next_attempt_at : datetime
* first_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* error_message : varchar(500)
* created_at : datetime
v mybill_v2 btw_lottery_referral_commissions
* id : bigint(20) unsigned
* payment_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* order_no : varchar(64)
* channel_id : varchar(32)
* line_user_id : varchar(64)
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* payment_amount : decimal(14,2)
* commission_rate : decimal(7,4)
* commission_amount : decimal(14,2)
* payment_reference : varchar(191)
* commission_ledger_id : bigint(20) unsigned
* status : enum('paid','reversed')
* created_at : datetime
* reversed_at : datetime
v mybill_v2 btw_lottery_referral_settings
* id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* is_enabled : tinyint(4)
* commission_rate : decimal(7,4)
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_member_bank_accounts
* member_id : bigint(20) unsigned
* slot : tinyint(3) unsigned
* bank_name : varchar(100)
* account_number : varchar(60)
* account_holder : varchar(150)
* updated_at : datetime
v mybill_v2 btw_member_bank_events
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* slot : tinyint(3) unsigned
* action : varchar(12)
* account_last4 : varchar(4)
* created_at : datetime
v mybill_v2 btw_member_presence
* session_key : char(64)
* member_id : bigint(20)
* last_seen : datetime
v mybill_v2 btw_member_referrals
* id : bigint(20) unsigned
* referred_member_id : bigint(20)
* referrer_member_id : bigint(20)
* source : varchar(20)
* created_by_admin : bigint(20)
* created_at : datetime
v mybill_v2 btw_native_lottery_cancel_reviews
* id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* reason : varchar(120)
* detail : varchar(500)
* status : varchar(20)
* created_at : datetime
* resolved_at : datetime
v mybill_v2 btw_native_lottery_draws
* id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* opens_at : datetime
* closes_at : datetime
* status : varchar(20)
* result_raw : varchar(6)
* result_bottom : varchar(2)
* result_top4 : varchar(4)
* result_top3 : varchar(3)
* result_top2 : varchar(2)
* result_bottom2 : varchar(2)
* confirmed_at : datetime
* created_at : datetime
v mybill_v2 btw_native_lottery_history
* id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* source_url : varchar(255)
* source_sha256 : char(64)
* payload_json : longtext
* status : varchar(20)
* fetched_at : datetime
* confirmed_by : bigint(20) unsigned
* confirmed_at : datetime
v mybill_v2 btw_native_lottery_live_evidence
* id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* raw_result : varchar(6)
* video_id : varchar(11)
* video_title : varchar(255)
* source_url : varchar(255)
* source_result_id : bigint(20) unsigned
* manifest_rel : varchar(255)
* evidence_status : varchar(30)
* created_at : datetime
v mybill_v2 btw_native_lottery_markets
* market_id : varchar(40)
* title : varchar(120)
* enabled : tinyint(1)
* betting_enabled : tinyint(1)
* created_at : datetime
v mybill_v2 btw_native_lottery_payouts
* id : bigint(20) unsigned
* line_id : bigint(20) unsigned
* slip_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* bet_type : varchar(20)
* number : varchar(4)
* stake_cents : bigint(20) unsigned
* rate : decimal(10,2)
* payout_cents : bigint(20) unsigned
* wallet_before : decimal(14,2)
* wallet_after : decimal(14,2)
* result_hash : char(64)
* created_at : datetime
v mybill_v2 btw_native_lottery_purchases
* slip_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* total_cents : bigint(20) unsigned
* balance_before : decimal(14,2)
* balance_after : decimal(14,2)
* quote_hash : char(64)
* lines_json : longtext
* created_at : datetime
v mybill_v2 btw_native_lottery_rates
* market_id : varchar(40)
* bet_type : varchar(20)
* payout_per_baht : decimal(10,2)
* updated_by : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 btw_native_lottery_recurrence
* market_id : varchar(40)
* frequency : varchar(12)
* schedule_values : varchar(100)
* open_time : char(5)
* close_time : char(5)
* updated_by : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 btw_native_lottery_refunds
* id : bigint(20) unsigned
* slip_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* refund_cents : bigint(20) unsigned
* wallet_before : decimal(14,2)
* wallet_after : decimal(14,2)
* reason : varchar(100)
* source_result_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 btw_native_lottery_source_control
* market_id : varchar(40)
* source_status : enum('missing','checking','ready')
* source_name : varchar(150)
* source_url : varchar(500)
* note : varchar(500)
* updated_by : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 btw_native_lottery_source_results
* id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* source_url : varchar(255)
* source_sha256 : char(64)
* payload_json : longtext
* status : varchar(20)
* fetched_at : datetime
* confirmed_by : bigint(20) unsigned
* confirmed_at : datetime
v mybill_v2 btw_native_lottery_test_lines
* id : bigint(20) unsigned
* slip_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* row_no : int(10) unsigned
* side : varchar(10)
* bet_type : varchar(20)
* number : varchar(4)
* stake_cents : bigint(20) unsigned
* result_status : varchar(20)
* checked_at : datetime
* result_hash : char(64)
v mybill_v2 btw_native_lottery_test_slips
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* request_id : varchar(64)
* payload_hash : char(64)
* created_at : datetime
v mybill_v2 btw_news
* id : bigint(20) unsigned
* title : varchar(160)
* body : mediumtext
* is_published : tinyint(1)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v mybill_v2 btw_payment_receipt_claims
* claim_key : char(64)
* owner_domain : varchar(16)
* owner_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 btw_promotions
* id : bigint(20) unsigned
* title : varchar(160)
* description : text
* terms : text
* is_published : tinyint(1)
* sort_order : int(11)
* starts_at : datetime
* ends_at : datetime
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v mybill_v2 btw_provider_controls
* provider_key : varchar(80)
* status : enum('online','watch','paused','reconciling')
* auto_monitor : tinyint(1)
* auto_pause : tinyint(1)
* reason : varchar(255)
* updated_by : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 btw_provider_control_audit
* id : bigint(20) unsigned
* provider_key : varchar(80)
* old_status : varchar(20)
* new_status : varchar(20)
* reason : varchar(255)
* source : enum('admin','system')
* admin_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 btw_provider_readiness
* product : varchar(16)
* provider_names : varchar(500)
* sandbox_status : enum('unknown','confirmed','unavailable')
* docs_received : tinyint(1)
* catalogue_received : tinyint(1)
* thb_confirmed : tinyint(1)
* launch_tested : tinyint(1)
* balance_tested : tinyint(1)
* bet_win_tested : tinyint(1)
* rollback_tested : tinyint(1)
* reconciliation_tested : tinyint(1)
* provider_ids : text
* notes : text
* updated_by : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 btw_push_subscriptions
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* endpoint : text
* endpoint_hash : char(64)
* p256dh : varchar(255)
* auth_token : varchar(255)
* content_encoding : varchar(32)
* user_agent : varchar(500)
* active : tinyint(1)
* fail_count : int(10) unsigned
* last_success_at : datetime
* last_failure_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_referral_commission_ledger
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* entry_type : enum('credit','withdraw_approved','transfer_to_main','adjustment')
* amount : decimal(14,2)
* balance_before : decimal(14,2)
* balance_after : decimal(14,2)
* source_member_id : bigint(20) unsigned
* deposit_ledger_id : bigint(20) unsigned
* request_id : bigint(20) unsigned
* description : varchar(255)
* available_at : datetime
* created_at : datetime
v mybill_v2 btw_referral_commission_settings
* id : tinyint(3) unsigned
* withdrawal_enabled : tinyint(1)
* minimum_withdraw : decimal(14,2)
* hold_hours : int(10) unsigned
* updated_at : datetime
v mybill_v2 btw_referral_commission_transfers
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* amount : decimal(14,2)
* commission_before : decimal(14,2)
* commission_after : decimal(14,2)
* main_before : decimal(14,2)
* main_after : decimal(14,2)
* created_at : datetime
v mybill_v2 btw_referral_commission_wallets
* member_id : bigint(20) unsigned
* balance : decimal(14,2)
* earned_total : decimal(14,2)
* withdrawn_total : decimal(14,2)
* updated_at : datetime
v mybill_v2 btw_saihuay_catalog
* slug : varchar(120)
* lottery_name : varchar(190)
* provider_status : varchar(30)
* category : varchar(50)
* display_order : int(11)
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_saihuay_results
* id : bigint(20) unsigned
* source : varchar(30)
* group_name : varchar(100)
* lottery_name : varchar(190)
* slug : varchar(120)
* drawn_number : varchar(100)
* top3 : varchar(50)
* bottom2 : varchar(50)
* result_date : date
* result_time : varchar(20)
* schedule_text : varchar(100)
* result_status : enum('result','waiting','cancelled','unknown')
* raw_json : longtext
* first_seen_at : datetime
* updated_at : datetime
v mybill_v2 btw_saihuay_worker_state
* worker_id : varchar(40)
* last_api_at : datetime
* last_success_at : datetime
* last_http_code : int(11)
* last_error : varchar(500)
* last_rows : int(11)
* last_candidates : int(11)
* updated_at : datetime
v mybill_v2 btw_sports_referral_commissions
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* sports_customer_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* payment_amount : decimal(14,2)
* commission_rate : decimal(7,4)
* commission_amount : decimal(14,2)
* payment_reference : varchar(191)
* commission_ledger_id : bigint(20) unsigned
* status : enum('paid','reversed')
* created_at : datetime
* reversed_at : datetime
v mybill_v2 btw_sports_referral_settings
* id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* is_enabled : tinyint(1)
* commission_rate : decimal(7,4)
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_support_alert_recipients
* id : bigint(20) unsigned
* line_user_id : varchar(64)
* display_name : varchar(100)
* active : tinyint(1)
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_support_click_events
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* source : varchar(60)
* created_at : datetime
v mybill_v2 btw_support_messages
* id : bigint(20) unsigned
* session_id : bigint(20) unsigned
* line_user_id : varchar(64)
* line_message_id : varchar(64)
* direction : varchar(16)
* message_text : text
* created_at : datetime
v mybill_v2 btw_support_sessions
* id : bigint(20) unsigned
* line_user_id : varchar(64)
* member_id : bigint(20) unsigned
* state : varchar(32)
* topic : varchar(100)
* summary : text
* first_message : text
* last_message : text
* ai_turns : int(10) unsigned
* alerted_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 btw_withdraw_reviews
* id : bigint(20) unsigned
* request_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* requested_amount : decimal(14,2)
* main_balance : decimal(14,2)
* casino_balance : decimal(14,2)
* slots_balance : decimal(14,2)
* sports_balance : decimal(14,2)
* lottery_balance : decimal(14,2)
* older_pending_count : int(10) unsigned
* older_pending_amount : decimal(14,2)
* recent_activity_count : int(10) unsigned
* review_status : enum('passed','attention','failed')
* ai_state : enum('completed','unavailable')
* ai_summary : varchar(700)
* checks_json : longtext
* checked_at : datetime
* updated_at : datetime
v mybill_v2 demo_btw_native_lottery_draws
* id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* opens_at : datetime
* closes_at : datetime
* status : varchar(20)
* result_raw : varchar(6)
* result_bottom : varchar(2)
* result_top4 : varchar(4)
* result_top3 : varchar(3)
* result_top2 : varchar(2)
* result_bottom2 : varchar(2)
* confirmed_at : datetime
* created_at : datetime
v mybill_v2 demo_btw_native_lottery_source_results
* id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* source_url : varchar(255)
* source_sha256 : char(64)
* payload_json : longtext
* status : varchar(20)
* fetched_at : datetime
* confirmed_by : bigint(20) unsigned
* confirmed_at : datetime
v mybill_v2 demo_line_lottery_drafts
* id : bigint(20) unsigned
* line_user_id : varchar(80)
* market_id : varchar(40)
* raw_text : text
* parsed_json : longtext
* total_amount : decimal(12,2)
* status : varchar(40)
* payment_account_id : bigint(20) unsigned
* expected_bank_name : varchar(120)
* expected_account_no : varchar(80)
* expected_account_name : varchar(180)
* confirmed_at : datetime
* paid_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 demo_line_lottery_oa_drafts
* id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* draw_id : bigint(20) unsigned
* market_id : varchar(40)
* market_title : varchar(120)
* draw_date : date
* closes_at : datetime
* status : varchar(24)
* source_type : varchar(12)
* image_name : varchar(64)
* items_json : longtext
* total_amount : decimal(12,2)
* created_at : datetime
* confirmed_at : datetime
v mybill_v2 demo_line_lottery_oa_payments
* id : bigint(20) unsigned
* oa_draft_id : bigint(20) unsigned
* legacy_draft_id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* status : varchar(24)
* payment_deadline : datetime
* confirmed_at : datetime
* account_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* transaction_ref : varchar(190)
* verification_json : longtext
* paid_at : datetime
v mybill_v2 demo_line_lottery_oa_payment_queue
* id : bigint(20) unsigned
* event_key : varchar(100)
* channel : varchar(16)
* recipient : varchar(64)
* payload : longtext
* retry_key : char(36)
* status : varchar(16)
* next_attempt_at : datetime
* first_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* attempts : int(11)
* error_message : varchar(250)
v mybill_v2 demo_line_lottery_oa_payouts
* id : bigint(20) unsigned
* payment_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* order_no : varchar(64)
* channel_id : varchar(32)
* line_user_id : varchar(64)
* result_hash : char(64)
* reward_amount : decimal(18,2)
* status : varchar(24)
* claim_token_hash : char(64)
* claim_expires_at : datetime
* bank_name : varchar(180)
* bank_account : varchar(20)
* account_name : varchar(180)
* bank_received_at : datetime
* paid_slip_id : bigint(20) unsigned
* paid_by : bigint(20) unsigned
* paid_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 demo_line_lottery_oa_payout_audit
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* event_type : varchar(40)
* admin_id : bigint(20) unsigned
* details : longtext
* created_at : datetime
v mybill_v2 demo_line_lottery_oa_payout_image_claims
* sha256 : char(64)
* payout_id : bigint(20) unsigned
* slip_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 demo_line_lottery_oa_payout_slips
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* admin_id : bigint(20) unsigned
* storage_key : varchar(64)
* mime_type : varchar(40)
* size_bytes : int(10) unsigned
* sha256 : char(64)
* expected_hash : char(64)
* status : varchar(24)
* check_token : char(32)
* checking_at : datetime
* result_json : longtext
* reason : text
* verified_by : bigint(20) unsigned
* verified_at : datetime
* image_token_hash : char(64)
* image_expires_at : datetime
* created_at : datetime
v mybill_v2 demo_line_lottery_oa_results
* payment_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* channel_id : varchar(32)
* line_user_id : varchar(64)
* status : varchar(20)
* result_hash : char(64)
* source_ids : longtext
* result_json : longtext
* items_json : longtext
* stake_amount : decimal(12,2)
* reward_amount : decimal(18,2)
* payout_status : varchar(24)
* review_required : tinyint(4)
* review_reason : text
* settled_at : datetime
* checked_at : datetime
* updated_at : datetime
v mybill_v2 demo_line_lottery_orders
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* line_user_id : varchar(80)
* market_id : varchar(40)
* total_amount : decimal(12,2)
* payment_account_id : bigint(20) unsigned
* transaction_ref : varchar(190)
* confirmed_at : datetime
v mybill_v2 demo_line_lottery_order_lines
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* row_no : int(11)
* side : varchar(20)
* bet_type : varchar(30)
* number : varchar(10)
* amount : decimal(12,2)
v mybill_v2 line_lottery_aliases
* id : bigint(20) unsigned
* alias_type : varchar(30)
* alias_text : varchar(120)
* normalized_text : varchar(160)
* market_id : varchar(40)
* priority : int(11)
* enabled : tinyint(1)
* created_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_lottery_auto_cancellations
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* line_user_id : varchar(80)
* market_id : varchar(40)
* draw_id : bigint(20) unsigned
* previous_status : varchar(40)
* total_amount : decimal(12,2)
* closes_at : datetime
* cancelled_at : datetime
* push_status : varchar(20)
* push_sent_at : datetime
* push_error : varchar(255)
v mybill_v2 line_lottery_close_warnings
* id : bigint(20) unsigned
* line_user_id : varchar(80)
* market_id : varchar(40)
* draw_id : bigint(20) unsigned
* draft_count : int(11)
* draft_ids : varchar(1000)
* closes_at : datetime
* sent_at : datetime
v mybill_v2 line_lottery_drafts
* id : bigint(20) unsigned
* line_user_id : varchar(80)
* market_id : varchar(40)
* raw_text : text
* parsed_json : longtext
* total_amount : decimal(12,2)
* status : varchar(40)
* payment_account_id : bigint(20) unsigned
* expected_bank_name : varchar(120)
* expected_account_no : varchar(80)
* expected_account_name : varchar(180)
* confirmed_at : datetime
* paid_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_lottery_oa_drafts
* id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* draw_id : bigint(20) unsigned
* market_id : varchar(40)
* market_title : varchar(120)
* draw_date : date
* closes_at : datetime
* status : varchar(24)
* source_type : varchar(12)
* image_name : varchar(64)
* items_json : longtext
* total_amount : decimal(12,2)
* created_at : datetime
* confirmed_at : datetime
v mybill_v2 line_lottery_oa_draft_edits
* channel_id : varchar(32)
* line_user_id : varchar(64)
* draft_id : bigint(20) unsigned
* revision : char(16)
* row_no : int(10) unsigned
* created_at : datetime
v mybill_v2 line_lottery_oa_draft_events
* channel_id : varchar(32)
* event_id : varchar(100)
* response_json : longtext
* created_at : datetime
v mybill_v2 line_lottery_oa_draft_images
* id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* message_id : varchar(40)
* storage_name : varchar(64)
* sha256 : char(64)
* created_at : datetime
v mybill_v2 line_lottery_oa_ocr_examples
* id : bigint(20) unsigned
* market_id : varchar(40)
* input_text : text
* expected_json : longtext
* enabled : tinyint(4)
* created_by : bigint(20) unsigned
* created_at : datetime
v mybill_v2 line_lottery_oa_payments
* id : bigint(20) unsigned
* oa_draft_id : bigint(20) unsigned
* legacy_draft_id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* status : varchar(24)
* payment_deadline : datetime
* confirmed_at : datetime
* account_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* transaction_ref : varchar(190)
* verification_json : longtext
* paid_at : datetime
v mybill_v2 line_lottery_oa_payment_attempts
* id : bigint(20) unsigned
* payment_id : bigint(20) unsigned
* channel_id : varchar(32)
* message_id : varchar(100)
* storage_name : varchar(64)
* sha256 : char(64)
* mime_type : varchar(40)
* size_bytes : int(10) unsigned
* status : varchar(24)
* reason : text
* result_json : longtext
* image_token_hash : char(64)
* image_token_expires_at : datetime
* contacted_at : datetime
* admin_id : bigint(20) unsigned
* admin_note : text
* decided_at : datetime
* created_at : datetime
v mybill_v2 line_lottery_oa_payment_claims
* claim_key : char(64)
* payment_id : bigint(20) unsigned
v mybill_v2 line_lottery_oa_payment_queue
* id : bigint(20) unsigned
* event_key : varchar(100)
* channel : varchar(16)
* recipient : varchar(64)
* payload : longtext
* retry_key : char(36)
* status : varchar(16)
* next_attempt_at : datetime
* first_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* attempts : int(11)
* error_message : varchar(250)
v mybill_v2 line_lottery_oa_payouts
* id : bigint(20) unsigned
* payment_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* order_no : varchar(64)
* channel_id : varchar(32)
* line_user_id : varchar(64)
* result_hash : char(64)
* reward_amount : decimal(18,2)
* status : varchar(24)
* claim_token_hash : char(64)
* claim_expires_at : datetime
* bank_name : varchar(180)
* bank_account : varchar(20)
* account_name : varchar(180)
* bank_received_at : datetime
* paid_slip_id : bigint(20) unsigned
* paid_by : bigint(20) unsigned
* paid_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_lottery_oa_payout_audit
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* event_type : varchar(40)
* admin_id : bigint(20) unsigned
* details : longtext
* created_at : datetime
v mybill_v2 line_lottery_oa_payout_image_claims
* sha256 : char(64)
* payout_id : bigint(20) unsigned
* slip_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 line_lottery_oa_payout_slips
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* admin_id : bigint(20) unsigned
* storage_key : varchar(64)
* mime_type : varchar(40)
* size_bytes : int(10) unsigned
* sha256 : char(64)
* expected_hash : char(64)
* status : varchar(24)
* check_token : char(32)
* checking_at : datetime
* result_json : longtext
* reason : text
* verified_by : bigint(20) unsigned
* verified_at : datetime
* image_token_hash : char(64)
* image_expires_at : datetime
* created_at : datetime
v mybill_v2 line_lottery_oa_referral_bind_tokens
* token_hash : char(64)
* channel_id : varchar(32)
* member_id : bigint(20) unsigned
* expires_at : datetime
* used_at : datetime
* created_at : datetime
v mybill_v2 line_lottery_oa_referral_customers
* channel_id : varchar(32)
* line_user_id : varchar(64)
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* referral_token : char(48)
* referral_locked_at : datetime
* bound_at : datetime
* created_at : datetime
v mybill_v2 line_lottery_oa_referral_snapshots
* payment_id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* commission_rate : decimal(7,4)
* created_at : datetime
v mybill_v2 line_lottery_oa_results
* payment_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* draw_id : bigint(20) unsigned
* market_id : varchar(40)
* draw_date : date
* channel_id : varchar(32)
* line_user_id : varchar(64)
* status : varchar(20)
* result_hash : char(64)
* source_ids : longtext
* result_json : longtext
* items_json : longtext
* stake_amount : decimal(12,2)
* reward_amount : decimal(18,2)
* payout_status : varchar(24)
* review_required : tinyint(4)
* review_reason : text
* settled_at : datetime
* checked_at : datetime
* updated_at : datetime
v mybill_v2 line_lottery_oa_selections
* channel_id : varchar(32)
* line_user_id : varchar(64)
* draw_id : bigint(20) unsigned
* market_id : varchar(40)
* selected_at : datetime
v mybill_v2 line_lottery_oa_web_bindings
* nonce : char(32)
* payment_id : bigint(20) unsigned
* channel_id : varchar(32)
* line_user_id : varchar(64)
* status : varchar(16)
* storage_name : varchar(64)
* sha256 : char(64)
* mime_type : varchar(40)
* size_bytes : int(10) unsigned
* response_json : longtext
* created_at : datetime
v mybill_v2 line_lottery_orders
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* line_user_id : varchar(80)
* market_id : varchar(40)
* total_amount : decimal(12,2)
* payment_account_id : bigint(20) unsigned
* transaction_ref : varchar(190)
* confirmed_at : datetime
v mybill_v2 line_lottery_order_lines
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* row_no : int(11)
* side : varchar(20)
* bet_type : varchar(30)
* number : varchar(10)
* amount : decimal(12,2)
v mybill_v2 line_lottery_payment_accounts
* id : bigint(20) unsigned
* bank_code : varchar(30)
* bank_name : varchar(120)
* account_no : varchar(80)
* account_name : varchar(180)
* qr_image : varchar(255)
* is_active : tinyint(1)
* active_from : datetime
* active_until : datetime
* note : varchar(255)
* created_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_lottery_payment_account_audit
* id : bigint(20) unsigned
* account_id : bigint(20) unsigned
* admin_id : bigint(20) unsigned
* action : varchar(50)
* details_json : longtext
* created_at : datetime
v mybill_v2 line_lottery_payment_rotation
* id : tinyint(3) unsigned
* account_ids_json : text
* last_account_id : bigint(20) unsigned
v mybill_v2 line_lottery_qa
* id : bigint(20) unsigned
* category : varchar(50)
* intent_key : varchar(80)
* question_pattern : varchar(255)
* answer_template : text
* use_live_data : tinyint(1)
* priority : int(11)
* enabled : tinyint(1)
* created_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_lottery_sessions
* line_user_id : varchar(80)
* display_name : varchar(180)
* state : varchar(40)
* current_market_id : varchar(40)
* current_draft_id : bigint(20) unsigned
* last_message : text
* updated_at : datetime
* created_at : datetime
v mybill_v2 line_lottery_slips
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* line_user_id : varchar(80)
* image_message_id : varchar(100)
* transaction_ref : varchar(190)
* receiver_name : varchar(180)
* receiver_bank : varchar(120)
* receiver_account : varchar(100)
* amount : decimal(12,2)
* transferred_at : datetime
* easyslip_status : varchar(40)
* verification_status : varchar(40)
* easyslip_json : longtext
* reject_reason : varchar(255)
* created_at : datetime
* verified_at : datetime
v mybill_v2 line_registration_events
* id : bigint(20) unsigned
* line_user_id : varchar(64)
* line_message_id : varchar(64)
* event_type : varchar(30)
* raw_text : text
* extracted_json : longtext
* result_code : varchar(50)
* created_at : datetime
v mybill_v2 line_registration_identities
* line_user_id : varchar(64)
* member_id : bigint(20) unsigned
* phone : varchar(30)
* registration_method : varchar(30)
* phone_verified_at : datetime
* created_at : datetime
v mybill_v2 line_registration_outbox
* id : bigint(20) unsigned
* line_user_id : varchar(64)
* member_id : bigint(20) unsigned
* payload : mediumtext
* retry_key : char(36)
* state : varchar(20)
* attempts : int(10) unsigned
* next_attempt_at : datetime
* last_error : varchar(200)
* created_at : datetime
* sent_at : datetime
v mybill_v2 line_registration_sessions
* id : bigint(20) unsigned
* line_user_id : varchar(64)
* state : enum('collecting','waiting_otp','verified','completed','cancelled','error','referral_collecting')
* full_name : varchar(150)
* phone : varchar(20)
* email : varchar(254)
* supplied_line_id : varchar(100)
* referral_token : char(48)
* referrer_member_id : bigint(20) unsigned
* otp_provider : varchar(30)
* otp_token : varchar(255)
* otp_ref : varchar(100)
* otp_phone : varchar(20)
* otp_requested_at : datetime
* otp_verified_at : datetime
* otp_attempts : int(10) unsigned
* member_id : bigint(20) unsigned
* last_message : text
* created_at : datetime
* updated_at : datetime
* completed_at : datetime
* fallback_due_at : datetime
v mybill_v2 line_sports_admin_alerts
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* alert_type : enum('winner_verified','bank_info_received','payment_completed')
* message : text
* status : enum('pending','sent','failed')
* sent_at : datetime
* error_message : varchar(500)
* created_at : datetime
v mybill_v2 line_sports_customers
* id : bigint(20) unsigned
* line_user_id : varchar(100)
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* referral_token : varchar(100)
* customer_type : enum('guest','member')
* referral_locked_at : datetime
* created_at : datetime
* last_seen_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_deposit_claims
* claim_key : char(64)
* order_id : bigint(20) unsigned
* created_at : datetime
v mybill_v2 line_sports_deposit_reviews
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* line_message_id : varchar(100)
* status : enum('pending','approved','rejected','auto_passed')
* storage_key : varchar(100)
* mime_type : varchar(50)
* size_bytes : bigint(20) unsigned
* sha256 : char(64)
* reason : varchar(500)
* verification_json : longtext
* expected_json : longtext
* image_token_hash : char(64)
* image_token_expires_at : datetime
* admin_id : bigint(20) unsigned
* admin_note : varchar(500)
* manual_json : longtext
* created_at : datetime
* decided_at : datetime
v mybill_v2 line_sports_drafts
* id : bigint(20) unsigned
* line_user_id : varchar(100)
* status : enum('building','waiting_stake','awaiting_confirmation','confirmed','cancelled','expired')
* stake : decimal(14,2)
* combined_odds : decimal(18,6)
* potential_payout : decimal(14,2)
* created_at : datetime
* updated_at : datetime
* confirmed_at : datetime
v mybill_v2 line_sports_draft_items
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* fixture_id : bigint(20) unsigned
* odds_id : bigint(20) unsigned
* league_name : varchar(255)
* home_name : varchar(255)
* away_name : varchar(255)
* kickoff_at : datetime
* market_code : varchar(50)
* selection_code : varchar(50)
* selection_label : varchar(255)
* handicap : decimal(8,3)
* odds_snapshot : decimal(10,3)
* created_at : datetime
v mybill_v2 line_sports_main_lines
* id : bigint(20) unsigned
* fixture_id : bigint(20) unsigned
* market_code : varchar(50)
* selected_line : decimal(8,3)
* mode : enum('auto','manual')
* fallback_auto : tinyint(1)
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_match_results
* id : bigint(20) unsigned
* fixture_id : bigint(20) unsigned
* external_id : varchar(100)
* provider_status : varchar(20)
* settlement_state : enum('pending','confirmed','void','review')
* home_score_90 : int(11)
* away_score_90 : int(11)
* halftime_home : int(11)
* halftime_away : int(11)
* result_source : varchar(50)
* source_updated_at : datetime
* confirmed_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_notification_queue
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* event_type : varchar(100)
* channel : enum('customer','admin','admin_event')
* recipient : varchar(100)
* payload : text
* retry_key : char(36)
* status : enum('pending','processing','retry','sent','blocked')
* attempts : int(10) unsigned
* next_attempt_at : datetime
* first_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* error_message : varchar(500)
* created_at : datetime
v mybill_v2 line_sports_odds
* id : bigint(20) unsigned
* fixture_id : bigint(20) unsigned
* market_code : varchar(50)
* selection_code : varchar(50)
* selection_name_th : varchar(255)
* handicap : decimal(8,3)
* odds : decimal(10,3)
* status : enum('open','suspended','closed')
* source : varchar(50)
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_orders
* id : bigint(20) unsigned
* order_no : varchar(40)
* line_user_id : varchar(100)
* sports_customer_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* stake : decimal(14,2)
* combined_odds : decimal(18,6)
* potential_payout : decimal(14,2)
* settled_payout : decimal(14,2)
* status : enum('pending_payment','accepted','confirmed','waiting_result','settled_lose','waiting_payout','paid_out','void','rejected','settled','cancelled')
* payment_status : enum('unpaid','checking','paid','failed','expired')
* payment_expires_at : datetime
* paid_at : datetime
* payment_reference : varchar(120)
* created_at : datetime
* settled_at : datetime
v mybill_v2 line_sports_order_items
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* fixture_id : bigint(20) unsigned
* league_name : varchar(255)
* home_name : varchar(255)
* away_name : varchar(255)
* kickoff_at : datetime
* market_code : varchar(50)
* selection_code : varchar(50)
* selection_label : varchar(255)
* handicap : decimal(8,3)
* odds : decimal(10,3)
* result_status : enum('pending','win','lose','push','half_win','half_lose','void')
* settlement_multiplier : decimal(12,6)
* result_home_score : int(11)
* result_away_score : int(11)
* settled_at : datetime
* created_at : datetime
v mybill_v2 line_sports_payment_assignments
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* deposit_account_id : bigint(20) unsigned
* bank_name : varchar(120)
* bank_account : varchar(100)
* account_holder : varchar(180)
* expected_amount : decimal(14,2)
* expires_at : datetime
* status : enum('assigned','checking','attention','paid','expired')
* line_message_id : varchar(100)
* slip_sha256 : char(64)
* payment_reference : varchar(191)
* verified_amount : decimal(14,2)
* verification_json : longtext
* error_message : varchar(500)
* verified_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_payment_control
* id : tinyint(3) unsigned
* next_index : int(10) unsigned
* updated_at : datetime
v mybill_v2 line_sports_payouts
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* order_no : varchar(40)
* line_user_id : varchar(100)
* sports_customer_id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* referrer_member_id : bigint(20) unsigned
* stake : decimal(14,2)
* winning_amount : decimal(14,2)
* verification_status : enum('pending','passed','failed')
* first_check_at : datetime
* second_check_at : datetime
* status : enum('detected_win','verified_win','waiting_bank_info','waiting_admin_payment','paid','cancelled')
* bank_name : varchar(120)
* bank_account : varchar(100)
* account_name : varchar(180)
* recipient_full_name : varchar(180)
* bank_info_received_at : datetime
* admin_id : bigint(20) unsigned
* admin_note : varchar(500)
* approved_at : datetime
* paid_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_payout_ai_image_claims
* transaction_key : char(64)
* attachment_id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* claimed_at : datetime
v mybill_v2 line_sports_payout_attachments
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* admin_id : bigint(20) unsigned
* storage_key : varchar(100)
* original_name : varchar(180)
* mime_type : varchar(50)
* size_bytes : bigint(20) unsigned
* sha256 : char(64)
* expected_hash : char(64)
* verification_status : enum('pending','checking','passed','attention','error')
* trans_ref : varchar(180)
* transaction_key : char(64)
* result_json : longtext
* error_message : varchar(500)
* check_token : char(32)
* checking_at : datetime
* verified_by : bigint(20) unsigned
* verified_at : datetime
* created_at : datetime
v mybill_v2 line_sports_payout_audit
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* event_type : varchar(60)
* details : text
* created_at : datetime
v mybill_v2 line_sports_payout_image_tokens
* id : bigint(20) unsigned
* attachment_id : bigint(20) unsigned
* token_hash : char(64)
* expires_at : datetime
* revoked_at : datetime
* created_at : datetime
v mybill_v2 line_sports_payout_slip_claims
* transaction_key : char(64)
* attachment_id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* claimed_at : datetime
v mybill_v2 line_sports_payout_tokens
* id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* token_hash : char(64)
* revoked_at : datetime
* created_at : datetime
v mybill_v2 line_sports_result_observations
* fixture_id : bigint(20) unsigned
* result_hash : char(64)
* first_seen_at : datetime
* last_checked_at : datetime
* observation_count : int(10) unsigned
* review_reason : varchar(500)
* manual_override : tinyint(1)
* manual_admin_id : bigint(20) unsigned
* manual_note : varchar(500)
v mybill_v2 line_sports_sessions
* id : bigint(20) unsigned
* line_user_id : varchar(100)
* state : varchar(50)
* current_draft_id : bigint(20) unsigned
* current_league : varchar(255)
* current_page : int(11)
* last_message : text
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_settlement_issues
* order_id : bigint(20) unsigned
* reason : varchar(500)
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_settlement_records
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* payout_amount : decimal(14,2)
* proof : longtext
* proof_hash : char(64)
* review_required : tinyint(1)
* created_at : datetime
v mybill_v2 line_sports_simulation_queue
* id : bigint(20) unsigned
* test_id : bigint(20) unsigned
* payout_id : bigint(20) unsigned
* event_type : varchar(100)
* channel : enum('customer','admin','admin_event')
* recipient : varchar(100)
* payload : text
* retry_key : char(36)
* status : enum('pending','processing','retry','sent','blocked')
* attempts : int(10) unsigned
* next_attempt_at : datetime
* first_attempt_at : datetime
* locked_at : datetime
* sent_at : datetime
* error_message : varchar(500)
* created_at : datetime
v mybill_v2 line_sports_simulation_runs
* id : bigint(20) unsigned
* request_key : char(64)
* admin_id : bigint(20) unsigned
* line_user_id : varchar(100)
* amount : decimal(14,2)
* token_hash : char(64)
* expires_at : datetime
* status : enum('waiting_bank','bank_received','simulated_paid','cancelled')
* bank_name : varchar(120)
* bank_account : varchar(100)
* account_name : varchar(180)
* recipient_full_name : varchar(180)
* created_at : datetime
* bank_received_at : datetime
* simulated_paid_at : datetime
v mybill_v2 line_sports_slip_image_bindings
* line_message_id : varchar(128)
* line_user_id : varchar(64)
* order_id : bigint(20) unsigned
* event_ms : bigint(20) unsigned
* created_at : datetime
v mybill_v2 line_sports_slip_selections
* line_user_id : varchar(64)
* order_id : bigint(20) unsigned
* event_ms : bigint(20) unsigned
* updated_at : datetime
v mybill_v2 line_sports_team_aliases
* id : bigint(20) unsigned
* provider : varchar(40)
* provider_name : varchar(190)
* canonical_name : varchar(190)
* created_at : datetime
* updated_at : datetime
v mybill_v2 line_sports_web_tokens
* id : bigint(20) unsigned
* token : char(64)
* line_user_id : varchar(100)
* expires_at : datetime
* used_at : datetime
* created_at : datetime
v mybill_v2 lottery_draws
* id : bigint(20) unsigned
* lottery_type_id : int(10) unsigned
* draw_date : date
* draw_code : varchar(50)
* open_at : datetime
* close_at : datetime
* status : enum('scheduled','open','closed','resulted','cancelled')
* note : varchar(255)
* created_at : datetime
* updated_at : datetime
v mybill_v2 lottery_types
* id : int(10) unsigned
* code : varchar(30)
* name : varchar(100)
* category : varchar(50)
* sort_order : int(11)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v mybill_v2 members
* id : bigint(20) unsigned
* member_code : varchar(20)
* username : varchar(50)
* password_hash : varchar(255)
* full_name : varchar(150)
* phone : varchar(30)
* email : varchar(150)
* line_id : varchar(100)
* status : enum('active','suspended','disabled')
* credit_limit : decimal(14,2)
* created_at : datetime
* updated_at : datetime
v mybill_v2 member_passkeys
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* credential_hash : char(64)
* credential_id : text
* public_key : text
* sign_count : bigint(20) unsigned
* password_fingerprint : char(64)
* label : varchar(80)
* created_at : datetime
* last_used_at : datetime
* revoked_at : datetime
v mybill_v2 member_passkey_limits
* bucket_key : char(64)
* hits : int(10) unsigned
* expires_at : bigint(20)
v mybill_v2 member_passkey_users
* member_id : bigint(20) unsigned
* user_handle : varchar(64)
创建关系
FOREIGN KEY
on delete
on update
删除关系