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 admin_notifications
* id : bigint(20) unsigned
* event_type : varchar(50)
* customer_user_id : int(10) unsigned
* customer_name : varchar(150)
* customer_phone : varchar(20)
* bill_id : int(10) unsigned
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* item_count : int(10) unsigned
* total_amount : decimal(15,2)
* title : varchar(180)
* message : varchar(500)
* target_url : varchar(255)
* created_at : datetime
* is_read : tinyint(1)
v mybill admin_push_subscriptions
* id : bigint(20) unsigned
* user_name : varchar(150)
* user_role : varchar(50)
* endpoint : text
* endpoint_hash : char(64)
* p256dh : text
* auth : text
* user_agent : varchar(255)
* device_label : varchar(120)
* is_active : tinyint(1)
* last_seen_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill baccarat_demo_bets
* id : bigint(20) unsigned
* player_id : bigint(20) unsigned
* round_no : bigint(20) unsigned
* side : enum('P','B','T')
* amount : decimal(15,2)
* status : enum('pending','win','lose')
* payout : decimal(15,2)
* created_at : datetime(3)
* settled_at : datetime(3)
v mybill baccarat_demo_players
* id : bigint(20) unsigned
* player_key : varchar(80)
* display_name : varchar(120)
* credit : decimal(15,2)
* created_at : datetime(3)
* updated_at : datetime(3)
v mybill baccarat_demo_rounds
* id : bigint(20) unsigned
* round_no : bigint(20) unsigned
* player_cards : varchar(255)
* banker_cards : varchar(255)
* player_score : tinyint(3) unsigned
* banker_score : tinyint(3) unsigned
* winner : enum('P','B','T')
* created_at : datetime(3)
v mybill baccarat_demo_state
* id : tinyint(3) unsigned
* round_no : bigint(20) unsigned
* phase : enum('betting','dealing','result')
* phase_started_at : datetime(3)
* betting_seconds : int(10) unsigned
* result_seconds : int(10) unsigned
* player_cards : varchar(255)
* banker_cards : varchar(255)
* player_score : tinyint(3) unsigned
* banker_score : tinyint(3) unsigned
* winner : enum('P','B','T')
* updated_at : datetime(3)
v mybill baccarat_wallet_demo_bets
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* round_no : bigint(20) unsigned
* side : enum('P','B','T')
* amount : decimal(15,2)
* status : enum('pending','win','lose')
* payout : decimal(15,2)
* created_at : datetime(3)
* settled_at : datetime(3)
v mybill bills
* id : int(11)
* customer : varchar(255)
* customer_user_id : int(10) unsigned
* customer_phone : varchar(20)
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* items : longtext
* total : decimal(10,2)
* date : date
* time : time
* created_by : varchar(100)
* created_at : timestamp
v mybill bill_items
* id : int(11)
* bill_ref_id : varchar(100)
* bill_id : int(11)
* number : varchar(50)
* type : varchar(100)
* amount : decimal(10,2)
v mybill customer_account_transactions
* id : int(10) unsigned
* customer_name : varchar(255)
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* transaction_type : enum('payment','opening_debt')
* amount : decimal(15,2)
* transaction_date : date
* note : varchar(255)
* created_by : varchar(100)
* created_at : timestamp
v mybill customer_bank_accounts
* id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* bank_code : varchar(30)
* bank_name : varchar(100)
* account_name : varchar(180)
* account_number : varchar(50)
* is_default : tinyint(1)
* status : enum('pending','verified','rejected','disabled')
* verified_at : datetime
* verified_by : varchar(150)
* created_at : datetime
* updated_at : datetime
v mybill customer_login_audit
* id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* phone : varchar(20)
* event_type : enum('login_success','login_failed','otp_requested','otp_verified','logout')
* ip_address : varchar(45)
* user_agent : varchar(255)
* created_at : datetime
v mybill customer_otp
* id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* phone : varchar(20)
* purpose : enum('register','login','reset_password','change_phone')
* provider : varchar(30)
* provider_token : varchar(255)
* provider_refno : varchar(50)
* otp_hash : varchar(255)
* expires_at : datetime
* attempts : tinyint(3) unsigned
* max_attempts : tinyint(3) unsigned
* sent_at : datetime
* verified_at : datetime
* used_at : datetime
* request_ip : varchar(45)
* created_at : datetime
v mybill customer_payment_status
* id : int(10) unsigned
* customer_name : varchar(255)
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* payment_status : enum('unpaid','paid')
* updated_at : timestamp
v mybill customer_users
* id : int(10) unsigned
* full_name : varchar(150)
* phone : varchar(20)
* profile_image : varchar(255)
* password_hash : varchar(255)
* phone_verified_at : datetime
* status : enum('pending','active','suspended')
* last_login_at : datetime
* created_at : datetime
* updated_at : datetime
v mybill customer_wallets
* id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* balance_available : decimal(15,2)
* balance_locked : decimal(15,2)
* currency : varchar(10)
* status : enum('active','suspended','closed')
* version_no : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v mybill lottery_draw_results_demo
* id : bigint(20) unsigned
* draw_date : date
* lottery_type : varchar(30)
* lottery_set : varchar(30)
* win_3_top : varchar(3)
* win_2_bottom : varchar(2)
* created_by : varchar(100)
* created_at : datetime(3)
* settled_at : datetime(3)
v mybill lottery_draw_settings
* id : int(10) unsigned
* draw_date : date
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* rate_2_full : decimal(12,2)
* rate_2_half : decimal(12,2)
* rate_3_straight : decimal(12,2)
* rate_3_tod : decimal(12,2)
* rate_4_straight : decimal(12,2)
* created_by : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v mybill lottery_half_numbers
* id : int(10) unsigned
* draw_date : date
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* number_kind : enum('2','3')
* number : varchar(3)
* created_by : varchar(100)
* created_at : timestamp
v mybill lottery_prize_payouts_demo
* id : bigint(20) unsigned
* draw_result_id : bigint(20) unsigned
* bill_id : bigint(20) unsigned
* item_index : int(11)
* wallet_user_id : bigint(20) unsigned
* customer_user_id : bigint(20)
* customer_name : varchar(255)
* number : varchar(20)
* bet_type : varchar(50)
* stake : decimal(15,2)
* rate_used : decimal(15,2)
* payout : decimal(15,2)
* is_half_pay : tinyint(1)
* created_at : datetime(3)
v mybill lottery_prize_payouts_demo_v2
* id : bigint(20) unsigned
* bill_id : bigint(20) unsigned
* customer_user_id : bigint(20) unsigned
* wallet_user_id : bigint(20) unsigned
* payout_amount : decimal(15,2)
* lottery_type : varchar(32)
* lottery_set : varchar(32)
* draw_date : date
* details_json : longtext
* created_at : datetime(3)
v mybill lottery_result_cache
* id : bigint(20) unsigned
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* draw_date : date
* raw_result : varchar(50)
* first_prize : varchar(6)
* three_top : varchar(3)
* two_bottom : varchar(2)
* source_name : varchar(150)
* source_url : varchar(500)
* fetched_at : timestamp
v mybill lottery_sale_overrides
* id : bigint(20) unsigned
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* sale_date : date
* status : enum('open','closed')
* open_time : time
* close_time : time
* note : varchar(255)
* updated_by : varchar(100)
* created_at : datetime
* updated_at : datetime
v mybill lottery_sale_schedules
* id : int(10) unsigned
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* display_name : varchar(100)
* schedule_mode : enum('days_of_month','weekdays')
* days_of_month : varchar(100)
* weekdays : varchar(50)
* open_time : time
* close_time : time
* timezone : varchar(64)
* is_enabled : tinyint(1)
* updated_by : varchar(100)
* created_at : datetime
* updated_at : datetime
v mybill lottery_settings_audit
* id : bigint(20) unsigned
* draw_date : date
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* snapshot_json : longtext
* created_by : varchar(100)
* created_at : timestamp
v mybill lottery_wallet_demo_orders
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* order_token : varchar(96)
* amount : decimal(15,2)
* status : enum('reserved','finalized','cancelled')
* bill_id : bigint(20)
* created_at : datetime(3)
* finalized_at : datetime(3)
* cancelled_at : datetime(3)
v mybill ml_audit
* id : bigint(20) unsigned
* actor : varchar(100)
* event : varchar(50)
* member_id : bigint(20) unsigned
* details : longtext
* created_at : datetime
v mybill ml_drafts
* id : bigint(20) unsigned
* member_id : bigint(20) unsigned
* event_key : varchar(100)
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* draw_date : date
* closes_at : datetime
* items_json : longtext
* quote_hash : char(64)
* gross_cents : bigint(20)
* discount_bps : int(11)
* discount_cents : bigint(20)
* net_cents : bigint(20)
* status : varchar(25)
* method : varchar(10)
* confirmed_at : datetime
* expires_at : datetime
* bill_id : bigint(20) unsigned
* verification_json : longtext
* created_at : datetime
v mybill ml_events
* event_key : varchar(100)
* member_line : varchar(64)
* payload : longtext
* status : varchar(20)
* attempts : int(11)
* last_error : varchar(500)
* created_at : datetime
v mybill ml_members
* id : bigint(20) unsigned
* line_user_id : varchar(64)
* display_name : varchar(150)
* full_name : varchar(150)
* phone : varchar(25)
* bank_name : varchar(100)
* bank_account : varchar(30)
* ledger_name : varchar(150)
* credit_approved : tinyint(4)
* credit_limit_cents : bigint(20)
* discount_bps : int(11)
* active : tinyint(4)
* selected_type : varchar(20)
* selected_set : varchar(20)
* current_draft : bigint(20) unsigned
* version : int(11)
* created_at : datetime
* updated_at : datetime
v mybill ml_outbox
* id : bigint(20) unsigned
* event_key : varchar(160)
* line_user_id : varchar(64)
* payload : longtext
* retry_key : char(36)
* status : varchar(20)
* attempts : int(11)
* last_error : varchar(500)
* created_at : datetime
v mybill ml_receipts
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* trans_ref : varchar(120)
* image_sha : char(64)
* storage_name : varchar(100)
* created_at : datetime
v mybill mybill_bill_settlements
* request_id : varchar(64)
* staff_id : bigint(20) unsigned
* payload_hash : char(64)
* bill_id : bigint(20) unsigned
* transaction_id : bigint(20) unsigned
* total_cents : bigint(20) unsigned
* paid_cents : bigint(20) unsigned
* due_cents : bigint(20) unsigned
* payment_mode : varchar(10)
* response_json : longtext
* created_at : timestamp
v mybill mybill_manual_result_entries
* id : bigint(20) unsigned
* draw_date : date
* lottery_type : varchar(20)
* lottery_set : varchar(20)
* result_json : longtext
* staff_id : bigint(20)
* staff_name : varchar(150)
* created_at : datetime
v mybill mybill_passkey_audit
* id : bigint(20) unsigned
* user_id : bigint(20)
* event : varchar(30)
* details : text
* created_at : datetime
v mybill mybill_passkey_credentials
* id : bigint(20) unsigned
* user_id : bigint(20)
* credential_hash : char(64)
* credential_id : blob
* public_key : text
* sign_count : bigint(20) unsigned
* label : varchar(80)
* password_tag : char(64)
* created_at : datetime
* last_used_at : datetime
* revoked_at : datetime
v mybill mybill_passkey_limits
* bucket_hash : char(64)
* window_id : bigint(20) unsigned
* hits : int(10) unsigned
v mybill mybill_passkey_users
* user_id : bigint(20)
* user_handle : binary(32)
v mybill payment_webhook_events
* id : bigint(20) unsigned
* provider : varchar(60)
* event_id : varchar(180)
* event_type : varchar(80)
* signature_valid : tinyint(1)
* processing_status : enum('received','processed','ignored','failed')
* related_type : varchar(40)
* related_id : bigint(20) unsigned
* http_headers : longtext
* payload : longtext
* error_message : varchar(1000)
* received_at : datetime
* processed_at : datetime
v mybill project_demo_mode
* id : tinyint(3) unsigned
* is_enabled : tinyint(1)
* enabled_at : datetime
* expires_at : datetime
* enabled_by : varchar(100)
* updated_at : datetime
v mybill staff_permissions
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* permission_key : varchar(50)
* allowed : tinyint(1)
* created_at : datetime
* updated_at : datetime
v mybill users
* id : int(11)
* username : varchar(100)
* password : varchar(255)
* name : varchar(255)
* role : varchar(50)
* created_at : timestamp
* user_id : varchar(100)
* status : varchar(20)
v mybill wallet_audit_log
* id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* admin_user : varchar(150)
* action_type : varchar(80)
* reference_type : varchar(40)
* reference_id : bigint(20) unsigned
* old_value : longtext
* new_value : longtext
* ip_address : varchar(64)
* user_agent : varchar(500)
* created_at : datetime
v mybill wallet_demo_accounts
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* wallet_type : enum('main','lottery','sports','baccarat','slots')
* balance : decimal(15,2)
* updated_at : datetime(3)
v mybill wallet_demo_transactions
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* from_wallet : enum('main','lottery','sports','baccarat','slots')
* to_wallet : enum('main','lottery','sports','baccarat','slots')
* amount : decimal(15,2)
* transaction_type : enum('seed','transfer','adjustment')
* note : varchar(255)
* created_at : datetime(3)
v mybill wallet_demo_users
* id : bigint(20) unsigned
* customer_user_id : bigint(20)
* user_key : varchar(80)
* display_name : varchar(120)
* created_at : datetime(3)
v mybill wallet_settings
* id : int(10) unsigned
* topup_enabled : tinyint(1)
* withdrawal_enabled : tinyint(1)
* min_topup : decimal(15,2)
* max_topup : decimal(15,2)
* min_withdrawal : decimal(15,2)
* max_withdrawal : decimal(15,2)
* max_withdrawals_per_day : int(10) unsigned
* withdrawal_requires_otp : tinyint(1)
* withdrawal_requires_verified_bank : tinyint(1)
* updated_by : varchar(150)
* updated_at : datetime
v mybill wallet_topup_requests
* id : bigint(20) unsigned
* topup_no : varchar(60)
* customer_user_id : int(10) unsigned
* wallet_id : bigint(20) unsigned
* amount : decimal(15,2)
* fee_amount : decimal(15,2)
* net_amount : decimal(15,2)
* payment_method : varchar(40)
* provider : varchar(60)
* provider_transaction_id : varchar(150)
* provider_reference : varchar(150)
* qr_payload : text
* qr_expires_at : datetime
* status : enum('pending','paid','expired','failed','cancelled')
* paid_at : datetime
* expired_at : datetime
* failed_at : datetime
* request_ip : varchar(64)
* user_agent : varchar(500)
* created_at : datetime
* updated_at : datetime
v mybill wallet_transactions
* id : bigint(20) unsigned
* wallet_id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* transaction_no : varchar(60)
* entry_type : varchar(40)
* direction : enum('credit','debit')
* amount : decimal(15,2)
* available_before : decimal(15,2)
* available_after : decimal(15,2)
* locked_before : decimal(15,2)
* locked_after : decimal(15,2)
* reference_type : varchar(40)
* reference_id : bigint(20) unsigned
* external_ref : varchar(150)
* note : varchar(500)
* created_by_type : enum('system','customer','admin','payment_provider')
* created_by : varchar(150)
* created_at : datetime
v mybill wallet_transaction_otp
* id : bigint(20) unsigned
* customer_user_id : int(10) unsigned
* purpose : enum('withdrawal','bank_change','high_value_action')
* reference_id : bigint(20) unsigned
* otp_hash : varchar(255)
* expires_at : datetime
* attempts : int(10) unsigned
* max_attempts : int(10) unsigned
* verified_at : datetime
* used_at : datetime
* request_ip : varchar(64)
* created_at : datetime
v mybill wallet_withdrawal_requests
* id : bigint(20) unsigned
* withdrawal_no : varchar(60)
* customer_user_id : int(10) unsigned
* wallet_id : bigint(20) unsigned
* bank_account_id : bigint(20) unsigned
* amount : decimal(15,2)
* fee_amount : decimal(15,2)
* net_amount : decimal(15,2)
* status : enum('pending','approved','processing','paid','rejected','cancelled','failed')
* customer_note : varchar(500)
* admin_note : varchar(500)
* approved_by : varchar(150)
* approved_at : datetime
* payout_provider : varchar(60)
* payout_transaction_id : varchar(150)
* payout_reference : varchar(150)
* paid_at : datetime
* rejected_at : datetime
* cancelled_at : datetime
* failed_at : datetime
* request_ip : varchar(64)
* user_agent : varchar(500)
* created_at : datetime
* updated_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship