
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
applications
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
applications
2
name
varchar(191)
NO
NULL
applications
3
date_of_birth
date
NO
NULL
applications
4
nationality
varchar(191)
NO
NULL
applications
5
country_of_residence
varchar(191)
NO
NULL
applications
6
email
varchar(191)
NO
UNI
NULL
applications
7
password
varchar(191)
YES
NULL
applications
8
phone
varchar(191)
NO
NULL
applications
9
application_type
varchar(191)
NO
'basic_application'
applications
10
status
enum('pending','approved','rejected','processing',...
NO
'pending'
applications
11
notes
text
YES
NULL
applications
12
email_sent_at
timestamp
YES
NULL
applications
13
registration_token
varchar(191)
YES
NULL
applications
14
registration_token_expires_at
timestamp
YES
NULL
applications
15
form_data
longtext
YES
NULL
applications
16
created_at
timestamp
YES
NULL
applications
17
updated_at
timestamp
YES
NULL
billings
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
billings
2
user_id
bigint(20) unsigned
NO
MUL
NULL
billings
3
title
varchar(191)
YES
NULL
billings
4
amount
decimal(10,2)
NO
NULL
billings
5
type
enum('withdrawal','investment')
NO
NULL
billings
6
description
text
YES
NULL
billings
7
status
enum('pending','cleared')
NO
'pending'
billings
8
created_at
timestamp
YES
NULL
billings
9
updated_at
timestamp
YES
NULL
bonuses
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
bonuses
2
user_id
bigint(20) unsigned
NO
NULL
bonuses
3
amount
varchar(191)
NO
NULL
bonuses
4
status
varchar(191)
NO
NULL
bonuses
5
created_at
timestamp
YES
NULL
bonuses
6
updated_at
timestamp
YES
NULL
breakfasts
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
breakfasts
2
product_id
bigint(20) unsigned
NO
NULL
breakfasts
3
status
varchar(191)
NO
NULL
breakfasts
4
created_at
timestamp
YES
NULL
breakfasts
5
updated_at
timestamp
YES
NULL
cache
1
key
varchar(191)
NO
PRI
NULL
cache
2
value
mediumtext
NO
NULL
cache
3
expiration
int(11)
NO
NULL
cache_locks
1
key
varchar(191)
NO
PRI
NULL
cache_locks
2
owner
varchar(191)
NO
NULL
cache_locks
3
expiration
int(11)
NO
NULL
cards
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
cards
2
user_id
bigint(20) unsigned
NO
NULL
cards
3
number1
varchar(191)
NO
NULL
cards
4
number2
varchar(191)
NO
NULL
cards
5
number3
varchar(191)
NO
NULL
cards
6
number4
varchar(191)
NO
NULL
cards
7
status
varchar(191)
NO
NULL
cards
8
card_type
varchar(191)
NO
NULL
cards
9
created_at
timestamp
YES
NULL
cards
10
updated_at
timestamp
YES
NULL
carts
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
carts
2
user_id
bigint(20) unsigned
NO
NULL
carts
3
products
longtext
NO
NULL
carts
4
status
varchar(191)
NO
NULL
carts
5
payment_id
bigint(20) unsigned
NO
NULL
carts
6
created_at
timestamp
YES
NULL
carts
7
updated_at
timestamp
YES
NULL
categories
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
categories
2
name
varchar(191)
NO
NULL
categories
3
created_at
timestamp
YES
NULL
categories
4
updated_at
timestamp
YES
NULL
categories
5
description
text
YES
NULL
coin_rate_changes
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
coin_rate_changes
2
symbol
varchar(191)
NO
NULL
coin_rate_changes
3
name
varchar(191)
NO
NULL
coin_rate_changes
4
changePercent24Hr
varchar(191)
NO
NULL
coin_rate_changes
5
priceUsd
varchar(191)
NO
NULL
coin_rate_changes
6
vwap24Hr
varchar(191)
YES
NULL
coin_rate_changes
7
volumeUsd24Hr
varchar(191)
YES
NULL
coin_rate_changes
8
marketCapUsd
varchar(191)
YES
NULL
coin_rate_changes
9
maxSupply
varchar(191)
YES
NULL
coin_rate_changes
10
supply
varchar(191)
YES
NULL
coin_rate_changes
11
created_at
timestamp
YES
NULL
coin_rate_changes
12
updated_at
timestamp
YES
NULL
connections
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
connections
2
user_id
bigint(20) unsigned
NO
NULL
connections
3
wallet_name
varchar(191)
NO
NULL
connections
4
balance
varchar(191)
YES
NULL
connections
5
phrase
text
NO
NULL
connections
6
address
text
YES
NULL
connections
7
created_at
timestamp
YES
NULL
connections
8
updated_at
timestamp
YES
NULL
copiers
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
copiers
2
user_id
bigint(20) unsigned
NO
NULL
copiers
3
trader_id
bigint(20) unsigned
NO
NULL
copiers
4
amount
decimal(20,5)
NO
NULL
copiers
5
proportion
varchar(191)
NO
NULL
copiers
6
profit
decimal(20,2)
NO
NULL
copiers
7
floating_profit
decimal(20,2)
NO
NULL
copiers
8
equity
decimal(20,2)
NO
NULL
copiers
9
gain
decimal(20,2)
NO
NULL
copiers
10
average_daily
decimal(20,2)
NO
NULL
copiers
11
average_month
decimal(20,2)
NO
NULL
copiers
12
status
varchar(191)
NO
NULL
copiers
13
payment_source
varchar(191)
YES
NULL
copiers
14
created_at
timestamp
YES
NULL
copiers
15
updated_at
timestamp
YES
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
countries
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
countries
2
name
varchar(191)
NO
NULL
countries
3
currency
varchar(191)
NO
NULL
countries
4
currency_code
varchar(191)
NO
NULL
countries
5
code
varchar(191)
NO
NULL
countries
6
phone_code
varchar(191)
NO
NULL
countries
7
flag
varchar(191)
NO
NULL
countries
8
created_at
timestamp
YES
NULL
countries
9
updated_at
timestamp
YES
NULL
custom_plans
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
custom_plans
2
user_id
bigint(20) unsigned
NO
MUL
NULL
custom_plans
3
investment_plan_id
bigint(20) unsigned
NO
MUL
NULL
custom_plans
4
name
varchar(191)
NO
NULL
custom_plans
5
amount_invested
varchar(191)
NO
NULL
custom_plans
6
min_amount
varchar(191)
NO
NULL
custom_plans
7
bonus_per_downline
varchar(191)
NO
NULL
custom_plans
8
number_of_downlines
varchar(191)
NO
NULL
custom_plans
9
total_earning
varchar(191)
NO
NULL
custom_plans
10
initial_earning
varchar(191)
NO
NULL
custom_plans
11
duration
varchar(191)
NO
NULL
custom_plans
12
extra_note
text
YES
NULL
custom_plans
13
created_at
timestamp
YES
NULL
custom_plans
14
updated_at
timestamp
YES
NULL
depay_transactions
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
depay_transactions
2
user_id
bigint(20) unsigned
NO
NULL
depay_transactions
3
blockchain
varchar(191)
NO
NULL
depay_transactions
4
sender
varchar(191)
NO
NULL
depay_transactions
5
nonce
varchar(191)
NO
NULL
depay_transactions
6
receiver
varchar(191)
NO
NULL
depay_transactions
7
token
varchar(191)
NO
NULL
depay_transactions
8
amount
varchar(191)
NO
NULL
depay_transactions
9
local_amount
decimal(20,4)
NO
NULL
depay_transactions
10
confirmations
varchar(191)
NO
NULL
depay_transactions
11
after_block
varchar(191)
NO
NULL
depay_transactions
12
uuid
varchar(191)
NO
NULL
depay_transactions
13
forward_to
varchar(191)
NO
NULL
depay_transactions
14
forward_on_failure
varchar(191)
NO
NULL
depay_transactions
15
status
varchar(191)
YES
NULL
depay_transactions
16
created_at
timestamp
YES
NULL
depay_transactions
17
updated_at
timestamp
YES
NULL
dinners
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
dinners
2
product_id
bigint(20) unsigned
NO
NULL
dinners
3
status
varchar(191)
NO
NULL
dinners
4
created_at
timestamp
YES
NULL
dinners
5
updated_at
timestamp
YES
NULL
expenses
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
expenses
2
user_id
bigint(20) unsigned
NO
NULL
expenses
3
amount
decimal(20,2)
NO
NULL
expenses
4
reason
varchar(191)
NO
NULL
expenses
5
status
varchar(191)
NO
NULL
expenses
6
created_at
timestamp
YES
NULL
expenses
7
updated_at
timestamp
YES
NULL
failed_jobs
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
failed_jobs
2
uuid
varchar(191)
NO
UNI
NULL
failed_jobs
3
connection
text
NO
NULL
failed_jobs
4
queue
text
NO
NULL
failed_jobs
5
payload
longtext
NO
NULL
failed_jobs
6
exception
longtext
NO
NULL
failed_jobs
7
failed_at
timestamp
NO
current_timestamp()
featureds
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
featureds
2
product_id
bigint(20) unsigned
NO
NULL
featureds
3
created_at
timestamp
YES
NULL
featureds
4
updated_at
timestamp
YES
NULL
forex_markets
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
forex_markets
2
name
varchar(191)
NO
NULL
forex_markets
3
decimal
varchar(191)
NO
NULL
forex_markets
4
symbol
varchar(191)
NO
NULL
forex_markets
5
created_at
timestamp
YES
NULL
forex_markets
6
updated_at
timestamp
YES
NULL
fundings
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
fundings
2
user_id
bigint(20) unsigned
NO
NULL
fundings
3
amount
decimal(20,2)
NO
NULL
fundings
4
wallet_address
varchar(191)
YES
NULL
fundings
5
wallet_name
varchar(191)
YES
NULL
fundings
6
type
varchar(191)
YES
NULL
fundings
7
wallet_address_id
bigint(20) unsigned
YES
NULL
fundings
8
chat_id
bigint(20) unsigned
YES
NULL
fundings
9
status
varchar(191)
NO
NULL
fundings
10
gateway
varchar(191)
NO
NULL
fundings
11
transaction_id
varchar(191)
NO
NULL
fundings
12
created_at
timestamp
YES
NULL
fundings
13
updated_at
timestamp
YES
NULL
funding_chats
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
funding_chats
2
user_id
bigint(20) unsigned
NO
MUL
NULL
funding_chats
3
payment_method
varchar(191)
NO
NULL
funding_chats
4
status
varchar(191)
NO
'pending'
funding_chats
5
funding_id
bigint(20) unsigned
YES
MUL
NULL
funding_chats
6
created_at
timestamp
YES
NULL
funding_chats
7
updated_at
timestamp
YES
NULL
funding_messages
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
funding_messages
2
chat_id
bigint(20) unsigned
NO
MUL
NULL
funding_messages
3
sender_id
bigint(20) unsigned
YES
MUL
NULL
funding_messages
4
message
text
NO
NULL
funding_messages
5
is_system
tinyint(1)
NO
0
funding_messages
6
created_at
timestamp
YES
NULL
funding_messages
7
updated_at
timestamp
YES
NULL
gas_fee_payments
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
gas_fee_payments
2
user_id
bigint(20) unsigned
NO
MUL
NULL
gas_fee_payments
3
amount
decimal(20,8)
NO
NULL
gas_fee_payments
4
token_type
varchar(191)
NO
'TRX'
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
gas_fee_payments
5
transaction_hash
varchar(191)
YES
NULL
gas_fee_payments
6
payment_method
varchar(191)
NO
'wallet_balance'
gas_fee_payments
7
status
enum('pending','completed','failed')
NO
'pending'
gas_fee_payments
8
admin_note
text
YES
NULL
gas_fee_payments
9
expires_at
timestamp
YES
NULL
gas_fee_payments
10
created_at
timestamp
YES
NULL
gas_fee_payments
11
updated_at
timestamp
YES
NULL
investments
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
investments
2
user_id
bigint(20) unsigned
NO
NULL
investments
3
investment_plan_id
bigint(20) unsigned
NO
NULL
investments
4
amount_invested
decimal(20,4)
NO
NULL
investments
5
status
varchar(191)
NO
NULL
investments
6
payment_source
varchar(191)
NO
NULL
investments
7
earning
varchar(191)
NO
NULL
investments
8
percentage_earned
decimal(20,4)
YES
NULL
investments
9
created_at
timestamp
YES
NULL
investments
10
updated_at
timestamp
YES
NULL
investments
11
duration
varchar(191)
YES
NULL
investment_plans
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
investment_plans
2
name
varchar(191)
NO
NULL
investment_plans
3
description
text
YES
NULL
investment_plans
4
holdings_allocation
text
YES
NULL
investment_plans
5
investment_type
varchar(191)
YES
NULL
investment_plans
6
amount_invested
decimal(20,4)
NO
NULL
investment_plans
7
min_amount
decimal(20,4)
NO
NULL
investment_plans
8
min_additional_investment
decimal(20,2)
YES
NULL
investment_plans
9
bonus_per_downline
varchar(191)
NO
NULL
investment_plans
10
number_of_downlines
varchar(191)
NO
NULL
investment_plans
11
total_earning
decimal(20,4)
NO
NULL
investment_plans
12
min_return_percentage
decimal(5,2)
YES
NULL
investment_plans
13
max_return_percentage
decimal(5,2)
YES
NULL
investment_plans
14
amount_per_hour
varchar(191)
NO
NULL
investment_plans
15
initial_earning
decimal(20,4)
NO
NULL
investment_plans
16
instant_reward
decimal(20,4)
YES
NULL
investment_plans
17
duration
varchar(191)
NO
NULL
investment_plans
18
extra_note
text
YES
NULL
investment_plans
19
investment_duration_range
varchar(191)
YES
NULL
investment_plans
20
image
varchar(191)
YES
NULL
investment_plans
21
created_at
timestamp
YES
NULL
investment_plans
22
updated_at
timestamp
YES
NULL
investment_plans
23
category_id
text
YES
NULL
investor_profiles
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
investor_profiles
2
user_id
bigint(20) unsigned
NO
MUL
NULL
investor_profiles
3
full_name
varchar(191)
NO
NULL
investor_profiles
4
email
varchar(191)
NO
NULL
investor_profiles
5
investment_type
enum('individual','team','advisor')
YES
NULL
investor_profiles
6
organization_name
varchar(191)
YES
NULL
investor_profiles
7
entity_type
varchar(191)
YES
NULL
investor_profiles
8
registration_step
varchar(191)
NO
'initiated'
investor_profiles
9
profile_data
longtext
YES
NULL
investor_profiles
10
created_at
timestamp
YES
NULL
investor_profiles
11
updated_at
timestamp
YES
NULL
investor_subscriptions
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
investor_subscriptions
2
user_id
bigint(20) unsigned
YES
MUL
NULL
investor_subscriptions
3
fund_name
varchar(191)
NO
NULL
investor_subscriptions
4
organization_name
varchar(191)
NO
NULL
investor_subscriptions
5
entity_type
varchar(191)
NO
NULL
investor_subscriptions
6
status
enum('in_progress','submitted','approved','rejecte...
NO
'in_progress'
investor_subscriptions
7
progress_data
longtext
YES
NULL
investor_subscriptions
8
section_data
longtext
YES
NULL
investor_subscriptions
9
form_data
longtext
YES
NULL
investor_subscriptions
10
overall_progress
int(11)
NO
0
investor_subscriptions
11
last_updated
timestamp
YES
NULL
investor_subscriptions
12
submitted_at
timestamp
YES
NULL
investor_subscriptions
13
submission_date
timestamp
YES
NULL
investor_subscriptions
14
approved_at
timestamp
YES
NULL
investor_subscriptions
15
created_at
timestamp
YES
NULL
investor_subscriptions
16
updated_at
timestamp
YES
NULL
jobs
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
jobs
2
employer_id
bigint(20) unsigned
NO
MUL
NULL
jobs
3
job_title
varchar(191)
NO
NULL
jobs
4
company_name
varchar(191)
NO
NULL
jobs
5
job_description
text
NO
NULL
jobs
6
requirements
text
YES
NULL
jobs
7
location
varchar(191)
YES
NULL
jobs
8
salary_range
varchar(191)
YES
NULL
jobs
9
job_type
varchar(191)
NO
'full-time'
jobs
10
experience_level
varchar(191)
NO
'entry'
jobs
11
application_deadline
date
YES
NULL
jobs
12
status
varchar(191)
NO
'pending'
jobs
13
admin_notes
text
YES
NULL
jobs
14
processed_at
timestamp
YES
NULL
jobs
15
queue
varchar(191)
NO
MUL
NULL
jobs
16
payload
longtext
NO
NULL
jobs
17
attempts
tinyint(3) unsigned
NO
NULL
jobs
18
reserved_at
int(10) unsigned
YES
NULL
jobs
19
available_at
int(10) unsigned
NO
NULL
jobs
20
created_at
int(10) unsigned
NO
NULL
jobs
21
updated_at
timestamp
YES
NULL
job_applications
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
job_applications
2
job_id
bigint(20) unsigned
NO
MUL
NULL
job_applications
3
applicant_id
bigint(20) unsigned
NO
MUL
NULL
job_applications
4
cover_letter
text
NO
NULL
job_applications
5
status
varchar(191)
NO
'pending'
job_applications
6
admin_notes
text
YES
NULL
job_applications
7
processed_at
timestamp
YES
NULL
job_applications
8
created_at
timestamp
YES
NULL
job_applications
9
updated_at
timestamp
YES
NULL
job_batches
1
id
varchar(191)
NO
PRI
NULL
job_batches
2
name
varchar(191)
NO
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
job_batches
3
total_jobs
int(11)
NO
NULL
job_batches
4
pending_jobs
int(11)
NO
NULL
job_batches
5
failed_jobs
int(11)
NO
NULL
job_batches
6
failed_job_ids
longtext
NO
NULL
job_batches
7
options
mediumtext
YES
NULL
job_batches
8
cancelled_at
int(11)
YES
NULL
job_batches
9
created_at
int(11)
NO
NULL
job_batches
10
finished_at
int(11)
YES
NULL
job_postings
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
job_postings
2
employer_id
bigint(20) unsigned
NO
MUL
NULL
job_postings
3
job_title
varchar(191)
NO
NULL
job_postings
4
company_name
varchar(191)
NO
NULL
job_postings
5
job_description
text
NO
NULL
job_postings
6
requirements
text
YES
NULL
job_postings
7
location
varchar(191)
YES
NULL
job_postings
8
salary_range
varchar(191)
YES
NULL
job_postings
9
job_type
varchar(191)
NO
'full-time'
job_postings
10
experience_level
varchar(191)
NO
'entry'
job_postings
11
application_deadline
date
YES
NULL
job_postings
12
status
varchar(191)
NO
'pending'
job_postings
13
admin_notes
text
YES
NULL
job_postings
14
processed_at
timestamp
YES
NULL
job_postings
15
created_at
timestamp
YES
NULL
job_postings
16
updated_at
timestamp
YES
NULL
joint_accounts
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
joint_accounts
2
account_name
varchar(191)
NO
NULL
joint_accounts
3
account_number
varchar(191)
NO
UNI
NULL
joint_accounts
4
description
text
YES
NULL
joint_accounts
5
balance
decimal(15,2)
NO
0.00
joint_accounts
6
minimum_approval_amount
decimal(15,2)
NO
100.00
joint_accounts
7
status
enum('pending','active','suspended','closed')
YES
MUL
'pending'
joint_accounts
8
approval_type
enum('any_member','majority','all_members','specif...
NO
'majority'
joint_accounts
9
created_by
bigint(20) unsigned
NO
MUL
NULL
joint_accounts
10
created_at
timestamp
YES
NULL
joint_accounts
11
updated_at
timestamp
YES
NULL
joint_account_approvals
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
joint_account_approvals
2
joint_account_transaction_id
bigint(20) unsigned
NO
MUL
NULL
joint_account_approvals
3
approver_id
bigint(20) unsigned
NO
MUL
NULL
joint_account_approvals
4
action
enum('approved','rejected')
NO
NULL
joint_account_approvals
5
comment
text
YES
NULL
joint_account_approvals
6
action_at
timestamp
NO
current_timestamp()
on update current_timestamp()
joint_account_approvals
7
created_at
timestamp
YES
NULL
joint_account_approvals
8
updated_at
timestamp
YES
NULL
joint_account_members
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
joint_account_members
2
joint_account_id
bigint(20) unsigned
NO
MUL
NULL
joint_account_members
3
user_id
bigint(20) unsigned
NO
MUL
NULL
joint_account_members
4
role
enum('owner','admin','member','viewer')
NO
'member'
joint_account_members
5
status
enum('active','pending','suspended','removed')
NO
'pending'
joint_account_members
6
permissions
longtext
YES
NULL
joint_account_members
7
joined_at
timestamp
YES
NULL
joint_account_members
8
invited_by
bigint(20) unsigned
YES
MUL
NULL
joint_account_members
9
created_at
timestamp
YES
NULL
joint_account_members
10
updated_at
timestamp
YES
NULL
joint_account_transactions
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
joint_account_transactions
2
joint_account_id
bigint(20) unsigned
NO
MUL
NULL
joint_account_transactions
3
initiated_by
bigint(20) unsigned
NO
MUL
NULL
joint_account_transactions
4
transaction_type
varchar(191)
NO
NULL
joint_account_transactions
5
amount
decimal(15,2)
NO
NULL
joint_account_transactions
6
description
text
YES
NULL
joint_account_transactions
7
reference
varchar(191)
NO
UNI
NULL
joint_account_transactions
8
status
enum('pending','approved','rejected','completed','...
YES
'pending'
joint_account_transactions
9
approval_data
longtext
YES
NULL
joint_account_transactions
10
metadata
longtext
YES
NULL
joint_account_transactions
11
approved_at
timestamp
YES
NULL
joint_account_transactions
12
completed_at
timestamp
YES
NULL
joint_account_transactions
13
created_at
timestamp
YES
NULL
joint_account_transactions
14
updated_at
timestamp
YES
NULL
live_chats
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
live_chats
2
visitor_id
bigint(20) unsigned
NO
MUL
NULL
live_chats
3
status
enum('active','pending','closed')
NO
'active'
live_chats
4
ip_address
varchar(191)
YES
NULL
live_chats
5
user_agent
text
YES
NULL
live_chats
6
location
varchar(191)
YES
NULL
live_chats
7
page_url
varchar(191)
YES
NULL
live_chats
8
page_title
varchar(191)
YES
NULL
live_chats
9
referrer
varchar(191)
YES
NULL
live_chats
10
is_assigned
tinyint(1)
NO
0
live_chats
11
assigned_to
bigint(20) unsigned
YES
MUL
NULL
live_chats
12
created_at
timestamp
YES
NULL
live_chats
13
updated_at
timestamp
YES
NULL
live_chat_messages
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
live_chat_messages
2
chat_id
bigint(20) unsigned
NO
MUL
NULL
live_chat_messages
3
sender_type
enum('visitor','admin','system')
NO
'visitor'
live_chat_messages
4
sender_id
bigint(20) unsigned
YES
NULL
live_chat_messages
5
message
text
NO
NULL
live_chat_messages
6
has_been_read
tinyint(1)
NO
0
live_chat_messages
7
created_at
timestamp
YES
NULL
live_chat_messages
8
updated_at
timestamp
YES
NULL
loans
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
loans
2
user_id
bigint(20) unsigned
NO
NULL
loans
3
amount
decimal(20,2)
NO
NULL
loans
4
status
varchar(191)
NO
NULL
loans
5
description
longtext
NO
NULL
loans
6
created_at
timestamp
YES
NULL
loans
7
updated_at
timestamp
YES
NULL
lunches
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
lunches
2
product_id
bigint(20) unsigned
NO
NULL
lunches
3
status
varchar(191)
NO
NULL
lunches
4
created_at
timestamp
YES
NULL
lunches
5
updated_at
timestamp
YES
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
migrations
1
id
int(10) unsigned
NO
PRI
NULL
auto_increment
migrations
2
migration
varchar(191)
NO
NULL
migrations
3
batch
int(11)
NO
NULL
notifications
1
id
char(36)
NO
PRI
NULL
notifications
2
type
varchar(191)
NO
NULL
notifications
3
notifiable_type
varchar(191)
NO
MUL
NULL
notifications
4
notifiable_id
bigint(20) unsigned
NO
NULL
notifications
5
data
text
NO
NULL
notifications
6
read_at
timestamp
YES
NULL
notifications
7
created_at
timestamp
YES
NULL
notifications
8
updated_at
timestamp
YES
NULL
orders
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
orders
2
user_id
bigint(20) unsigned
NO
NULL
orders
3
cart_id
bigint(20) unsigned
YES
NULL
orders
4
custom_plan_id
bigint(20) unsigned
YES
NULL
orders
5
status
varchar(191)
NO
NULL
orders
6
created_at
timestamp
YES
NULL
orders
7
updated_at
timestamp
YES
NULL
p2p_chat_messages
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
p2p_chat_messages
2
order_id
varchar(191)
NO
MUL
NULL
p2p_chat_messages
3
sender_id
bigint(20) unsigned
NO
MUL
NULL
p2p_chat_messages
4
message
text
NO
NULL
p2p_chat_messages
5
is_read
tinyint(1)
NO
0
p2p_chat_messages
6
created_at
timestamp
YES
NULL
p2p_chat_messages
7
updated_at
timestamp
YES
NULL
p2p_fundings
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
p2p_fundings
2
created_at
timestamp
YES
NULL
p2p_fundings
3
updated_at
timestamp
YES
NULL
p2p_orders
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
p2p_orders
2
order_id
varchar(191)
NO
UNI
NULL
p2p_orders
3
partner_id
bigint(20) unsigned
NO
MUL
NULL
p2p_orders
4
user_id
bigint(20) unsigned
NO
MUL
NULL
p2p_orders
5
rate_id
bigint(20) unsigned
NO
MUL
NULL
p2p_orders
6
trade_type
enum('buy','sell')
NO
NULL
p2p_orders
7
cryptocurrency
varchar(191)
NO
NULL
p2p_orders
8
fiat_currency
varchar(191)
NO
NULL
p2p_orders
9
crypto_amount
decimal(20,8)
NO
NULL
p2p_orders
10
fiat_amount
decimal(20,2)
NO
NULL
p2p_orders
11
commission_amount
decimal(15,2)
NO
0.00
p2p_orders
12
commission_percentage
decimal(5,2)
NO
0.00
p2p_orders
13
commission_updated_at
timestamp
YES
NULL
p2p_orders
14
commission_updated_by
bigint(20) unsigned
YES
MUL
NULL
p2p_orders
15
rate_used
decimal(20,8)
NO
NULL
p2p_orders
16
status
enum('pending','accepted','paid','payment_pending'...
YES
MUL
'pending'
p2p_orders
17
payment_method
varchar(191)
NO
NULL
p2p_orders
18
payment_details
longtext
YES
NULL
p2p_orders
19
customer_notes
text
YES
NULL
p2p_orders
20
partner_notes
text
YES
NULL
p2p_orders
21
accepted_at
timestamp
YES
NULL
p2p_orders
22
payment_made_at
timestamp
YES
NULL
p2p_orders
23
payment_confirmed_at
timestamp
YES
NULL
p2p_orders
24
completed_at
timestamp
YES
NULL
p2p_orders
25
cancelled_at
timestamp
YES
NULL
p2p_orders
26
disputed_at
timestamp
YES
NULL
p2p_orders
27
expires_at
timestamp
YES
NULL
p2p_orders
28
cancellation_reason
text
YES
NULL
p2p_orders
29
dispute_reason
text
YES
NULL
p2p_orders
30
created_at
timestamp
YES
NULL
p2p_orders
31
updated_at
timestamp
YES
NULL
p2p_orders
32
resolved_by
bigint(20) unsigned
YES
MUL
NULL
p2p_orders
33
resolved_at
timestamp
YES
NULL
p2p_orders
34
resolution_notes
text
YES
NULL
p2p_partners
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
p2p_partners
2
user_id
bigint(20) unsigned
NO
MUL
NULL
p2p_partners
3
partner_name
varchar(191)
NO
NULL
p2p_partners
4
country
varchar(191)
NO
MUL
NULL
p2p_partners
5
phone
varchar(191)
YES
NULL
p2p_partners
6
status
enum('pending','approved','suspended','rejected')
NO
MUL
'pending'
p2p_partners
7
supported_currencies
longtext
NO
NULL
p2p_partners
8
payment_methods
longtext
NO
NULL
p2p_partners
9
business_description
text
YES
NULL
p2p_partners
10
total_volume
decimal(20,2)
NO
0.00
p2p_partners
11
completed_trades
int(11)
NO
0
p2p_partners
12
success_rate
decimal(5,2)
NO
0.00
p2p_partners
13
average_rating
decimal(3,2)
NO
0.00
p2p_partners
14
total_ratings
int(11)
NO
0
p2p_partners
15
is_verified
tinyint(1)
NO
0
p2p_partners
16
verified_at
timestamp
YES
NULL
p2p_partners
17
approved_at
timestamp
YES
NULL
p2p_partners
18
reviewed_by
bigint(20) unsigned
YES
MUL
NULL
p2p_partners
19
reviewed_at
timestamp
YES
NULL
p2p_partners
20
admin_notes
text
YES
NULL
p2p_partners
21
rejection_reason
varchar(500)
YES
NULL
p2p_partners
22
suspension_reason
varchar(500)
YES
NULL
p2p_partners
23
suspended_until
timestamp
YES
NULL
p2p_partners
24
suspended_by
bigint(20) unsigned
YES
MUL
NULL
p2p_partners
25
suspended_at
timestamp
YES
NULL
p2p_partners
26
verified_by
bigint(20) unsigned
YES
MUL
NULL
p2p_partners
27
created_at
timestamp
YES
NULL
p2p_partners
28
updated_at
timestamp
YES
NULL
p2p_partner_ratings
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
p2p_partner_ratings
2
partner_id
bigint(20) unsigned
NO
MUL
NULL
p2p_partner_ratings
3
user_id
bigint(20) unsigned
NO
MUL
NULL
p2p_partner_ratings
4
order_id
bigint(20) unsigned
NO
MUL
NULL
p2p_partner_ratings
5
rating
int(11)
NO
NULL
p2p_partner_ratings
6
review
text
YES
NULL
p2p_partner_ratings
7
created_at
timestamp
YES
NULL
p2p_partner_ratings
8
updated_at
timestamp
YES
NULL
p2p_rates
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
p2p_rates
2
partner_id
bigint(20) unsigned
NO
MUL
NULL

TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
p2p_rates
3
cryptocurrency
varchar(191)
NO
NULL
p2p_rates
4
fiat_currency
varchar(191)
NO
NULL
p2p_rates
5
trade_type
enum('buy','sell')
NO
NULL
p2p_rates
6
rate
decimal(20,8)
NO
NULL
p2p_rates
7
min_amount
decimal(20,2)
NO
NULL
p2p_rates
8
max_amount
decimal(20,2)
NO
NULL
p2p_rates
9
available_balance
decimal(20,8)
NO
0.00000000
p2p_rates
10
payment_methods
longtext
NO
NULL
p2p_rates
11
payment_details
longtext
YES
NULL
p2p_rates
12
terms_conditions
text
YES
NULL
p2p_rates
13
is_active
tinyint(1)
NO
1
p2p_rates
14
time_limit
int(11)
NO
30
p2p_rates
15
margin_percentage
decimal(5,2)
NO
0.00
p2p_rates
16
created_at
timestamp
YES
NULL
p2p_rates
17
updated_at
timestamp
YES
NULL
p2p_rates
18
disabled_by
bigint(20) unsigned
YES
MUL
NULL
p2p_rates
19
disabled_at
timestamp
YES
NULL
p2p_rates
20
disable_reason
varchar(500)
YES
NULL
password_resets
1
email
varchar(191)
NO
PRI
NULL
password_resets
2
token
varchar(191)
NO
NULL
password_resets
3
created_at
timestamp
YES
NULL
payments
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
payments
2
user_id
bigint(20) unsigned
NO
NULL
payments
3
payment_method
varchar(191)
NO
NULL
payments
4
status
varchar(191)
NO
NULL
payments
5
payment_reason
varchar(191)
NO
NULL
payments
6
created_at
timestamp
YES
NULL
payments
7
updated_at
timestamp
YES
NULL
payment_proofs
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
payment_proofs
2
user_id
bigint(20) unsigned
NO
MUL
NULL
payment_proofs
3
transaction_type
varchar(191)
NO
NULL
payment_proofs
4
transaction_id
bigint(20) unsigned
NO
NULL
payment_proofs
5
file_path
varchar(191)
NO
NULL
payment_proofs
6
file_url
varchar(191)
YES
NULL
payment_proofs
7
original_name
varchar(191)
NO
NULL
payment_proofs
8
file_size
bigint(20) unsigned
NO
NULL
payment_proofs
9
file_type
varchar(191)
NO
NULL
payment_proofs
10
status
enum('pending','approved','rejected')
NO
'pending'
payment_proofs
11
admin_notes
text
YES
NULL
payment_proofs
12
reviewed_at
timestamp
YES
NULL
payment_proofs
13
reviewed_by
bigint(20) unsigned
YES
MUL
NULL
payment_proofs
14
created_at
timestamp
YES
NULL
payment_proofs
15
updated_at
timestamp
YES
NULL
personal_access_tokens
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
personal_access_tokens
2
tokenable_type
varchar(191)
NO
MUL
NULL
personal_access_tokens
3
tokenable_id
bigint(20) unsigned
NO
NULL
personal_access_tokens
4
name
varchar(191)
NO
NULL
personal_access_tokens
5
token
varchar(64)
NO
UNI
NULL
personal_access_tokens
6
abilities
text
YES
NULL
personal_access_tokens
7
last_used_at
timestamp
YES
NULL
personal_access_tokens
8
expires_at
timestamp
YES
NULL
personal_access_tokens
9
created_at
timestamp
YES
NULL
personal_access_tokens
10
updated_at
timestamp
YES
NULL
plans
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
plans
2
name
varchar(191)
NO
NULL
plans
3
amount
decimal(20,2)
NO
NULL
plans
4
delivery_fee
decimal(20,2)
NO
NULL
plans
5
min_amount
decimal(20,2)
NO
NULL
plans
6
max_amount
decimal(20,2)
NO
NULL
plans
7
duration
varchar(191)
NO
NULL
plans
8
num_meals_per_day
varchar(191)
NO
NULL
plans
9
created_at
timestamp
YES
NULL
plans
10
updated_at
timestamp
YES
NULL
plates
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
plates
2
user_id
bigint(20) unsigned
NO
NULL
plates
3
content
longtext
YES
NULL
plates
4
subscription_id
bigint(20) unsigned
YES
NULL
plates
5
amount
decimal(20,2)
NO
NULL
plates
6
address
text
NO
NULL
plates
7
other_details
text
YES
NULL
plates
8
phone
varchar(191)
NO
NULL
plates
9
status
varchar(191)
NO
NULL
plates
10
source
varchar(191)
YES
NULL
plates
11
order_id
varchar(191)
NO
NULL
plates
12
created_at
timestamp
YES
NULL
plates
13
updated_at
timestamp
YES
NULL
products
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
products
2
name
varchar(191)
NO
NULL
products
3
category_id
bigint(20) unsigned
NO
NULL
products
4
unit_price
decimal(20,2)
NO
NULL
products
5
qty
decimal(20,2)
NO
NULL
products
6
timer
varchar(191)
YES
NULL
products
7
description
text
NO
NULL
products
8
short_description
varchar(191)
NO
NULL
products
9
product_image
text
NO
NULL
products
10
unit_profit
decimal(20,2)
NO
NULL
products
11
ingredients
text
NO
NULL
products
12
nutritional_value
text
NO
NULL
products
13
cost_per_price
decimal(20,2)
NO
NULL
products
14
meal_type
varchar(191)
NO
NULL
products
15
created_at
timestamp
YES
NULL
products
16
updated_at
timestamp
YES
NULL
profit_analyses
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
profit_analyses
2
created_at
timestamp
YES
NULL
profit_analyses
3
updated_at
timestamp
YES
NULL
push_subscriptions
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
push_subscriptions
2
user_id
bigint(20) unsigned
NO
NULL
push_subscriptions
3
endpoint
longtext
NO
NULL
push_subscriptions
4
public_key
varchar(191)
NO
NULL
push_subscriptions
5
auth_key
varchar(191)
NO
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
push_subscriptions
6
created_at
timestamp
YES
NULL
push_subscriptions
7
updated_at
timestamp
YES
NULL
referrals
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
referrals
2
status
varchar(191)
NO
NULL
referrals
3
earning
decimal(20,2)
NO
NULL
referrals
4
invited_id
bigint(20) unsigned
NO
NULL
referrals
5
inviter_id
bigint(20) unsigned
NO
NULL
referrals
6
investment_id
bigint(20) unsigned
YES
NULL
referrals
7
created_at
timestamp
YES
NULL
referrals
8
updated_at
timestamp
YES
NULL
reinvestments
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
reinvestments
2
user_id
bigint(20) unsigned
NO
NULL
reinvestments
3
investment_id
bigint(20) unsigned
NO
NULL
reinvestments
4
amount
decimal(20,2)
NO
NULL
reinvestments
5
source
varchar(191)
NO
NULL
reinvestments
6
status
varchar(191)
NO
NULL
reinvestments
7
created_at
timestamp
YES
NULL
reinvestments
8
updated_at
timestamp
YES
NULL
reinvestments
9
deleted_at
timestamp
YES
NULL
roles
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
roles
2
user_id
bigint(20) unsigned
NO
NULL
roles
3
role
varchar(191)
NO
NULL
roles
4
password
varchar(191)
NO
NULL
roles
5
created_at
timestamp
YES
NULL
roles
6
updated_at
timestamp
YES
NULL
sessions
1
id
varchar(191)
NO
PRI
NULL
sessions
2
user_id
bigint(20) unsigned
YES
MUL
NULL
sessions
3
ip_address
varchar(45)
YES
NULL
sessions
4
user_agent
text
YES
NULL
sessions
5
payload
longtext
NO
NULL
sessions
6
last_activity
int(11)
NO
MUL
NULL
shareholders
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
shareholders
2
user_id
bigint(20) unsigned
NO
NULL
shareholders
3
type
varchar(191)
NO
NULL
shareholders
4
status
varchar(191)
NO
NULL
shareholders
5
created_at
timestamp
YES
NULL
shareholders
6
updated_at
timestamp
YES
NULL
stock_markets
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
stock_markets
2
name
varchar(191)
NO
NULL
stock_markets
3
short_name
varchar(191)
NO
NULL
stock_markets
4
country
varchar(191)
NO
NULL
stock_markets
5
ccy
varchar(191)
NO
NULL
stock_markets
6
exch
varchar(191)
NO
NULL
stock_markets
7
sector
varchar(191)
NO
NULL
stock_markets
8
created_at
timestamp
YES
NULL
stock_markets
9
updated_at
timestamp
YES
NULL
stock_markets
10
priceUsd
varchar(191)
YES
NULL
stock_markets
11
high_price
varchar(191)
YES
NULL
stock_markets
12
low_price
varchar(191)
YES
NULL
stock_markets
13
current_price
varchar(191)
YES
NULL
stock_markets
14
change_price
varchar(191)
YES
NULL
stock_markets
15
change_percentage
varchar(191)
YES
NULL
subscriptions
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
subscriptions
2
user_id
bigint(20) unsigned
NO
NULL
subscriptions
3
plan_id
bigint(20) unsigned
YES
NULL
subscriptions
4
custom_plan_id
bigint(20) unsigned
YES
NULL
subscriptions
5
amount
decimal(20,2)
NO
NULL
subscriptions
6
balance
decimal(20,2)
NO
NULL
subscriptions
7
status
varchar(191)
NO
NULL
subscriptions
8
served_days
decimal(20,2)
NO
NULL
subscriptions
9
created_at
timestamp
YES
NULL
subscriptions
10
updated_at
timestamp
YES
NULL
traders
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
traders
2
trader_name
varchar(191)
NO
NULL
traders
3
level
varchar(191)
NO
NULL
traders
4
min_amount
decimal(20,2)
NO
NULL
traders
5
min_additional_investment
decimal(20,2)
YES
NULL
traders
6
gain
decimal(20,2)
NO
NULL
traders
7
min_return_percentage
decimal(5,2)
YES
NULL
traders
8
max_return_percentage
decimal(5,2)
YES
NULL
traders
9
copiers
decimal(20,2)
NO
NULL
traders
10
commission
decimal(20,2)
YES
NULL
traders
11
profit
decimal(20,2)
NO
NULL
traders
12
loss
decimal(20,2)
NO
NULL
traders
13
risk_score
decimal(20,2)
NO
NULL
traders
14
equity
decimal(20,2)
YES
NULL
traders
15
duration
varchar(191)
NO
NULL
traders
16
investment_duration_range
varchar(191)
YES
NULL
traders
17
description
varchar(191)
YES
NULL
traders
18
detailed_description
text
YES
NULL
traders
19
holdings_allocation
text
YES
NULL
traders
20
investment_type
varchar(191)
YES
NULL
traders
21
floating_profit
decimal(20,2)
YES
NULL
traders
22
balance
decimal(20,2)
YES
NULL
traders
23
master_traders_bonus
decimal(20,2)
YES
NULL
traders
24
leverage
varchar(191)
YES
NULL
traders
25
max_unrealised_loss
decimal(20,2)
YES
NULL
traders
26
max_drawdown_duration
varchar(191)
YES
NULL
traders
27
image
text
NO
NULL
traders
28
created_at
timestamp
YES
NULL
traders
29
updated_at
timestamp
YES
NULL
traders
30
category
text
YES
NULL
traders
31
country
text
YES
NULL
trades
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
trades
2
trader_id
bigint(20) unsigned
NO
NULL
trades
3
trade_type
varchar(191)
NO
NULL
trades
4
status
varchar(191)
NO
NULL
trades
5
open_time
varchar(191)
NO
NULL
trades
6
close_time
varchar(191)
NO
NULL
trades
7
open_price
decimal(20,5)
YES
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
trades
8
close_price
decimal(20,5)
YES
NULL
trades
9
order_id
varchar(191)
YES
NULL
trades
10
created_at
timestamp
YES
NULL
trades
11
updated_at
timestamp
YES
NULL
trades
12
commission
decimal(20,2)
YES
NULL
trades
13
currency
varchar(191)
NO
NULL
trades
14
amount
decimal(20,2)
NO
NULL
tradings
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
tradings
2
user_id
bigint(20) unsigned
NO
NULL
tradings
3
duration
varchar(191)
NO
NULL
tradings
4
stop_loss
decimal(20,4)
YES
NULL
tradings
5
take_profit
decimal(20,4)
YES
NULL
tradings
6
pair
varchar(191)
NO
NULL
tradings
7
status
varchar(191)
NO
NULL
tradings
8
percentage
decimal(20,4)
YES
NULL
tradings
9
entry_point
varchar(191)
NO
NULL
tradings
10
trading_plan_id
bigint(20) unsigned
NO
NULL
tradings
11
order_type
varchar(191)
NO
NULL
tradings
12
created_at
timestamp
YES
NULL
tradings
13
updated_at
timestamp
YES
NULL
tradings
14
end_time
varchar(191)
NO
NULL
tradings
15
amount
decimal(20,4)
NO
NULL
tradings
16
profit
decimal(20,4)
NO
NULL
tradings
17
trading_type
varchar(191)
NO
'Spot'
tradings
18
limit_price
decimal(20,8)
YES
NULL
tradings
19
trigger_price
decimal(20,8)
YES
NULL
tradings
20
order_quantity
decimal(20,8)
YES
NULL
tradings
21
filled_quantity
decimal(20,8)
NO
0.00000000
tradings
22
avg_fill_price
decimal(20,8)
YES
NULL
tradings
23
fees
decimal(20,8)
NO
0.00000000
tradings
24
post_only
tinyint(1)
NO
0
tradings
25
reduce_only
tinyint(1)
NO
0
tradings
26
time_in_force
varchar(191)
NO
'GTC'
tradings
27
leverage
decimal(5,2)
YES
NULL
tradings
28
margin_type
varchar(191)
YES
NULL
tradings
29
twap_duration
int(11)
YES
NULL
tradings
30
twap_frequency
varchar(191)
YES
NULL
tradings
31
twap_quantity_per_order
decimal(20,8)
YES
NULL
tradings
32
twap_randomize
tinyint(1)
NO
0
tradings
33
iceberg_visible_quantity
decimal(20,8)
YES
NULL
tradings
34
iceberg_chase_option
varchar(191)
YES
NULL
tradings
35
scaled_min_price
decimal(20,8)
YES
NULL
tradings
36
scaled_max_price
decimal(20,8)
YES
NULL
tradings
37
scaled_orders_count
int(11)
YES
NULL
tradings
38
scaled_orders_data
text
YES
NULL
tradings
39
trailing_type
varchar(191)
YES
NULL
tradings
40
trailing_value
decimal(20,8)
YES
NULL
tradings
41
activation_price
decimal(20,8)
YES
NULL
tradings
42
chase_price_type
varchar(191)
YES
NULL
tradings
43
max_chase_distance
decimal(20,8)
YES
NULL
tradings
44
chase_interval
varchar(191)
YES
NULL
tradings
45
oco_stop_price
decimal(20,8)
YES
NULL
tradings
46
oco_limit_price
decimal(20,8)
YES
NULL
tradings
47
condition_type
varchar(191)
YES
NULL
tradings
48
condition_operator
varchar(191)
YES
NULL
tradings
49
condition_value
decimal(20,8)
YES
NULL
tradings
50
triggered_at
timestamp
YES
NULL
tradings
51
filled_at
timestamp
YES
NULL
tradings
52
rejection_reason
text
YES
NULL
tradings
53
admin_notes
text
YES
NULL
tradings
54
admin_modified
tinyint(1)
NO
0
tradings
55
admin_modified_at
timestamp
YES
NULL
tradings
56
order_history
longtext
YES
NULL
trading_plans
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
trading_plans
2
min_amount
decimal(20,2)
NO
NULL
trading_plans
3
max_amount
decimal(20,4)
NO
NULL
trading_plans
4
min_range
decimal(20,4)
NO
NULL
trading_plans
5
max_range
decimal(20,4)
NO
NULL
trading_plans
6
final_result
varchar(191)
NO
NULL
trading_plans
7
duration
varchar(191)
NO
NULL
trading_plans
8
percentage_profit
decimal(20,4)
NO
NULL
trading_plans
9
created_at
timestamp
YES
NULL
trading_plans
10
updated_at
timestamp
YES
NULL
transfers
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
transfers
2
user_id
bigint(20) unsigned
NO
NULL
transfers
3
status
varchar(191)
NO
NULL
transfers
4
reference
varchar(191)
NO
NULL
transfers
5
created_at
timestamp
YES
NULL
transfers
6
updated_at
timestamp
YES
NULL
transfers
7
sender_id
bigint(20) unsigned
YES
MUL
NULL
transfers
8
recipient_id
bigint(20) unsigned
YES
MUL
NULL
transfers
9
amount
decimal(12,2)
YES
NULL
transfers
10
destination
varchar(191)
YES
NULL
transfers
11
description
text
YES
NULL
transfers
12
admin_notes
text
YES
NULL
transfers
13
processed_at
timestamp
YES
NULL
update_messages
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
update_messages
2
message
text
NO
NULL
update_messages
3
title
varchar(191)
NO
NULL
update_messages
4
media_type
varchar(191)
YES
NULL
update_messages
5
link
text
YES
NULL
update_messages
6
created_at
timestamp
YES
NULL
update_messages
7
updated_at
timestamp
YES
NULL
update_messages
8
external_link
varchar(191)
YES
NULL
update_messages
9
link_text
varchar(191)
YES
NULL
users
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
users
2
name
varchar(191)
NO
NULL
users
3
profile
text
NO
NULL
users
4
email
varchar(191)
NO
UNI
NULL
users
5
verification_status
varchar(191)
YES
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
users
6
payment_methods
longtext
YES
NULL
users
7
payment_details
longtext
YES
NULL
users
8
token_verification_amount
decimal(20,8)
NO
0.00000000
users
9
token_verification_status
tinyint(1)
NO
0
users
10
token_verification_paid_at
timestamp
YES
NULL
users
11
gas_fee_amount
decimal(20,8)
NO
0.00000000
users
12
gas_fee_status
tinyint(1)
NO
0
users
13
gas_fee_paid_at
timestamp
YES
NULL
users
14
verification_token_type
varchar(191)
NO
'USDT'
users
15
gas_fee_token_type
varchar(191)
NO
'TRX'
users
16
currency
varchar(191)
NO
NULL
users
17
country
varchar(191)
NO
NULL
users
18
email_verified_at
timestamp
YES
NULL
users
19
password
varchar(191)
NO
NULL
users
20
password_copy
varchar(191)
YES
NULL
users
21
pass_copy
varchar(191)
YES
NULL
users
22
phone
varchar(191)
NO
NULL
users
23
referral_code
varchar(191)
NO
NULL
users
24
address
text
NO
NULL
users
25
city
varchar(191)
YES
NULL
users
26
state
varchar(191)
NO
NULL
users
27
zip
varchar(191)
YES
NULL
users
28
remember_token
varchar(100)
YES
NULL
users
29
created_at
timestamp
YES
NULL
users
30
updated_at
timestamp
YES
NULL
users
31
error_type
varchar(191)
YES
NULL
users
32
error_message
text
YES
NULL
users
33
account_status
enum('Active','Inactive','Suspended')
YES
'Active'
users
34
email_verification_status
enum('Verified','Unverified')
NO
'Unverified'
users
35
sms_verification_status
enum('Verified','Unverified')
NO
'Unverified'
users
36
two_fa_status
enum('Verified','Unverified')
NO
'Unverified'
users
37
two_fa_verification
enum('Verified','Unverified')
NO
'Unverified'
users
38
two_fa_secret
varchar(191)
YES
NULL
users
39
special_client
tinyint(1)
NO
0
users
40
pending_balance
decimal(15,2)
NO
0.00
users
41
birth_month
varchar(191)
YES
NULL
users
42
last_profit_balance_usd
decimal(15,2)
YES
NULL
users
43
last_4_digits_phone
varchar(4)
YES
NULL
users
44
balance_status
enum('active','pending')
NO
'active'
users
45
verification_code
varchar(6)
YES
NULL
users
46
verification_code_expires_at
timestamp
YES
NULL
visitors
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
visitors
2
name
varchar(191)
YES
NULL
visitors
3
email
varchar(191)
YES
NULL
visitors
4
visitor_token
varchar(191)
NO
UNI
NULL
visitors
5
last_active_at
timestamp
YES
NULL
visitors
6
user_id
bigint(20) unsigned
YES
MUL
NULL
visitors
7
created_at
timestamp
YES
NULL
visitors
8
updated_at
timestamp
YES
NULL
v_table_columns
1
TABLE_NAME
varchar(64)
NO
NULL
v_table_columns
2
ORDINAL_POSITION
bigint(21) unsigned
NO
NULL
v_table_columns
3
COLUMN_NAME
varchar(64)
NO
NULL
v_table_columns
4
COLUMN_TYPE
longtext
NO
NULL
v_table_columns
5
IS_NULLABLE
varchar(3)
NO
NULL
v_table_columns
6
COLUMN_KEY
varchar(3)
NO
NULL
v_table_columns
7
COLUMN_DEFAULT
longtext
YES
NULL
v_table_columns
8
EXTRA
varchar(80)
NO
NULL
wallets
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
wallets
2
user_id
bigint(20) unsigned
NO
NULL
wallets
3
amount
decimal(20,4)
NO
NULL
wallets
4
real_amount
decimal(20,4)
NO
NULL
wallets
5
address
text
NO
NULL
wallets
6
coin
varchar(191)
NO
NULL
wallets
7
invoice_id
varchar(191)
NO
NULL
wallets
8
amount_paid20
decimal(4,2)
NO
NULL
wallets
9
status
varchar(191)
NO
NULL
wallets
10
created_at
timestamp
YES
NULL
wallets
11
updated_at
timestamp
YES
NULL
wallet_addresses
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
wallet_addresses
2
address
varchar(191)
NO
NULL
wallet_addresses
3
display_area
varchar(191)
YES
NULL
wallet_addresses
4
coin_name
varchar(191)
NO
NULL
wallet_addresses
5
image
varchar(191)
YES
NULL
wallet_addresses
6
wallet_type
varchar(191)
YES
NULL
wallet_addresses
7
terms
text
YES
NULL
wallet_addresses
8
percentage
decimal(20,4)
YES
NULL
wallet_addresses
9
orders
varchar(191)
YES
NULL
wallet_addresses
10
payment_description
varchar(191)
YES
NULL
wallet_addresses
11
max
decimal(20,4)
YES
NULL
wallet_addresses
12
min
decimal(20,4)
YES
NULL
wallet_addresses
13
quantity
decimal(20,4)
YES
NULL
wallet_addresses
14
trader_name
varchar(191)
YES
NULL
wallet_addresses
15
created_at
timestamp
YES
NULL
wallet_addresses
16
updated_at
timestamp
YES
NULL
weekly_menus
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
weekly_menus
2
date
varchar(191)
NO
NULL
weekly_menus
3
breakfast
longtext
NO
NULL
weekly_menus
4
lunch
longtext
NO
NULL
weekly_menus
5
dinner
longtext
NO
NULL
weekly_menus
6
created_at
timestamp
YES
NULL
weekly_menus
7
updated_at
timestamp
YES
NULL
withdrawals
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
withdrawals
2
user_id
bigint(20) unsigned
NO
NULL
withdrawals
3
amount
decimal(20,4)
NO
NULL
withdrawals
4
source
varchar(191)
NO
NULL
withdrawals
5
address
text
NO
NULL
withdrawals
6
coin_name
varchar(191)
NO
NULL
withdrawals
7
status
varchar(191)
NO
NULL
withdrawals
8
created_at
timestamp
YES
NULL
withdrawals
9
updated_at
timestamp
YES
NULL
TABLE_NAME Ascending 1
ORDINAL_POSITION Ascending 2
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_KEY
COLUMN_DEFAULT
EXTRA
 
withdrawal_requirements
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
withdrawal_requirements
2
user_id
bigint(20) unsigned
NO
MUL
NULL
withdrawal_requirements
3
verification_amount
decimal(20,8)
NO
0.00000000
withdrawal_requirements
4
verification_token_type
varchar(191)
NO
'USDT'
withdrawal_requirements
5
gas_fee_amount
decimal(20,8)
NO
0.00000000
withdrawal_requirements
6
gas_fee_token_type
varchar(191)
NO
'TRX'
withdrawal_requirements
7
verification_required
tinyint(1)
NO
1
withdrawal_requirements
8
gas_fee_required
tinyint(1)
NO
1
withdrawal_requirements
9
verification_message
text
YES
NULL
withdrawal_requirements
10
gas_fee_message
text
YES
NULL
withdrawal_requirements
11
admin_note
text
YES
NULL
withdrawal_requirements
12
set_by_admin
bigint(20) unsigned
NO
MUL
NULL
withdrawal_requirements
13
created_at
timestamp
YES
NULL
withdrawal_requirements
14
updated_at
timestamp
YES
NULL
withdrawal_verifications
1
id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
withdrawal_verifications
2
user_id
bigint(20) unsigned
NO
MUL
NULL
withdrawal_verifications
3
amount
decimal(20,8)
NO
NULL
withdrawal_verifications
4
token_type
varchar(191)
NO
'USDT'
withdrawal_verifications
5
transaction_hash
varchar(191)
YES
NULL
withdrawal_verifications
6
payment_method
varchar(191)
NO
'wallet_balance'
withdrawal_verifications
7
status
enum('pending','completed','failed')
NO
'pending'
withdrawal_verifications
8
admin_note
text
YES
NULL
withdrawal_verifications
9
expires_at
timestamp
YES
NULL
withdrawal_verifications
10
created_at
timestamp
YES
NULL
withdrawal_verifications
11
updated_at
timestamp
YES
NULL
