Print view - phpMyAdmin 4.5.1

agama

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(100)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	5	A	No
agama_createby	BTREE	No	No	CreateBy	2	A	Yes
agama_updateby	BTREE	No	No	UpdateBy	2	A	Yes
agama_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
agama_createdate	BTREE	No	No	CreateDate	2	A	Yes
agama_updatedate	BTREE	No	No	UpdateDate	2	A	Yes

app_installed

Column	Type	Null	Default
ID (Primary)	int(11)	No
ActivationCode	varchar(255)	No
PerpustakaanName	text	Yes	NULL
CreateDate	datetime	No
CreateTerminal	varchar(100)	No
Type	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ID	59	A	No
UNIQUE	BTREE	Yes	No	ActivationCode	59	A	No

applications

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(100)	No
Name	varchar(255)	No
URL	varchar(255)	Yes	NULL
WhenDownMessageError	varchar(255)	Yes	NULL
IsPublish	bit(1)	Yes	b'1'
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
applications_createby	BTREE	No	No	CreateBy	2	A	Yes
applications_updateby	BTREE	No	No	UpdateBy	2	A	Yes

auth_assignment

Column	Type	Null	Default	Links to
item_name (Primary)	varchar(64)	No		auth_item -> name
user_id (Primary)	varchar(64)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
created_at	varchar(45)	Yes	NULL
updated_at	varchar(45)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	item_name	9	A	No
PRIMARY	BTREE	Yes	No	user_id	9	A	No
auth_assignment_createby	BTREE	No	No	CreateBy	2	A	Yes
auth_assignment_updateby	BTREE	No	No	UpdateBy	2	A	Yes

auth_data

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Auth_Header_ID	int(11)	No		auth_header -> ID
Tag	varchar(3)	No
Indicator1	char(1)	Yes	NULL
Indicator2	char(1)	Yes	NULL
Value	varchar(700)	Yes	NULL
DataItem	varchar(700)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	109722	A	No
auth_data_auth_header	BTREE	No	No	Auth_Header_ID	21944	A	No
auth_data_createby	BTREE	No	No	CreateBy	2	A	Yes
auth_data_updateby	BTREE	No	No	UpdateBy	2	A	Yes
auth_data_IDX1	BTREE	No	No	Auth_Header_ID	21944	A	No
auth_data_IDX1	BTREE	No	No	Tag	109722	A	No
auth_data_IDX2	BTREE	No	No	Tag	48	A	No
auth_data_IDX2	BTREE	No	No	Value	109722	A	Yes
auth_data_IDX3	BTREE	No	No	Tag	50	A	No
auth_data_IDX3	BTREE	No	No	DataItem	50	A	Yes
auth_data_IDX4	BTREE	No	No	Value	109722	A	Yes

auth_header

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Worksheet_id	int(11)	No		worksheets -> ID
Auth_ID	varchar(20)	No
MARC_LOC	text	Yes	NULL
ISTILAH_DIGUNAKAN	text	Yes	NULL
ISTILAH_TDK_DIGUNAKAN	text	Yes	NULL
ISTILAH_TERKAIT	text	Yes	NULL
TANGGALPEMBAHASAN	varchar(45)	Yes	NULL
QUARANTINEDBY	int(11)	Yes	NULL
QUARANTINEDDATE	datetime	Yes	NULL
QUARANTINEDTERMINAL	varchar(100)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	10143	A	No
auth_header_id	BTREE	Yes	No	Auth_ID	10143	A	No
auth_header_worksheet_id	BTREE	No	No	Worksheet_id	2	A	No
auth_header_createby	BTREE	No	No	CreateBy	2	A	Yes
auth_header_updateby	BTREE	No	No	UpdateBy	2	A	Yes
auth_header_authid	BTREE	No	No	Auth_ID	10143	A	No

auth_item

Column	Type	Null	Default	Links to
name (Primary)	varchar(64)	No
type	int(11)	No
description	text	Yes	NULL
rule_name	varchar(64)	Yes	NULL	auth_rule -> name
data	text	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
created_at	varchar(45)	Yes	NULL
updated_at	varchar(45)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	name	1168	A	No
rule_name	BTREE	No	No	rule_name	2	A	Yes
idx-auth_item-type	BTREE	No	No	type	4	A	No
auth_item_createby	BTREE	No	No	CreateBy	2	A	Yes
auth_item_updateby	BTREE	No	No	UpdateBy	2	A	Yes

auth_item_child

Column	Type	Null	Default	Links to
parent (Primary)	varchar(64)	No		auth_item -> name
child (Primary)	varchar(64)	No		auth_item -> name
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	parent	12	A	No
PRIMARY	BTREE	Yes	No	child	111	A	No
child	BTREE	No	No	child	111	A	No
auth_item_child_createby	BTREE	No	No	CreateBy	2	A	Yes
auth_item_child_updateby	BTREE	No	No	UpdateBy	2	A	Yes

auth_rule

Column	Type	Null	Default	Links to
name (Primary)	varchar(64)	No
data	text	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	name	A	No
auth_rule_createby	BTREE	No	No	CreateBy	A	Yes
auth_rule_updateby	BTREE	No	No	UpdateBy	A	Yes

bacaditempat

Column	Type	Null	Default	Links to
ID (Primary)	double	No
NoPengunjung	varchar(50)	Yes	NULL
collection_id	double	No		collections -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
Member_id	double	Yes	NULL	members -> ID
Location_Id	int(11)	Yes	NULL	locations -> ID
Is_return	enum('0', '1')	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	53	A	No
BacaDitempat_NoPengujung	BTREE	No	No	NoPengunjung	4	A	Yes
bacaditempat_createby	BTREE	No	No	CreateBy	2	A	Yes
bacaditempat_updateby	BTREE	No	No	UpdateBy	2	A	Yes
bacaditempat_collections	BTREE	No	No	collection_id	53	A	No
bacaditempat_locations	BTREE	No	No	Location_Id	13	A	Yes
bacaditempat_Noanggota	BTREE	No	No	Member_id	26	A	Yes

bacaditempat_locations

Column	Type	Null	Default
ID (Primary)	int(11)	No
IP_PC	varchar(100)	No
Location_ID	int(11)	Yes	NULL
CreateBy	int(11)	Yes	NULL
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
FK_logincheckpoint_locations	BTREE	No	No	Location_ID	A	Yes
checkpoint_locations_createby	BTREE	No	No	CreateBy	A	Yes
checkpoint_locations_updateby	BTREE	No	No	UpdateBy	A	Yes
bacaditempat_locations_ip	BTREE	No	No	IP_PC	A	No

backup

Column	Type	Null	Default
ID (Primary)	int(11)	No
BackupType	varchar(20)	No
FileName	varchar(255)	No
FileSize	varchar(100)	Yes	NULL
CreateBy	int(11)	Yes	NULL
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ID	2	A	No
backup_createby	BTREE	No	No	CreateBy	2	A	Yes

bibidavailable

Column	Type	Null	Default	Links to
BIBID (Primary)	varchar(50)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	BIBID	A	No
BIBID_UNIQUE	BTREE	Yes	No	BIBID	A	No
bibidavailable_createby	BTREE	No	No	CreateBy	A	Yes
bibidavailable_updateby	BTREE	No	No	UpdateBy	A	Yes

bookinglogs

Column	Type	Null	Default	Links to
memberId	varchar(50)	Yes	NULL	members -> MemberNo
collectionId	double	Yes	NULL
bookingDate	datetime	Yes	NULL
bookingExpired	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
fk_bookinglogs_memberId_idx	BTREE	No	No	memberId	3	A	Yes

bookmark

Column	Type	Null	Default	Links to
ID (Primary)	double	No
Sesi	text	No
Value	text	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
bookmark_createby	BTREE	No	No	CreateBy	A	Yes
bookmark_updateby	BTREE	No	No	UpdateBy	A	Yes

branchs

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	43	A	No
branchs_createby	BTREE	No	No	CreateBy	6	A	Yes
branchs_updateby	BTREE	No	No	UpdateBy	6	A	Yes
branchs_code	BTREE	No	No	Code	43	A	No

cardformats

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(100)	No
Width	int(11)	Yes	400
Height	int(11)	Yes	400
FontName	varchar(30)	Yes	Verdana
FontSize	int(11)	Yes	12
FormatTeks	text	Yes	NULL
FormatTeksNoAuthor	text	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	5	A	No
cardformats_createby	BTREE	No	No	CreateBy	2	A	Yes
cardformats_updateby	BTREE	No	No	UpdateBy	2	A	Yes

catalog_ruas

Column	Type	Null	Default	Links to
ID (Primary)	double	No
CatalogId	double	No		catalogs -> ID
Tag	varchar(3)	No
Indicator1	char(1)	Yes	NULL
Indicator2	char(1)	Yes	NULL
Value	text	Yes	NULL
Sequence	int(11)	No	0
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2013	A	No
catalog_ruas_catalogs_idx	BTREE	No	No	CatalogId	251	A	No
catalog_ruas_createby_idx	BTREE	No	No	CreateBy	26	A	Yes
catalog_ruas_tag	BTREE	No	No	Tag	154	A	No
catalog_ruas_IDX1	BTREE	No	No	CatalogId	251	A	No
				Tag	2013	A	No
				Value (767)	2013	A	Yes
catalog_ruas_updateby_idx	BTREE	No	No	UpdateBy	26	A	Yes

catalog_subruas

Column	Type	Null	Default	Links to
ID (Primary)	double	No
RuasID	double	No		catalog_ruas -> ID
SubRuas	varchar(10)	Yes	NULL
Value	text	Yes	NULL
Sequence	int(11)	No	0
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2711	A	No
SubRuas	BTREE	No	No	SubRuas	64	A	Yes
RuasID_SubRuas	BTREE	No	No	RuasID	2711	A	No
RuasID_SubRuas	BTREE	No	No	SubRuas	2711	A	Yes
Catalog_Subruas_Value	BTREE	No	No	Value (767)	2711	A	Yes
catalog_subruas_createby	BTREE	No	No	CreateBy	26	A	Yes
catalog_subruas_updateby	BTREE	No	No	UpdateBy	26	A	Yes

catalogfiles

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Catalog_id	double	No		catalogs -> ID
FileURL	varchar(255)	Yes	NULL
FileFlash	varchar(255)	Yes	NULL
IsPublish	tinyint(4)	Yes	1
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
IsFromMember	bit(1)	Yes	b'0'
Member_id	double	Yes	NULL	members -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	28	A	No
catalogfiles_catalog	BTREE	No	No	Catalog_id	28	A	No
catalogfiles_createby	BTREE	No	No	CreateBy	14	A	Yes
catalogfiles_updateby	BTREE	No	No	UpdateBy	14	A	Yes
catalogfiles_fileurl	BTREE	No	No	FileURL	28	A	Yes
catalogfiles_fileflash	BTREE	No	No	FileFlash	9	A	Yes
catalogfiles_ispublish	BTREE	No	No	IsPublish	4	A	Yes
catalogfiles_member_idx	BTREE	No	No	Member_id	2	A	Yes

catalogs

Column	Type	Null	Default	Links to
ID (Primary)	double	No
ControlNumber	varchar(50)	No
BIBID	varchar(50)	No
Title	varchar(700)	No
Author	varchar(700)	Yes	NULL
Edition	varchar(255)	Yes	NULL
Publisher	varchar(255)	Yes	NULL
PublishLocation	varchar(255)	Yes	NULL
PublishYear	varchar(255)	Yes	NULL
Subject	varchar(700)	Yes	NULL
PhysicalDescription	varchar(255)	Yes	NULL
ISBN	varchar(700)	Yes	NULL
CallNumber	varchar(700)	Yes	NULL
Note	text	Yes	NULL
Languages	varchar(255)	Yes	NULL
DeweyNo	varchar(255)	Yes	NULL
ApproveDateOPAC	datetime	Yes	NULL
IsOPAC	tinyint(4)	Yes	1
IsBNI	bit(1)	Yes	b'1'
IsKIN	bit(1)	Yes	b'1'
IsRDA	bit(1)	Yes	b'0'
CoverURL	varchar(255)	Yes	NULL
Branch_id	int(11)	Yes	NULL	branchs -> ID
Worksheet_id	int(11)	No		worksheets -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
MARC_LOC	text	Yes	NULL
PRESERVASI_ID	varchar(20)	Yes	NULL
QUARANTINEDBY	int(11)	Yes	NULL	users -> ID
QUARANTINEDDATE	datetime	Yes	NULL
QUARANTINEDTERMINAL	varchar(100)	Yes	NULL
Member_id	double	Yes	NULL	members -> ID
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	116	A	No
catalogs_BIBID	BTREE	Yes	No	BIBID	116	A	No
catalogs_createby	BTREE	No	No	CreateBy	38	A	Yes
catalogs_updateby	BTREE	No	No	UpdateBy	12	A	Yes
catalogs_author	BTREE	No	No	Author	116	A	Yes
catalogs_edition	BTREE	No	No	Edition	116	A	Yes
catalogs_publisher	BTREE	No	No	Publisher	116	A	Yes
catalogs_publishlocation	BTREE	No	No	PublishLocation	116	A	Yes
catalogs_publishyear	BTREE	No	No	PublishYear	116	A	Yes
catalogs_subject	BTREE	No	No	Subject	116	A	Yes
catalogs_physicaldesc	BTREE	No	No	PhysicalDescription	116	A	Yes
catalogs_isbn	BTREE	No	No	ISBN	116	A	Yes
catalogs_callnumber	BTREE	No	No	CallNumber	116	A	Yes
catalogs_deweyno	BTREE	No	No	DeweyNo	116	A	Yes
catalogs_languages	BTREE	No	No	Languages	16	A	Yes
catalogs_quarantinedby	BTREE	No	No	QUARANTINEDBY	2	A	Yes
catalogs_createdate	BTREE	No	No	CreateDate	116	A	Yes
catalogs_isopac	BTREE	No	No	IsOPAC	4	A	Yes
catalogs_Worksheet_id	BTREE	No	No	Worksheet_id	4	A	No
catalogs_Branch_id	BTREE	No	No	Branch_id	4	A	Yes
catalogs_member_idx	BTREE	No	No	Member_id	2	A	Yes
catalogs_controlnumber	BTREE	No	No	ControlNumber	116	A	No
catalogs_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
catalogs_updatedate	BTREE	No	No	UpdateDate	116	A	Yes
catalogs_title	BTREE	No	No	Title	116	A	No

catalogstaging

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Title	varchar(700)	No
Author	varchar(700)	Yes	NULL
Publishment	varchar(255)	Yes	NULL
Edition	varchar(255)	Yes	NULL
MARC_LOC	text	Yes	NULL
Worksheet_id	int(11)	Yes	1
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
catalogstaging_createby	BTREE	No	No	CreateBy	A	Yes
catalogstaging_updateby	BTREE	No	No	UpdateBy	A	Yes

cetak_bebas_pustaka

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(100)	No
RDLC_File_Name	varchar(100)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
cetak_bebas_pustaka_createby	BTREE	No	No	CreateBy	2	A	Yes
cetak_bebas_pustaka_updateby	BTREE	No	No	UpdateBy	2	A	Yes
cetak_bebas_pustaka_createdate	BTREE	No	No	CreateDate	2	A	Yes
cetak_bebas_pustaka_updatedate	BTREE	No	No	UpdateDate	2	A	Yes

cetak_kartu_anggota

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(100)	No
RDLC_File_Name	varchar(100)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	5	A	No
cetak_kartu_anggota_createby	BTREE	No	No	CreateBy	5	A	Yes
cetak_kartu_anggota_updateby	BTREE	No	No	UpdateBy	5	A	Yes
cetak_kartu_anggota_createdate	BTREE	No	No	CreateDate	5	A	Yes
cetak_kartu_anggota_updatedate	BTREE	No	No	UpdateDate	5	A	Yes

checkpoint_locations

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
IP_PC	varchar(100)	No
Location_ID	int(11)	Yes	NULL	locations -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
IP_PC	BTREE	Yes	No	IP_PC	A	No
FK_logincheckpoint_locations	BTREE	No	No	Location_ID	A	Yes
checkpoint_locations_createby	BTREE	No	No	CreateBy	A	Yes
checkpoint_locations_updateby	BTREE	No	No	UpdateBy	A	Yes

collectioncategorys

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	8	A	No
collectioncategorys_createby	BTREE	No	No	CreateBy	8	A	Yes
collectioncategorys_updateby	BTREE	No	No	UpdateBy	8	A	Yes
collectioncategorys_kii	BTREE	No	No	KIILastUploadDate	4	A	Yes
collectioncategorys_createdate	BTREE	No	No	CreateDate	8	A	Yes
collectioncategorys_updatedate	BTREE	No	No	UpdateDate	8	A	Yes

collectioncategorysdefault

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
CollectionCategory_id	int(11)	Yes	NULL	collectioncategorys -> ID
JenisAnggota_id	int(11)	No		jenis_anggota -> id
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	12	A	No
collectioncategorysdefault_category	BTREE	No	No	CollectionCategory_id	12	A	Yes
collectioncategorysdefault_jenis_anggota	BTREE	No	No	JenisAnggota_id	6	A	No
collectioncategorysdefault_createby	BTREE	No	No	CreateBy	4	A	Yes
collectioncategorysdefault_updateby	BTREE	No	No	UpdateBy	4	A	Yes

collectionloanextends

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
CollectionLoan_id	varchar(255)	No		collectionloans -> ID
CollectionLoanItem_id	double	No		collectionloanitems -> ID
Collection_id	double	No		collections -> ID
Member_id	double	No		members -> ID
DateExtend	datetime	No
DueDateExtend	datetime	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
collectionloanextends_colloan_idx	BTREE	No	No	CollectionLoan_id	A	No
collectionloanextends_colloanitem_idx	BTREE	No	No	CollectionLoanItem_id	A	No
collectionloanextends_col_idx	BTREE	No	No	Collection_id	A	No
collectionloanextends_member_idx	BTREE	No	No	Member_id	A	No
collectionloanextends_createby_idx	BTREE	No	No	CreateBy	A	Yes
collectionloanextends_updateby_idx	BTREE	No	No	UpdateBy	A	Yes

collectionloanitems

Column	Type	Null	Default	Links to
ID (Primary)	double	No
CollectionLoan_id	varchar(255)	No		collectionloans -> ID
LoanDate	datetime	Yes	NULL
DueDate	datetime	Yes	NULL
ActualReturn	datetime	Yes	NULL
LateDays	int(11)	Yes	NULL
LoanStatus	varchar(50)	Yes	NULL
Collection_id	double	No		collections -> ID
member_id	double	No		members -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	28	A	No
collectionloanitems_members	BTREE	No	No	member_id	28	A	No
collectionloanitems_LoanDate	BTREE	No	No	LoanDate	28	A	Yes
collectionloanitems_LoanStatus	BTREE	No	No	LoanStatus	4	A	Yes
collectionloanitems_createby	BTREE	No	No	CreateBy	14	A	Yes
collectionloanitems_updateby	BTREE	No	No	UpdateBy	14	A	Yes
collectionloanitems_collections	BTREE	No	No	Collection_id	28	A	No
collectionloanitems_collectionloans	BTREE	No	No	CollectionLoan_id	28	A	No
collectionloanitems_duedate	BTREE	No	No	DueDate	28	A	Yes
collectionloanitems_actualreturn	BTREE	No	No	ActualReturn	28	A	Yes
collectionloanitems_idx1	BTREE	No	No	LoanDate	28	A	Yes
collectionloanitems_idx1	BTREE	No	No	member_id	28	A	No

collectionloans

Column	Type	Null	Default	Links to
ID (Primary)	varchar(255)	No
CollectionCount	int(11)	Yes	0
LateCount	int(11)	Yes	0
ExtendCount	int(11)	Yes	0
LoanCount	int(11)	Yes	0
ReturnCount	int(11)	Yes	0
Member_id	double	No		members -> ID
Branch_id	int(11)	Yes	NULL	branchs -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	22	A	No
Member_id	BTREE	No	No	Member_id	22	A	No
Branch_id	BTREE	No	No	Branch_id	2	A	Yes
collectionloans_createby	BTREE	No	No	CreateBy	11	A	Yes
collectionloans_updateby	BTREE	No	No	UpdateBy	11	A	Yes

collectionlocations

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
Description	varchar(255)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
collectionlocations_createby	BTREE	No	No	CreateBy	A	Yes
collectionlocations_updateby	BTREE	No	No	UpdateBy	A	Yes

collectionmedias

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
Worksheet_id	int(11)	Yes	NULL	worksheets -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	47	A	No
collectionmedias_worksheet	BTREE	No	No	Worksheet_id	47	A	Yes
collectionmedias_createby	BTREE	No	No	CreateBy	4	A	Yes
collectionmedias_updateby	BTREE	No	No	UpdateBy	4	A	Yes
collectionmedias_kii	BTREE	No	No	KIILastUploadDate	4	A	Yes
collectionmedias_createdate	BTREE	No	No	CreateDate	47	A	Yes
collectionmedias_updatedate	BTREE	No	No	UpdateDate	47	A	Yes

collectionrules

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(50)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	5	A	No
collectionrules_createby	BTREE	No	No	CreateBy	5	A	Yes
collectionrules_updateby	BTREE	No	No	UpdateBy	5	A	Yes
collectionrules_kii	BTREE	No	No	KIILastUploadDate	5	A	Yes
collectionrules_createdate	BTREE	No	No	CreateDate	5	A	Yes
collectionrules_updatedate	BTREE	No	No	UpdateDate	5	A	Yes

collectionrulesitems

Column	Type	Null	Default	Links to
CollectionRules_id	int(11)	No		collectionrules -> ID
StartDay	int(11)	No
EndDay	int(11)	No
SuspendDays	int(11)	Yes	0
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
CollectionRules_id	BTREE	No	No	CollectionRules_id	A	No
collectionrulesitems_createby	BTREE	No	No	CreateBy	A	Yes
collectionrulesitems_updateby	BTREE	No	No	UpdateBy	A	Yes

collections

Column	Type	Null	Default	Links to
ID (Primary)	double	No
NomorBarcode	varchar(50)	No
NoInduk	varchar(50)	Yes	NULL
Currency	varchar(30)	Yes	NULL	currency -> Currency
RFID	varchar(50)	Yes	NULL
Price	decimal(10,0)	Yes	NULL
PriceType	varchar(45)	Yes	NULL
TanggalPengadaan	datetime	Yes	NULL
CallNumber	varchar(255)	Yes	NULL
Branch_id	int(11)	Yes	NULL	branchs -> ID
Catalog_id	double	Yes	NULL	catalogs -> ID
Partner_id	int(11)	Yes	NULL	partners -> ID
Location_id	int(11)	Yes	NULL	locations -> ID
Rule_id	int(11)	Yes	NULL	collectionrules -> ID
Category_id	int(11)	Yes	NULL	collectioncategorys -> ID
Media_id	int(11)	Yes	NULL	collectionmedias -> ID
Source_id	int(11)	Yes	NULL	collectionsources -> ID
Status_id	int(11)	Yes	9	collectionstatus -> ID
Location_Library_id	int(11)	Yes	NULL	location_library -> ID
Keterangan_Sumber	varchar(255)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
IsVerified	bit(1)	Yes	b'0'
QUARANTINEDBY	int(11)	Yes	NULL	users -> ID
QUARANTINEDDATE	date	Yes	NULL
QUARANTINEDTERMINAL	varchar(100)	Yes	NULL
ISREFERENSI	bit(1)	Yes	b'0'
EDISISERIAL	varchar(255)	Yes	NULL
NOJILID	int(11)	Yes	NULL
TANGGAL_TERBIT_EDISI_SERIAL	date	Yes	NULL
BAHAN_SERTAAN	varchar(255)	Yes	NULL
KETERANGAN_LAIN	varchar(255)	Yes	NULL
TGLENTRYJILID	date	Yes	NULL
IDJILID	varchar(20)	Yes	NULL
NOMORPANGGILJILID	varchar(100)	Yes	NULL
ISOPAC	tinyint(4)	Yes	1
JILIDCREATEBY	int(11)	Yes	NULL	users -> ID
KIILastUploadDate	datetime	Yes	NULL
BookingMemberID	varchar(50)	Yes	NULL
BookingExpiredDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	65	A	No
collections_NomorBarcode	BTREE	Yes	No	NomorBarcode	65	A	No
Branch_id	BTREE	No	No	Branch_id	2	A	Yes
Catalog_id	BTREE	No	No	Catalog_id	65	A	Yes
Partner_id	BTREE	No	No	Partner_id	65	A	Yes
Location_id	BTREE	No	No	Location_id	13	A	Yes
Rule_id	BTREE	No	No	Rule_id	8	A	Yes
Category_id	BTREE	No	No	Category_id	10	A	Yes
Media_id	BTREE	No	No	Media_id	16	A	Yes
Source_id	BTREE	No	No	Source_id	8	A	Yes
collections_callnumber	BTREE	No	No	CallNumber	65	A	Yes
collections_status	BTREE	No	No	Status_id	8	A	Yes
collections_createby	BTREE	No	No	CreateBy	16	A	Yes
collections_updateby	BTREE	No	No	UpdateBy	8	A	Yes
collections_quarantinedby	BTREE	No	No	QUARANTINEDBY	4	A	Yes
collections_jilidcreateby	BTREE	No	No	JILIDCREATEBY	4	A	Yes
collections_idjilid	BTREE	No	No	IDJILID	4	A	Yes
collections_currency	BTREE	No	No	Currency	6	A	Yes
collections_NoInduk	BTREE	No	No	NoInduk	65	A	Yes
collections_edisiserial	BTREE	No	No	EDISISERIAL	21	A	Yes
collections_nopanggiljilid	BTREE	No	No	NOMORPANGGILJILID	2	A	Yes
collections_jilid1	BTREE	No	No	IDJILID	4	A	Yes
				NOMORPANGGILJILID	4	A	Yes
				Catalog_id	65	A	Yes
collections_tglentryjilid	BTREE	No	No	TGLENTRYJILID	4	A	Yes
collections_tanggalpengadaan	BTREE	No	No	TanggalPengadaan	65	A	Yes
collections_rfid	BTREE	No	No	RFID	65	A	Yes
collections_location_library_idx	BTREE	No	No	Location_Library_id	8	A	Yes
collections_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
collections_createdate	BTREE	No	No	CreateDate	65	A	Yes
collections_updatedate	BTREE	No	No	UpdateDate	65	A	Yes

collectionsources

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	7	A	No
collectionsources_createby	BTREE	No	No	CreateBy	2	A	Yes
collectionsources_updateby	BTREE	No	No	UpdateBy	7	A	Yes
collectionsources_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
collectionsources_createdate	BTREE	No	No	CreateDate	2	A	Yes
collectionsources_updatedate	BTREE	No	No	UpdateDate	7	A	Yes

collectionstatus

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(50)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	11	A	No
collectionstatus_createby	BTREE	No	No	CreateBy	5	A	Yes
collectionstatus_updateby	BTREE	No	No	UpdateBy	5	A	Yes
collectionstatus_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
collectionstatus_createdate	BTREE	No	No	CreateDate	11	A	Yes
collectionstatus_updatedate	BTREE	No	No	UpdateDate	11	A	Yes

colloclib

Column	Type	Null	Default	Links to
Col_id	double	No		collections -> ID
LocLib_id	int(11)	No		location_library -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
Col_id	BTREE	No	No	Col_id	A	No
LocLib_id	BTREE	No	No	LocLib_id	A	No
colloclib_createby	BTREE	No	No	CreateBy	A	Yes
colloclib_updateby	BTREE	No	No	UpdateBy	A	Yes

column_stats

Table comments: Statistics on Columns

Column	Type	Null	Default
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
column_name (Primary)	varchar(64)	No
min_value	varchar(255)	Yes	NULL
max_value	varchar(255)	Yes	NULL
nulls_ratio	decimal(12,4)	Yes	NULL
avg_length	decimal(12,4)	Yes	NULL
avg_frequency	decimal(12,4)	Yes	NULL
hist_size	tinyint(3)	Yes	NULL
hist_type	enum('SINGLE_PREC_HB', 'DOUBLE_PREC_HB')	Yes	NULL
histogram	varbinary(255)	Yes	NULL

Indexes

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

columns_priv

Table comments: Column privileges

Column	Type	Null	Default	Links to
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(80)	No
Table_name (Primary)	char(64)	No
Column_name (Primary)	char(64)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP
Column_priv	set('Select', 'Insert', 'Update', 'References')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Host	1	A	No
				Db	1	A	No
				User	1	A	No
				Table_name	2	A	No
				Column_name	30	A	No

currency

Column	Type	Null	Default	Links to
Currency (Primary)	varchar(20)	No
Description	varchar(200)	No
Sort_ID	int(11)	Yes	999
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Currency	184	A	No
CURRENCY_UNIQUE	BTREE	Yes	No	Currency	184	A	No
currency_createby	BTREE	No	No	CreateBy	2	A	Yes
currency_updateby	BTREE	No	No	UpdateBy	2	A	Yes
currency_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
currency_createdate	BTREE	No	No	CreateDate	4	A	Yes
currency_updatedate	BTREE	No	No	UpdateDate	2	A	Yes
currency_sortno	BTREE	No	No	Sort_ID	12	A	Yes

daemons

Column	Type	Null	Default	Links to	Comments	MIME
Start	text	No
Info	text	No

db

Table comments: Database privileges

Column	Type	Null	Default	Links to
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(80)	No
Select_priv	enum('N', 'Y')	No	N
Insert_priv	enum('N', 'Y')	No	N
Update_priv	enum('N', 'Y')	No	N
Delete_priv	enum('N', 'Y')	No	N
Create_priv	enum('N', 'Y')	No	N
Drop_priv	enum('N', 'Y')	No	N
Grant_priv	enum('N', 'Y')	No	N
References_priv	enum('N', 'Y')	No	N
Index_priv	enum('N', 'Y')	No	N
Alter_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Create_view_priv	enum('N', 'Y')	No	N
Show_view_priv	enum('N', 'Y')	No	N
Create_routine_priv	enum('N', 'Y')	No	N
Alter_routine_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Event_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Host	1	A	No
				Db	3	A	No
				User	3	A	No
User	BTREE	No	No	User	1	A	No

departments

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
Description	varchar(255)	Yes	NULL
IsActive	bit(1)	Yes	b'1'
ParentID	int(11)	Yes	NULL	departments -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	3	A	No
Code	BTREE	Yes	No	Code	3	A	No
ParentID	BTREE	No	No	ParentID	3	A	Yes
departments_createby	BTREE	No	No	CreateBy	3	A	Yes
departments_updateby	BTREE	No	No	UpdateBy	3	A	Yes
departments_kii	BTREE	No	No	KIILastUploadDate	3	A	Yes
departments_createdate	BTREE	No	No	CreateDate	3	A	Yes
departments_updatedate	BTREE	No	No	UpdateDate	3	A	Yes

djkn_data

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Collection_id	double	Yes	NULL	collections -> ID
Cover	varchar(100)	Yes	NULL
Finishing_Cover	varchar(100)	Yes	NULL
Finishing_HardCover	varchar(100)	Yes	NULL
Binding	varchar(100)	Yes	NULL
Total_Page	varchar(20)	Yes	NULL
Paper_Type	varchar(100)	Yes	NULL
Book_Size	varchar(100)	Yes	NULL
Condition_Book	varchar(100)	Yes	NULL
Conditions_Outdated	varchar(100)	Yes	NULL
FULL_COLOR	varchar(100)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(45)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(45)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
djkn_data_createby_idx	BTREE	No	No	CreateBy	A	Yes
djkn_data_updateby_idx	BTREE	No	No	UpdateBy	A	Yes
djkn_data_collection_idx	BTREE	No	No	Collection_id	A	Yes

event

Table comments: Events

Column	Type	Null	Default	Links to
db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
name (Primary)	char(64)	No
body	longblob	No
definer	char(141)	No
execute_at	datetime	Yes	NULL
interval_value	int(11)	Yes	NULL
interval_field	enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')	Yes	NULL
created	timestamp	No	CURRENT_TIMESTAMP
modified	timestamp	No	0000-00-00 00:00:00
last_executed	datetime	Yes	NULL
starts	datetime	Yes	NULL
ends	datetime	Yes	NULL
status	enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')	No	ENABLED
on_completion	enum('DROP', 'PRESERVE')	No	DROP
sql_mode	set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')	No
comment	char(64)	No
originator	int(10)	No
time_zone	char(64)	No	SYSTEM
character_set_client	char(32)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connection	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
db_collation	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
body_utf8	longblob	Yes	NULL

Indexes

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

favorite

Column	Type	Null	Default	Links to
id (Primary)	double	No
Catalog_Id	double	Yes	NULL	catalogs -> ID
Member_Id	varchar(50)	Yes	NULL	members -> MemberNo
Createdate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	6	A	No
FK_Catalog	BTREE	No	No	Catalog_Id	6	A	Yes
FK_members	BTREE	No	No	Member_Id	6	A	Yes

fielddatas

Column	Type	Null	Default	Links to
Field_id (Primary)	int(11)	No		fields -> ID
Code (Primary)	varchar(10)	No
Name	varchar(255)	No
Delimiter	varchar(5)	Yes	NULL
SortNo	int(11)	Yes	99
Repeatable	bit(1)	Yes	b'0'
IsShow	bit(1)	Yes	b'1'
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Field_id	288	A	No
PRIMARY	BTREE	Yes	No	Code	865	A	No
fielddatas_delimiter	BTREE	No	No	Delimiter	14	A	Yes
fielddatas_createby	BTREE	No	No	CreateBy	6	A	Yes
fielddatas_updateby	BTREE	No	No	UpdateBy	6	A	Yes
fielddatas_fieldid	BTREE	No	No	Field_id	288	A	No
fielddatas_code	BTREE	No	No	Code	66	A	No

fieldgroups

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(20)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
fieldgroups_createby	BTREE	No	No	CreateBy	2	A	Yes
fieldgroups_updateby	BTREE	No	No	UpdateBy	2	A	Yes

fieldindicator1s

Column	Type	Null	Default	Links to
Field_id (Primary)	int(11)	No		fields -> ID
Code (Primary)	varchar(10)	No
Name	varchar(255)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Field_id	302	A	No
PRIMARY	BTREE	Yes	No	Code	302	A	No
Field_id	BTREE	No	No	Field_id	302	A	No
fieldindicator1s_createby	BTREE	No	No	CreateBy	6	A	Yes
fieldindicator1s_updateby	BTREE	No	No	UpdateBy	6	A	Yes

fieldindicator2s

Column	Type	Null	Default	Links to
Field_id (Primary)	int(11)	No		fields -> ID
Code (Primary)	varchar(10)	No
Name	varchar(255)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Field_id	254	A	No
PRIMARY	BTREE	Yes	No	Code	254	A	No
Field_id	BTREE	No	No	Field_id	254	A	No
fieldindicator2s_createby	BTREE	No	No	CreateBy	6	A	Yes
fieldindicator2s_updateby	BTREE	No	No	UpdateBy	6	A	Yes

fields

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Tag	varchar(3)	No
Name	varchar(100)	No
Fixed	bit(1)	Yes	NULL
Enabled	bit(1)	Yes	NULL
Length	int(11)	Yes	NULL
Repeatable	bit(1)	Yes	NULL
Mandatory	bit(1)	Yes	NULL
IsCustomable	bit(1)	Yes	NULL
Format_id	int(11)	No		formats -> ID
Group_id	int(11)	No		fieldgroups -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
DEFAULTSUBTAG	varchar(12)	Yes	a
ISSUBSERIAL	bit(1)	Yes	b'0'

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	138	A	No
UQ_Tag	BTREE	Yes	No	Tag	138	A	No
UQ_Tag	BTREE	Yes	No	Format_id	138	A	No
Format_id	BTREE	No	No	Format_id	2	A	No
Group_id	BTREE	No	No	Group_id	4	A	No
fields_createby	BTREE	No	No	CreateBy	6	A	Yes
fields_updateby	BTREE	No	No	UpdateBy	6	A	Yes

formats

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(10)	No
Name	varchar(20)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
formats_createby	BTREE	No	No	CreateBy	2	A	Yes
formats_updateby	BTREE	No	No	UpdateBy	2	A	Yes

func

Table comments: User defined functions

Column	Type	Null	Default
name (Primary)	char(64)	No
ret	tinyint(1)	No	0
dl	char(128)	No
type	enum('function', 'aggregate')	No

Indexes

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

gammu

Column	Type	Null	Default	Links to	Comments	MIME
Version	int(11)	No	0

general_log

Table comments: General log

Column	Type	Null	Default
event_time	timestamp	No	CURRENT_TIMESTAMP
user_host	mediumtext	No
thread_id	bigint(21)	No
server_id	int(10)	No
command_type	varchar(64)	No
argument	mediumtext	No

groupguesses

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
NamaKetua	varchar(255)	No
NomerTelponKetua	varchar(20)	Yes	NULL
AsalInstansi	varchar(255)	No
AlamatInstansi	varchar(255)	No
CountPersonel	int(11)	Yes	NULL
CountPNS	int(11)	Yes	NULL
CountPSwasta	int(11)	Yes	NULL
CountPeneliti	int(11)	Yes	NULL
CountGuru	int(11)	Yes	NULL
CountDosen	int(11)	Yes	NULL
CountPensiunan	int(11)	Yes	NULL
CountTNI	int(11)	Yes	NULL
CountWiraswasta	int(11)	Yes	NULL
CountPelajar	int(11)	Yes	NULL
CountMahasiswa	int(11)	Yes	NULL
CountLainnya	int(11)	Yes	NULL
CountSD	int(11)	Yes	NULL
CountSMP	int(11)	Yes	NULL
CountSMA	int(11)	Yes	NULL
CountD1	int(11)	Yes	NULL
CountD2	int(11)	Yes	NULL
CountD3	int(11)	Yes	NULL
CountS1	int(11)	Yes	NULL
CountS2	int(11)	Yes	NULL
CountS3	int(11)	Yes	NULL
CountLaki	int(11)	Yes	NULL
CountPerempuan	int(11)	Yes	NULL
TujuanKunjungan_ID	int(11)	Yes	NULL	tujuan_kunjungan -> ID
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
LocationLoans_ID	int(11)	Yes	NULL	location_library -> ID
Location_ID	int(11)	Yes	NULL	locations -> ID
TeleponInstansi	varchar(20)	Yes	NULL
EmailInstansi	varchar(255)	Yes	NULL
Information	varchar(255)	Yes	NULL
NoPengunjung	varchar(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	5	A	No
groupguesses_locations	BTREE	No	No	Location_ID	5	A	Yes
groupguesses_tujuankunjungan_fk	BTREE	No	No	TujuanKunjungan_ID	2	A	Yes
groupguesses_createby	BTREE	No	No	CreateBy	2	A	Yes
groupguesses_updateby	BTREE	No	No	UpdateBy	2	A	Yes
groupguesses_loclib_idx	BTREE	No	No	LocationLoans_ID	2	A	Yes

gtid_slave_pos

Table comments: Replication slave GTID position

Column	Type	Null
domain_id (Primary)	int(10)	No
sub_id (Primary)	bigint(20)	No
server_id	int(10)	No
seq_no	bigint(20)	No

Indexes

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

help_category

Table comments: help categories

Column	Type	Null	Default	Links to
help_category_id (Primary)	smallint(5)	No
name	char(64)	No
parent_category_id	smallint(5)	Yes	NULL	help_category -> help_category_id
url	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_category_id	40	A	No
name	BTREE	Yes	No	name	40	A	No

help_keyword

Table comments: help keywords

Column	Type	Null	Default	Links to	Comments	MIME
help_keyword_id (Primary)	int(10)	No
name	char(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_keyword_id	475	A	No
name	BTREE	Yes	No	name	475	A	No

help_relation

Table comments: keyword-topic relation

Column	Type	Null	Default	Links to	Comments	MIME
help_topic_id (Primary)	int(10)	No		help_topic -> help_topic_id
help_keyword_id (Primary)	int(10)	No		help_keyword -> help_keyword_id

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_keyword_id	529	A	No
PRIMARY	BTREE	Yes	No	help_topic_id	1059	A	No

help_topic

Table comments: help topics

Column	Type	Null	Links to
help_topic_id (Primary)	int(10)	No
name	char(64)	No
help_category_id	smallint(5)	No	help_category -> help_category_id
description	text	No
example	text	No
url	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	help_topic_id	529	A	No
name	BTREE	Yes	No	name	529	A	No

historydata

Column	Type	Null	Default	Links to
ID (Primary)	bigint(20)	No
Action	varchar(10)	No
TableName	varchar(45)	No
IDRef	varchar(45)	No
Note	text	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL
Member_id	double	Yes	NULL	members -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	214	A	No
historydata_createby	BTREE	No	No	CreateBy	2	A	Yes
historydata_updateby	BTREE	No	No	UpdateBy	2	A	Yes
historydata_IDX1	BTREE	No	No	TableName	26	A	No
				IDRef	214	A	No
				Action	214	A	No
historydata_IDX2	BTREE	No	No	TableName	26	A	No
				Action	42	A	No
				CreateBy	42	A	Yes
				CreateDate	214	A	Yes
historydata_createdate	BTREE	No	No	CreateDate	214	A	Yes
historydata_member_idx	BTREE	No	No	Member_id	2	A	Yes

holidays

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Dates	datetime	No
Names	varchar(255)	No
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	32	A	No
holidays_createby	BTREE	No	No	CreateBy	2	A	Yes
holidays_updateby	BTREE	No	No	UpdateBy	2	A	Yes

host

Table comments: Host privileges; Merged with database privileges

Column	Type	Null	Default
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No
Select_priv	enum('N', 'Y')	No	N
Insert_priv	enum('N', 'Y')	No	N
Update_priv	enum('N', 'Y')	No	N
Delete_priv	enum('N', 'Y')	No	N
Create_priv	enum('N', 'Y')	No	N
Drop_priv	enum('N', 'Y')	No	N
Grant_priv	enum('N', 'Y')	No	N
References_priv	enum('N', 'Y')	No	N
Index_priv	enum('N', 'Y')	No	N
Alter_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Create_view_priv	enum('N', 'Y')	No	N
Show_view_priv	enum('N', 'Y')	No	N
Create_routine_priv	enum('N', 'Y')	No	N
Alter_routine_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N

Indexes

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

inbox

Column	Type	Null	Default
UpdatedInDB	timestamp	No	CURRENT_TIMESTAMP
ReceivingDateTime	timestamp	No	0000-00-00 00:00:00
Text	text	No
SenderNumber	varchar(20)	No
Coding	enum('Default_No_Compression', 'Unicode_No_Compression', '8bit', 'Default_Compression', 'Unicode_Compression')	No	Default_No_Compression
UDH	text	No
SMSCNumber	varchar(20)	No
Class	int(11)	No	-1
TextDecoded	text	No
ID (Primary)	int(10)	No
RecipientID	text	No
Processed	enum('false', 'true')	No	false

Indexes

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

index_stats

Table comments: Statistics on Indexes

Column	Type	Null	Default
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
index_name (Primary)	varchar(64)	No
prefix_arity (Primary)	int(11)	No
avg_frequency	decimal(12,4)	Yes	NULL

Indexes

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

innodb_index_stats

Column	Type	Null	Default	Links to
database_name (Primary)	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
table_name (Primary)	varchar(64)	No
index_name (Primary)	varchar(64)	No
last_update	timestamp	No	CURRENT_TIMESTAMP
stat_name (Primary)	varchar(64)	No
stat_value	bigint(20)	No
sample_size	bigint(20)	Yes	NULL
stat_description	varchar(1024)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	database_name	2	A	No
				table_name	565	A	No
				index_name	5657	A	No
				stat_name	5657	A	No

innodb_table_stats

Column	Type	Null	Default	Links to
database_name (Primary)	varchar(64)	No		SCHEMATA -> SCHEMA_NAME
table_name (Primary)	varchar(64)	No
last_update	timestamp	No	CURRENT_TIMESTAMP
n_rows	bigint(20)	No
clustered_index_size	bigint(20)	No
sum_of_other_index_sizes	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	database_name	10	A	No
PRIMARY	BTREE	Yes	No	table_name	149	A	No

ndb_binlog_index

Column	Type	Null
Position	bigint(20)	No
File	varchar(255)	No
epoch (Primary)	bigint(20)	No
inserts	int(10)	No
updates	int(10)	No
deletes	int(10)	No
schemaops	int(10)	No
orig_server_id (Primary)	int(10)	No
orig_epoch (Primary)	bigint(20)	No
gci	int(10)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	epoch		A	No
				orig_server_id		A	No
				orig_epoch	0	A	No

plugin

Table comments: MySQL plugins

Column	Type	Null	Default	Links to	Comments	MIME
name (Primary)	varchar(64)	No
dl	varchar(128)	No

Indexes

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

proc

Table comments: Stored Procedures

Column	Type	Null	Default	Links to
db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
name (Primary)	char(64)	No
type (Primary)	enum('FUNCTION', 'PROCEDURE')	No
specific_name	char(64)	No
language	enum('SQL')	No	SQL
sql_data_access	enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')	No	CONTAINS_SQL
is_deterministic	enum('YES', 'NO')	No	NO
security_type	enum('INVOKER', 'DEFINER')	No	DEFINER
param_list	blob	No
returns	longblob	No
body	longblob	No
definer	char(141)	No
created	timestamp	No	CURRENT_TIMESTAMP
modified	timestamp	No	0000-00-00 00:00:00
sql_mode	set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')	No
comment	text	No
character_set_client	char(32)	Yes	NULL	CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connection	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
db_collation	char(32)	Yes	NULL	COLLATIONS -> COLLATION_NAME
body_utf8	longblob	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	db		A	No
				name		A	No
				type	55	A	No

procs_priv

Table comments: Procedure privileges

Column	Type	Null	Default
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No
User (Primary)	char(80)	No
Routine_name (Primary)	char(64)	No
Routine_type (Primary)	enum('FUNCTION', 'PROCEDURE')	No
Grantor	char(141)	No
Proc_priv	set('Execute', 'Alter Routine', 'Grant')	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Host		A	No
				Db		A	No
				User		A	No
				Routine_name		A	No
				Routine_type	0	A	No
Grantor	BTREE	No	No	Grantor		A	No

proxies_priv

Table comments: User proxy privileges

Column	Type	Null	Default
Host (Primary)	char(60)	No
User (Primary)	char(80)	No
Proxied_host (Primary)	char(60)	No
Proxied_user (Primary)	char(80)	No
With_grant	tinyint(1)	No	0
Grantor	char(141)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Host		A	No
				User		A	No
				Proxied_host		A	No
				Proxied_user	1	A	No
Grantor	BTREE	No	No	Grantor		A	No

roles_mapping

Table comments: Granted roles

Column	Type	Null	Default
Host	char(60)	No
User	char(80)	No
Role	char(80)	No
Admin_option	enum('N', 'Y')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
Host	BTREE	Yes	No	Host		A	No
				User		A	No
				Role	0	A	No

servers

Table comments: MySQL Foreign Servers table

Column	Type	Null	Default	Links to
Server_name (Primary)	char(64)	No
Host	char(64)	No
Db	char(64)	No		SCHEMATA -> SCHEMA_NAME
Username	char(80)	No
Password	char(64)	No
Port	int(4)	No	0
Socket	char(64)	No
Wrapper	char(64)	No
Owner	char(64)	No

Indexes

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

slave_master_info

Table comments: Master Information

Column	Type	Null	Default	Comments
Number_of_lines	int(10)	No		Number of lines in the file.
Master_log_name	text	No		The name of the master binary log currently being read from the master.
Master_log_pos	bigint(20)	No		The master log position of the last read event.
Host (Primary)	char(64)	No		The host name of the master.
User_name	text	Yes	NULL	The user name used to connect to the master.
User_password	text	Yes	NULL	The password used to connect to the master.
Port (Primary)	int(10)	No		The network port used to connect to the master.
Connect_retry	int(10)	No		The period (in seconds) that the slave will wait before trying to reconnect to the master.
Enabled_ssl	tinyint(1)	No		Indicates whether the server supports SSL connections.
Ssl_ca	text	Yes	NULL	The file used for the Certificate Authority (CA) certificate.
Ssl_capath	text	Yes	NULL	The path to the Certificate Authority (CA) certificates.
Ssl_cert	text	Yes	NULL	The name of the SSL certificate file.
Ssl_cipher	text	Yes	NULL	The name of the cipher in use for the SSL connection.
Ssl_key	text	Yes	NULL	The name of the SSL key file.
Ssl_verify_server_cert	tinyint(1)	No		Whether to verify the server certificate.
Heartbeat	float	No
Bind	text	Yes	NULL	Displays which interface is employed when connecting to the MySQL server
Ignored_server_ids	text	Yes	NULL	The number of server IDs to be ignored, followed by the actual server IDs
Uuid	text	Yes	NULL	The master server uuid.
Retry_count	bigint(20)	No		Number of reconnect attempts, to the master, before giving up.
Ssl_crl	text	Yes	NULL	The file used for the Certificate Revocation List (CRL)
Ssl_crlpath	text	Yes	NULL	The path used for Certificate Revocation List (CRL) files
Enabled_auto_position	tinyint(1)	No		Indicates whether GTIDs will be used to retrieve events from the master.

Indexes

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

slave_relay_log_info

Table comments: Relay Log Information

Column	Type	Null	Comments
Number_of_lines	int(10)	No	Number of lines in the file or rows in the table. Used to version table definitions.
Relay_log_name	text	No	The name of the current relay log file.
Relay_log_pos	bigint(20)	No	The relay log position of the last executed event.
Master_log_name	text	No	The name of the master binary log file from which the events in the relay log file were read.
Master_log_pos	bigint(20)	No	The master log position of the last executed event.
Sql_delay	int(11)	No	The number of seconds that the slave must lag behind the master.
Number_of_workers	int(10)	No
Id (Primary)	int(10)	No	Internal Id that uniquely identifies this record.

Indexes

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

slave_worker_info

Table comments: Worker Information

Column	Type	Null
Id (Primary)	int(10)	No
Relay_log_name	text	No
Relay_log_pos	bigint(20)	No
Master_log_name	text	No
Master_log_pos	bigint(20)	No
Checkpoint_relay_log_name	text	No
Checkpoint_relay_log_pos	bigint(20)	No
Checkpoint_master_log_name	text	No
Checkpoint_master_log_pos	bigint(20)	No
Checkpoint_seqno	int(10)	No
Checkpoint_group_size	int(10)	No
Checkpoint_group_bitmap	blob	No

Indexes

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

slow_log

Table comments: Slow log

Column	Type	Null	Default	Links to
start_time	timestamp(6)	No	CURRENT_TIMESTAMP(6)
user_host	mediumtext	No
query_time	time(6)	No
lock_time	time(6)	No
rows_sent	int(11)	No
rows_examined	int(11)	No
db	varchar(512)	No		SCHEMATA -> SCHEMA_NAME
last_insert_id	int(11)	No
insert_id	int(11)	No
server_id	int(10)	No
sql_text	mediumtext	No
thread_id	bigint(21)	No
rows_affected	int(11)	No

table_stats

Table comments: Statistics on Tables

Column	Type	Null	Default
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
cardinality	bigint(21)	Yes	NULL

Indexes

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

tables_priv

Table comments: Table privileges

Column	Type	Null	Default	Links to
Host (Primary)	char(60)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(80)	No
Table_name (Primary)	char(64)	No
Grantor	char(141)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP
Table_priv	set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')	No
Column_priv	set('Select', 'Insert', 'Update', 'References')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Host		A	No
				Db		A	No
				User		A	No
				Table_name	0	A	No
Grantor	BTREE	No	No	Grantor		A	No

time_zone

Table comments: Time zones

Column	Type	Null	Default	Links to	Comments	MIME
Time_zone_id (Primary)	int(10)	No
Use_leap_seconds	enum('Y', 'N')	No	N

Indexes

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

time_zone_leap_second

Table comments: Leap seconds information for time zones

Column	Type	Null	Default	Links to	Comments	MIME
Transition_time (Primary)	bigint(20)	No
Correction	int(11)	No

Indexes

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

time_zone_name

Table comments: Time zone names

Column	Type	Null	Default	Links to	Comments	MIME
Name (Primary)	char(64)	No
Time_zone_id	int(10)	No		time_zone -> Time_zone_id

Indexes

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

time_zone_transition

Table comments: Time zone transitions

Column	Type	Null	Links to
Time_zone_id (Primary)	int(10)	No	time_zone -> Time_zone_id
Transition_time (Primary)	bigint(20)	No	time_zone_leap_second -> Transition_time
Transition_type_id	int(10)	No

Indexes

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

time_zone_transition_type

Table comments: Time zone transition types

Column	Type	Null	Default	Links to
Time_zone_id (Primary)	int(10)	No		time_zone -> Time_zone_id
Transition_type_id (Primary)	int(10)	No
Offset	int(11)	No	0
Is_DST	tinyint(3)	No	0
Abbreviation	char(8)	No

Indexes

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

user

Table comments: Users and global privileges

Column	Type	Null	Default
Host (Primary)	char(60)	No
User (Primary)	char(80)	No
Password	char(41)	No
Select_priv	enum('N', 'Y')	No	N
Insert_priv	enum('N', 'Y')	No	N
Update_priv	enum('N', 'Y')	No	N
Delete_priv	enum('N', 'Y')	No	N
Create_priv	enum('N', 'Y')	No	N
Drop_priv	enum('N', 'Y')	No	N
Reload_priv	enum('N', 'Y')	No	N
Shutdown_priv	enum('N', 'Y')	No	N
Process_priv	enum('N', 'Y')	No	N
File_priv	enum('N', 'Y')	No	N
Grant_priv	enum('N', 'Y')	No	N
References_priv	enum('N', 'Y')	No	N
Index_priv	enum('N', 'Y')	No	N
Alter_priv	enum('N', 'Y')	No	N
Show_db_priv	enum('N', 'Y')	No	N
Super_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Repl_slave_priv	enum('N', 'Y')	No	N
Repl_client_priv	enum('N', 'Y')	No	N
Create_view_priv	enum('N', 'Y')	No	N
Show_view_priv	enum('N', 'Y')	No	N
Create_routine_priv	enum('N', 'Y')	No	N
Alter_routine_priv	enum('N', 'Y')	No	N
Create_user_priv	enum('N', 'Y')	No	N
Event_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N
Create_tablespace_priv	enum('N', 'Y')	No	N
ssl_type	enum('', 'ANY', 'X509', 'SPECIFIED')	No
ssl_cipher	blob	No
x509_issuer	blob	No
x509_subject	blob	No
max_questions	int(11)	No	0
max_updates	int(11)	No	0
max_connections	int(11)	No	0
max_user_connections	int(11)	No	0
plugin	char(64)	No
authentication_string	text	No
password_expired	enum('N', 'Y')	No	N
is_role	enum('N', 'Y')	No	N
default_role	char(80)	No
max_statement_time	decimal(12,6)	No	0.000000

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	Host	3	A	No
PRIMARY	BTREE	Yes	No	User	6	A	No