ai.surenasolutions.in / 127.0.0.1 / edbroad_ai_sumanth / hr_employees

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.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

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.

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.

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

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

Column	Type	Collation
id	int(10)
company_id	int(10)
branch_id	int(10)
employee_code	varchar(50)	utf8mb4_unicode_ci
biometric_code	varchar(50)	utf8mb4_unicode_ci
old_employee_code	varchar(50)	utf8mb4_unicode_ci
salutation	varchar(20)	utf8mb4_unicode_ci
first_name	varchar(100)	utf8mb4_unicode_ci
middle_name	varchar(100)	utf8mb4_unicode_ci
last_name	varchar(100)	utf8mb4_unicode_ci
display_name	varchar(180)	utf8mb4_unicode_ci
gender	varchar(20)	utf8mb4_unicode_ci
date_of_birth	date
blood_group	varchar(20)	utf8mb4_unicode_ci
marital_status	varchar(30)	utf8mb4_unicode_ci
nationality	varchar(80)	utf8mb4_unicode_ci
religion	varchar(80)	utf8mb4_unicode_ci
caste_category	varchar(80)	utf8mb4_unicode_ci
mobile_no	varchar(30)	utf8mb4_unicode_ci
alternate_mobile_no	varchar(30)	utf8mb4_unicode_ci
email	varchar(150)	utf8mb4_unicode_ci
personal_email	varchar(150)	utf8mb4_unicode_ci
current_address	text	utf8mb4_unicode_ci
current_city	varchar(100)	utf8mb4_unicode_ci
current_state	varchar(100)	utf8mb4_unicode_ci
current_pincode	varchar(20)	utf8mb4_unicode_ci
permanent_address	text	utf8mb4_unicode_ci
permanent_city	varchar(100)	utf8mb4_unicode_ci
permanent_state	varchar(100)	utf8mb4_unicode_ci
permanent_pincode	varchar(20)	utf8mb4_unicode_ci
joining_date	date
confirmation_date	date
probation_end_date	date
resignation_date	date
relieving_date	date
employee_type	varchar(50)	utf8mb4_unicode_ci
employment_category	varchar(80)	utf8mb4_unicode_ci
staff_category	varchar(80)	utf8mb4_unicode_ci
department_name	varchar(120)	utf8mb4_unicode_ci
designation_name	varchar(120)	utf8mb4_unicode_ci
reporting_manager_id	int(10)
work_location	varchar(150)	utf8mb4_unicode_ci
shift_name	varchar(100)	utf8mb4_unicode_ci
employee_status	varchar(40)	utf8mb4_unicode_ci
attendance_applicable	tinyint(1)
payroll_applicable	tinyint(1)
portal_access	tinyint(1)
aadhaar_no	varchar(30)	utf8mb4_unicode_ci
pan_no	varchar(30)	utf8mb4_unicode_ci
passport_no	varchar(50)	utf8mb4_unicode_ci
driving_license_no	varchar(50)	utf8mb4_unicode_ci
emergency_contact_name	varchar(150)	utf8mb4_unicode_ci
emergency_contact_relation	varchar(80)	utf8mb4_unicode_ci
emergency_contact_mobile	varchar(30)	utf8mb4_unicode_ci
photo_path	varchar(255)	utf8mb4_unicode_ci
signature_path	varchar(255)	utf8mb4_unicode_ci
notes	text	utf8mb4_unicode_ci
is_active	tinyint(1)
delete_status	tinyint(1)
created_by	int(10)
updated_by	int(10)
deleted_by	int(10)
created_at	datetime
updated_at	datetime
deleted_at	datetime

id

int(10)

company_id

int(10)

branch_id

int(10)

employee_code

varchar(50)

utf8mb4_unicode_ci

biometric_code

varchar(50)

utf8mb4_unicode_ci

old_employee_code

varchar(50)

utf8mb4_unicode_ci

salutation

varchar(20)

utf8mb4_unicode_ci

first_name

varchar(100)

