Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 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)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship