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	0	A	No
UNIQUE	BTREE	Yes	No	ActivationCode	0	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	4	A	No
PRIMARY	BTREE	Yes	No	user_id	4	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	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
auth_data_auth_header	BTREE	No	No	Auth_Header_ID	A	No
auth_data_createby	BTREE	No	No	CreateBy	A	Yes
auth_data_updateby	BTREE	No	No	UpdateBy	A	Yes
auth_data_IDX1	BTREE	No	No	Auth_Header_ID	A	No
auth_data_IDX1	BTREE	No	No	Tag	A	No
auth_data_IDX2	BTREE	No	No	Tag	A	No
auth_data_IDX2	BTREE	No	No	Value	A	Yes
auth_data_IDX3	BTREE	No	No	Tag	A	No
auth_data_IDX3	BTREE	No	No	DataItem	A	Yes
auth_data_IDX4	BTREE	No	No	Value	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	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
auth_header_id	BTREE	Yes	No	Auth_ID	A	No
auth_header_worksheet_id	BTREE	No	No	Worksheet_id	A	No
auth_header_createby	BTREE	No	No	CreateBy	A	Yes
auth_header_updateby	BTREE	No	No	UpdateBy	A	Yes
auth_header_authid	BTREE	No	No	Auth_ID	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	1254	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	32	A	No
PRIMARY	BTREE	Yes	No	child	163	A	No
child	BTREE	No	No	child	163	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	1	A	No
BacaDitempat_NoPengujung	BTREE	No	No	NoPengunjung	1	A	Yes
bacaditempat_createby	BTREE	No	No	CreateBy	1	A	Yes
bacaditempat_updateby	BTREE	No	No	UpdateBy	1	A	Yes
bacaditempat_collections	BTREE	No	No	collection_id	1	A	No
bacaditempat_locations	BTREE	No	No	Location_Id	1	A	Yes
bacaditempat_Noanggota	BTREE	No	No	Member_id	1	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	0	A	No
backup_createby	BTREE	No	No	CreateBy	0	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	0	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	23427	A	No
catalog_ruas_catalogs_idx	BTREE	No	No	CatalogId	3904	A	No
catalog_ruas_createby_idx	BTREE	No	No	CreateBy	4	A	Yes
catalog_ruas_tag	BTREE	No	No	Tag	42	A	No
catalog_ruas_IDX1	BTREE	No	No	CatalogId	3904	A	No
				Tag	23427	A	No
				Value (767)	23427	A	Yes
catalog_ruas_updateby_idx	BTREE	No	No	UpdateBy	4	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	27313	A	No
SubRuas	BTREE	No	No	SubRuas	12	A	Yes
RuasID_SubRuas	BTREE	No	No	RuasID	27313	A	No
RuasID_SubRuas	BTREE	No	No	SubRuas	27313	A	Yes
Catalog_Subruas_Value	BTREE	No	No	Value (767)	27313	A	Yes
catalog_subruas_createby	BTREE	No	No	CreateBy	2	A	Yes
catalog_subruas_updateby	BTREE	No	No	UpdateBy	2	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	1	A	No
catalogfiles_catalog	BTREE	No	No	Catalog_id	1	A	No
catalogfiles_createby	BTREE	No	No	CreateBy	1	A	Yes
catalogfiles_updateby	BTREE	No	No	UpdateBy	1	A	Yes
catalogfiles_fileurl	BTREE	No	No	FileURL	1	A	Yes
catalogfiles_fileflash	BTREE	No	No	FileFlash	1	A	Yes
catalogfiles_ispublish	BTREE	No	No	IsPublish	1	A	Yes
catalogfiles_member_idx	BTREE	No	No	Member_id	1	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
Publikasi	varchar(700)	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	1751	A	No
catalogs_BIBID	BTREE	Yes	No	BIBID	1751	A	No
catalogs_createby	BTREE	No	No	CreateBy	2	A	Yes
catalogs_updateby	BTREE	No	No	UpdateBy	2	A	Yes
catalogs_author	BTREE	No	No	Author	1751	A	Yes
catalogs_edition	BTREE	No	No	Edition	103	A	Yes
catalogs_publisher	BTREE	No	No	Publisher	1751	A	Yes
catalogs_publishlocation	BTREE	No	No	PublishLocation	159	A	Yes
catalogs_publishyear	BTREE	No	No	PublishYear	103	A	Yes
catalogs_subject	BTREE	No	No	Subject	6	A	Yes
catalogs_physicaldesc	BTREE	No	No	PhysicalDescription	1751	A	Yes
catalogs_isbn	BTREE	No	No	ISBN	1751	A	Yes
catalogs_callnumber	BTREE	No	No	CallNumber	1751	A	Yes
catalogs_deweyno	BTREE	No	No	DeweyNo	875	A	Yes
catalogs_languages	BTREE	No	No	Languages	12	A	Yes
catalogs_quarantinedby	BTREE	No	No	QUARANTINEDBY	2	A	Yes
catalogs_createdate	BTREE	No	No	CreateDate	1751	A	Yes
catalogs_isopac	BTREE	No	No	IsOPAC	4	A	Yes
catalogs_Worksheet_id	BTREE	No	No	Worksheet_id	6	A	No
catalogs_Branch_id	BTREE	No	No	Branch_id	2	A	Yes
catalogs_member_idx	BTREE	No	No	Member_id	2	A	Yes
catalogs_controlnumber	BTREE	No	No	ControlNumber	1751	A	No
catalogs_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
catalogs_updatedate	BTREE	No	No	UpdateDate	1751	A	Yes
catalogs_title	BTREE	No	No	Title	1751	A	No
catalogs_publikasi	BTREE	No	No	Publikasi	1751	A	Yes

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

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	3	A	No
collectioncategorys_createby	BTREE	No	No	CreateBy	3	A	Yes
collectioncategorys_updateby	BTREE	No	No	UpdateBy	3	A	Yes
collectioncategorys_kii	BTREE	No	No	KIILastUploadDate	3	A	Yes
collectioncategorys_createdate	BTREE	No	No	CreateDate	3	A	Yes
collectioncategorys_updatedate	BTREE	No	No	UpdateDate	3	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	6	A	Yes
collectioncategorysdefault_jenis_anggota	BTREE	No	No	JenisAnggota_id	12	A	No
collectioncategorysdefault_createby	BTREE	No	No	CreateBy	2	A	Yes
collectioncategorysdefault_updateby	BTREE	No	No	UpdateBy	2	A	Yes

collectioncategorysloanhari

Column	Type	Null	Default	Links to
DataID (Primary)	int(11)	No
Category_id	int(11)	Yes	NULL	collectioncategorys -> ID
Peminjaman_hari_id	int(11)	Yes	NULL	peraturan_peminjaman_hari -> 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	DataID	A	No
collectioncategorysloanhari_category_id	BTREE	No	No	Category_id	A	Yes
collectioncategorysloanhari_peminjaman_hari_id	BTREE	No	No	Peminjaman_hari_id	A	Yes
collectioncategorysloanhari_createby	BTREE	No	No	CreateBy	A	Yes
collectioncategorysloanhari_updateby	BTREE	No	No	UpdateBy	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	5	A	No
collectionloanitems_members	BTREE	No	No	member_id	5	A	No
collectionloanitems_LoanDate	BTREE	No	No	LoanDate	2	A	Yes
collectionloanitems_LoanStatus	BTREE	No	No	LoanStatus	5	A	Yes
collectionloanitems_createby	BTREE	No	No	CreateBy	2	A	Yes
collectionloanitems_updateby	BTREE	No	No	UpdateBy	2	A	Yes
collectionloanitems_collections	BTREE	No	No	Collection_id	5	A	No
collectionloanitems_collectionloans	BTREE	No	No	CollectionLoan_id	5	A	No
collectionloanitems_duedate	BTREE	No	No	DueDate	2	A	Yes
collectionloanitems_actualreturn	BTREE	No	No	ActualReturn	5	A	Yes
collectionloanitems_idx1	BTREE	No	No	LoanDate	2	A	Yes
collectionloanitems_idx1	BTREE	No	No	member_id	5	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
LocationLibrary_id	int(11)	Yes	NULL	location_library -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	4	A	No
Member_id	BTREE	No	No	Member_id	4	A	No
Branch_id	BTREE	No	No	Branch_id	2	A	Yes
collectionloans_createby	BTREE	No	No	CreateBy	2	A	Yes
collectionloans_updateby	BTREE	No	No	UpdateBy	2	A	Yes
FK_collectionloans_location_library	BTREE	No	No	LocationLibrary_id	2	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
KodeBahanPustaka	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
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	29	A	No
collectionmedias_worksheet	BTREE	No	No	Worksheet_id	29	A	Yes
collectionmedias_createby	BTREE	No	No	CreateBy	2	A	Yes
collectionmedias_updateby	BTREE	No	No	UpdateBy	2	A	Yes
collectionmedias_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
collectionmedias_createdate	BTREE	No	No	CreateDate	29	A	Yes
collectionmedias_updatedate	BTREE	No	No	UpdateDate	29	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	2	A	Yes
collectionrules_updateby	BTREE	No	No	UpdateBy	2	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
IsDeposit	int(1)	Yes	NULL
NomorDeposit	varchar(21)	Yes	NULL
ThnTerbitDeposit	int(11)	Yes	NULL
deposit_ws_ID	int(11)	Yes	NULL	deposit_ws -> ID
deposit_kode_wilayah_ID	int(11)	Yes	NULL	deposit_kode_wilayah -> ID
Nomor_Regis	varchar(11)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2501	A	No
collections_NomorBarcode	BTREE	Yes	No	NomorBarcode	2501	A	No
Branch_id	BTREE	No	No	Branch_id	4	A	Yes
Catalog_id	BTREE	No	No	Catalog_id	2501	A	Yes
Partner_id	BTREE	No	No	Partner_id	8	A	Yes
Location_id	BTREE	No	No	Location_id	58	A	Yes
Rule_id	BTREE	No	No	Rule_id	4	A	Yes
Category_id	BTREE	No	No	Category_id	6	A	Yes
Media_id	BTREE	No	No	Media_id	4	A	Yes
Source_id	BTREE	No	No	Source_id	6	A	Yes
collections_callnumber	BTREE	No	No	CallNumber	2501	A	Yes
collections_status	BTREE	No	No	Status_id	6	A	Yes
collections_createby	BTREE	No	No	CreateBy	2	A	Yes
collections_updateby	BTREE	No	No	UpdateBy	4	A	Yes
collections_quarantinedby	BTREE	No	No	QUARANTINEDBY	2	A	Yes
collections_jilidcreateby	BTREE	No	No	JILIDCREATEBY	2	A	Yes
collections_idjilid	BTREE	No	No	IDJILID	2	A	Yes
collections_currency	BTREE	No	No	Currency	2	A	Yes
collections_NoInduk	BTREE	No	No	NoInduk	2501	A	Yes
collections_edisiserial	BTREE	No	No	EDISISERIAL	4	A	Yes
collections_nopanggiljilid	BTREE	No	No	NOMORPANGGILJILID	2	A	Yes
collections_jilid1	BTREE	No	No	IDJILID	2	A	Yes
				NOMORPANGGILJILID	2	A	Yes
				Catalog_id	2501	A	Yes
collections_tglentryjilid	BTREE	No	No	TGLENTRYJILID	2	A	Yes
collections_tanggalpengadaan	BTREE	No	No	TanggalPengadaan	24	A	Yes
collections_rfid	BTREE	No	No	RFID	2501	A	Yes
collections_location_library_idx	BTREE	No	No	Location_Library_id	2	A	Yes
collections_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
collections_createdate	BTREE	No	No	CreateDate	1250	A	Yes
collections_updatedate	BTREE	No	No	UpdateDate	2501	A	Yes
collections_deposit_ws_ID	BTREE	No	No	deposit_ws_ID	2	A	Yes
collection_deposit_kode_wilayah_ID	BTREE	No	No	deposit_kode_wilayah_ID	2	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	8	A	No
collectionsources_createby	BTREE	No	No	CreateBy	4	A	Yes
collectionsources_updateby	BTREE	No	No	UpdateBy	4	A	Yes
collectionsources_kii	BTREE	No	No	KIILastUploadDate	4	A	Yes
collectionsources_createdate	BTREE	No	No	CreateDate	4	A	Yes
collectionsources_updatedate	BTREE	No	No	UpdateDate	8	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	2	A	Yes
collectionstatus_updateby	BTREE	No	No	UpdateBy	2	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

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

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

deposit_group_ws

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

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id_group	A	No
deposit_group_ws_createby	BTREE	No	No	CreateBy	A	Yes
deposit_group_ws_updateby	BTREE	No	No	UpdateBy	A	Yes

deposit_kelompok_penerbit

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(111)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL

Indexes

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

deposit_kode_wilayah

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

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
deposit_kode_wilayah_createby	BTREE	No	No	CreateBy	A	Yes
deposit_kode_wilayah_updateby	BTREE	No	No	UpdateBy	A	Yes

deposit_taksiran_harga

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
ID_collections	double	Yes	NULL	collections -> ID
cover	varchar(65)	Yes	NULL
muka_buku	varchar(65)	Yes	NULL
hard_cover	varchar(65)	Yes	NULL
penjilidan	varchar(65)	Yes	NULL
jumlah_halaman	int(11)	Yes	NULL
jenis_kertas_buku	varchar(25)	Yes	NULL
ukuran_buku	varchar(6)	Yes	NULL
kondisi_buku	varchar(10)	Yes	NULL
kondisi_usang	varchar(25)	Yes	NULL
full_color	varchar(9)	Yes	NULL

Indexes

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

deposit_ws

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
jenis_penerbit	varchar(55)	Yes	NULL
id_group_deposit_group_ws	int(11)	Yes	NULL	deposit_group_ws -> id_group
id_deposit_kelompok_penerbit_ws	int(11)	Yes	NULL	deposit_kelompok_penerbit -> ID
nama_penerbit	varchar(55)	Yes	NULL
alamat1	varchar(65)	Yes	NULL
alamat2	varchar(65)	Yes	NULL
alamat3	varchar(65)	Yes	NULL
kabupaten	varchar(65)	Yes	NULL
ID_deposit_kode_wilayah	int(11)	Yes	NULL	deposit_kode_wilayah -> ID
kode_pos	int(11)	Yes	NULL
no_telp1	int(11)	Yes	NULL
no_telp2	int(11)	Yes	NULL
no_telp3	int(11)	Yes	NULL
no_fax	int(11)	Yes	NULL
email	char(30)	Yes	NULL
contact_person	char(50)	Yes	NULL
no_contact	int(11)	Yes	NULL
koleksi_per_tahun	int(11)	Yes	NULL
keterangan	varchar(50)	Yes	NULL
status	int(11)	Yes	NULL
CreateBy	int(11)	Yes	NULL
CreateDate	datetime	Yes	NULL
UpdateBy	int(11)	Yes	NULL
UpdateDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
(id_group)group-ws	BTREE	No	No	id_group_deposit_group_ws	A	Yes
(ID)deposit_kode_wilayah	BTREE	No	No	ID_deposit_kode_wilayah	A	Yes
(ID)deposit_kelompok_penerbit	BTREE	No	No	id_deposit_kelompok_penerbit_ws	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

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	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
FK_Catalog	BTREE	No	No	Catalog_Id	A	Yes
FK_members	BTREE	No	No	Member_Id	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	282	A	No
PRIMARY	BTREE	Yes	No	Code	846	A	No
fielddatas_delimiter	BTREE	No	No	Delimiter	14	A	Yes
fielddatas_createby	BTREE	No	No	CreateBy	4	A	Yes
fielddatas_updateby	BTREE	No	No	UpdateBy	4	A	Yes
fielddatas_fieldid	BTREE	No	No	Field_id	282	A	No
fielddatas_code	BTREE	No	No	Code	70	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	299	A	No
PRIMARY	BTREE	Yes	No	Code	299	A	No
Field_id	BTREE	No	No	Field_id	299	A	No
fieldindicator1s_createby	BTREE	No	No	CreateBy	4	A	Yes
fieldindicator1s_updateby	BTREE	No	No	UpdateBy	4	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	244	A	No
PRIMARY	BTREE	Yes	No	Code	244	A	No
Field_id	BTREE	No	No	Field_id	244	A	No
fieldindicator2s_createby	BTREE	No	No	CreateBy	4	A	Yes
fieldindicator2s_updateby	BTREE	No	No	UpdateBy	4	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	2	A	Yes
fields_updateby	BTREE	No	No	UpdateBy	4	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

gammu

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

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	18	A	No
groupguesses_locations	BTREE	No	No	Location_ID	2	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

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	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
historydata_createby	BTREE	No	No	CreateBy	A	Yes
historydata_updateby	BTREE	No	No	UpdateBy	A	Yes
historydata_IDX1	BTREE	No	No	TableName	A	No
				IDRef	A	No
				Action	A	No
historydata_IDX2	BTREE	No	No	TableName	A	No
				Action	A	No
				CreateBy	A	Yes
				CreateDate	A	Yes
historydata_createdate	BTREE	No	No	CreateDate	A	Yes
historydata_member_idx	BTREE	No	No	Member_id	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	2	A	No
holidays_createby	BTREE	No	No	CreateBy	2	A	Yes
holidays_updateby	BTREE	No	No	UpdateBy	2	A	Yes

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

item_koleksi

Table comments: VIEW

Column	Type	Null	Default
periode	varchar(6)	Yes	NULL
bulan	int(2)	Yes	NULL
tahun	int(4)	Yes	NULL
jumlah_eksemplar	bigint(21)	No	0

jenis_anggota

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
jenisanggota	varchar(50)	No
MasaBerlakuAnggota	int(11)	Yes	365
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
BiayaPendaftaran	decimal(10,0)	Yes	0
BiayaPerpanjangan	decimal(10,0)	Yes	0
UploadDokumenKeanggotaanOnline	bit(1)	Yes	b'0'
MaxPinjamKoleksi	int(11)	Yes	1000
MaxLoanDays	int(11)	Yes	0
DendaType	varchar(45)	Yes	Konstan
DendaTenorJumlah	double	Yes	0
DendaTenorSatuan	varchar(45)	Yes	Hari
DendaPerTenor	decimal(10,0)	Yes	0
DendaTenorMultiply	int(11)	Yes	1
SuspendMember	bit(1)	Yes	b'0'
WarningLoanDueDay	int(11)	Yes	0
SuspendType	varchar(45)	Yes	Konstan
SuspendTenorJumlah	double	Yes	0
SuspendTenorSatuan	varchar(45)	Yes	Hari
DaySuspend	int(11)	Yes	0
SuspendTenorMultiply	int(11)	Yes	1
DayPerpanjang	int(11)	Yes	0
CountPerpanjang	int(11)	Yes	0
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	5	A	No
jenis_anggota_createby	BTREE	No	No	CreateBy	5	A	Yes
jenis_anggota_updateby	BTREE	No	No	UpdateBy	2	A	Yes
jenis_anggota_kii	BTREE	No	No	KIILastUploadDate	5	A	Yes
jenis_anggota_createdate	BTREE	No	No	CreateDate	5	A	Yes
jenis_anggota_updatedate	BTREE	No	No	UpdateDate	5	A	Yes

jenis_denda

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	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

Indexes

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

jenis_kelamin

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
jenis_kelamin_createby	BTREE	No	No	CreateBy	2	A	Yes
jenis_kelamin_updateby	BTREE	No	No	UpdateBy	2	A	Yes

jenis_pelanggaran

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
JenisPelanggaran	varchar(50)	No
Keterangan	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	4	A	No
jenis_pelanggaran_createby	BTREE	No	No	CreateBy	2	A	Yes
jenis_pelanggaran_updateby	BTREE	No	No	UpdateBy	2	A	Yes

jenis_permohonan

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

Indexes

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

jenis_perpustakaan

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

Indexes

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

judul_koleksi

Column	Type	Null	Default	Links to
no	int(11)	No
judul_pernyataan	varchar(255)	No
ed_cet	varchar(100)	Yes	NULL
kota	varchar(100)	Yes	NULL
penerbit	varchar(255)	Yes	NULL
tahun	int(11)	Yes	NULL
no_induk	varchar(100)	Yes	NULL
no_class	varchar(50)	Yes	NULL
no_panggil	varchar(50)	Yes	NULL
pengarang	varchar(255)	Yes	NULL
kolasi	text	Yes	NULL
catatan	varchar(255)	Yes	NULL
bibliografi	varchar(255)	Yes	NULL
indeks	varchar(255)	Yes	NULL
isbn	varchar(100)	Yes	NULL
subjek1	varchar(255)	Yes	NULL
subjek2	varchar(255)	Yes	NULL
subjek3	varchar(255)	Yes	NULL
subjek4	varchar(255)	Yes	NULL
tet1	varchar(255)	Yes	NULL
tet2	varchar(255)	Yes	NULL
tet3	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	Cardinality	Collation	Null	Comment
judul_koleksi_createby	BTREE	No	No	CreateBy	0	A	Yes
judul_koleksi_updateby	BTREE	No	No	UpdateBy	0	A	Yes

kabupaten

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
NamaKab	varchar(50)	No
PropinsiID	int(5)	No		propinsi -> 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	498	A	No
kabupaten_nama	BTREE	No	No	NamaKab	498	A	No
kabupaten_propinsi	BTREE	No	No	PropinsiID	71	A	No
kabupaten_createby	BTREE	No	No	CreateBy	2	A	Yes
kabupaten_updateby	BTREE	No	No	UpdateBy	2	A	Yes

kata_sandang

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Tag	varchar(3)	No
Name	varchar(100)	No
JumlahKarakter	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	9	A	No
kata_sandang_tag	BTREE	No	No	Tag	2	A	No
kata_sandang_name	BTREE	No	No	Name	9	A	No
kata_sandang_createby	BTREE	No	No	CreateBy	2	A	Yes
kata_sandang_updateby	BTREE	No	No	UpdateBy	2	A	Yes

kelas_siswa

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
namakelassiswa	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	2	A	No
kelas_siswa_createby	BTREE	No	No	CreateBy	2	A	Yes
kelas_siswa_updateby	BTREE	No	No	UpdateBy	2	A	Yes
kelas_siswa_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
kelas_siswa_createdate	BTREE	No	No	CreateDate	2	A	Yes
kelas_siswa_updatedate	BTREE	No	No	UpdateDate	2	A	Yes

kelompok_pelanggaran

Column	Type	Null	Default	Links to	Comments
ID (Primary)	int(11)	No
Name	varchar(50)	No
Jumlah	int(11)	Yes	0		JumlahPelanggaran
Warna	varchar(50)	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
SuspendMember	tinyint(3)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
kelompok_pelanggaran_createby	BTREE	No	No	CreateBy	A	Yes
kelompok_pelanggaran_updateby	BTREE	No	No	UpdateBy	A	Yes

keranjang_anggota

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
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

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
keranjang_anggota_createby	BTREE	No	No	CreateBy	A	Yes
keranjang_anggota_updateby	BTREE	No	No	UpdateBy	A	Yes
keranjang_anggota_createdate	BTREE	No	No	CreateDate	A	Yes
keranjang_anggota_updatedate	BTREE	No	No	UpdateDate	A	Yes
keranjang_anggota_member_idx	BTREE	No	No	Member_id	A	No

keranjang_katalog

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Catalog_id	double	No		catalogs -> 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
keranjang_katalog_createby	BTREE	No	No	CreateBy	A	Yes
keranjang_katalog_updateby	BTREE	No	No	UpdateBy	A	Yes
keranjang_katalog_createdate	BTREE	No	No	CreateDate	A	Yes
keranjang_katalog_updatedate	BTREE	No	No	UpdateDate	A	Yes
keranjang_katalog_catalog_idx	BTREE	No	No	Catalog_id	A	No

keranjang_koleksi

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
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	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
keranjang_koleksi_createby	BTREE	No	No	CreateBy	A	Yes
keranjang_koleksi_updateby	BTREE	No	No	UpdateBy	A	Yes
keranjang_koleksi_createdate	BTREE	No	No	CreateDate	A	Yes
keranjang_koleksi_updatedate	BTREE	No	No	UpdateDate	A	Yes
keranjang_koleksi_collection_idx	BTREE	No	No	Collection_id	A	No

kriteria_koleksi

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
jns_kriteria	varchar(255)	No
catalog_id	double	Yes	NULL	catalogs -> ID
title	varchar(255)	Yes	NULL
author	varchar(255)	Yes	NULL
alamat_image	varchar(500)	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
PublishYear	varchar(25)	Yes	NULL
Jumlah	int(11)	Yes	NULL
worksheet_name	varchar(100)	Yes	NULL
isLKD	varchar(10)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
kriteria_koleksi_idx1	BTREE	No	No	catalog_id	A	Yes
kriteria_koleksi_createby_idx	BTREE	No	No	CreateBy	A	Yes
kriteria_koleksi_updateby_idx	BTREE	No	No	UpdateBy	A	Yes

letter

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
TYPE_OF_DELIVERY	varchar(21)	Yes	NULL
LETTER_DATE	date	Yes	NULL
LETTER_NUMBER	varchar(35)	Yes	NULL
ACCEPT_DATE	date	Yes	NULL
SENDER	varchar(155)	Yes	NULL
PHONE	int(11)	Yes	NULL
INTENDED_TO	varchar(155)	Yes	NULL
IS_PRINTED	int(4)	Yes	NULL
CreateDate	datetime	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
CreateTerminal	varchar(111)	Yes	NULL
UpdateDate	datetime	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateTerminal	varchar(111)	Yes	NULL
PUBLISHER_ID	int(11)	Yes	NULL	deposit_ws -> ID
LETTER_NUMBER_UT	varchar(45)	Yes	NULL
IS_SENDEDEMAIL	int(4)	Yes	NULL
IS_NOTE	int(4)	Yes	NULL
LANG	varchar(20)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
(ID)deposit_ws	BTREE	No	No	PUBLISHER_ID	A	Yes
letter_createby	BTREE	No	No	CreateBy	A	Yes
letter_updateby	BTREE	No	No	UpdateBy	A	Yes

