web.rceroorkee.in / 127.0.0.1 / rceroork_lms_rceroorkee

There are no favourite tables.

Customise appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.	Not a non-negative number!

Customise the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		rceroork_lms_rceroorkee old_wh_lms_leadsource
id : int(10) unsigned
name : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp
print_status : enum('NOT','YES')

v		rceroork_lms_rceroorkee temp_lead_history
lead_id : int(11)
assigned_id : int(11)
c_date : timestamp

v		rceroork_lms_rceroorkee wh_lms_additional_info_leads
id : int(11)
service_name : varchar(255)
service_type : varchar(255)
service_with : varchar(255)
service_price : int(11)
service_responsible : varchar(255)
service_expiry : datetime
lead_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_api_tokens
id : varchar(40)
user_id : int(10) unsigned
ip_address : varchar(45)
user_agent : text
created_at : timestamp
updated_at : timestamp
expires_at : timestamp
company_id : int(11)

v		rceroork_lms_rceroorkee wh_lms_assign_teles
id : int(11)
company_id : int(11)
user_id : int(11)
source_id : int(11)
division_id : int(11)
status : int(10)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_autolead_schedule
id : int(11)
company_id : int(11)
schedule_time : int(11)
status : smallint(2)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_auto_assign_user
id : int(11)
source_id : int(11)
division_id : int(11)
company_id : int(11)
user_id : int(11)
status : int(11)
level : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_branch
id : int(11)
branch_id : int(11)
name : varchar(255)
company_id : int(11)
status : smallint(4)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_bulk_mails
id : int(11)
lead_ids : text
subject : varchar(255)
message : text
count : int(11)
status : int(11)
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_bulk_mail_status
id : int(11)
lead_ids : text
mail_list : text
subject : varchar(255)
message : text
count : smallint(4)
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_callstatus
id : int(10) unsigned
name : varchar(191)
purpose_id : int(11)
custome_fields : text
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_cities
id : int(11)
state_id : int(11)
name : varchar(255)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_company
id : int(10) unsigned
name : varchar(255)
slug : varchar(200)
description : mediumtext
email : varchar(255)
phone : varchar(255)
address : varchar(255)
city : varchar(100)
state : varchar(100)
contact_person : varchar(100)
logo : varchar(255)
user_id : int(11)
sms_api : text
status : smallint(6)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_company_permissions
id : int(10) unsigned
name : varchar(150)
display_name : varchar(150)
description : varchar(255)
removable : smallint(6)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_company_permission_role
id : int(10) unsigned
permission_id : int(10) unsigned
role_id : int(10) unsigned
company_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_countries
id : int(10) unsigned
capital : varchar(255)
citizenship : varchar(255)
country_code : varchar(3)
currency : varchar(255)
currency_code : varchar(255)
currency_sub_unit : varchar(255)
currency_symbol : varchar(3)
full_name : varchar(255)
iso_3166_2 : varchar(2)
iso_3166_3 : varchar(3)
name : varchar(255)
region_code : varchar(3)
sub_region_code : varchar(3)
eea : tinyint(1)
calling_code : varchar(3)
flag : varchar(6)

v		rceroork_lms_rceroorkee wh_lms_course
id : int(11)
name : varchar(256)
full_name : varchar(255)
company_id : int(11)
status : varchar(24)
created_at : datetime
updated_at : datetime
deleted_at : datetime
course_group_id : int(11)
similar_name : text

v		rceroork_lms_rceroorkee wh_lms_course_group
id : int(11)
name : varchar(255)
company_id : int(11)
status : varchar(24)
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		rceroork_lms_rceroorkee wh_lms_course_type
id : tinyint(4)
name : varchar(64)
alias : varchar(24)

v		rceroork_lms_rceroorkee wh_lms_customer_type
id : int(11)
name : varchar(200)
status : varchar(100)
comapny_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_dealers
id : int(11)
name : varchar(250)
email : varchar(250)
phone : varchar(250)
city : int(11)
state : int(11)
address : varchar(250)
company_id : int(11)
status : smallint(4)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_departments
id : int(10) unsigned
name : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_district
id : int(10) unsigned
name : varchar(191)
state_id : int(11)
status : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_divisons
id : int(10) unsigned
name : varchar(191)
company_id : int(11)
active : tinyint(4)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_email_template
template_id : int(11)
name : varchar(255)
message : tinytext
subject : tinytext
para1 : text
para2 : text
type : enum('TEXT','IMAGE','SINGLE-PAGE')

v		rceroork_lms_rceroorkee wh_lms_employee_designations
id : int(10) unsigned
company_id : int(10) unsigned
role_id : int(10) unsigned
title : varchar(191)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_facebooklead
id : int(10) unsigned
company_name : varchar(255)
name : varchar(255)
description : mediumtext
email : varchar(255)
phone : varchar(255)
lead_source : smallint(6)
address : varchar(255)
city : varchar(100)
state : varchar(100)
pincode : int(11)
contact_person : varchar(100)
assigned : smallint(6)
executive : smallint(6)
lead_status : smallint(6)
lead_type : mediumint(9)
is_repeat : smallint(4)
q_type : smallint(4)
lead_date : timestamp
region_id : int(11)
divison : varchar(255)
purpose : smallint(4)
service : varchar(255)
DL_number : text
GST_number : text
website_lnik : text
created_at : timestamp
updated_at : timestamp
company_id : int(11)
ref_id : varchar(200)
state_id : int(11)
district_id : int(11)
dead_reason_id : int(11)
transfer_id : int(11)
order_count : int(11)
dispatch_status : int(10)
dispatch_detials : text
customer_type : int(11)
dealer_id : int(11)
deleted_at : timestamp
country_iso : varchar(100)
additional_remark : text
course : int(11)
branch : int(11)
fee_deposited : text
dor : date
consultancy : varchar(200)

