--- Tables ---
- activity_log
- admin_cold_wallets
- asset_update_log
- assets
- broker_applications
- chat_channels
- chat_messages
- crypto_deposits
- demo_fund_applications
- investment_campaigns
- investment_listings
- investment_opportunities
- investments
- joint_account_activity_log
- joint_account_invitations
- joint_account_members
- joint_account_transactions
- joint_accounts
- managers
- messages
- notifications
- partnership_accounts
- partnership_activity_log
- partnership_invitations
- partnership_members
- partnership_transactions
- payment_details
- payment_methods
- payment_requests
- payments
- pnl_history
- portfolio_assets
- portfolios
- refresh_tokens
- special_plans
- stock_suggestions
- support_messages
- support_tickets
- transactions
- user_activity
- user_activity_logs
- user_adoptions
- user_balances
- user_restrictions
- user_settings
- user_special_investments
- users
- wallets
- watchlist_assets
- watchlists
- withdrawal_requests

--- Columns (user_special_investments) ---
id | int(11) | NO | PRI |  | auto_increment
user_id | int(11) | NO | MUL |  | 
plan_id | int(11) | NO | MUL |  | 
amount | decimal(15,2) | NO |  |  | 
start_date | datetime | NO |  | current_timestamp() | 
end_date | datetime | YES |  |  | 
status | enum('active','completed','cancelled') | YES |  | active | 
accrued_profit | decimal(15,2) | YES |  | 0.00 | 
created_at | timestamp | NO |  | current_timestamp() | 
last_growth_update | timestamp | YES |  | current_timestamp() | 

--- Columns (users) ---
id | int(11)
email | varchar(255)
password_hash | varchar(255)
role | enum('user','manager','admin')
full_name | varchar(255)
avatar_url | varchar(255)
two_fa_secret | varchar(255)
two_fa_enabled | tinyint(1)
created_at | timestamp
updated_at | timestamp
account_type | varchar(32)
investment_management | varchar(32)
first_name | varchar(64)
last_name | varchar(64)
date_of_birth | date
country | varchar(8)
ssn | varchar(32)
nin | varchar(32)
sin | varchar(32)
tax_id | varchar(32)
passport_number | varchar(32)
address | varchar(255)
city | varchar(64)
state | varchar(64)
zip_code | varchar(16)
phone | varchar(32)
id_type | varchar(32)
id_number | varchar(64)
selfie_url | varchar(255)
referral_id | varchar(64)
agreed_to_terms | tinyint(1)
email_verified | tinyint(1)
verification_token | varchar(255)
magic_login_token | varchar(255)
magic_login_expires_at | datetime
funded_balance | decimal(15,2)
demo_balance | decimal(15,2)
demo_first_used_at | datetime
demo_created_at | timestamp
demo_notified | tinyint(1)
status | enum('active','suspended','pending','deleted')
last_login | timestamp
deleted_at | timestamp
admin_type | enum('alpha','limited')
approval_limit | decimal(15,2)
is_hidden | tinyint(1)
last_duplicate_check_at | timestamp
can_view_private_keys | tinyint(1)