letter_detail

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
SUB_TYPE_COLLECTION	int(11)	Yes	NULL	collectionmedias -> ID
TITLE	varchar(255)	Yes	NULL
QUANTITY	int(11)	Yes	NULL
COPY	int(11)	Yes	NULL
PRICE	varchar(100)	Yes	NULL
LETTER_ID	int(111)	Yes	NULL	letter -> ID
COLLECTION_TYPE_ID	int(11)	Yes	NULL
REMARK	varchar(255)	Yes	NULL
AUTHOR	varchar(155)	Yes	NULL
PUBLISHER	varchar(50)	Yes	NULL
PUBLISHER_ADDRESS	varchar(255)	Yes	NULL
ISBN	varchar(25)	Yes	NULL
PUBLISH_YEAR	varchar(15)	Yes	NULL
PUBLISHER_CITY	varchar(25)	Yes	NULL
ISBN_STATUS	varchar(55)	Yes	NULL
KD_PENERBIT_DTL	varchar(25)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
(ID)letter	BTREE	No	No	LETTER_ID	A	Yes
(ID)collectiomedias	BTREE	No	No	SUB_TYPE_COLLECTION	A	Yes

library

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
NAME	varchar(50)	No
URL	varchar(255)	Yes	NULL
PORT	varchar(10)	Yes	NULL
DATABASENAME	varchar(50)	Yes	NULL
RECORDSYNTAX	varchar(20)	Yes	NULL
FULLNAME	varchar(255)	Yes	NULL
PROTOCOL	varchar(45)	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	2	A	No
library_createby	BTREE	No	No	CreateBy	2	A	Yes
library_updateby	BTREE	No	No	UpdateBy	2	A	Yes

librarysearchcriteria

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
LIBRARYID	int(11)	No		library -> ID
CRITERIANAME	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	9	A	No
librarysearchcriteria_library	BTREE	No	No	LIBRARYID	4	A	No
librarysearchcriteria_createby	BTREE	No	No	CreateBy	4	A	Yes
librarysearchcriteria_updateby	BTREE	No	No	UpdateBy	4	A	Yes

location_library

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
Address	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
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
location_library_createby	BTREE	No	No	CreateBy	2	A	Yes
location_library_updateby	BTREE	No	No	UpdateBy	2	A	Yes
location_library_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
location_library_createdate	BTREE	No	No	CreateDate	2	A	Yes
location_library_updatedate	BTREE	No	No	UpdateDate	2	A	Yes

location_library_default

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Location_Library_id	int(11)	Yes	NULL	location_library -> ID
JenisAnggota_id	int(11)	Yes	NULL	jenis_anggota -> id
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTeminal	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	7	A	No
location_library_default_loc	BTREE	No	No	Location_Library_id	7	A	Yes
location_library_default_jenis_anggota	BTREE	No	No	JenisAnggota_id	7	A	Yes
location_library_default_createby	BTREE	No	No	CreateBy	2	A	Yes
location_library_default_updateby	BTREE	No	No	UpdateBy	2	A	Yes

locations

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(20)	No
Name	varchar(255)	No
Description	varchar(255)	Yes	NULL
ISPUSTELING	bit(1)	Yes	b'0'
UrlLogo	varchar(100)	Yes	NULL
IsPrintBarcode	bit(1)	Yes	b'0'
IsGenerateVisitorNumber	bit(1)	Yes	b'0'
IsInformationSought	bit(1)	Yes	b'0'
IsVisitsDestination	bit(1)	Yes	b'0'
LocationLibrary_id	int(11)	Yes	NULL	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
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	29	A	No
locations_createby	BTREE	No	No	CreateBy	4	A	Yes
locations_updateby	BTREE	No	No	UpdateBy	2	A	Yes
locations_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
locations_createdate	BTREE	No	No	CreateDate	14	A	Yes
locations_updatedate	BTREE	No	No	UpdateDate	14	A	Yes
locations_loclib_idx	BTREE	No	No	LocationLibrary_id	4	A	Yes

lockers

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
No_pinjaman	varchar(255)	No
no_member	varchar(45)	Yes	NULL
no_identitas	varchar(50)	Yes	NULL
jenis_jaminan	varchar(20)	Yes	NULL
id_jamin_idt	int(11)	Yes	NULL	master_jenis_identitas -> id
id_jamin_uang	int(11)	Yes	NULL	master_uang_jaminan -> ID
loker_id	int(11)	Yes	NULL	master_loker -> ID
tanggal_pinjam	datetime	Yes	NULL
tanggal_kembali	datetime	Yes	NULL
id_pelanggaran_locker	int(11)	Yes	NULL	master_pelanggaran_locker -> ID
denda	int(11)	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
fk_lockers_master_loker_idx	BTREE	No	No	loker_id	A	Yes
lockers_createby_idx	BTREE	No	No	CreateBy	A	Yes
lockers_jenisidentitas_idx	BTREE	No	No	id_jamin_idt	A	Yes
lockers_jenisjaminan	BTREE	No	No	jenis_jaminan	A	Yes
lockers_noidentitas	BTREE	No	No	no_identitas	A	Yes
lockers_nopinjama	BTREE	No	No	No_pinjaman	A	No
lockers_pelanggaran_idx	BTREE	No	No	id_pelanggaran_locker	A	Yes
lockers_tglkembali	BTREE	No	No	tanggal_kembali	A	Yes
lockers_tglpinjam	BTREE	No	No	tanggal_pinjam	A	Yes
lockers_uangjaminan_idx	BTREE	No	No	id_jamin_uang	A	Yes
lockers_updateby_idx	BTREE	No	No	UpdateBy	A	Yes

logsdownload

Column	Type	Null	Default	Links to
id (Primary)	bigint(30)	No
User_id	varchar(50)	Yes	NULL	members -> MemberNo
ip	varchar(15)	Yes	NULL
catalogfilesID	int(11)	Yes	NULL	catalogfiles -> ID
isLKD	tinyint(1)	Yes	0
waktu	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	2	A	No
fk_logsDownload_1_idx	BTREE	No	No	User_id	2	A	Yes
fk_logsDownload_catalogfiles_idx	BTREE	No	No	catalogfilesID	2	A	Yes

logsdownload_article

Column	Type	Null	Default	Links to
id (Primary)	bigint(30)	No
User_id	varchar(50)	Yes	NULL	members -> MemberNo
ip	varchar(15)	Yes	NULL
articlefilesID	int(11)	Yes	NULL	serial_articlefiles -> ID
waktu	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
fk_logsDownload_u_idx	BTREE	No	No	User_id	A	Yes
fk_logsDownload_articlefiles_idx	BTREE	No	No	articlefilesID	A	Yes

mailserver

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Modul	varchar(50)	No
Host	varchar(50)	No
Port	int(11)	No
CredentialMail	varchar(50)	No
CredentialPassword	varchar(50)	No
EnableSsl	bit(1)	Yes	b'1'
MailFrom	varchar(50)	No
MailDisplayName	varchar(50)	No
IsActive	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	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
mailserver_createby	BTREE	No	No	CreateBy	A	Yes
mailserver_updateby	BTREE	No	No	UpdateBy	A	Yes

masa_berlaku_anggota

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
jumlah	int(20)	No
satuan	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	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
masa_berlaku_anggota_createby	BTREE	No	No	CreateBy	A	Yes
masa_berlaku_anggota_updateby	BTREE	No	No	UpdateBy	A	Yes
masa_berlaku_anggota_kii	BTREE	No	No	KIILastUploadDate	A	Yes
masa_berlaku_anggota_createdate	BTREE	No	No	CreateDate	A	Yes
masa_berlaku_anggota_updatedate	BTREE	No	No	UpdateDate	A	Yes

master_counter_barcode

Column	Type	Null	Default	Links to	Comments	MIME
tahun	year(4)	Yes	NULL
value	int(111)	Yes	NULL

master_djkn

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Option_id	varchar(20)	Yes	NULL
Option_Name	varchar(100)	Yes	NULL
Value	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
master_djkn_createby_idx	BTREE	No	No	CreateBy	A	Yes
master_djkn_updateby_idx	BTREE	No	No	UpdateBy	A	Yes
master_djkn_option	BTREE	No	No	Option_id	A	Yes

master_edisi_serial

Column	Type	Null	Default	Links to
id (Primary)	double	No
tgl_edisi_serial	date	Yes	NULL
no_edisi_serial	varchar(111)	Yes	NULL
Catalog_id	double	Yes	NULL	catalogs -> ID
CreateBy	int(11)	Yes	NULL
UpdateBy	int(11)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
unique	BTREE	Yes	No	no_edisi_serial	A	Yes
edisiSerial_catalog	BTREE	No	No	Catalog_id	A	Yes

master_fakultas

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
Nama	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	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
master_fakultas_createby	BTREE	No	No	CreateBy	A	Yes
master_fakultas_updateby	BTREE	No	No	UpdateBy	A	Yes
master_fakultas_createdate	BTREE	No	No	CreateDate	A	Yes
master_fakultas_updatedate	BTREE	No	No	UpdateDate	A	Yes
master_fakultas_kii	BTREE	No	No	KIILastUploadDate	A	Yes

master_jam_buka

Column	Type	Null	Default
ID (Primary)	int(11)	No
hari	varchar(50)	Yes	0
jam_buka	time	Yes	00:00:00
jam_tutup	time	Yes	00:00:00
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	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ID	7	A	No

master_jenis_identitas

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
Nama	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
IsNIK	bit(1)	Yes	b'0'
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	5	A	No
master_jenis_identitas_createby	BTREE	No	No	CreateBy	2	A	Yes
master_jenis_identitas_updateby	BTREE	No	No	UpdateBy	2	A	Yes

master_jenjang_pendidikan

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

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
masjer_jenjang_pendidikan_create_by	BTREE	No	No	CreateBy	A	Yes
masjer_jenjang_pendidikan_create_date	BTREE	No	No	CreateDate	A	Yes
masjer_jenjang_pendidikan_update_by	BTREE	No	No	UpdateBy	A	Yes
masjer_jenjang_pendidikan_update_date	BTREE	No	No	UpdateDate	A	Yes

master_jurusan

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
id_fakultas	int(11)	Yes	NULL	master_fakultas -> id
Nama	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	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
master_jurusan_fakultas	BTREE	No	No	id_fakultas	A	Yes
master_jurusan_createby	BTREE	No	No	CreateBy	A	Yes
master_jurusan_updateby	BTREE	No	No	UpdateBy	A	Yes
master_jurusan_kii	BTREE	No	No	KIILastUploadDate	A	Yes
master_jurusan_createdate	BTREE	No	No	CreateDate	A	Yes
master_jurusan_updatedate	BTREE	No	No	UpdateDate	A	Yes

master_kelas_besar

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
kdKelas	varchar(3)	No
namakelas	varchar(255)	No
warna	varchar(50)	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	10	A	No
master_kelas_besar_createby	BTREE	No	No	CreateBy	2	A	Yes
master_kelas_besar_updateby	BTREE	No	No	UpdateBy	2	A	Yes

master_kependudukan

Column	Type	Null	Default	Links to	Comments
id (Primary)	int(11)	No
nomorkk	varchar(50)	Yes	NULL
nik	varchar(50)	No
namalengkap	varchar(100)	No
nama_ibu	varchar(100)	Yes	NULL
al1	varchar(255)	Yes	NULL
rt	varchar(50)	Yes	NULL
rw	varchar(50)	Yes	NULL
kodekec	varchar(50)	Yes	NULL
kodekel	varchar(50)	Yes	NULL
nama_kec	varchar(100)	Yes	NULL
nama_kel	varchar(100)	Yes	NULL
nama_kab	varchar(100)	Yes	NULL
nama_prov	varchar(100)	Yes	NULL
alamat	varchar(255)	Yes	NULL
lhrtempat	varchar(50)	Yes	NULL
lhrtanggal	varchar(50)	Yes	NULL
ttl	varchar(50)	Yes	NULL
umur	varchar(50)	Yes	NULL
jk	int(11)	Yes	NULL
jenis	varchar(50)	Yes	NULL
status	int(11)	Yes	NULL
sts	varchar(50)	Yes	NULL		Status Kawin
hub	varchar(50)	Yes	NULL
agama	int(50)	Yes	NULL
agm	varchar(50)	Yes	NULL
pendidikan	varchar(50)	Yes	NULL
pekerjaan	varchar(50)	Yes	NULL
klain_fisik	varchar(50)	Yes	NULL
aktalhr	varchar(50)	Yes	NULL
aktakawin	varchar(50)	Yes	NULL
aktacerai	varchar(50)	Yes	NULL
nocacat	varchar(50)	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	2	A	No
master_kependudukan_createby	BTREE	No	No	CreateBy	2	A	Yes
master_kependudukan_updateby	BTREE	No	No	UpdateBy	2	A	Yes
master_kependudukan_nik	BTREE	No	No	nik	2	A	No