v		rceroork_lms_rceroorkee wh_lms_ipaddresses
id : int(11)
type_id : int(11)
allowed_ip : text
type : varchar(100)
company_id : int(11)
status : smallint(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_jobs
id : bigint(20) unsigned
queue : varchar(191)
payload : longtext
attempts : tinyint(3) unsigned
reserved_at : int(10) unsigned
available_at : int(10) unsigned
created_at : int(10) unsigned

v		rceroork_lms_rceroorkee wh_lms_leads
id : int(10) unsigned
company_name : varchar(255)
name : varchar(255)
description : mediumtext
email : varchar(255)
phone : varchar(255)
lead_source : smallint(6)
address : varchar(255)
city : varchar(100)
state : varchar(100)
pincode : int(11)
contact_person : varchar(100)
assigned : smallint(6)
executive : smallint(6)
lead_status : smallint(6)
lead_type : mediumint(9)
is_repeat : smallint(4)
q_type : smallint(4)
lead_date : timestamp
region_id : int(11)
divison : varchar(255)
purpose : smallint(4)
service : varchar(255)
DL_number : text
GST_number : text
website_lnik : text
created_at : timestamp
updated_at : timestamp
company_id : int(11)
ref_id : varchar(200)
state_id : int(11)
district_id : int(11)
dead_reason_id : int(11)
transfer_id : int(11)
order_count : int(11)
dispatch_status : int(10)
dispatch_detials : text
customer_type : int(11)
dealer_id : int(11)
deleted_at : timestamp
country_iso : varchar(100)
additional_remark : text
course : int(11)
branch : int(11)
fee_deposited : text
dor : date
consultancy : varchar(200)
sub_divison : varchar(255)
lead_score : tinyint(4)
hold : int(11)
dead : int(11)
mature : int(11)

v		rceroork_lms_rceroorkee wh_lms_leadsource
id : int(10) unsigned
name : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp
print_status : enum('NOT','YES')
leadsource_group_id : int(11)

v		rceroork_lms_rceroorkee wh_lms_leadsource_group
id : int(11)
name : varchar(255)
company_id : int(11)
status : varchar(24)
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		rceroork_lms_rceroorkee wh_lms_leadstatus
id : int(10) unsigned
name : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_leads_assigned
id : int(10) unsigned
lead_id : int(10) unsigned
user_id : int(10) unsigned
assigned_to : int(10) unsigned
status : tinyint(2)
level : smallint(4)
company_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
assigned_by : int(11)
assigned_status : enum('ASSIGNED','UNASSIGNED','REASSIGNED')

v		rceroork_lms_rceroorkee wh_lms_leads_assigned_deleted
id : int(10) unsigned
lead_id : int(10) unsigned
user_id : int(10) unsigned
assigned_to : int(10) unsigned
status : tinyint(2)
level : smallint(4)
company_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
assigned_by : int(11)
assigned_status : enum('ASSIGNED','UNASSIGNED','REASSIGNED')

v		rceroork_lms_rceroorkee wh_lms_leads_assigned_old2024data
id : int(10) unsigned
lead_id : int(10) unsigned
user_id : int(10) unsigned
assigned_to : int(10) unsigned
status : tinyint(2)
level : smallint(4)
company_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
assigned_by : int(11)
assigned_status : enum('ASSIGNED','UNASSIGNED','REASSIGNED')

v		rceroork_lms_rceroorkee wh_lms_leads_copy
id : int(10) unsigned
company_name : varchar(255)
name : varchar(255)
description : mediumtext
email : varchar(255)
phone : varchar(255)
lead_source : smallint(6)
address : varchar(255)
city : varchar(100)
state : varchar(100)
contact_person : varchar(100)
assigned : smallint(6)
executive : smallint(6)
lead_status : smallint(6)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
ref_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_leads_history
id : int(10) unsigned
team_id : int(11)
assigned_id : int(11)
lead_id : int(11)
subject : varchar(255)
purpose_id : int(11)
service_id : varchar(255)
callstatus_id : int(11)
remarks : mediumtext
attachment : varchar(255)
reminder_on : datetime
lead_type : int(11)
lead_status : int(11)
edit_lead_data : text
transfer_status : int(11)
transfer_remark : varchar(255)
company : smallint(4)
state_id : int(11)
district_id : int(11)
division_id : int(11)
dealer_id : int(11)
dispatch_status : int(11)
dispatch_details : text
lat : varchar(200)
log : varchar(200)
request_address : varchar(250)
created_at : timestamp
updated_at : timestamp
meeting_with : int(11)
meeting_person_name : varchar(200)
meeting_person_phone : varchar(200)
visit_with : int(11)
customer_type : int(11)
repeat_lead : varchar(200)
course : int(11)
branch : int(11)
fee_deposited : text
dor : date
visited_date : timestamp
history_status : enum('ACTIVE','INACTIVE')

v		rceroork_lms_rceroorkee wh_lms_leads_history_deleted
id : int(10) unsigned
team_id : int(11)
assigned_id : int(11)
lead_id : int(11)
subject : varchar(255)
purpose_id : int(11)
service_id : varchar(255)
callstatus_id : int(11)
remarks : mediumtext
attachment : varchar(255)
reminder_on : datetime
lead_type : int(11)
lead_status : int(11)
edit_lead_data : text
transfer_status : int(11)
transfer_remark : varchar(255)
company : smallint(4)
state_id : int(11)
district_id : int(11)
division_id : int(11)
dealer_id : int(11)
dispatch_status : int(11)
dispatch_details : text
lat : varchar(200)
log : varchar(200)
request_address : varchar(250)
created_at : timestamp
updated_at : timestamp
meeting_with : int(11)
meeting_person_name : varchar(200)
meeting_person_phone : varchar(200)
visit_with : int(11)
customer_type : int(11)
repeat_lead : varchar(200)
course : int(11)
branch : int(11)
fee_deposited : text
dor : date
visited_date : timestamp
history_status : enum('ACTIVE','INACTIVE')

v		rceroork_lms_rceroorkee wh_lms_leads_india_mart
id : int(10) unsigned
company_name : varchar(255)
name : varchar(255)
description : mediumtext
email : varchar(255)
phone : varchar(255)
lead_source : smallint(6)
address : varchar(255)
city : varchar(100)
state : varchar(100)
contact_person : varchar(100)
assigned : smallint(6)
executive : smallint(6)
lead_status : smallint(6)
lead_date : timestamp
created_at : timestamp
updated_at : timestamp
company_id : int(11)
ref_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_leads_old2024data
id : int(10) unsigned
company_name : varchar(255)
name : varchar(255)
description : mediumtext
email : varchar(255)
phone : varchar(255)
lead_source : smallint(6)
address : varchar(255)
city : varchar(100)
state : varchar(100)
pincode : int(11)
contact_person : varchar(100)
assigned : smallint(6)
executive : smallint(6)
lead_status : smallint(6)
lead_type : mediumint(9)
is_repeat : smallint(4)
q_type : smallint(4)
lead_date : timestamp
region_id : int(11)
divison : varchar(255)
purpose : smallint(4)
service : varchar(255)
DL_number : text
GST_number : text
website_lnik : text
created_at : timestamp
updated_at : timestamp
company_id : int(11)
ref_id : varchar(200)
state_id : int(11)
district_id : int(11)
dead_reason_id : int(11)
transfer_id : int(11)
order_count : int(11)
dispatch_status : int(10)
dispatch_detials : text
customer_type : int(11)
dealer_id : int(11)
deleted_at : timestamp
country_iso : varchar(100)
additional_remark : text
course : int(11)
branch : int(11)
fee_deposited : text
dor : date
consultancy : varchar(200)
sub_divison : varchar(255)
lead_score : tinyint(4)

v		rceroork_lms_rceroorkee wh_lms_leadtype
id : int(10) unsigned
name : varchar(191)
color : varchar(20)
status : varchar(20)
order : smallint(4)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_lead_dead_reasons
id : int(10) unsigned
name : varchar(191)
company_id : int(11)
status : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_lead_documents
id : int(10) unsigned
lead_id : int(11)
user_id : int(11)
bank_name : varchar(191)
cheque_number : varchar(191)
amount : varchar(250)
cheque_date : varchar(200)
services : text
images : text
status : int(11)
order_type : varchar(255)
start_date : datetime
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_lead_documents_info
id : int(11)
user_id : int(11)
lead_id : int(11)
name : varchar(150)
father_name : varchar(150)
branch : varchar(200)
course : varchar(200)
contact_no : varchar(150)
father_contact_no : varchar(150)
email : varchar(150)
tenth_board : varchar(200)
tenth_board_per : varchar(100)
twelve_board : varchar(200)
twelve_board_per : varchar(100)
images : text
status : smallint(4)
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_lead_field_permission
id : int(11)
company_id : int(11)
type_name : varchar(100)
field_name : varchar(200)
display_name : varchar(200)
field_order : int(10)
status : varchar(100)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_lead_transfer_reason
id : int(11)
name : varchar(255)
company_id : int(11)
status : smallint(4)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_loop_users
id : int(11)
user_id : int(11)
company_id : int(11)
source_id : int(11)
division_id : int(11)
status : int(4)
order : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_mail_templates
id : int(11)
name : varchar(200)
subject : varchar(200)
message : text
help : text
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_migrations
id : int(10) unsigned
migration : varchar(191)
batch : int(11)

v		rceroork_lms_rceroorkee wh_lms_myteam
id : int(11) unsigned
name : varchar(191)
tl_id : int(11)
region_id : int(11)
team_ids : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_myteam_old
id : int(10) unsigned
name : varchar(191)
tl_id : int(11)
region_id : int(11)
team_ids : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_order_products
id : int(11)
document_id : int(11)
lead_id : int(11)
product_id : int(11)
quantity : int(11)
price : int(11)
start_date : timestamp
end_date : timestamp
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_password_resets
email : varchar(191)
token : varchar(191)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_permissions
id : int(10) unsigned
name : varchar(191)
display_name : varchar(191)
description : varchar(191)
removable : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_permission_role
permission_id : int(10) unsigned
role_id : int(10) unsigned

v		rceroork_lms_rceroorkee wh_lms_permission_role_
permission_id : int(10) unsigned
role_id : int(10) unsigned

v		rceroork_lms_rceroorkee wh_lms_products
id : int(11)
name : varchar(250)
composition : text
quantity : varchar(200)
price : varchar(200)
packing : varchar(200)
mrp : varchar(200)
exp : varchar(200)
rate : varchar(200)
mfg : varchar(200)
batch : varchar(200)
company_id : int(11)
status : smallint(4)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_purposestatus
id : int(10) unsigned
name : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_regions
id : int(10) unsigned
name : varchar(191)
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_roles
id : int(10) unsigned
name : varchar(191)
display_name : varchar(191)
description : varchar(191)
removable : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_servicestatus
id : int(10) unsigned
name : varchar(191)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp
course_type : tinyint(4)
duration : varchar(24)
links : varchar(128)
print : tinyint(4)

v		rceroork_lms_rceroorkee wh_lms_sessions
id : varchar(191)
user_id : int(11)
ip_address : varchar(45)
user_agent : text
payload : text
last_activity : int(11)

v		rceroork_lms_rceroorkee wh_lms_settings
id : int(10) unsigned
key : varchar(191)
value : text
company_id : int(11)
division_id : int(11)

v		rceroork_lms_rceroorkee wh_lms_sms
id : int(11)
lead_id : longtext
phone : varchar(100)
message : text
status : smallint(4)
company_id : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_social_logins
id : int(10) unsigned
user_id : int(10) unsigned
provider : varchar(50)
provider_id : varchar(191)
avatar : varchar(191)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_states
id : int(10) unsigned
name : varchar(191)
country_id : int(11)
status : int(11)
created_at : timestamp
updated_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_sub_company
id : int(11)
division_id : int(11)
company_id : int(11)
company_slug : varchar(200)
division_head : int(11)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_team_members
id : int(11) unsigned
team_id : int(11)
level : int(11)
tl_id : int(11)
users_ids : text
status : varchar(20)
ref_id : int(11)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_team_members_old
id : int(10) unsigned
team_id : int(11)
level : int(11)
tl_id : int(11)
users_ids : text
status : varchar(20)
ref_id : int(11)
created_at : timestamp
updated_at : timestamp
company_id : int(11)
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_tele_leads
id : int(11)
tele_id : int(11)
assigned_by : int(11)
lead_id : int(11)
company_id : int(11)
status : int(11)
created_at : timestamp
deleted_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_temp_data
id : int(11)
user_id : int(11)
lead_id : longtext
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_users
id : int(10) unsigned
email : varchar(191)
username : varchar(191)
password : varchar(191)
first_name : varchar(191)
last_name : varchar(191)
phone : varchar(191)
avatar : varchar(191)
address : varchar(191)
country_id : int(10) unsigned
role_id : int(10) unsigned
birthday : date
organisation_name : varchar(255)
last_login : timestamp
confirmation_token : varchar(60)
status : varchar(20)
two_factor_country_code : int(11)
two_factor_phone : int(11)
two_factor_options : text
remember_token : varchar(100)
created_at : timestamp
updated_at : timestamp
company_id : int(10) unsigned
engage_status : int(11)
is_refresh_leads : smallint(4)
team_hierarchy : text
print_status : enum('NOT','YES')
show_on_dashboard : enum('YES','NO')
lead_source_id : int(11)

v		rceroork_lms_rceroorkee wh_lms_user_activity
id : int(10) unsigned
description : text
user_id : int(10) unsigned
ip_address : varchar(45)
user_agent : text
company_id : int(11)
created_at : timestamp

v		rceroork_lms_rceroorkee wh_lms_user_assigned_list
id : int(11)
assign_tb_id : int(11)
user_id : int(11)
level : int(11)
created_at : timestamp
updated_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update