NG大舞台

pma__bookmark

Table comments: Bookmarks

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

pma__central_columns

Table comments: Central list of columns

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	1	A	No
				col_name	1	A	No

pma__column_info

Table comments: Column information for phpMyAdmin

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
db_name	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No
				column_name	0	A	No

pma__designer_settings

Table comments: Settings related to Designer

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__export_templates

Table comments: Saved export templates

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
u_user_type_template	BTREE	Yes	No	username	0	A	No
				export_type	0	A	No
				template_name	0	A	No

pma__favorite

Table comments: Favorite tables

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__history

Table comments: SQL history for phpMyAdmin

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
username	BTREE	No	No	username	0	A	No
				db	0	A	No
				table	0	A	No
				timevalue	0	A	No

pma__navigationhiding

Table comments: Hidden items of navigation tree

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
				item_name	0	A	No
				item_type	0	A	No
				db_name	0	A	No
				table_name	0	A	No

pma__pdf_pages

Table comments: PDF relation pages for phpMyAdmin

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	page_nr	0	A	No
db_name	BTREE	No	No	db_name	0	A	No

pma__recent

Table comments: Recently accessed tables

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__relation

Table comments: Relation table

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	master_db	0	A	No
				master_table	0	A	No
				master_field	0	A	No
foreign_field	BTREE	No	No	foreign_db	0	A	No
				foreign_table	0	A	No

pma__savedsearches

Table comments: Saved searches

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
u_savedsearches_username_dbname	BTREE	Yes	No	username	0	A	No
				db_name	0	A	No
				search_name	0	A	No

pma__table_coords

Table comments: Table coordinates for phpMyAdmin PDF output

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No
				pdf_page_number	0	A	No

pma__table_info

Table comments: Table information for phpMyAdmin

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	1	A	No
				table_name	1	A	No

pma__table_uiprefs

Table comments: Tables' UI preferences

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
				db_name	0	A	No
				table_name	0	A	No

pma__tracking

Table comments: Database changes tracking for phpMyAdmin

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No
				version	0	A	No

pma__userconfig

Table comments: User preferences storage for phpMyAdmin

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__usergroups

Table comments: User groups with configured menu items

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	usergroup	0	A	No
				tab	0	A	No
				allowed	0	A	No

pma__users

Table comments: Users and their assignments to user groups

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
				usergroup	0	A	No