master_loker

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
No	varchar(255)	No
Name	varchar(255)	No
locations_id	int(11)	Yes	NULL	locations -> ID
status	varchar(20)	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
master_loker_createby_idx	BTREE	No	No	CreateBy	2	A	Yes
master_loker_location_idx	BTREE	No	No	locations_id	5	A	Yes
master_loker_updateby_idx	BTREE	No	No	UpdateBy	2	A	Yes

master_pekerjaan

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
Pekerjaan	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
master_pekerjaan_createby	BTREE	No	No	CreateBy	2	A	Yes
master_pekerjaan_updateby	BTREE	No	No	UpdateBy	2	A	Yes

master_pelanggaran_locker

Column	Type	Null	Default
ID (Primary)	int(11)	No
jenis_pelanggaran	varchar(50)	Yes	NULL
denda	decimal(10,0)	Yes	NULL
deskripsi	text	Yes	NULL
CreateBy	varchar(100)	Yes	NULL
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(100)	Yes	NULL
UpdateBy	varchar(100)	Yes	NULL
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(100)	Yes	NULL

Indexes

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

master_pendidikan

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
Nama	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	42	A	No
master_pendidikan_createby	BTREE	No	No	CreateBy	4	A	Yes
master_pendidikan_updateby	BTREE	No	No	UpdateBy	4	A	Yes

master_program_studi

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
id_jurusan	int(11)	Yes	NULL	master_jurusan -> id
Nama	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	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
master_program_studi_createby	BTREE	No	No	CreateBy	A	Yes
master_program_studi_updateby	BTREE	No	No	UpdateBy	A	Yes
master_program_studi_kii	BTREE	No	No	KIILastUploadDate	A	Yes
master_program_studi_jurusan_idx	BTREE	No	No	id_jurusan	A	Yes

master_range_umur

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
umur1	int(11)	No
umur2	int(11)	No
Keterangan	varchar(255)	Yes	NULL
NoUrut	int(11)	Yes	99
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	8	A	No
master_range_umur_createby	BTREE	No	No	CreateBy	2	A	Yes
master_range_umur_updateby	BTREE	No	No	UpdateBy	2	A	Yes

master_status_perkawinan

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
Nama	varchar(30)	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
master_status_perkawinan_createby	BTREE	No	No	CreateBy	2	A	Yes
master_status_perkawinan_updateby	BTREE	No	No	UpdateBy	2	A	Yes

master_uang_jaminan

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

Indexes

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

member_fields

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
name	varchar(255)	No
mandatory	bit(1)	Yes	b'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	48	A	No
member_fields_mandatory	BTREE	No	No	mandatory	4	A	Yes
member_fields_createby	BTREE	No	No	CreateBy	2	A	Yes
member_fields_updateby	BTREE	No	No	UpdateBy	2	A	Yes

member_perpanjangan

Column	Type	Null	Default	Links to
ID (Primary)	double	No
Member_id	double	Yes	NULL	members -> ID
Tanggal	datetime	No
Biaya	decimal(10,0)	Yes	0
IsLunas	bit(1)	Yes	b'0'
Keterangan	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
member_perpanjangan_member	BTREE	No	No	Member_id	A	Yes
member_perpanjangan_createby	BTREE	No	No	CreateBy	A	Yes
member_perpanjangan_updateby	BTREE	No	No	UpdateBy	A	Yes
member_perpanjangan_createdate	BTREE	No	No	CreateDate	A	Yes
member_perpanjangan_tanggal	BTREE	No	No	Tanggal	A	No

