Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ID (Primary) | int(11) | No | ||||
ActivationCode | varchar(255) | No | ||||
PerpustakaanName | text | Yes | NULL | |||
CreateDate | datetime | No | ||||
CreateTerminal | varchar(100) | No | ||||
Type | varchar(100) | No |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | item_name | 4 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
auth_data_auth_header | BTREE | No | No | Auth_Header_ID | 0 | A | No | |
auth_data_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
auth_data_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
auth_data_IDX1 | BTREE | No | No | Auth_Header_ID | 0 | A | No | |
Tag | 0 | A | No | |||||
auth_data_IDX2 | BTREE | No | No | Tag | 0 | A | No | |
Value | 0 | A | Yes | |||||
auth_data_IDX3 | BTREE | No | No | Tag | 0 | A | No | |
DataItem | 0 | A | Yes | |||||
auth_data_IDX4 | BTREE | No | No | Value | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
auth_header_id | BTREE | Yes | No | Auth_ID | 0 | A | No | |
auth_header_worksheet_id | BTREE | No | No | Worksheet_id | 0 | A | No | |
auth_header_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
auth_header_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
auth_header_authid | BTREE | No | No | Auth_ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | parent | 32 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | name | 0 | A | No | |
auth_rule_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
auth_rule_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
FK_logincheckpoint_locations | BTREE | No | No | Location_ID | 0 | A | Yes | |
checkpoint_locations_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
checkpoint_locations_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
bacaditempat_locations_ip | BTREE | No | No | IP_PC | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | BIBID | 0 | A | No | |
BIBID_UNIQUE | BTREE | Yes | No | BIBID | 0 | A | No | |
bibidavailable_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
bibidavailable_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
memberId | varchar(50) | Yes | NULL | members -> MemberNo | ||
collectionId | double | Yes | NULL | |||
bookingDate | datetime | Yes | NULL | |||
bookingExpired | datetime | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
fk_bookinglogs_memberId_idx | BTREE | No | No | memberId | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
bookmark_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
bookmark_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 | |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
catalogstaging_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
catalogstaging_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
IP_PC | BTREE | Yes | No | IP_PC | 0 | A | No | |
FK_logincheckpoint_locations | BTREE | No | No | Location_ID | 0 | A | Yes | |
checkpoint_locations_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
checkpoint_locations_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | DataID | 0 | A | No | |
collectioncategorysloanhari_category_id | BTREE | No | No | Category_id | 0 | A | Yes | |
collectioncategorysloanhari_peminjaman_hari_id | BTREE | No | No | Peminjaman_hari_id | 0 | A | Yes | |
collectioncategorysloanhari_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
collectioncategorysloanhari_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
collectionloanextends_colloan_idx | BTREE | No | No | CollectionLoan_id | 0 | A | No | |
collectionloanextends_colloanitem_idx | BTREE | No | No | CollectionLoanItem_id | 0 | A | No | |
collectionloanextends_col_idx | BTREE | No | No | Collection_id | 0 | A | No | |
collectionloanextends_member_idx | BTREE | No | No | Member_id | 0 | A | No | |
collectionloanextends_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
collectionloanextends_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 | |
member_id | 5 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
collectionlocations_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
collectionlocations_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
CollectionRules_id | BTREE | No | No | CollectionRules_id | 0 | A | No | |
collectionrulesitems_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
collectionrulesitems_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
Col_id | BTREE | No | No | Col_id | 0 | A | No | |
LocLib_id | BTREE | No | No | LocLib_id | 0 | A | No | |
colloclib_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
colloclib_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Start | text | No | ||||
Info | text | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id_group | 0 | A | No | |
deposit_group_ws_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
deposit_group_ws_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ID (Primary) | int(11) | No | ||||
Name | varchar(111) | Yes | NULL | |||
CreateBy | int(11) | Yes | NULL | users -> ID | ||
CreateDate | datetime | Yes | NULL |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
deposit_kode_wilayah_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
deposit_kode_wilayah_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 | |||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
(id_group)group-ws | BTREE | No | No | id_group_deposit_group_ws | 0 | A | Yes | |
(ID)deposit_kode_wilayah | BTREE | No | No | ID_deposit_kode_wilayah | 0 | A | Yes | |
(ID)deposit_kelompok_penerbit | BTREE | No | No | id_deposit_kelompok_penerbit_ws | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
djkn_data_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
djkn_data_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes | |
djkn_data_collection_idx | BTREE | No | No | Collection_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
id (Primary) | double | No | ||||
Catalog_Id | double | Yes | NULL | catalogs -> ID | ||
Member_Id | varchar(50) | Yes | NULL | members -> MemberNo | ||
Createdate | datetime | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
FK_Catalog | BTREE | No | No | Catalog_Id | 0 | A | Yes | |
FK_members | BTREE | No | No | Member_Id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Field_id | 282 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Field_id | 299 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Field_id | 244 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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' |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 138 | A | No | |
UQ_Tag | BTREE | Yes | No | Tag | 138 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Version | int(11) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
historydata_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
historydata_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
historydata_IDX1 | BTREE | No | No | TableName | 0 | A | No | |
IDRef | 0 | A | No | |||||
Action | 0 | A | No | |||||
historydata_IDX2 | BTREE | No | No | TableName | 0 | A | No | |
Action | 0 | A | No | |||||
CreateBy | 0 | A | Yes | |||||
CreateDate | 0 | A | Yes | |||||
historydata_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
historydata_member_idx | BTREE | No | No | Member_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
periode | varchar(6) | Yes | NULL | |||
bulan | int(2) | Yes | NULL | |||
tahun | int(4) | Yes | NULL | |||
jumlah_eksemplar | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
kelompok_pelanggaran_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
kelompok_pelanggaran_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
keranjang_anggota_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
keranjang_anggota_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
keranjang_anggota_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
keranjang_anggota_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes | |
keranjang_anggota_member_idx | BTREE | No | No | Member_id | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
keranjang_katalog_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
keranjang_katalog_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
keranjang_katalog_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
keranjang_katalog_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes | |
keranjang_katalog_catalog_idx | BTREE | No | No | Catalog_id | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
keranjang_koleksi_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
keranjang_koleksi_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
keranjang_koleksi_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
keranjang_koleksi_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes | |
keranjang_koleksi_collection_idx | BTREE | No | No | Collection_id | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
kriteria_koleksi_idx1 | BTREE | No | No | catalog_id | 0 | A | Yes | |
kriteria_koleksi_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
kriteria_koleksi_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
(ID)deposit_ws | BTREE | No | No | PUBLISHER_ID | 0 | A | Yes | |
letter_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
letter_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
(ID)letter | BTREE | No | No | LETTER_ID | 0 | A | Yes | |
(ID)collectiomedias | BTREE | No | No | SUB_TYPE_COLLECTION | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
fk_lockers_master_loker_idx | BTREE | No | No | loker_id | 0 | A | Yes | |
lockers_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
lockers_jenisidentitas_idx | BTREE | No | No | id_jamin_idt | 0 | A | Yes | |
lockers_jenisjaminan | BTREE | No | No | jenis_jaminan | 0 | A | Yes | |
lockers_noidentitas | BTREE | No | No | no_identitas | 0 | A | Yes | |
lockers_nopinjama | BTREE | No | No | No_pinjaman | 0 | A | No | |
lockers_pelanggaran_idx | BTREE | No | No | id_pelanggaran_locker | 0 | A | Yes | |
lockers_tglkembali | BTREE | No | No | tanggal_kembali | 0 | A | Yes | |
lockers_tglpinjam | BTREE | No | No | tanggal_pinjam | 0 | A | Yes | |
lockers_uangjaminan_idx | BTREE | No | No | id_jamin_uang | 0 | A | Yes | |
lockers_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
fk_logsDownload_u_idx | BTREE | No | No | User_id | 0 | A | Yes | |
fk_logsDownload_articlefiles_idx | BTREE | No | No | articlefilesID | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
mailserver_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
mailserver_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
masa_berlaku_anggota_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
masa_berlaku_anggota_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
masa_berlaku_anggota_kii | BTREE | No | No | KIILastUploadDate | 0 | A | Yes | |
masa_berlaku_anggota_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
masa_berlaku_anggota_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
tahun | year(4) | Yes | NULL | |||
value | int(111) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
master_djkn_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
master_djkn_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes | |
master_djkn_option | BTREE | No | No | Option_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
unique | BTREE | Yes | No | no_edisi_serial | 0 | A | Yes | |
edisiSerial_catalog | BTREE | No | No | Catalog_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
master_fakultas_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
master_fakultas_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
master_fakultas_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
master_fakultas_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes | |
master_fakultas_kii | BTREE | No | No | KIILastUploadDate | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 7 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
masjer_jenjang_pendidikan_create_by | BTREE | No | No | CreateBy | 0 | A | Yes | |
masjer_jenjang_pendidikan_create_date | BTREE | No | No | CreateDate | 0 | A | Yes | |
masjer_jenjang_pendidikan_update_by | BTREE | No | No | UpdateBy | 0 | A | Yes | |
masjer_jenjang_pendidikan_update_date | BTREE | No | No | UpdateDate | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
master_jurusan_fakultas | BTREE | No | No | id_fakultas | 0 | A | Yes | |
master_jurusan_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
master_jurusan_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
master_jurusan_kii | BTREE | No | No | KIILastUploadDate | 0 | A | Yes | |
master_jurusan_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
master_jurusan_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 3 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
master_program_studi_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
master_program_studi_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
master_program_studi_kii | BTREE | No | No | KIILastUploadDate | 0 | A | Yes | |
master_program_studi_jurusan_idx | BTREE | No | No | id_jurusan | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
member_perpanjangan_member | BTREE | No | No | Member_id | 0 | A | Yes | |
member_perpanjangan_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
member_perpanjangan_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
member_perpanjangan_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
member_perpanjangan_tanggal | BTREE | No | No | Tanggal | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 | |||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ID (Primary) | int(9) | No | ||||
NoAnggota | varchar(50) | Yes | NULL | |||
NickName | varchar(100) | Yes | NULL | |||
Password | varchar(100) | Yes | NULL | |||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | version | 0 | A | No | |
migration_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
migration_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 1396637 | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | hit_id | 285 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 1853019 | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Id (Primary) | int(11) | No | ||||
OpaclogsId | int(11) | No | opaclogs -> ID | |||
Field | varchar(20) | Yes | NULL | |||
Keyword | text | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id | 4120435 | A | No | |
opaclogs_keyword_field_idx | BTREE | No | No | Field | 16 | A | Yes | |
opaclogs_keyword_opaclogsid_idx | BTREE | No | No | OpaclogsId | 4120435 | A | No | |
opaclogs_keyword_keyword_idx | BTREE | No | No | Keyword (240) | 4019 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 5 | A | No | |
outbox_date | BTREE | No | No | SendingDateTime | 2 | A | No | |
SendingTimeOut | 2 | A | Yes | |||||
outbox_sender | BTREE | No | No | SenderID | 5 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | A | No | ||
SequencePosition | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
ID (Primary) | int(11) | No | ||||
GroupID | int(11) | No | -1 | |||
Name | text | No | ||||
Number | text | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Name | text | No | ||||
ID (Primary) | int(11) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
Pelanggaran_JumlahDenda | BTREE | No | No | JumlahDenda | 0 | A | Yes | |
pelanggaran_cli | BTREE | No | No | CollectionLoanItem_id | 0 | A | Yes | |
Pelanggaran_JenisPelanggaran | BTREE | No | No | JenisPelanggaran_id | 0 | A | Yes | |
Pelanggaran_JenisDenda | BTREE | No | No | JenisDenda_id | 0 | A | Yes | |
pelanggaran_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
pelanggaran_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
pelanggaran_collectionloan | BTREE | No | No | CollectionLoan_id | 0 | A | Yes | |
pelanggaran_member | BTREE | No | No | Member_id | 0 | A | Yes | |
pelanggaran_collection | BTREE | No | No | Collection_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
pengiriman_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
pengiriman_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
pengirimankoleksi_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
pengirimankoleksi_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
pengiriman_cetak_id | BTREE | No | No | PengirimanID | 0 | A | Yes | |
pengirimankoleksi_collectionid | BTREE | No | No | Collection_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
pp_hari_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
pp_hari_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
pp_hari_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
pp_hari_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
pp_tanggal_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
pp_tanggal_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
pp_tanggal_createdate | BTREE | No | No | CreateDate | 0 | A | Yes | |
pp_tanggal_updatedate | BTREE | No | No | UpdateDate | 0 | A | Yes | |
pp_tanggalawal | BTREE | No | No | TanggalAwal | 0 | A | Yes | |
pp_tanggalakhir | BTREE | No | No | TanggalAkhir | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | IMEI | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
publishers_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
publishers_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
quarantined_auth_data_auth_header | BTREE | No | No | Auth_Header_ID | 0 | A | No | |
quarantined_auth_data_ID | BTREE | No | No | ID | 0 | A | No | |
quarantined_auth_data_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
quarantined_auth_data_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
quarantined_auth_header_ID | BTREE | No | No | ID | 0 | A | No | |
quarantined_auth_header_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
quarantined_auth_header_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
quarantined_pengiriman_ID | BTREE | No | No | ID | 0 | A | No | |
quarantined_pengiriman_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
quarantined_pengiriman_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
readinlocation_location | BTREE | No | No | LocationId | 0 | A | No | |
readinlocation_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
readinlocation_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
requestcatalog_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
requestcatalog_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
requestcatalog_daterequest | BTREE | No | No | DateRequest | 0 | A | Yes | |
requestcatalog_member_idx | BTREE | No | No | MemberID | 0 | A | Yes | |
requestcatalog_Title | BTREE | No | No | Title | 0 | A | No | |
requestcatalog_PublishLocation | BTREE | No | No | PublishLocation | 0 | A | Yes | |
requestcatalog_PublishYear | BTREE | No | No | PublishYear | 0 | A | Yes | |
requestcatalog_Publisher | BTREE | No | No | Publisher | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
rfid_temp_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
rfid_temp_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
rfid_temp_ip | BTREE | No | No | ip | 0 | A | Yes | |
rfid_temp_rfidno | BTREE | No | No | rfid_no | 0 | A | Yes | |
rfid_temp_statusalarm | BTREE | No | No | status_alarm | 0 | A | Yes | |
rfid_temp_serialnumber | BTREE | No | No | serial_number | 0 | A | Yes | |
rfid_temp_itemtype | BTREE | No | No | item_type | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Role_id | 22 | A | 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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
name (Primary) | varchar(64) | No | ||||
alias | varchar(64) | No | ||||
type | varchar(64) | No | ||||
status | smallint(6) | No | 1 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | name | 100 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
SequencePosition | 0 | A | No | |||||
sentitems_date | BTREE | No | No | DeliveryDateTime | 0 | A | Yes | |
sentitems_tpmr | BTREE | No | No | TPMR | 0 | A | No | |
sentitems_dest | BTREE | No | No | DestinationNumber | 0 | A | No | |
sentitems_sender | BTREE | No | No | SenderID | 0 | A | No | |
sentitems_cli_idx | BTREE | No | No | CollectionLoanItem_id | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_title | BTREE | No | No | Title | 0 | A | No | |
articles_catalog | BTREE | No | No | Catalog_id | 0 | A | Yes | |
articles_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
articles_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
SERIAL_ARTICLE_ID | BTREE | No | No | serial_article_ID | 0 | A | No | |
CREATE_USER | BTREE | No | No | CreateBy | 0 | A | Yes | |
UPDATE_USER | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
id (Primary) | char(40) | No | ||||
expire | int(11) | Yes | NULL | |||
data | blob | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 307 | A | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
stockopname_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
stockopname_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
stockopnamedetail_stockopname | BTREE | No | No | StockOpnameID | 0 | A | No | |
stockopnamedetail_collection | BTREE | No | No | CollectionID | 0 | A | No | |
stockopnamedetail_location1 | BTREE | No | No | PrevLocationID | 0 | A | Yes | |
stockopnamedetail_location2 | BTREE | No | No | CurrentLocationID | 0 | A | Yes | |
stockopnamedetail_collectionrule1 | BTREE | No | No | PrevCollectionRuleID | 0 | A | Yes | |
stockopnamedetail_collectionrule2 | BTREE | No | No | CurrentCollectionRuleID | 0 | A | Yes | |
stockopnamedetail_colstatus1 | BTREE | No | No | PrevStatusID | 0 | A | Yes | |
stockopnamedetail_colstatus2 | BTREE | No | No | CurrentStatusID | 0 | A | Yes | |
stockopnamedetail_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
stockopnamedetail_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
sumbangan_member | BTREE | No | No | Member_id | 0 | A | Yes | |
sumbangan_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
sumbangan_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes | |
sumbangan_createdate | BTREE | No | No | CreateDate | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
sumbangan_koleksi_collection_idx | BTREE | No | No | Collection_id | 0 | A | Yes | |
sumbangan_koleksi_sumbangan_idx | BTREE | No | No | Sumbangan_id | 0 | A | Yes | |
sumbangan_koleksi_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
sumbangan_koleksi_updateby | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
survey_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
survey_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
survey_isian_pertanyaan_idx | BTREE | No | No | Survey_Pertanyaan_id | 0 | A | Yes | |
survey_isian_sesi | BTREE | No | No | Sesi | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
survey_pertanyaan_survey_idx | BTREE | No | No | Survey_id | 0 | A | Yes | |
survey_pertanyaan_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
survey_pertanyaan_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes | |
survey_pertanyaan_nourut | BTREE | No | No | NoUrut | 0 | A | Yes | |
survey_pertanyaan_jenis | BTREE | No | No | JenisPertanyaan | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
survey_pilihan_survey_pertanyaan_idx | BTREE | No | No | Survey_Pertanyaan_id | 0 | A | Yes | |
survey_pilihan_createby_idx | BTREE | No | No | CreateBy | 0 | A | Yes | |
survey_pilihan_updateby_idx | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
survey_pilihan_sesi_pilihan_idx | BTREE | No | No | Survey_Pilihan_id | 0 | A | Yes | |
survey_pilihan_sesi | BTREE | No | No | Sesi | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 | |||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
username | BTREE | Yes | No | username | 0 | A | No | |
BTREE | Yes | No | 0 | A | No | |||
password_reset_token | BTREE | Yes | No | password_reset_token | 0 | A | Yes | |
user_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
user | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
User_id | BTREE | No | No | User_id | 0 | A | No | |
userlogs_createby | BTREE | No | No | CreateBy | 0 | A | Yes | |
userlogs | BTREE | No | No | UpdateBy | 0 | A | Yes |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
A | varchar(1) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
kriteria | varchar(14) | No | ||||
id_dtl_anggota | varchar(255) | No | ||||
dtl_anggota | varchar(255) | No |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
kriteria | varchar(19) | No | ||||
id_dtl_kriteria | text | Yes | NULL | |||
dtl_kriteria | text | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
kriteria | varchar(10) | No | ||||
tahun | bigint(20) | Yes | NULL | |||
jumlah | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
kriteria | varchar(10) | No | ||||
tahun | bigint(20) | Yes | NULL | |||
bulan | bigint(20) | Yes | NULL | |||
jumlah | decimal(32,0) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
tahun | int(4) | No | 0 | |||
bulan | int(1) | No | 0 | |||
jumlah_judul | int(2) | No | 0 | |||
jumlah_eksemplar | int(3) | No | 0 | |||
jumlah_dijital | int(2) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Keterangan | varchar(50) | No | ||||
Jumlah | bigint(21) | No | 0 | |||
Tahun | varchar(4) | Yes | NULL | |||
bulan | int(2) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Keterangan | varchar(255) | No | ||||
Jumlah | int(11) | No | 0 | |||
Tahun | int(4) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
tahun | int(4) | Yes | NULL | |||
bulan | int(2) | Yes | NULL | |||
jumlah_eksemplar | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
tahun | int(4) | Yes | NULL | |||
bulan | int(2) | Yes | NULL | |||
jumlah_judul | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Nama | varchar(50) | No | ||||
Jumlah | int(11) | No | 0 | |||
Tahun | int(4) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Keterangan | varchar(200) | Yes | NULL | |||
Tahun | varchar(4) | Yes | NULL | |||
Jumlah | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
Keterangan | varchar(200) | Yes | NULL | |||
Tahun | varchar(4) | Yes | NULL | |||
bulan | int(2) | Yes | NULL | |||
Jumlah | bigint(21) | No | 0 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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' |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
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' |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |