ai.surenasolutions.in / 127.0.0.1 / aiskgl / h01_emp_basic_details

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

Press Ctrl+Enter to execute query

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Table navigation bar

Use only icons, only text or both.

How to display various action links

Use only icons, only text or both.

Allow to display all the rows

Whether a user should be displayed a "show all (rows)" button.

Maximum number of rows to display

Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.

Default sorting order

SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.

Highlight pointer

Highlight row pointed by the mouse cursor.

Row marker

Highlight selected rows.

Grid editing: trigger action

Grid editing: save all edited cells at once

Repeat headers

Repeat the headers every X cells, 0 deactivates this feature.

Limit column characters

Maximum number of characters shown in any non-numeric column on browse view.

Where to show the table row links

These are Edit, Copy and Delete links.

Show row links anyway

Whether to show row links even in the absence of a unique key.

Primary key default sort order

Default sort order for tables with a primary key.

Remember table's sorting

When browsing tables, the sorting of each table is remembered.

Relational display

For display Options

			empid	chatid	role	first_name First Name	last_name Last Name	date_of_birth Date Of Birth	designation Designation	department Department	date_of_joining	confirmation_date	employement_status	teaching_experience Teaching Experience	other_experience	notice_period	unique_id	biometric_id	languages_known	languages_type	blood_group_id Blood Group	religion_id Religion	caste_id Caste	gender_id Gender	sub_caste_id Sub Caste	caste_category_id Caste Category	father_guardian_name Father Or Guardian Name	father_guardian_qualification	father_guardian_occupation	mother_name	mother_qualification	mother_occupation	account_number	bank_name	ifsc_code	facility Facility	com_address_one Address1	com_address_two Address2	com_city City	com_zipcode Zipcode	country_code Country Code	marital_status	qualification Qualification	whatsapp_number Whatsapp Number	contact_one Contact One	contact_two Contact Two	email_address Email	address_one	address_two	city	zipcode	submenu_permition	mob_app_permit	menu_type_id	pr_location_id	pr_inst_type_id	pr_institution_type	pr_yr_id	active_status	added_by	modified_by	modified_at	employee_image	authorization	deptid
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 1	1	EMPAISKGL1		Kavitha V		1976-06-01	Office assistant	3	2015-07-10	0000-00-00	1	20 years			EMPAISKGL1	EMP001			5	0	0	7	0	0	Vasu Rai B.V								IBKL0001508		'Guru kirana' 5th cross, Andanaiah Extention, Kuni...	NA	Kunigal	572130	0	Married	B com, MBA	9742620070	9742620070		vraikavitha@gmail.com	'Guru kirana' 5th cross, Andanaiah Extention, Kuni...	NA	Kunigal	572130	1,2,3,4,5,6,7,8,9,10	1	2	1	39	School	20	1	0	0	2026-04-15 14:12:04	design/app-assets/images/useremp/1.jpg	1	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 2	2	EMPAISKGL2		Sunitha.G		1987-04-07	Office Assistent	1	2016-01-01	1970-01-01	0	6			EMPAISKGL2	EMP002			0	0	0	7	0	0	Gangadhar										Maveena Thopu,Kunigal	0	Kunigal	572130	0	Un Married	BBM	9743356270	9743356270		sunitha.nikki92@gmail.com	Maveena Thopu,Kunigal	0	Kunigal	572130	1,2,3,4,5,6,7,8,9,10	0	2	1	37	School	19	0	0	0	2025-06-05 13:52:23	design/app-assets/images/useremp/2.jpg	0	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 4	4	EMPAISKGL4		Usha N		1979-01-09	Admin Incharge		2011-05-11	0000-00-00	1				EMPAISKGL4	EMP004			1	0	0	7	0	0	Nagaraj B S							IDBI Bank	IBKL0001508		Bhaktharahalli post, Kunigal		Kunigal	572130	0	Married	MSc,(MBA)(BEd)	9606488869	9606488869		kavanavarsha123@gmail.com	Bhaktharahalli post, Kunigal		Kunigal	572130	1,2,3,4,5,6,7,8,9,10	1	2	1	37	School	19	1	0	0	2026-03-03 09:59:57	design/app-assets/images/useremp/4.jpg	1	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 5	5	EMPAISKGL5		Manikandan T		1983-05-17	P E Teacher	1	2014-09-01	0000-00-00	1	9			EMPAISKGL5	EMP005			1	0	0	6	0	0	Thamilarasan.N						1508104000041715	IDBI Bank	IBKL0001508		No.19, Singaara Street, Ariyalur, Tamilnadu-621704		Kunigal	621704	0	Married	MA, Mped, PHD Yoga	9791764143	9791764143		manikandant88@gmail.com	No.19, Singaara Street, Ariyalur, Tamilnadu-621704		Kunigal	621704	1,2,3,4,5,6,7,8,9,10	1	2	1	37	School	19	1	0	0	2026-01-17 16:47:33	design/app-assets/images/useremp/5.jpg	1	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 6	6	EMPAISKGL6		Anthony Prakash		1982-10-03	P E Teacher	1	2014-09-01	0000-00-00	1				EMPAISKGL6	EMP006			5	0	0	6	0	0	Mathiyas										Sannenahalli, Masavaghatta Post, Nuluvinakere Hobl...	Housing Board, Kunigal	Kunigal	572130	0	Married	BA,BPED	9980510642	9980510642			Sannenahalli, Masavaghatta Post, Nuluvinakere Hobl...	Housing Board, Kunigal	Kunigal	572130	1,2,3,4,5,6,7,8,9,10	1	2	1	37	School	19	1	0	0	2026-01-17 16:47:33	design/app-assets/images/useremp/6.jpg	1	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 7	7	EMPAISKGL7		Pratap.L.S		0000-00-00	Asst. Teacher	1	0000-00-00	0000-00-00	0				EMPAISKGL7	EMP007			0	0	0	6	0	0	Siddanna.P												Kunigal	572130	0	Married		9916615354	9916615354					Kunigal	572130	1,2,3,4,5,6,7,8,9,10	0	2	1	37	School	19	0	0	0	2025-07-14 16:19:38	design/app-assets/images/useremp/7.jpg	0	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 8	8	EMPAISKGL8		Muthanjani		1987-07-08	Asst teacher	1	2014-09-01	0000-00-00	1	12			EMPAISKGL8	EMP008			0	0	0	6	0	0	Narasa Muthaiah										S/O NARASHIMAIAH,KALLI PALYA,KUDDAHALLI POST,KORAT...		KORATAGERE	572130	0	Married	BA.DEd	9008257646	9008257646		muthanjani@gmail.com	S/O NARASHIMAIAH,KALLI PALYA,KUDDAHALLI POST,KORAT...		KORATAGERE	572130	1,2,3,4,5,6,7,8,9,10	1	2	1	37	School	19	1	0	0	2026-01-17 16:47:33	design/app-assets/images/useremp/8.jpg	1	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 9	9	EMPAISKGL9		Kasturi.M.K		0000-00-00	Asst teacher	1	0000-00-00	0000-00-00	0				EMPAISKGL9	EMP009			0	0	0	7	0	0	Kuppuswamy .M												kunigal	572130	0	Un Married		9964413844	9964413844					kunigal	572130	1,2,3,4,5,6,7,8,9,10	0	2	1	37	School	19	0	0	0	2025-12-10 12:15:38	design/app-assets/images/useremp/9.jpg	0	NULL
Edit	Copy	Delete DELETE FROM h01_emp_basic_details WHERE `h01_emp_basic_details`.`empid` = 10	10	EMPAISKGL10		Rudramuni N		1982-05-29	Asst teacher	1	2014-09-01	0000-00-00	0	12			EMPAISKGL10	EMP010			1	0	0	6	0	0	Nanjundappa										Honnu nilaya, Behind sarvodaya school,KHB, Kunigal		Kunigal	561202	0	Married	MA,BEd	9741067496	9741067496		rudramunin1@gmail.com	Honnu nilaya, Behind sarvodaya school,KHB, Kunigal		Kunigal	561202	1,2,3,4,5,6,7,8,9,10	0	2	1	37	School	19	0	0	0	2025-06-05 13:52:23	design/app-assets/images/useremp/10.jpg	0	NULL

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

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 -

Browse mode

Customize browse mode.