www.kikkoman.mx / 127.0.0.1 / kikko / document_table_bk

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

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

			doc_table_id	user_level	kcc	ref_kcc	productcode	doc_name	doc_description	doc_keyword	created_user	created_date	expire_date	mod_user	mod_date	doc_file_name	upload_date	status 2=pending
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 35	35	3	110106		00050	110106.00050.3D.tiff	12 5 fl oz Soy Sauce 3D Image	00050 5 OZ SOY SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110106.00050.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 16667	16667	3	110704	1218	06156	110704_pearl-unsweetened.pdf	32 fl oz Pearl Organic Soymilk Unsweetened Sales S...	NULL	ahack	2021-03-15	2031-03-15	NULL	NULL	NULL	2021-03-15	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 42	42	3	110108	6c01	00160	110108.00160.SoySc_ 1Gal.specs.pdf	Soy Sauce Specifications	Soy Sauce SPECIFICATIONS SPECS 00160	miwa	2008-03-06	2029-12-31		2013-09-17	110108.00160.SoySc_ 1Gal.specs.pdf	2013-09-18	2
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 46	46	3	110111		00050, 00070, 00078, 00090	110111. Soy Sauce Allergen Main Letter_1.pdf	Soy Sauce Allergen Letter	Soy Sauce Allergen Letter	miwa	2008-03-06	2029-12-31		2013-09-17	110111. Soy Sauce Allergen Main Letter_1.pdf	2013-09-18	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 65	65	3	110207		00101, 00105, 00107, 00110	110207. LessSodiumSoySauce.3-05.nut.pdf	Less Sodium Soy Sauce Nutrition Facts	Less Sodium Soy Sauce nutrition nutritionals facts	miwa	2008-03-06	2029-12-31		2008-03-06	110207. LessSodiumSoySauce.3-05.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 95	95	3	110304		01504, 01500, 01512, 01508	110304.Q&E_marinades.pdf	Q&E Sales Sheet	Q&E sell sales Sheet 01504 01500 01512 01508 Roast...	miwa	2008-02-07	2029-12-31		2008-02-07	110304.Q&E_marinades.pdf	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 101	101	3	110306		01011	110306.01011.3D.tiff	12 5 fl oz Teriyaki Sauce 3D Image	01011 5 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01011.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 102	102	3	110306		01022	110306.01022.3D.tiff	12 10 fl oz Teriyaki Sauce 3D Image	01022 10 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01022.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 103	103	3	110306		01030	110306.01030.3D.tif	12 15 fl oz Teriyaki Sauce 3D Image	01030 15 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01030.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 104	104	3	110306		01033	110306.01033.3D.tiff	12 20 fl oz Teriyaki Sauce 3D Image	01033 20 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01033.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 105	105	3	110306		01035	110306.01035.3D.tiff	9 40 fl oz Teriyaki Sauce 3D Image	01035 40 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01035.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 106	106	3	110306		01040	110306.01040.3D.tiff	12 10 fl oz Less Sodium Teriyaki Sauce 3D Image	01040 10 OZ LESS SODIUM TERIYAKI SAUCE (LITE TERI)...	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01040.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 107	107	3	110306		01052	110306.01052.3D.tif	12 10 fl oz Roasted Garlic Teriyaki Sauce 3D Image	01052 10 OZ ROASTED GARLIC TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01052.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 108	108	3	110306		01054	110306.01054.3D.tiff	12 15 fl oz Roasted Garlic Teriyaki Sauce 3D Image	01054 15 OZ ROASTED GARLIC TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01054.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 109	109	3	110306		01056	110306.01056.3D.tiff	12 20 fl oz Roasted Garlic Teriyaki Sauce 3D Image	01056 20 OZ ROASTED GARLIC TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01056.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 110	110	3	110306		01110	110306.01110.3D.tif	12 12 wt oz Teriyaki B&G 3D Image	01110 12 OZ TERIYAKI B&G 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01110.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 111	111	3	110306		01185	110306.01185.3D.tif	12 12.8 wt oz Teriyaki B&G H&P 3D Image	01185 12.8 OZ TERIYAKI B&G H&P 3D Image	miwa	2008-02-07	2029-12-31		2008-02-07	110306.01185.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 112	112	3	110307		01040	110307. 01040.nut.pdf	12 10 fl oz Less Sodium Teriyaki Sauce Nutrition F...	01040 Less Sodium Teriyaki M&S nutrition nutrition...	miwa	2008-03-06	2029-12-31		2008-03-06	110307. 01040.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 113	113	3	110307		01500	110307. 01500 Q&E_Toast_Ses.nut.pdf	12 14 wt oz Q&E Toasted Sesame Teriyaki Nutrition ...	01500 Q&E Toasted Sesame nutrition nutritionals fa...	miwa	2008-03-06	2029-12-31		2013-09-12	110307. 01500 Q&E_Toast_Ses.nut.pdf	2013-09-12	0
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 114	114	3	110307		01504	110307. 01504.nut.pdf	12 14 wt oz Q&E Roasted Garlic & Herb Nutrition Fa...	01504 Q&E RG&H nutrition nutritionals facts	miwa	2008-03-06	2029-12-31		2008-03-06	110307. 01504.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 115	115	3	110307		01508	110307. 01508.nut.pdf	12 14 wt oz Q&E Gourmet Teriyaki Nutrition Facts	01508 Q&E Gourmet Teriyaki nutrition nutritionals ...	miwa	2008-03-06	2029-12-31		2008-03-06	110307. 01508.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 116	116	3	110307		01512	110307. 01512.3-05.nut.pdf	12 14 wt oz Q&E Honey & Mustard Teriyaki Nutrition...	01512 Honey & Mustard nutrition nutritionals facts	miwa	2008-03-06	2029-12-31		2008-03-06	110307. 01512.3-05.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 117	117	3	110307		01052, 01054, 01056	110307. RGT_M&S.nut.pdf	10 fl, 15 fl, 20 fl oz Roasted Garlic M&S Nutritio...	Roasted Garlic M&S nutrition nutritionals facts 01...	miwa	2008-03-06	2029-12-31		2008-03-06	110307. RGT_M&S.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 118	118	3	110307		01110	110307. TeriB&G.nut.pdf	12 12 wt oz Teriyaki B&G Nutrition Facts	Teriyaki Baste & Glaze nutrition nutritionals fact...	miwa	2008-03-06	2029-12-31		2008-03-06	110307. TeriB&G.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table_bk` WHERE `document_table_bk`.`doc_table_id` = 119	119	3	110307		01185	110307. TeriB&GwithH&P.nut.pdf	12 12.8 wt oz Teriyaki B&G H&P Nutrition Facts	Teriyaki Baste & Glaze with Honey & Pineapple nutr...	miwa	2008-03-06	2029-12-31		2008-03-06	110307. TeriB&GwithH&P.nut.pdf	2008-03-06	1

SQL upload ( 0 ) x-