memberguesses

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
NoAnggota	varchar(50)	Yes	NULL
Nama	varchar(100)	No
Status_id	int(11)	Yes	NULL	status_anggota -> id
MasaBerlaku_id	int(11)	Yes	NULL	masa_berlaku_anggota -> id
Profesi_id	int(11)	Yes	NULL	master_pekerjaan -> id
PendidikanTerakhir_id	int(11)	Yes	NULL	master_pendidikan -> id
JenisKelamin_id	int(11)	Yes	NULL	jenis_kelamin -> ID
Alamat	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
Deskripsi	varchar(255)	Yes	NULL
LOCATIONLOANS_ID	int(11)	Yes	NULL	location_library -> ID
Location_Id	int(11)	Yes	NULL	locations -> ID
TujuanKunjungan_Id	int(11)	Yes	NULL	tujuan_kunjungan -> ID
Information	varchar(255)	Yes	NULL
NoPengunjung	varchar(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2071	A	No
memberguesses_locationloans	BTREE	No	No	LOCATIONLOANS_ID	2	A	Yes
memberguesses_location_id	BTREE	No	No	Location_Id	30	A	Yes
memberguesses_TujuanKunjungan_Id	BTREE	No	No	TujuanKunjungan_Id	2	A	Yes
Membergueeses_NoPengunjung	BTREE	No	No	NoPengunjung	2	A	Yes
memberguesses_status	BTREE	No	No	Status_id	2	A	Yes
memberguesses_pekerjaan	BTREE	No	No	Profesi_id	2	A	Yes
memberguesses_pendidikan	BTREE	No	No	PendidikanTerakhir_id	2	A	Yes
memberguesses_jeniskelamin	BTREE	No	No	JenisKelamin_id	2	A	Yes
memberguesses_masaberlaku	BTREE	No	No	MasaBerlaku_id	2	A	Yes
memberguesses_createby	BTREE	No	No	CreateBy	4	A	Yes
memberguesses_updateby	BTREE	No	No	UpdateBy	4	A	Yes
memberguesses_nama	BTREE	No	No	Nama	2071	A	No
memberguesses_createdate	BTREE	No	No	CreateDate	2071	A	Yes
memberguesses_noanggota	BTREE	No	No	NoAnggota	2071	A	Yes

memberloanauthorizecategory

Column	Type	Null	Default	Links to
DataID (Primary)	bigint(20)	No
Member_id	double	No		members -> ID
CategoryLoan_id	int(11)	No		collectioncategorys -> 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	DataID	2596	A	No
CategoryLoan_id	BTREE	No	No	CategoryLoan_id	6	A	No
Member_id	BTREE	No	No	Member_id	2596	A	No
memberloanauthorizecategory_createby	BTREE	No	No	CreateBy	2	A	Yes
memberloanauthorizecategory_updateby	BTREE	No	No	UpdateBy	2	A	Yes

memberloanauthorizelocation

Column	Type	Null	Default	Links to
DataID (Primary)	bigint(20)	No
Member_id	double	No		members -> ID
LocationLoan_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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	DataID	1722	A	No
memberloanauthorizelocation_createby	BTREE	No	No	CreateBy	2	A	Yes
memberloanauthorizelocation_updateby	BTREE	No	No	UpdateBy	2	A	Yes
memberloanauthorizelocation_loc_idx	BTREE	No	No	LocationLoan_id	4	A	No
memberloanauthorizelocation_member_idx	BTREE	No	No	Member_id	1722	A	No

memberrules

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
NameCategory	varchar(50)	No
Contents	text	Yes	NULL
isPublish	bit(1)	Yes	b'1'
SortNum	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
memberrules_createby	BTREE	No	No	CreateBy	2	A	Yes
memberrules_updateby	BTREE	No	No	UpdateBy	2	A	Yes

members

Column	Type	Null	Default	Links to
ID (Primary)	double	No
MemberNo	varchar(50)	No
Fullname	varchar(255)	No
PlaceOfBirth	varchar(255)	Yes	NULL
DateOfBirth	datetime	Yes	NULL
Address	varchar(255)	Yes	NULL
AddressNow	varchar(255)	Yes	NULL
Phone	varchar(100)	Yes	NULL
InstitutionName	varchar(255)	Yes	NULL
InstitutionAddress	varchar(255)	Yes	NULL
InstitutionPhone	varchar(255)	Yes	NULL
IdentityType_id	int(11)	Yes	NULL	master_jenis_identitas -> id
IdentityNo	varchar(100)	Yes	NULL
EducationLevel_id	int(11)	Yes	NULL	master_pendidikan -> id
Sex_id	int(11)	Yes	NULL	jenis_kelamin -> ID
MaritalStatus_id	int(11)	Yes	NULL	master_status_perkawinan -> id
Job_id	int(11)	Yes	NULL	master_pekerjaan -> id
RegisterDate	datetime	Yes	NULL
EndDate	datetime	Yes	NULL
MotherMaidenName	varchar(100)	Yes	NULL
Email	varchar(100)	Yes	NULL
JenisPermohonan_id	int(11)	Yes	NULL	jenis_permohonan -> ID
JenisAnggota_id	int(11)	Yes	NULL	jenis_anggota -> id
StatusAnggota_id	int(11)	Yes	NULL	status_anggota -> id
LoanReturnLateCount	int(11)	Yes	0
Branch_id	int(11)	Yes	NULL	branchs -> ID
PhotoUrl	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
NoHp	varchar(100)	Yes	NULL
NamaDarurat	varchar(100)	Yes	NULL
TelpDarurat	varchar(100)	Yes	NULL
AlamatDarurat	varchar(255)	Yes	NULL
StatusHubunganDarurat	varchar(100)	Yes	NULL
City	varchar(255)	Yes	NULL
Province	varchar(255)	Yes	NULL
CityNow	varchar(255)	Yes	NULL
ProvinceNow	varchar(255)	Yes	NULL
Kecamatan	varchar(100)	Yes	NULL
Kelurahan	varchar(100)	Yes	NULL
RT	varchar(50)	Yes	NULL
RW	varchar(50)	Yes	NULL
KecamatanNow	varchar(100)	Yes	NULL
KelurahanNow	varchar(100)	Yes	NULL
RTNow	varchar(50)	Yes	NULL
RWNow	varchar(50)	Yes	NULL
Kelas_id	int(11)	Yes	NULL	kelas_siswa -> id
TahunAjaran	varchar(50)	Yes	NULL
Agama_id	int(11)	Yes	NULL	agama -> ID
Fakultas_id	int(11)	Yes	NULL	master_fakultas -> id
Jurusan_id	int(11)	Yes	NULL	master_jurusan -> id
ProgramStudi_id	int(11)	Yes	NULL	master_program_studi -> id
JenjangPendidikan_id	int(11)	Yes	NULL	master_jenjang_pendidikan -> ID
UnitKerja_id	int(11)	Yes	NULL	departments -> ID
KeteranganLain	varchar(255)	Yes	NULL
IsLunasBiayaPendaftaran	bit(1)	Yes	b'0'
BiayaPendaftaran	decimal(10,0)	Yes	0
TanggalBebasPustaka	datetime	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	955	A	No
Branch_id	BTREE	No	No	Branch_id	2	A	Yes
MemberNo	BTREE	No	No	MemberNo	955	A	No
member_job	BTREE	No	No	Job_id	6	A	Yes
member_sex	BTREE	No	No	Sex_id	4	A	Yes
member_agama	BTREE	No	No	Agama_id	2	A	Yes
member_unit_kerja	BTREE	No	No	UnitKerja_id	2	A	Yes
members_status_perkawinan	BTREE	No	No	MaritalStatus_id	4	A	Yes
members_jenispermohonan	BTREE	No	No	JenisPermohonan_id	2	A	Yes
members_statusanggota	BTREE	No	No	StatusAnggota_id	2	A	Yes
members_education	BTREE	No	No	EducationLevel_id	79	A	Yes
members_jenis_anggota	BTREE	No	No	JenisAnggota_id	4	A	Yes
members_identitytype	BTREE	No	No	IdentityType_id	4	A	Yes
members_kelassiswa	BTREE	No	No	Kelas_id	2	A	Yes
members_fakultas	BTREE	No	No	Fakultas_id	2	A	Yes
members_jurusan	BTREE	No	No	Jurusan_id	2	A	Yes
members_createby	BTREE	No	No	CreateBy	2	A	Yes
members_updateby	BTREE	No	No	UpdateBy	2	A	Yes
members_dateofbirth	BTREE	No	No	DateOfBirth	955	A	Yes
members_createdate	BTREE	No	No	CreateDate	318	A	Yes
members_updatedate	BTREE	No	No	UpdateDate	318	A	Yes
members_kii	BTREE	No	No	KIILastUploadDate	2	A	Yes
members_registerdate	BTREE	No	No	RegisterDate	2	A	Yes
members_programstudi_idx	BTREE	No	No	ProgramStudi_id	2	A	Yes
members_jenjang_pendidikan	BTREE	No	No	JenjangPendidikan_id	2	A	Yes

members_form

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	66	A	No
members_form_field	BTREE	No	No	Member_Field_id	66	A	Yes
members_form_perpus	BTREE	No	No	Jenis_Perpustakaan_id	4	A	Yes
members_form_createby	BTREE	No	No	CreateBy	2	A	Yes
members_form_updateby	BTREE	No	No	UpdateBy	2	A	Yes

members_form_list

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	44	A	No
members_form_list_field	BTREE	No	No	Member_Field_id	44	A	Yes
members_form_list_perpus	BTREE	No	No	Jenis_Perpustakaan_id	8	A	Yes
members_form_list_createby	BTREE	No	No	CreateBy	4	A	Yes
members_form_list_updateby	BTREE	No	No	UpdateBy	4	A	Yes

members_info_form

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	53	A	No
members_info_form_field	BTREE	No	No	Member_Field_id	53	A	Yes
members_info_form_perpus	BTREE	No	No	Jenis_Perpustakaan_id	4	A	Yes
members_info_form_createby	BTREE	No	No	CreateBy	2	A	Yes
members_info_form_updateby	BTREE	No	No	UpdateBy	2	A	Yes

members_loan_form

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	17	A	No
members_loan_form_field	BTREE	No	No	Member_Field_id	17	A	Yes
members_loan_form_perpus	BTREE	No	No	Jenis_Perpustakaan_id	8	A	Yes
members_loan_form_createby	BTREE	No	No	CreateBy	2	A	Yes
members_loan_form_updateby	BTREE	No	No	UpdateBy	2	A	Yes

members_loanreturn_form

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	16	A	No
members_loanreturn_form_field	BTREE	No	No	Member_Field_id	16	A	Yes
members_loanreturn_form_perpus	BTREE	No	No	Jenis_Perpustakaan_id	8	A	Yes
members_loanreturn_form_createby	BTREE	No	No	CreateBy	2	A	Yes
members_loanreturn_form_updateby	BTREE	No	No	UpdateBy	2	A	Yes

members_online_form

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	99	A	No
members_online_form_field	BTREE	No	No	Member_Field_id	99	A	Yes
members_online_form_perpus	BTREE	No	No	Jenis_Perpustakaan_id	6	A	Yes
members_online_form_createby	BTREE	No	No	CreateBy	4	A	Yes
members_online_form_updateby	BTREE	No	No	UpdateBy	4	A	Yes

members_online_form_edit

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_Field_id	int(11)	Yes	NULL	member_fields -> 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
Jenis_Perpustakaan_id	int(11)	Yes	NULL	jenis_perpustakaan -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	28	A	No
members_online_form_edit_field	BTREE	No	No	Member_Field_id	28	A	Yes
members_online_form_edit_perpus	BTREE	No	No	Jenis_Perpustakaan_id	4	A	Yes
members_online_form_edit_createby	BTREE	No	No	CreateBy	2	A	Yes
members_online_form_edit_updateby	BTREE	No	No	UpdateBy	2	A	Yes

membersonline

Column	Type	Null	Default	Links to
ID (Primary)	int(9)	No
NoAnggota	varchar(50)	Yes	NULL
NickName	varchar(100)	Yes	NULL
Password	varchar(100)	Yes	NULL
Email	varchar(100)	Yes	NULL
BranchId	int(11)	Yes	NULL	branchs -> ID
LocationLoanId	int(11)	Yes	NULL	location_library -> ID
Status	varchar(100)	Yes	NULL
Activation_Code	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
auth_key	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	25987	A	No
BranchId	BTREE	No	No	BranchId	2	A	Yes
LocationLoanId	BTREE	No	No	LocationLoanId	2	A	Yes
NoAnggota	BTREE	No	No	NoAnggota	25987	A	Yes
membersonline_createby	BTREE	No	No	CreateBy	2	A	Yes
membersonline_updateby	BTREE	No	No	UpdateBy	2	A	Yes

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
name	varchar(128)	No
parent	int(11)	Yes	NULL	menu -> id
route	varchar(256)	Yes	NULL
order	int(11)	Yes	NULL
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
UpdateTerminal	varchar(100)	Yes	NULL
UpdateDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	232	A	No
parent	BTREE	No	No	parent	77	A	Yes
menu_createby	BTREE	No	No	CreateBy	2	A	Yes
menu_updateby	BTREE	No	No	UpdateBy	2	A	Yes

migration

Column	Type	Null	Default	Links to
version (Primary)	varchar(180)	No
apply_time	int(11)	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
UpdateTerminal	varchar(100)	Yes	NULL
UpdateDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	version	A	No
migration_createby	BTREE	No	No	CreateBy	A	Yes
migration_updateby	BTREE	No	No	UpdateBy	A	Yes

modelhistory

Column	Type	Null	Default
id (Primary)	bigint(20)	No
date	datetime	No
table	varchar(255)	No
field_name	varchar(255)	No
field_id	varchar(255)	No
old_value	text	Yes	NULL
new_value	text	Yes	NULL
type	smallint(6)	No
user_id	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	1396636	A	No
idx-table	BTREE	No	No	table	102	A	No
idx-field_name	BTREE	No	No	field_name	394	A	No
idx-type	BTREE	No	No	type	4	A	No
idx-user_id	BTREE	No	No	user_id	10	A	No

modules

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(100)	No
URL	varchar(255)	Yes	NULL
SortNo	int(11)	Yes	0
IsPublish	bit(1)	Yes	b'1'
ClassName	varchar(50)	Yes	NULL
IsHeader	bit(1)	Yes	b'0'
ModuleLevel	int(11)	Yes	NULL
Application_id	int(11)	No		applications -> ID
ParentID	int(11)	Yes	NULL	modules -> 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	276	A	No
Application_id	BTREE	No	No	Application_id	4	A	No
ParentID	BTREE	No	No	ParentID	39	A	Yes
modules_url	BTREE	No	No	URL	276	A	Yes
modules_IsPublish	BTREE	No	No	IsPublish	4	A	Yes
modules_name	BTREE	No	No	Name	276	A	No
modules_isheader	BTREE	No	No	IsHeader	4	A	Yes
modules_classname	BTREE	No	No	ClassName	18	A	Yes
modules_sortno	BTREE	No	No	SortNo	39	A	Yes
modules_moduleslevel	BTREE	No	No	ModuleLevel	4	A	Yes
modules_createby	BTREE	No	No	CreateBy	2	A	Yes
modules_updateby	BTREE	No	No	UpdateBy	2	A	Yes

notif_sms_gateway

Column	Type	Null	Default
ID (Primary)	int(11)	No
member_id	int(11)	No
number_HP	int(20)	No
collectionloanitem_id	int(11)	Yes	NULL
send_message_text	text	Yes	NULL
criteria_message	varchar(20)	Yes	NULL
send_date	datetime	Yes	NULL
send_status	varchar(10)	Yes	NULL

Indexes

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

notif_sms_gateway_hist

Column	Type	Null	Default
ID (Primary)	int(11)	No
member_id	int(11)	No
number_HP	int(20)	No
collectionloanitem_id	int(11)	Yes	NULL
send_message_text	text	Yes	NULL
criteria_message	varchar(20)	Yes	NULL
send_date	datetime	Yes	NULL
send_status	varchar(10)	Yes	NULL

Indexes

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

opac_counter

Column	Type	Null	Default
hit_id (Primary)	int(11)	No
ip_address	varchar(30)	No
city	varchar(100)	Yes	NULL
region_name	varchar(100)	Yes	NULL
country	varchar(100)	Yes	NULL
lat	varchar(100)	Yes	NULL
long	varchar(100)	Yes	NULL
create_at	datetime	Yes	NULL
update_at	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	hit_id	291	A	No

opacfields

Column	Type	Null	Default	Links to
ID (Primary)	decimal(10,0)	No
TAG	varchar(255)	No
NAME	varchar(255)	No
Column4	varchar(255)	Yes	NULL
Column5	varchar(255)	Yes	NULL
Column6	varchar(255)	Yes	NULL
Column7	varchar(255)	Yes	NULL
Column8	varchar(255)	Yes	NULL
Column9	varchar(255)	Yes	NULL
Column10	varchar(255)	Yes	NULL
Column11	varchar(255)	Yes	NULL
Column12	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	32	A	No
opacfields_createby	BTREE	No	No	CreateBy	2	A	Yes
opacfields_updateby	BTREE	No	No	UpdateBy	2	A	Yes

opaclogs

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
User_id	varchar(50)	Yes	NULL	members -> MemberNo
ip	varchar(15)	Yes	NULL
jenis_pencarian	text	Yes	NULL
keyword	text	Yes	NULL
jenis_bahan	varchar(50)	Yes	NULL
waktu	datetime	Yes	NULL
url	text	Yes	NULL
isLKD	tinyint(4)	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
Target_Pembaca	varchar(50)	Yes	NULL
Bahasa	varchar(50)	Yes	NULL
Bentuk_Karya	varchar(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	1909427	A	No
opaclogs_userid	BTREE	No	No	User_id	2	A	Yes
opaclogs_createby_idx	BTREE	No	No	CreateBy	2	A	Yes
opaclogs_updateby_idx	BTREE	No	No	UpdateBy	2	A	Yes

opaclogs_keyword

Column	Type	Null	Default	Links to
Id (Primary)	int(11)	No
OpaclogsId	int(11)	No		opaclogs -> ID
Field	varchar(20)	Yes	NULL
Keyword	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	Id	4233245	A	No
opaclogs_keyword_field_idx	BTREE	No	No	Field	16	A	Yes
opaclogs_keyword_opaclogsid_idx	BTREE	No	No	OpaclogsId	4233245	A	No
opaclogs_keyword_keyword_idx	BTREE	No	No	Keyword (240)	4047	A	Yes

outbox

Column	Type	Null	Default
UpdatedInDB	timestamp	No	CURRENT_TIMESTAMP
InsertIntoDB	timestamp	No	0000-00-00 00:00:00
SendingDateTime	timestamp	No	0000-00-00 00:00:00
SendBefore	time	No	23:59:59
SendAfter	time	No	00:00:00
Text	text	Yes	NULL
DestinationNumber	varchar(20)	No
Coding	enum('Default_No_Compression', 'Unicode_No_Compression', '8bit', 'Default_Compression', 'Unicode_Compression')	No	Default_No_Compression
UDH	text	Yes	NULL
Class	int(11)	Yes	-1
TextDecoded	text	No
ID (Primary)	int(10)	No
MultiPart	enum('false', 'true')	Yes	false
RelativeValidity	int(11)	Yes	-1
SenderID	varchar(255)	Yes	NULL
SendingTimeOut	timestamp	Yes	0000-00-00 00:00:00
DeliveryReport	enum('default', 'yes', 'no')	Yes	default
CreatorID	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	5	A	No
outbox_date	BTREE	No	No	SendingDateTime	2	A	No
outbox_date	BTREE	No	No	SendingTimeOut	2	A	Yes
outbox_sender	BTREE	No	No	SenderID	5	A	Yes

outbox_multipart

Column	Type	Null	Default
Text	text	Yes	NULL
Coding	enum('Default_No_Compression', 'Unicode_No_Compression', '8bit', 'Default_Compression', 'Unicode_Compression')	No	Default_No_Compression
UDH	text	Yes	NULL
Class	int(11)	Yes	-1
TextDecoded	text	Yes	NULL
ID (Primary)	int(10)	No	0
SequencePosition (Primary)	int(11)	No	1

Indexes

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

partners

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(255)	No
Address	varchar(255)	Yes	NULL
Phone	varchar(100)	Yes	NULL
Fax	varchar(100)	Yes	NULL
Province	varchar(255)	Yes	NULL
City	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
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	3	A	No
Partners_Name	BTREE	No	No	Name	3	A	No
partners_createby	BTREE	No	No	CreateBy	3	A	Yes
partners_updateby	BTREE	No	No	UpdateBy	3	A	Yes
partners_kii	BTREE	No	No	KIILastUploadDate	3	A	Yes
partners_createdate	BTREE	No	No	CreateDate	3	A	Yes
partners_updatedate	BTREE	No	No	UpdateDate	3	A	Yes

pbk

Column	Type	Null	Default
ID (Primary)	int(11)	No
GroupID	int(11)	No	-1
Name	text	No
Number	text	No

Indexes

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

pbk_groups

Column	Type	Null	Default	Links to	Comments	MIME
Name	text	No
ID (Primary)	int(11)	No

Indexes

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

pelanggaran

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
CollectionLoan_id	varchar(255)	Yes	NULL	collectionloans -> ID
CollectionLoanItem_id	double	Yes	NULL	collectionloanitems -> ID
JenisPelanggaran_id	int(11)	Yes	NULL	jenis_pelanggaran -> ID
JenisDenda_id	int(11)	Yes	NULL	jenis_denda -> ID
JumlahDenda	decimal(10,0)	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
JumlahSuspend	int(11)	Yes	0
Paid	bit(1)	Yes	b'0'
Member_id	double	Yes	NULL	members -> ID
Collection_id	double	Yes	NULL	collections -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
Pelanggaran_JumlahDenda	BTREE	No	No	JumlahDenda	A	Yes
pelanggaran_cli	BTREE	No	No	CollectionLoanItem_id	A	Yes
Pelanggaran_JenisPelanggaran	BTREE	No	No	JenisPelanggaran_id	A	Yes
Pelanggaran_JenisDenda	BTREE	No	No	JenisDenda_id	A	Yes
pelanggaran_createby	BTREE	No	No	CreateBy	A	Yes
pelanggaran_updateby	BTREE	No	No	UpdateBy	A	Yes
pelanggaran_collectionloan	BTREE	No	No	CollectionLoan_id	A	Yes
pelanggaran_member	BTREE	No	No	Member_id	A	Yes
pelanggaran_collection	BTREE	No	No	Collection_id	A	Yes

penduduk

Column	Type	Null	Default
id (Primary)	int(11)	No
Nik	varchar(16)	Yes	NULL
Nama	varchar(255)	Yes	NULL
Tempat_Lahir	varchar(100)	Yes	NULL
Provinsi	varchar(50)	Yes	NULL
Kabupaten_Kota	varchar(100)	Yes	NULL
Kecamatan	varchar(100)	Yes	NULL
Kelurahan_desa	varchar(100)	Yes	NULL
TPS	varchar(100)	Yes	NULL

Indexes

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

pengiriman

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
JudulKiriman	text	No
PenanggungJawab	varchar(100)	No
NipPenanggungJawab	varchar(50)	Yes	NULL
FromDate	date	Yes	NULL
ToDate	date	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
pengiriman_createby	BTREE	No	No	CreateBy	A	Yes
pengiriman_updateby	BTREE	No	No	UpdateBy	A	Yes

pengiriman_koleksi

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Collection_id	double	Yes	NULL	collections -> ID
BIBID	varchar(50)	Yes	NULL
JUDUL	varchar(4000)	Yes	NULL
TAHUNTERBIT	varchar(20)	Yes	NULL
CALLNUMBER	varchar(255)	Yes	NULL
NOBARCODE	varchar(100)	Yes	NULL
NOINDUK	varchar(255)	Yes	NULL
QUANTITY	int(10)	Yes	NULL
TANGGALKIRIM	date	Yes	NULL
PengirimanID	int(11)	Yes	NULL	pengiriman -> ID
IsCheck	bit(1)	No	b'0'
CreateBy	int(11)	Yes	NULL	users -> ID
CreateDate	datetime	Yes	NULL
CreateTerminal	varchar(50)	Yes	NULL
UpdateBy	int(11)	Yes	NULL	users -> ID
UpdateDate	datetime	Yes	NULL
UpdateTerminal	varchar(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
pengirimankoleksi_createby	BTREE	No	No	CreateBy	A	Yes
pengirimankoleksi_updateby	BTREE	No	No	UpdateBy	A	Yes
pengiriman_cetak_id	BTREE	No	No	PengirimanID	A	Yes
pengirimankoleksi_collectionid	BTREE	No	No	Collection_id	A	Yes

peraturan_peminjaman_hari

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
DayIndex	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
MaxPinjamKoleksi	int(11)	Yes	0
MaxLoanDays	int(11)	Yes	0
DendaType	varchar(45)	Yes	Konstan
DendaTenorJumlah	double	Yes	0
DendaTenorSatuan	varchar(45)	Yes	Hari
DendaPerTenor	decimal(10,0)	Yes	NULL
DendaTenorMultiply	int(11)	Yes	NULL
SuspendMember	bit(1)	Yes	b'0'
WarningLoanDueDay	int(11)	Yes	0
SuspendType	varchar(45)	Yes	Konstan
SuspendTenorJumlah	double	Yes	0
SuspendTenorSatuan	varchar(45)	Yes	Hari
DaySuspend	int(11)	Yes	0
SuspendTenorMultiply	int(11)	Yes	1
DayPerpanjang	int(11)	Yes	0
CountPerpanjang	int(11)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
pp_hari_createby	BTREE	No	No	CreateBy	A	Yes
pp_hari_updateby	BTREE	No	No	UpdateBy	A	Yes
pp_hari_createdate	BTREE	No	No	CreateDate	A	Yes
pp_hari_updatedate	BTREE	No	No	UpdateDate	A	Yes

peraturan_peminjaman_tanggal

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
TanggalAwal	datetime	Yes	NULL
TanggalAkhir	datetime	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
MaxPinjamKoleksi	int(11)	Yes	0
MaxLoanDays	int(11)	Yes	0
DendaType	varchar(45)	Yes	Konstan
DendaTenorJumlah	double	Yes	0
DendaTenorSatuan	varchar(45)	Yes	Hari
DendaPerTenor	decimal(10,0)	Yes	NULL
DendaTenorMultiply	int(11)	Yes	NULL
SuspendMember	bit(1)	Yes	b'0'
WarningLoanDueDay	int(11)	Yes	0
SuspendType	varchar(45)	Yes	Konstan
SuspendTenorJumlah	double	Yes	0
SuspendTenorSatuan	varchar(45)	Yes	Hari
DaySuspend	int(11)	Yes	0
SuspendTenorMultiply	int(11)	Yes	1
DayPerpanjang	int(11)	Yes	0
CountPerpanjang	int(11)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
pp_tanggal_createby	BTREE	No	No	CreateBy	A	Yes
pp_tanggal_updateby	BTREE	No	No	UpdateBy	A	Yes
pp_tanggal_createdate	BTREE	No	No	CreateDate	A	Yes
pp_tanggal_updatedate	BTREE	No	No	UpdateDate	A	Yes
pp_tanggalawal	BTREE	No	No	TanggalAwal	A	Yes
pp_tanggalakhir	BTREE	No	No	TanggalAkhir	A	Yes

phones

Column	Type	Null	Default
ID	text	No
UpdatedInDB	timestamp	No	CURRENT_TIMESTAMP
InsertIntoDB	timestamp	No	0000-00-00 00:00:00
TimeOut	timestamp	No	0000-00-00 00:00:00
Send	enum('yes', 'no')	No	no
Receive	enum('yes', 'no')	No	no
IMEI (Primary)	varchar(35)	No
Client	text	No
Battery	int(11)	No	-1
Signal	int(11)	No	-1
Sent	int(11)	No	0
Received	int(11)	No	0

Indexes

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

propinsi

Column	Type	Null	Default	Links to
ID (Primary)	int(5)	No
NamaPropinsi	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	33	A	No
propinsi_nama	BTREE	No	No	NamaPropinsi	33	A	No
propinsi_createby	BTREE	No	No	CreateBy	2	A	Yes
propinsi_updateby	BTREE	No	No	UpdateBy	2	A	Yes

publishers

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	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	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
publishers_createby	BTREE	No	No	CreateBy	A	Yes
publishers_updateby	BTREE	No	No	UpdateBy	A	Yes

quarantined_auth_data

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Auth_Header_ID	int(11)	No		quarantined_auth_header -> ID
Tag	varchar(3)	No
Indicator1	char(1)	Yes	NULL
Indicator2	char(1)	Yes	NULL
Value	text	Yes	NULL
DataItem	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	ID	A	No
quarantined_auth_data_auth_header	BTREE	No	No	Auth_Header_ID	A	No
quarantined_auth_data_ID	BTREE	No	No	ID	A	No
quarantined_auth_data_createby	BTREE	No	No	CreateBy	A	Yes
quarantined_auth_data_updateby	BTREE	No	No	UpdateBy	A	Yes

quarantined_auth_header

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Worksheet_id	int(11)	Yes	NULL
Auth_ID	varchar(20)	Yes	NULL
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	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
quarantined_auth_header_ID	BTREE	No	No	ID	A	No
quarantined_auth_header_createby	BTREE	No	No	CreateBy	A	Yes
quarantined_auth_header_updateby	BTREE	No	No	UpdateBy	A	Yes

quarantined_catalog_ruas

Column	Type	Null	Default	Links to
ID (Primary)	double	No
CatalogId	double	No		quarantined_catalogs -> ID
Tag	varchar(3)	No
Indicator1	char(1)	Yes	NULL
Indicator2	char(1)	Yes	NULL
Value	text	Yes	NULL
Sequence	int(10)	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	1489	A	No
quarantined_catalog_ruas_catalogs	BTREE	No	No	CatalogId	45	A	No
quarantined_catalog_ruas_ID	BTREE	No	No	ID	1489	A	No
quarantined_catalog_ruas_createby	BTREE	No	No	CreateBy	2	A	Yes
quarantined_catalog_ruas_updateby	BTREE	No	No	UpdateBy	2	A	Yes

quarantined_catalog_subruas

Column	Type	Null	Default	Links to
ID (Primary)	double	No
RuasID	double	No		quarantined_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	1526	A	No
quarantined_catalog_subruas_ruas	BTREE	No	No	RuasID	1526	A	No
quarantined_catalog_subruas_createby	BTREE	No	No	CreateBy	2	A	Yes
quarantined_catalog_subruas_updateby	BTREE	No	No	UpdateBy	2	A	Yes

quarantined_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
Publikasi	varchar(700)	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	0
IsBNI	bit(1)	Yes	b'0'
IsKIN	bit(1)	Yes	b'0'
IsRDA	bit(1)	Yes	b'0'
CoverURL	varchar(255)	Yes	NULL
Branch_id	int(11)	Yes	NULL
Worksheet_id	int(11)	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
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	22	A	No
quarantined_catalogs_ID	BTREE	No	No	ID	22	A	No
quarantined_catalogs_createby	BTREE	No	No	CreateBy	2	A	Yes
quarantined_catalogs_updateby	BTREE	No	No	UpdateBy	2	A	Yes
quarantined_catalogs_member_idx	BTREE	No	No	Member_id	2	A	Yes
quarantined_catalogs_qby_idx	BTREE	No	No	QUARANTINEDBY	2	A	Yes

quarantined_collections

Column	Type	Null	Default	Links to
ID (Primary)	double	No
NomorBarcode	varchar(50)	Yes	NULL
NoInduk	varchar(50)	Yes	NULL
Currency	varchar(30)	Yes	NULL
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
Catalog_id	double	Yes	NULL
Partner_id	int(11)	Yes	NULL
Location_id	int(11)	Yes	NULL
Rule_id	int(11)	Yes	NULL
Category_id	int(11)	Yes	NULL
Media_id	int(11)	Yes	NULL
Source_id	int(11)	Yes	NULL
Status_id	int(11)	Yes	9
Location_Library_id	int(11)	Yes	NULL
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
KIILastUploadDate	datetime	Yes	NULL
BookingMemberID	varchar(50)	Yes	NULL
BookingExpiredDate	date	Yes	NULL
IsDeposit	int(1)	Yes	NULL
NomorDeposit	varchar(21)	Yes	NULL
ThnTerbitDeposit	int(11)	Yes	NULL
deposit_ws_ID	int(11)	Yes	NULL
deposit_kode_wilayah_ID	int(11)	Yes	NULL
Nomor_Regis	varchar(11)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	2	A	No
quarantined_collections_ID	BTREE	No	No	ID	2	A	No
quarantined_collections_createby	BTREE	No	No	CreateBy	2	A	Yes
quarantined_collections_updateby	BTREE	No	No	UpdateBy	2	A	Yes
quarantined_collections_qby_idx	BTREE	No	No	QUARANTINEDBY	2	A	Yes

quarantined_pengiriman

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
TanggalKirim	date	No
Collection_ID	double	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
quarantined_pengiriman_ID	BTREE	No	No	ID	A	No
quarantined_pengiriman_createby	BTREE	No	No	CreateBy	A	Yes
quarantined_pengiriman_updateby	BTREE	No	No	UpdateBy	A	Yes

readinlocation

Column	Type	Null	Default	Links to
ID (Primary)	double	No
MemberNo	varchar(50)	Yes	NULL
Nama	varchar(100)	No
Status	varchar(50)	Yes	NULL
Profesi	varchar(50)	Yes	NULL
Pendidikan	varchar(50)	Yes	NULL
JenisKelamin	varchar(50)	Yes	NULL
Alamat	varchar(255)	Yes	NULL
TypeIdCard	varchar(50)	Yes	NULL
NoIdCard	varchar(50)	Yes	NULL
NoBarcode	varchar(50)	Yes	NULL
Title	text	No
Author	text	Yes	NULL
Publisher	varchar(255)	Yes	NULL
ControlNumber	varchar(50)	Yes	NULL
LocationId	int(11)	No		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
readinlocation_location	BTREE	No	No	LocationId	A	No
readinlocation_createby	BTREE	No	No	CreateBy	A	Yes
readinlocation_updateby	BTREE	No	No	UpdateBy	A	Yes

refferenceitems

Column	Type	Null	Default	Links to
RefferenceItemsID (Primary)	int(11)	No
Refference_id	int(11)	No		refferences -> ID
Code	varchar(10)	Yes	NULL
Name	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	RefferenceItemsID	1411	A	No
Refference_id	BTREE	No	No	Refference_id	282	A	No
refferenceitems_code	BTREE	No	No	Code	470	A	Yes
refferenceitems_createby	BTREE	No	No	CreateBy	2	A	Yes
refferenceitems_updateby	BTREE	No	No	UpdateBy	2	A	Yes

refferences

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(255)	No
Format_id	int(11)	No		formats -> 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	138	A	No
refferences_format	BTREE	No	No	Format_id	2	A	No
refferences_createby	BTREE	No	No	CreateBy	2	A	Yes
refferences_updateby	BTREE	No	No	UpdateBy	2	A	Yes

requestcatalog

Column	Type	Null	Default	Links to
ID (Primary)	int(10)	No
Type	varchar(50)	Yes	NULL
Title	varchar(255)	No
Subject	varchar(255)	Yes	NULL
Author	varchar(255)	Yes	NULL
PublishLocation	varchar(255)	Yes	NULL
PublishYear	varchar(50)	Yes	NULL
Publisher	varchar(50)	Yes	NULL
Comments	text	Yes	NULL
MemberID	double	Yes	NULL	members -> ID
CallNumber	varchar(50)	Yes	NULL
ControlNumber	varchar(50)	Yes	NULL
DateRequest	datetime	Yes	NULL
Status	varchar(20)	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
WorksheetID	int(11)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
requestcatalog_createby	BTREE	No	No	CreateBy	A	Yes
requestcatalog_updateby	BTREE	No	No	UpdateBy	A	Yes
requestcatalog_daterequest	BTREE	No	No	DateRequest	A	Yes
requestcatalog_member_idx	BTREE	No	No	MemberID	A	Yes
requestcatalog_Title	BTREE	No	No	Title	A	No
requestcatalog_PublishLocation	BTREE	No	No	PublishLocation	A	Yes
requestcatalog_PublishYear	BTREE	No	No	PublishYear	A	Yes
requestcatalog_Publisher	BTREE	No	No	Publisher	A	Yes

rfid_temp

Column	Type	Null	Default	Links to	Comments
rfid_no	varchar(50)	Yes	NULL
ip	varchar(50)	Yes	NULL
status_alarm	varchar(50)	Yes	NULL		diset null jika dari service rfid lalu jika dari website.
serial_number	varchar(50)	Yes	NULL
item_type	varchar(45)	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
rfid_temp_createby	BTREE	No	No	CreateBy	A	Yes
rfid_temp_updateby	BTREE	No	No	UpdateBy	A	Yes
rfid_temp_ip	BTREE	No	No	ip	A	Yes
rfid_temp_rfidno	BTREE	No	No	rfid_no	A	Yes
rfid_temp_statusalarm	BTREE	No	No	status_alarm	A	Yes
rfid_temp_serialnumber	BTREE	No	No	serial_number	A	Yes
rfid_temp_itemtype	BTREE	No	No	item_type	A	Yes

rolemodule

Column	Type	Null	Default	Links to
Role_id (Primary)	int(11)	No		roles -> ID
IsView	bit(1)	Yes	b'0'
IsAdd	bit(1)	Yes	b'0'
IsEdit	bit(1)	Yes	b'0'
IsDelete	bit(1)	Yes	b'0'
IsPrint	bit(1)	Yes	b'0'
Module_id (Primary)	int(11)	No	0	modules -> 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	Role_id	22	A	No
PRIMARY	BTREE	Yes	No	Module_id	776	A	No
Module_id	BTREE	No	No	Module_id	776	A	No
Role_id	BTREE	No	No	Role_id	22	A	No
rolemodule_isview	BTREE	No	No	IsView	6	A	Yes
rolemodule_isadd	BTREE	No	No	IsAdd	4	A	Yes
rolemodule_isedit	BTREE	No	No	IsEdit	6	A	Yes
rolemodule_createby	BTREE	No	No	CreateBy	4	A	Yes
rolemodule_updateby	BTREE	No	No	UpdateBy	4	A	Yes

roles

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(50)	No
Name	varchar(255)	No
IsActive	bit(1)	Yes	b'1'
Application_id	int(11)	No		applications -> 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	45	A	No
Application_id	BTREE	No	No	Application_id	4	A	No
roles_createby	BTREE	No	No	CreateBy	6	A	Yes
roles_updateby	BTREE	No	No	UpdateBy	4	A	Yes
roles_kii	BTREE	No	No	KIILastUploadDate	4	A	Yes
roles_createdate	BTREE	No	No	CreateDate	45	A	Yes
roles_updatedate	BTREE	No	No	UpdateDate	45	A	Yes

route

Column	Type	Null	Default
name (Primary)	varchar(64)	No
alias	varchar(64)	No
type	varchar(64)	No
status	smallint(6)	No	1

Indexes

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

sentitems

Column	Type	Null	Default	Links to
UpdatedInDB	timestamp	No	CURRENT_TIMESTAMP
InsertIntoDB	timestamp	No	0000-00-00 00:00:00
SendingDateTime	timestamp	No	0000-00-00 00:00:00
DeliveryDateTime	timestamp	Yes	NULL
Text	text	No
DestinationNumber	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	0
SenderID	varchar(255)	No
SequencePosition (Primary)	int(11)	No	1
Status	enum('SendingOK', 'SendingOKNoReport', 'SendingError', 'DeliveryOK', 'DeliveryFailed', 'DeliveryPending', 'DeliveryUnknown', 'Error')	No	SendingOK
StatusError	int(11)	No	-1
TPMR	int(11)	No	-1
RelativeValidity	int(11)	No	-1
CreatorID	text	No
CollectionLoanItem_id	double	Yes	NULL	collectionloanitems -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
PRIMARY	BTREE	Yes	No	SequencePosition	A	No
sentitems_date	BTREE	No	No	DeliveryDateTime	A	Yes
sentitems_tpmr	BTREE	No	No	TPMR	A	No
sentitems_dest	BTREE	No	No	DestinationNumber	A	No
sentitems_sender	BTREE	No	No	SenderID	A	No
sentitems_cli_idx	BTREE	No	No	CollectionLoanItem_id	A	Yes

serial_articlefiles

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Articles_id	double	No		serial_articles -> id
FileURL	varchar(255)	Yes	NULL
FileFlash	varchar(255)	Yes	NULL
sizeFile	varchar(255)	Yes	NULL
IsPublish	tinyint(4)	Yes	1
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
IsFromMember	bit(1)	Yes	b'0'
Member_id	double	Yes	NULL

Indexes

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

serial_articles

Column	Type	Null	Default	Links to
id (Primary)	double	No
Article_type	varchar(255)	Yes	NULL
Title	varchar(700)	No
Content	text	Yes	NULL
Creator	varchar(700)	Yes	NULL
Contributor	varchar(700)	Yes	NULL
StartPage	int(11)	Yes	NULL
Pages	int(11)	Yes	NULL
Subject	varchar(700)	Yes	NULL
DDC	varchar(255)	Yes	NULL
Call_Number	varchar(255)	Yes	NULL
EDISISERIAL	varchar(255)	Yes	NULL
TANGGAL_TERBIT_EDISI_SERIAL	date	Yes	NULL
Catalog_id	double	Yes	NULL	catalogs -> 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
ISOPAC	bit(1)	Yes	b'0'
Abstract	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_title	BTREE	No	No	Title	A	No
articles_catalog	BTREE	No	No	Catalog_id	A	Yes
articles_createby	BTREE	No	No	CreateBy	A	Yes
articles_updateby	BTREE	No	No	UpdateBy	A	Yes

serial_articles_repeatable

Column	Type	Null	Default	Links to
ID (Primary)	bigint(20)	No
serial_article_ID	double	No		serial_articles -> id
article_field	varchar(50)	Yes	NULL
value	varchar(111)	Yes	NULL
CreateBy	int(11)	Yes	NULL	users -> ID
UpdateBy	int(11)	Yes	NULL	users -> ID

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
SERIAL_ARTICLE_ID	BTREE	No	No	serial_article_ID	A	No
CREATE_USER	BTREE	No	No	CreateBy	A	Yes
UPDATE_USER	BTREE	No	No	UpdateBy	A	Yes

session

Column	Type	Null	Default
id (Primary)	char(40)	No
expire	int(11)	Yes	NULL
data	blob	Yes	NULL

Indexes

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

settingcatalogdetail

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Field_id	int(11)	No		fields -> 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	15	A	No
settingcatalogdetail_Field	BTREE	No	No	Field_id	15	A	No
settingcatalogdetail_createby	BTREE	No	No	CreateBy	2	A	Yes
settingcatalogdetail_updateby	BTREE	No	No	UpdateBy	2	A	Yes

settingparameters

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(50)	No
Value	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	121	A	No
settingparameters_name	BTREE	No	No	Name	121	A	No
settingparameters_createby	BTREE	No	No	CreateBy	2	A	Yes
settingparameters_updateby	BTREE	No	No	UpdateBy	4	A	Yes

smslogs

Column	Type	Null	Default
ID (Primary)	int(11)	No
recieverID	double	Yes	NULL
phoneNumber	varchar(20)	Yes	NULL
Text	text	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	0	A	No
recieverID_IDX	BTREE	No	No	recieverID		A	Yes
phoneNumber_IDX	BTREE	No	No	phoneNumber		A	Yes
updateby	BTREE	No	No	CreateBy		A	Yes
createby	BTREE	No	No	UpdateBy		A	Yes

status_anggota

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
Nama	varchar(30)	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	6	A	No
status_anggota_createby	BTREE	No	No	CreateBy	2	A	Yes
status_anggota_updateby	BTREE	No	No	UpdateBy	2	A	Yes

stockopname

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
ProjectName	varchar(100)	No
TglMulai	datetime	Yes	NULL
Tahun	int(11)	No
Koordinator	varchar(100)	No
Keterangan	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
stockopname_createby	BTREE	No	No	CreateBy	A	Yes
stockopname_updateby	BTREE	No	No	UpdateBy	A	Yes

stockopnamedetail

Column	Type	Null	Default	Links to
ID (Primary)	double	No
StockOpnameID	int(11)	No		stockopname -> ID
CollectionID	double	No		collections -> ID
PrevLocationID	int(11)	Yes	NULL	locations -> ID
CurrentLocationID	int(11)	Yes	NULL	locations -> ID
PrevStatusID	int(11)	Yes	NULL	collectionstatus -> ID
CurrentStatusID	int(11)	Yes	NULL	collectionstatus -> ID
PrevCollectionRuleID	int(11)	Yes	NULL	collectionrules -> ID
CurrentCollectionRuleID	int(11)	Yes	NULL	collectionrules -> 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
stockopnamedetail_stockopname	BTREE	No	No	StockOpnameID	A	No
stockopnamedetail_collection	BTREE	No	No	CollectionID	A	No
stockopnamedetail_location1	BTREE	No	No	PrevLocationID	A	Yes
stockopnamedetail_location2	BTREE	No	No	CurrentLocationID	A	Yes
stockopnamedetail_collectionrule1	BTREE	No	No	PrevCollectionRuleID	A	Yes
stockopnamedetail_collectionrule2	BTREE	No	No	CurrentCollectionRuleID	A	Yes
stockopnamedetail_colstatus1	BTREE	No	No	PrevStatusID	A	Yes
stockopnamedetail_colstatus2	BTREE	No	No	CurrentStatusID	A	Yes
stockopnamedetail_createby	BTREE	No	No	CreateBy	A	Yes
stockopnamedetail_updateby	BTREE	No	No	UpdateBy	A	Yes

sumbangan

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Member_id	double	Yes	NULL	members -> ID
Jumlah	decimal(10,0)	Yes	0
Keterangan	varchar(45)	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
sumbangan_member	BTREE	No	No	Member_id	A	Yes
sumbangan_createby	BTREE	No	No	CreateBy	A	Yes
sumbangan_updateby	BTREE	No	No	UpdateBy	A	Yes
sumbangan_createdate	BTREE	No	No	CreateDate	A	Yes

sumbangan_koleksi

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Sumbangan_id	int(11)	Yes	NULL	sumbangan -> ID
Collection_id	double	Yes	NULL	collections -> 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
sumbangan_koleksi_collection_idx	BTREE	No	No	Collection_id	A	Yes
sumbangan_koleksi_sumbangan_idx	BTREE	No	No	Sumbangan_id	A	Yes
sumbangan_koleksi_createby	BTREE	No	No	CreateBy	A	Yes
sumbangan_koleksi_updateby	BTREE	No	No	UpdateBy	A	Yes

survey

Column	Type	Null	Default	Links to	Comments
ID (Primary)	int(11)	No
NamaSurvey	varchar(200)	No
TanggalMulai	datetime	No
TanggalSelesai	datetime	No
IsActive	bit(1)	Yes	b'0'
NomorUrut	int(11)	Yes	99
TargetSurvey	int(11)	Yes	0		0: Semua, 1: Anggota
HasilSurveyShow	int(11)	Yes	0		0: Back Office dan Modul Survey, 1: Back Office
RedaksiAwal	text	Yes	NULL
RedaksiAkhir	text	Yes	NULL
Keterangan	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
survey_createby_idx	BTREE	No	No	CreateBy	A	Yes
survey_updateby_idx	BTREE	No	No	UpdateBy	A	Yes

survey_isian

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Survey_Pertanyaan_id	int(11)	Yes	NULL	survey_pertanyaan -> ID
Sesi	varchar(255)	Yes	NULL
MemberNo	varchar(50)	Yes	NULL
Isian	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
survey_isian_pertanyaan_idx	BTREE	No	No	Survey_Pertanyaan_id	A	Yes
survey_isian_sesi	BTREE	No	No	Sesi	A	Yes

survey_pertanyaan

Column	Type	Null	Default	Links to	Comments
ID (Primary)	int(11)	No
Survey_id	int(11)	Yes	NULL	survey -> ID
Pertanyaan	text	No
JenisPertanyaan	varchar(20)	Yes	Pilihan		Pilihan/isian
Orientation	varchar(20)	Yes	Vertikal		Vertikal/Horisontal
IsMandatory	bit(1)	Yes	b'1'
IsCanMultipleAnswer	bit(1)	Yes	b'0'
NoUrut	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
survey_pertanyaan_survey_idx	BTREE	No	No	Survey_id	A	Yes
survey_pertanyaan_createby_idx	BTREE	No	No	CreateBy	A	Yes
survey_pertanyaan_updateby_idx	BTREE	No	No	UpdateBy	A	Yes
survey_pertanyaan_nourut	BTREE	No	No	NoUrut	A	Yes
survey_pertanyaan_jenis	BTREE	No	No	JenisPertanyaan	A	Yes

survey_pilihan

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Survey_Pertanyaan_id	int(11)	Yes	NULL	survey_pertanyaan -> ID
Pilihan	text	No
ChoosenCount	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
PRIMARY	BTREE	Yes	No	ID	A	No
survey_pilihan_survey_pertanyaan_idx	BTREE	No	No	Survey_Pertanyaan_id	A	Yes
survey_pilihan_createby_idx	BTREE	No	No	CreateBy	A	Yes
survey_pilihan_updateby_idx	BTREE	No	No	UpdateBy	A	Yes

survey_pilihan_sesi

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Survey_Pilihan_id	int(11)	Yes	NULL	survey_pilihan -> ID
MemberNo	varchar(50)	Yes	NULL
Sesi	varchar(255)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ID	A	No
survey_pilihan_sesi_pilihan_idx	BTREE	No	No	Survey_Pilihan_id	A	Yes
survey_pilihan_sesi	BTREE	No	No	Sesi	A	Yes

tempnoinduk

Column	Type	Null	Default	Links to
ID (Primary)	double	No
NoInduk	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	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	1519	A	No
tempnoinduk_createby	BTREE	No	No	CreateBy	2	A	Yes
tempnoinduk_updateby	BTREE	No	No	UpdateBy	2	A	Yes

tujuan_kunjungan

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Code	varchar(100)	No
TujuanKunjungan	varchar(255)	No
Member	tinyint(1)	Yes	NULL
NonMember	tinyint(1)	Yes	NULL
Rombongan	tinyint(1)	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	6	A	No
Code	BTREE	Yes	No	Code	6	A	No
tujuan_kunjungan_createby	BTREE	No	No	CreateBy	2	A	Yes
tujuan_kunjungan_updateby	BTREE	No	No	UpdateBy	2	A	Yes

user

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
username	varchar(255)	No
auth_key	varchar(32)	No
password_hash	varchar(255)	No
password_reset_token	varchar(255)	Yes	NULL
email	varchar(255)	No
status	smallint(6)	No	10
created_at	int(11)	No
updated_at	int(11)	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
username	BTREE	Yes	No	username	A	No
email	BTREE	Yes	No	email	A	No
password_reset_token	BTREE	Yes	No	password_reset_token	A	Yes
user_createby	BTREE	No	No	CreateBy	A	Yes
user	BTREE	No	No	UpdateBy	A	Yes

userloclibforcol

Column	Type	Null	Default	Links to
User_id	int(11)	No		users -> 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	Cardinality	Collation	Null
User_id	BTREE	No	No	User_id	2	A	No
LocLib_id	BTREE	No	No	LocLib_id	2	A	No
userloclibforcol_createby	BTREE	No	No	CreateBy	2	A	Yes
userloclibforcol_updateby	BTREE	No	No	UpdateBy	2	A	Yes

userloclibforloan

Column	Type	Null	Default	Links to
User_id	int(11)	No		users -> 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	Cardinality	Collation	Null
User_id	BTREE	No	No	User_id	2	A	No
LocLib_id	BTREE	No	No	LocLib_id	2	A	No
userloclibforloan_createby	BTREE	No	No	CreateBy	2	A	Yes
userloclibforloan	BTREE	No	No	UpdateBy	2	A	Yes

userlogs

Column	Type	Null	Default	Links to
User_id	int(11)	No		users -> ID
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
User_id	BTREE	No	No	User_id	A	No
userlogs_createby	BTREE	No	No	CreateBy	A	Yes
userlogs	BTREE	No	No	UpdateBy	A	Yes

users

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
username	varchar(50)	No
password	varchar(255)	No
auth_key	varchar(32)	Yes	NULL
password_hash	varchar(255)	Yes	NULL
password_reset_token	varchar(255)	Yes	NULL
status	smallint(10)	Yes	NULL
PhotoUrl	varchar(255)	Yes	NULL
Fullname	varchar(255)	No
EmailAddress	varchar(255)	Yes	NULL
IsActive	bit(1)	Yes	b'1'
SesID	varchar(255)	Yes	NULL
MaxDateSesID	datetime	Yes	NULL
ActivationCode	varchar(255)	Yes	NULL
LoginAttemp	int(11)	Yes	NULL
LastSubmtLogin	datetime	Yes	NULL
LastSuccess	datetime	Yes	NULL
Department_id	int(11)	Yes	NULL	departments -> ID
Branch_id	int(11)	Yes	NULL	branchs -> ID
Role_id	int(11)	No		roles -> ID
IsCanResetUserPassword	bit(1)	Yes	b'0'
IsCanResetMemberPassword	bit(1)	Yes	b'0'
IsAdvanceEntryCatalog	bit(1)	Yes	b'0'
IsAdvanceEntryCollection	bit(1)	Yes	b'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
created_at	int(11)	Yes	NULL
updated_at	int(11)	Yes	NULL
KIILastUploadDate	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	3	A	No
Department_id	BTREE	No	No	Department_id	3	A	Yes
Branch_id	BTREE	No	No	Branch_id	3	A	Yes
Role_id	BTREE	No	No	Role_id	3	A	No
Users_Password	BTREE	No	No	password	3	A	No
users_createby	BTREE	No	No	CreateBy	3	A	Yes
users_updateby	BTREE	No	No	UpdateBy	3	A	Yes
users_kii	BTREE	No	No	KIILastUploadDate	3	A	Yes
Users_UserName	BTREE	No	No	username	3	A	No
users_createdate	BTREE	No	No	CreateDate	3	A	Yes
users_updatedate	BTREE	No	No	UpdateDate	3	A	Yes
users_IsActive	BTREE	No	No	IsActive	3	A	Yes

v_abjadopac

Table comments: VIEW

Column	Type	Null	Default	Links to	Comments	MIME
A	varchar(1)	No

v_lap_kriteria_anggota

Table comments: VIEW

Column	Type	Null
kriteria	varchar(14)	No
id_dtl_anggota	varchar(255)	No
dtl_anggota	varchar(255)	No

v_lap_kriteria_koleksi

Table comments: VIEW

Column	Type	Null	Default
kriteria	varchar(19)	No
id_dtl_kriteria	text	Yes	NULL
dtl_kriteria	text	Yes	NULL

v_pertumb_jml_kunjungan

Table comments: VIEW

Column	Type	Null	Default
kriteria	varchar(10)	No
tahun	bigint(20)	Yes	NULL
jumlah	bigint(21)	No	0

v_pertumb_jml_kunjungan_bulanan

Table comments: VIEW

Column	Type	Null	Default
kriteria	varchar(10)	No
tahun	bigint(20)	Yes	NULL
bulan	bigint(20)	Yes	NULL
jumlah	decimal(32,0)	Yes	NULL

v_stat_anggota

Table comments: VIEW

Column	Type	Null	Default
tahun	int(4)	Yes	NULL
bulan	int(2)	Yes	NULL
jumlah	bigint(21)	No	0
jenisanggota	varchar(50)	Yes	NULL
IDjenisanggota	int(11)	Yes	0

v_stat_colectionloan

Table comments: VIEW

Column	Type	Null
tahun	int(4)	No
bulan	int(1)	No
jumlah_judul	int(2)	No
jumlah_eksemplar	int(3)	No
jumlah_dijital	int(2)	No

v_stat_jenis_pendidikan

Table comments: VIEW

Column	Type	Null	Default
Keterangan	varchar(50)	No
Jumlah	bigint(21)	No	0
Tahun	varchar(4)	Yes	NULL
bulan	int(2)	Yes	NULL

v_stat_jumlah_koleksi

Table comments: VIEW

Column	Type	Null	Default
bulan	int(2)	Yes	NULL
tahun	int(4)	Yes	NULL
jumlah_judul	bigint(21)	Yes	NULL
jumlah_eksemplar	bigint(21)	No	0
jumlah_dijital	bigint(21)	Yes	NULL

v_stat_kelas_subjek

Table comments: VIEW

Column	Type	Null	Default
Keterangan	varchar(255)	No
Jumlah	int(11)	No	0
Tahun	int(4)	No	0

v_stat_koleksi_dipinjam_eksemplar

Table comments: VIEW

Column	Type	Null	Default
tahun	int(4)	Yes	NULL
bulan	int(2)	Yes	NULL
jumlah_eksemplar	bigint(21)	No	0

v_stat_koleksi_dipinjam_judul

Table comments: VIEW

Column	Type	Null	Default
tahun	int(4)	Yes	NULL
bulan	int(2)	Yes	NULL
jumlah_judul	bigint(21)	No	0

v_stat_pendidikan

Table comments: VIEW

Column	Type	Null	Default
Nama	varchar(50)	No
Jumlah	int(11)	No	0
Tahun	int(4)	No	0

v_stat_rangeumur_kunj

Table comments: VIEW

Column	Type	Null	Default
Keterangan	varchar(200)	Yes	NULL
Tahun	varchar(4)	Yes	NULL
Jumlah	bigint(21)	No	0

v_stat_rangeumur_kunj_bulanan

Table comments: VIEW

Column	Type	Null	Default
Keterangan	varchar(200)	Yes	NULL
Tahun	varchar(4)	Yes	NULL
bulan	int(2)	Yes	NULL
Jumlah	bigint(21)	No	0

worksheetfielditems

Column	Type	Null	Default	Links to
WorksheetField_id	int(11)	No		worksheetfields -> ID
Name	varchar(255)	No
RefferenceMode	varchar(20)	No
StartPosition	int(11)	Yes	NULL
Length	int(11)	Yes	NULL
DefaultValue	varchar(255)	Yes	NULL
IdemTag	varchar(255)	Yes	NULL
IdemStartPosition	int(11)	Yes	NULL
Refference_id	int(11)	Yes	NULL	refferences -> 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
Refference_id	BTREE	No	No	Refference_id	263	A	Yes
WorksheetField_id	BTREE	No	No	WorksheetField_id	52	A	No
WFItems_StartPosition	BTREE	No	No	StartPosition	87	A	Yes
worksheetfielditems_createby	BTREE	No	No	CreateBy	2	A	Yes
worksheetfielditems_updateby	BTREE	No	No	UpdateBy	2	A	Yes

worksheetfields

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Field_id	int(11)	Yes	NULL	fields -> 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
Worksheet_id	int(11)	Yes	NULL	worksheets -> ID
IsAkuisisi	bit(1)	Yes	b'0'
ISDEPOSIT	bit(1)	Yes	b'0'
ISDETAILKOLEKSI_PENGOLAHAN	bit(1)	Yes	b'0'
ISDETAILKOLEKSI_AKUISISI	bit(1)	Yes	b'0'

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	540	A	No
Field_id	BTREE	No	No	Field_id	270	A	Yes
Worksheet_id	BTREE	No	No	Worksheet_id	33	A	Yes
worksheetfields_createby	BTREE	No	No	CreateBy	4	A	Yes
worksheetfields_updateby	BTREE	No	No	UpdateBy	4	A	Yes

worksheets

Column	Type	Null	Default	Links to
ID (Primary)	int(11)	No
Name	varchar(100)	No
Format_id	int(11)	No		formats -> 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
NoUrut	int(11)	Yes	99
DEPOSITFORMAT_CODE	varchar(5)	Yes	NULL
ISSERIAL	tinyint(1)	Yes	0
ISMUSIK	bit(1)	Yes	b'0'
ISKARTOGRAFI	bit(1)	Yes	b'0'
CODE	varchar(10)	No
Keterangan	varchar(255)	Yes	NULL
MaxPinjamKoleksi	int(11)	Yes	0
MaxLoanDays	int(11)	Yes	0
DendaType	varchar(45)	Yes	Konstan
DendaTenorJumlah	decimal(10,0)	Yes	0
DendaTenorSatuan	varchar(45)	Yes	Hari
DendaPerTenor	decimal(10,0)	Yes	0
DendaTenorMultiply	int(11)	Yes	1
SuspendMember	bit(1)	Yes	b'0'
WarningLoanDueDay	int(11)	Yes	0
SuspendType	varchar(45)	Yes	Konstan
SuspendTenorJumlah	double	Yes	0
SuspendTenorSatuan	varchar(45)	Yes	Hari
DaySuspend	int(11)	Yes	0
SuspendTenorMultiply	int(11)	Yes	1
DayPerpanjang	int(11)	Yes	0
CountPerpanjang	int(11)	Yes	0
IsBerisiArtikel	bit(1)	Yes	b'0'

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	ID	16	A	No
Name	BTREE	Yes	No	Name	16	A	No
Format_id	BTREE	No	No	Format_id	2	A	No
worksheets_createby	BTREE	No	No	CreateBy	4	A	Yes
worksheets_updateby	BTREE	No	No	UpdateBy	4	A	Yes