utf8mb4_unicode_ci

middle_name

varchar(100)

utf8mb4_unicode_ci

last_name

varchar(100)

utf8mb4_unicode_ci

display_name

varchar(180)

utf8mb4_unicode_ci

gender

varchar(20)

utf8mb4_unicode_ci

date_of_birth

date

blood_group

varchar(20)

utf8mb4_unicode_ci

marital_status

varchar(30)

utf8mb4_unicode_ci

nationality

varchar(80)

utf8mb4_unicode_ci

religion

varchar(80)

utf8mb4_unicode_ci

caste_category

varchar(80)

utf8mb4_unicode_ci

mobile_no

varchar(30)

utf8mb4_unicode_ci

alternate_mobile_no

varchar(30)

utf8mb4_unicode_ci

email

varchar(150)

utf8mb4_unicode_ci

personal_email

varchar(150)

utf8mb4_unicode_ci

current_address

text

utf8mb4_unicode_ci

current_city

varchar(100)

utf8mb4_unicode_ci

current_state

varchar(100)

utf8mb4_unicode_ci

current_pincode

varchar(20)

utf8mb4_unicode_ci

permanent_address

text

utf8mb4_unicode_ci

permanent_city

varchar(100)

utf8mb4_unicode_ci

permanent_state

varchar(100)

utf8mb4_unicode_ci

permanent_pincode

varchar(20)

utf8mb4_unicode_ci

joining_date

date

confirmation_date

date

probation_end_date

date

resignation_date

date

relieving_date

date

employee_type

varchar(50)

utf8mb4_unicode_ci

employment_category

varchar(80)

utf8mb4_unicode_ci

staff_category

varchar(80)

utf8mb4_unicode_ci

department_name

varchar(120)

utf8mb4_unicode_ci

designation_name

varchar(120)

utf8mb4_unicode_ci

reporting_manager_id

int(10)

work_location

varchar(150)

utf8mb4_unicode_ci

shift_name

varchar(100)

utf8mb4_unicode_ci

employee_status

varchar(40)

utf8mb4_unicode_ci

attendance_applicable

tinyint(1)

payroll_applicable

tinyint(1)

portal_access

tinyint(1)

aadhaar_no

varchar(30)

utf8mb4_unicode_ci

pan_no

varchar(30)

utf8mb4_unicode_ci

passport_no

varchar(50)

utf8mb4_unicode_ci

driving_license_no

varchar(50)

utf8mb4_unicode_ci

emergency_contact_name

varchar(150)

utf8mb4_unicode_ci

emergency_contact_relation

varchar(80)

utf8mb4_unicode_ci

emergency_contact_mobile

varchar(30)

utf8mb4_unicode_ci

photo_path

varchar(255)

utf8mb4_unicode_ci

signature_path

varchar(255)

utf8mb4_unicode_ci

notes

text

utf8mb4_unicode_ci

is_active

tinyint(1)

delete_status

tinyint(1)

created_by

int(10)

updated_by

int(10)

deleted_by

int(10)

created_at

datetime

updated_at

datetime

deleted_at

datetime

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

id
company_id
branch_id
employee_code
biometric_code
old_employee_code
salutation
first_name
middle_name
last_name
display_name
gender
date_of_birth
blood_group
marital_status
nationality
religion
caste_category
mobile_no
alternate_mobile_no
email
personal_email
current_address
current_city
current_state
current_pincode
permanent_address
permanent_city
permanent_state
permanent_pincode
joining_date
confirmation_date
probation_end_date
resignation_date
relieving_date
employee_type
employment_category
staff_category
department_name
designation_name
reporting_manager_id
work_location
shift_name
employee_status
attendance_applicable
payroll_applicable
portal_access
aadhaar_no
pan_no
passport_no
driving_license_no
emergency_contact_name
emergency_contact_relation
emergency_contact_mobile
photo_path
signature_path
notes
is_active
delete_status
created_by
updated_by
deleted_by
created_at
updated_at
deleted_at

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Range search