dev.surenasolutions.in / 127.0.0.1 / surena_crm / items_godowns

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.

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

			id	godown_name	code Short code like GD001, GODOWN_MAIN	description	branch_id Related to setting_branch_details.id	address	city	pincode	state_id	country_id	contact_number	email	incharge_name	is_primary	active_status	delete_status	created_at	updated_at
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 5	5	Main Godown	GOD001	NULL	1	NULL	Bangalore	560001	29	1	9876543210	main.godown@example.com	Rajesh Kumar	1	1	0	2025-04-15 13:19:55	2026-02-28 11:09:10
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 6	6	North Zone Storage	GOD002	Spare storage for northern dispatch	1	Warehouse 5, Sector 47	Delhi	110045	10	101	9811122233	northzone.gdn@example.com	Sunita Sharma	0	1	0	2025-04-15 13:19:56	2025-12-20 11:35:41
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 7	7	Old Inventory Block	GOD003	Reserved for returned/damaged items	1	Backside Block, HO Campus	Bangalore	560001	29	101	9822334455	old.godown@example.com	Karthik R.	0	0	0	2025-04-15 13:19:56	NULL
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 8	8	Main Warehouse	GODOWN_MAIN		1		Bangalore	560001	29	1	9876543210	main@godown.com	Ravi Kumar	0	1	0	2025-04-23 05:39:40	2026-01-10 11:32:02
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 9	9	Main Warehouse1	GODOWN_MAIN1		1		Bangalore1	560001	1	1	98765432101	main1@godown.com	Ravi Kumar1	0	1	0	2025-04-30 23:12:38	2025-05-15 13:32:07
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 25	25	test	test		1		test	123123	1	1	asdfasdf	asdfasdfasd	asdfasdfasdf	0	1	1	2025-05-03 17:50:10	2025-11-10 15:59:23
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 26	26	asdfasdf	123321		1		asdffdsa	123123	1	1	1234561234	asdfasdfasdf	asdfasdfasdf	0	1	1	2025-05-03 18:04:31	2025-05-04 11:43:51
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 27	27	Dfas	55777	NULL	1	NULL	Ff	577205	2	1	99999		Fffff	0	1	1	2025-06-27 16:36:37	2025-06-27 16:36:48
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 28	28	Dfd	7888		1		Dd	2233	11	1	22255	mjhkdk	Dfdss	0	1	1	2025-07-17 17:11:58	2025-07-17 17:15:25
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 29	29	Hhjkjjjdkkfdjf	78888		1			0	11	1	78878	fjgjhsssss	Nhhggh	0	1	0	2025-07-25 11:39:04	2025-07-25 12:26:22
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 30	30	Main Warehouse	MAIN-WH	Central godown for inventory	1	Industrial Area, Sector 3	Chennai	600001	33	101	9876543210	store@company.com	Mr. Kumar	1	1	1	2025-07-25 12:17:26	2025-07-25 12:19:59
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 36	36	Abcd	8888		1			0	11	1	9838	dfdf	Dhfhhd	0	1	0	2025-07-25 12:38:54	2025-07-25 15:04:55
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 37	37	Fsdf	3432	NULL	1	NULL		0	11	1	34		Dsf	0	1	0	2025-07-25 15:08:15	NULL
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 38	38	Gjfjdhgs	545	NULL	1		Djjsgh	87533	11	1	7357350	89399	Dgfsh	0	1	0	2025-07-29 13:02:35	NULL
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 41	41	shdkdsk	dfdhf	Central godown for inventory	1	Industrial Area, Sector 3	Chennai	600001	33	101	9876543210	store@company.com	Mr. Kumar	0	1	0	2025-07-29 13:05:02	2025-07-29 15:06:35
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 42	42	Dfgjs	57885		1		Jdfk	87533	11	1	7357350	89399kl;jkhh	Dgfsh	0	0	1	2025-07-29 13:05:39	2025-10-17 11:36:57
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 43	43	Hdkfds	85335		1		Dfds	444	11	1	384347	dfdfl	Dfhdsk	0	1	1	2025-07-29 13:07:18	2025-08-22 15:59:52
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 44	44	Dfsfa	3477		1		Fdsahf	4834	11	1	74346	dfddfd	Dfsja	0	0	1	2025-07-29 15:07:55	2025-08-22 15:59:35
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 45	45	Fgdsj	48548		1		Fgdjs	4584	11	1	847574	jfjhll	Fgdjs	0	0	1	2025-07-29 15:32:56	2025-10-17 11:36:53
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 46	46	Dfhfd	934873		1		Fhds	394	11	1	3948347	fjdhf	Fjdf	0	0	1	2025-07-29 15:34:01	2025-08-22 17:44:19
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 47	47	Tests	1222		1		Shimoga	1234	11	1	123456	dfhdk	Nagraj	0	1	0	2025-07-29 16:04:21	2025-10-18 11:43:30
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 48	48	Hkjdh	34347		1		Hdkfjd	232763	11	1	9248247	fdsfah	Fdhfdsf	0	0	0	2025-07-29 16:11:26	2025-07-30 15:35:50
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 49	49	Dfd	3483		1		Dfdhsfa	3874	11	1	2472	375fjds	Fkdjs	0	1	0	2025-07-29 16:24:32	2025-07-30 15:36:24
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 50	50	Hfjds	74574		1		Fhsd	495	11	1	47545	fgshdg	Fhdf	0	1	0	2025-07-30 15:36:24	2025-08-20 16:46:06
Edit	Copy	Delete DELETE FROM items_godowns WHERE `items_godowns`.`id` = 51	51	Godown Namesjghj	1235454		1		Shimoga	577204	10	1	4565456	1645	Incharge Name	0	1	0	2025-08-20 12:50:12	2025-10-18 10:54:19

Customise appearance of the navigation panel.

Customise the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customise browse mode.

Navigation panel

Customise appearance of the navigation panel.

Navigation tree

Customise the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customise browse mode.