Letakkan berkas disini

SQL upload ( 0 ) x-

Server: 127.0.0.1:3309 »Basis data: inlislite_v3
Page-related settingsKlik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueriPress Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Count: Time taken:
Bookmark
Segarkan
Tambah
Tidak ada bookmark
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data: Waktu eksekusi kueri:
1
inlislite_v3
{"j_tabs":{"inlislite_v3.agama":1,"inlislite_v3.applications":1,"inlislite_v3.app_installed":1,"inlislite_v3.auth_assignment":1,"inlislite_v3.auth_data":1,"inlislite_v3.auth_header":1,"inlislite_v3.auth_item":1,"inlislite_v3.auth_item_child":1,"inlislite_v3.auth_rule":1,"inlislite_v3.bacaditempat":1,"inlislite_v3.bacaditempat_locations":1,"inlislite_v3.backup":1,"inlislite_v3.bibidavailable":1,"inlislite_v3.bookinglogs":1,"inlislite_v3.bookmark":1,"inlislite_v3.branchs":1,"inlislite_v3.cardformats":1,"inlislite_v3.catalogfiles":1,"inlislite_v3.catalogs":1,"inlislite_v3.catalogstaging":1,"inlislite_v3.catalog_ruas":1,"inlislite_v3.catalog_subruas":1,"inlislite_v3.checkpoint_locations":1,"inlislite_v3.collectioncategorys":1,"inlislite_v3.collectioncategorysdefault":1,"inlislite_v3.collectioncategorysloanhari":1,"inlislite_v3.collectionloanextends":1,"inlislite_v3.collectionloanitems":1,"inlislite_v3.collectionloans":1,"inlislite_v3.collectionlocations":1,"inlislite_v3.collectionmedias":1,"inlislite_v3.collectionrules":1,"inlislite_v3.collectionrulesitems":1,"inlislite_v3.collections":1,"inlislite_v3.collectionsources":1,"inlislite_v3.collectionstatus":1,"inlislite_v3.colloclib":1,"inlislite_v3.currency":1,"inlislite_v3.daemons":0,"inlislite_v3.departments":1,"inlislite_v3.deposit_group_ws":1,"inlislite_v3.deposit_kelompok_penerbit":1,"inlislite_v3.deposit_kode_wilayah":1,"inlislite_v3.deposit_taksiran_harga":1,"inlislite_v3.deposit_ws":1,"inlislite_v3.djkn_data":1,"inlislite_v3.favorite":1,"inlislite_v3.fielddatas":1,"inlislite_v3.fieldgroups":1,"inlislite_v3.fieldindicator1s":1,"inlislite_v3.fieldindicator2s":1,"inlislite_v3.fields":1,"inlislite_v3.formats":1,"inlislite_v3.gammu":0,"inlislite_v3.groupguesses":1,"inlislite_v3.historydata":1,"inlislite_v3.holidays":1,"inlislite_v3.inbox":0,"inlislite_v3.item_koleksi":0,"inlislite_v3.jenis_anggota":1,"inlislite_v3.jenis_denda":1,"inlislite_v3.jenis_kelamin":1,"inlislite_v3.jenis_pelanggaran":1,"inlislite_v3.jenis_permohonan":1,"inlislite_v3.jenis_perpustakaan":1,"inlislite_v3.judul_koleksi":1,"inlislite_v3.kabupaten":1,"inlislite_v3.kata_sandang":1,"inlislite_v3.kelas_siswa":1,"inlislite_v3.kelompok_pelanggaran":1,"inlislite_v3.keranjang_anggota":1,"inlislite_v3.keranjang_katalog":1,"inlislite_v3.keranjang_koleksi":1,"inlislite_v3.kriteria_koleksi":1,"inlislite_v3.letter":1,"inlislite_v3.letter_detail":1,"inlislite_v3.library":1,"inlislite_v3.librarysearchcriteria":1,"inlislite_v3.locations":1,"inlislite_v3.location_library":1,"inlislite_v3.location_library_default":1,"inlislite_v3.lockers":1,"inlislite_v3.logsdownload":1,"inlislite_v3.logsdownload_article":1,"inlislite_v3.mailserver":1,"inlislite_v3.masa_berlaku_anggota":1,"inlislite_v3.master_counter_barcode":1,"inlislite_v3.master_djkn":1,"inlislite_v3.master_edisi_serial":1,"inlislite_v3.master_fakultas":1,"inlislite_v3.master_jam_buka":1,"inlislite_v3.master_jenis_identitas":1,"inlislite_v3.master_jenjang_pendidikan":1,"inlislite_v3.master_jurusan":1,"inlislite_v3.master_kelas_besar":1,"inlislite_v3.master_kependudukan":1,"inlislite_v3.master_loker":1,"inlislite_v3.master_pekerjaan":1,"inlislite_v3.master_pelanggaran_locker":1,"inlislite_v3.master_pendidikan":1,"inlislite_v3.master_program_studi":1,"inlislite_v3.master_range_umur":1,"inlislite_v3.master_status_perkawinan":1,"inlislite_v3.master_uang_jaminan":1,"inlislite_v3.memberguesses":1,"inlislite_v3.memberloanauthorizecategory":1,"inlislite_v3.memberloanauthorizelocation":1,"inlislite_v3.memberrules":1,"inlislite_v3.members":1,"inlislite_v3.membersonline":1,"inlislite_v3.members_form":1,"inlislite_v3.members_form_list":1,"inlislite_v3.members_info_form":1,"inlislite_v3.members_loanreturn_form":1,"inlislite_v3.members_loan_form":1,"inlislite_v3.members_online_form":1,"inlislite_v3.members_online_form_edit":1,"inlislite_v3.member_fields":1,"inlislite_v3.member_perpanjangan":1,"inlislite_v3.menu":1,"inlislite_v3.migration":1,"inlislite_v3.modelhistory":1,"inlislite_v3.modules":1,"inlislite_v3.notif_sms_gateway":1,"inlislite_v3.notif_sms_gateway_hist":1,"inlislite_v3.opacfields":1,"inlislite_v3.opaclogs":1,"inlislite_v3.opaclogs_keyword":1,"inlislite_v3.opac_counter":0,"inlislite_v3.outbox":0,"inlislite_v3.outbox_multipart":0,"inlislite_v3.partners":1,"inlislite_v3.pbk":0,"inlislite_v3.pbk_groups":0,"inlislite_v3.pelanggaran":1,"inlislite_v3.penduduk":1,"inlislite_v3.pengiriman":1,"inlislite_v3.pengiriman_koleksi":1,"inlislite_v3.peraturan_peminjaman_hari":1,"inlislite_v3.peraturan_peminjaman_tanggal":1,"inlislite_v3.phones":0,"inlislite_v3.propinsi":1,"inlislite_v3.publishers":1,"inlislite_v3.quarantined_auth_data":1,"inlislite_v3.quarantined_auth_header":1,"inlislite_v3.quarantined_catalogs":1,"inlislite_v3.quarantined_catalog_ruas":1,"inlislite_v3.quarantined_catalog_subruas":1,"inlislite_v3.quarantined_collections":1,"inlislite_v3.quarantined_pengiriman":1,"inlislite_v3.readinlocation":1,"inlislite_v3.refferenceitems":1,"inlislite_v3.refferences":1,"inlislite_v3.requestcatalog":1,"inlislite_v3.rfid_temp":1,"inlislite_v3.rolemodule":1,"inlislite_v3.roles":1,"inlislite_v3.route":1,"inlislite_v3.sentitems":1,"inlislite_v3.serial_articlefiles":1,"inlislite_v3.serial_articles":1,"inlislite_v3.serial_articles_repeatable":1,"inlislite_v3.session":1,"inlislite_v3.settingcatalogdetail":1,"inlislite_v3.settingparameters":1,"inlislite_v3.smslogs":0,"inlislite_v3.status_anggota":1,"inlislite_v3.stockopname":1,"inlislite_v3.stockopnamedetail":1,"inlislite_v3.sumbangan":1,"inlislite_v3.sumbangan_koleksi":1,"inlislite_v3.survey":1,"inlislite_v3.survey_isian":1,"inlislite_v3.survey_pertanyaan":1,"inlislite_v3.survey_pilihan":1,"inlislite_v3.survey_pilihan_sesi":1,"inlislite_v3.tempnoinduk":1,"inlislite_v3.tujuan_kunjungan":1,"inlislite_v3.user":1,"inlislite_v3.userloclibforcol":1,"inlislite_v3.userloclibforloan":1,"inlislite_v3.userlogs":1,"inlislite_v3.users":1,"inlislite_v3.v_abjadopac":0,"inlislite_v3.v_lap_kriteria_anggota":0,"inlislite_v3.v_lap_kriteria_koleksi":0,"inlislite_v3.v_pertumb_jml_kunjungan":0,"inlislite_v3.v_pertumb_jml_kunjungan_bulanan":0,"inlislite_v3.v_stat_anggota":0,"inlislite_v3.v_stat_colectionloan":0,"inlislite_v3.v_stat_jenis_pendidikan":0,"inlislite_v3.v_stat_jumlah_koleksi":0,"inlislite_v3.v_stat_kelas_subjek":0,"inlislite_v3.v_stat_koleksi_dipinjam_eksemplar":0,"inlislite_v3.v_stat_koleksi_dipinjam_judul":0,"inlislite_v3.v_stat_pendidikan":0,"inlislite_v3.v_stat_rangeumur_kunj":0,"inlislite_v3.v_stat_rangeumur_kunj_bulanan":0,"inlislite_v3.worksheetfielditems":1,"inlislite_v3.worksheetfields":1,"inlislite_v3.worksheets":1},"h_tabs":{"inlislite_v3.agama":1,"inlislite_v3.applications":1,"inlislite_v3.app_installed":1,"inlislite_v3.auth_assignment":1,"inlislite_v3.auth_data":1,"inlislite_v3.auth_header":1,"inlislite_v3.auth_item":1,"inlislite_v3.auth_item_child":1,"inlislite_v3.auth_rule":1,"inlislite_v3.bacaditempat":1,"inlislite_v3.bacaditempat_locations":1,"inlislite_v3.backup":1,"inlislite_v3.bibidavailable":1,"inlislite_v3.bookinglogs":1,"inlislite_v3.bookmark":1,"inlislite_v3.branchs":1,"inlislite_v3.cardformats":1,"inlislite_v3.catalogfiles":1,"inlislite_v3.catalogs":1,"inlislite_v3.catalogstaging":1,"inlislite_v3.catalog_ruas":1,"inlislite_v3.catalog_subruas":1,"inlislite_v3.checkpoint_locations":1,"inlislite_v3.collectioncategorys":1,"inlislite_v3.collectioncategorysdefault":1,"inlislite_v3.collectioncategorysloanhari":1,"inlislite_v3.collectionloanextends":1,"inlislite_v3.collectionloanitems":1,"inlislite_v3.collectionloans":1,"inlislite_v3.collectionlocations":1,"inlislite_v3.collectionmedias":1,"inlislite_v3.collectionrules":1,"inlislite_v3.collectionrulesitems":1,"inlislite_v3.collections":1,"inlislite_v3.collectionsources":1,"inlislite_v3.collectionstatus":1,"inlislite_v3.colloclib":1,"inlislite_v3.currency":1,"inlislite_v3.daemons":1,"inlislite_v3.departments":1,"inlislite_v3.deposit_group_ws":1,"inlislite_v3.deposit_kelompok_penerbit":1,"inlislite_v3.deposit_kode_wilayah":1,"inlislite_v3.deposit_taksiran_harga":1,"inlislite_v3.deposit_ws":1,"inlislite_v3.djkn_data":1,"inlislite_v3.favorite":1,"inlislite_v3.fielddatas":1,"inlislite_v3.fieldgroups":1,"inlislite_v3.fieldindicator1s":1,"inlislite_v3.fieldindicator2s":1,"inlislite_v3.fields":1,"inlislite_v3.formats":1,"inlislite_v3.gammu":1,"inlislite_v3.groupguesses":1,"inlislite_v3.historydata":1,"inlislite_v3.holidays":1,"inlislite_v3.inbox":1,"inlislite_v3.item_koleksi":1,"inlislite_v3.jenis_anggota":1,"inlislite_v3.jenis_denda":1,"inlislite_v3.jenis_kelamin":1,"inlislite_v3.jenis_pelanggaran":1,"inlislite_v3.jenis_permohonan":1,"inlislite_v3.jenis_perpustakaan":1,"inlislite_v3.judul_koleksi":1,"inlislite_v3.kabupaten":1,"inlislite_v3.kata_sandang":1,"inlislite_v3.kelas_siswa":1,"inlislite_v3.kelompok_pelanggaran":1,"inlislite_v3.keranjang_anggota":1,"inlislite_v3.keranjang_katalog":1,"inlislite_v3.keranjang_koleksi":1,"inlislite_v3.kriteria_koleksi":1,"inlislite_v3.letter":1,"inlislite_v3.letter_detail":1,"inlislite_v3.library":1,"inlislite_v3.librarysearchcriteria":1,"inlislite_v3.locations":1,"inlislite_v3.location_library":1,"inlislite_v3.location_library_default":1,"inlislite_v3.lockers":1,"inlislite_v3.logsdownload":1,"inlislite_v3.logsdownload_article":1,"inlislite_v3.mailserver":1,"inlislite_v3.masa_berlaku_anggota":1,"inlislite_v3.master_counter_barcode":1,"inlislite_v3.master_djkn":1,"inlislite_v3.master_edisi_serial":1,"inlislite_v3.master_fakultas":1,"inlislite_v3.master_jam_buka":1,"inlislite_v3.master_jenis_identitas":1,"inlislite_v3.master_jenjang_pendidikan":1,"inlislite_v3.master_jurusan":1,"inlislite_v3.master_kelas_besar":1,"inlislite_v3.master_kependudukan":1,"inlislite_v3.master_loker":1,"inlislite_v3.master_pekerjaan":1,"inlislite_v3.master_pelanggaran_locker":1,"inlislite_v3.master_pendidikan":1,"inlislite_v3.master_program_studi":1,"inlislite_v3.master_range_umur":1,"inlislite_v3.master_status_perkawinan":1,"inlislite_v3.master_uang_jaminan":1,"inlislite_v3.memberguesses":1,"inlislite_v3.memberloanauthorizecategory":1,"inlislite_v3.memberloanauthorizelocation":1,"inlislite_v3.memberrules":1,"inlislite_v3.members":1,"inlislite_v3.membersonline":1,"inlislite_v3.members_form":1,"inlislite_v3.members_form_list":1,"inlislite_v3.members_info_form":1,"inlislite_v3.members_loanreturn_form":1,"inlislite_v3.members_loan_form":1,"inlislite_v3.members_online_form":1,"inlislite_v3.members_online_form_edit":1,"inlislite_v3.member_fields":1,"inlislite_v3.member_perpanjangan":1,"inlislite_v3.menu":1,"inlislite_v3.migration":1,"inlislite_v3.modelhistory":1,"inlislite_v3.modules":1,"inlislite_v3.notif_sms_gateway":1,"inlislite_v3.notif_sms_gateway_hist":1,"inlislite_v3.opacfields":1,"inlislite_v3.opaclogs":1,"inlislite_v3.opaclogs_keyword":1,"inlislite_v3.opac_counter":1,"inlislite_v3.outbox":1,"inlislite_v3.outbox_multipart":1,"inlislite_v3.partners":1,"inlislite_v3.pbk":1,"inlislite_v3.pbk_groups":1,"inlislite_v3.pelanggaran":1,"inlislite_v3.penduduk":1,"inlislite_v3.pengiriman":1,"inlislite_v3.pengiriman_koleksi":1,"inlislite_v3.peraturan_peminjaman_hari":1,"inlislite_v3.peraturan_peminjaman_tanggal":1,"inlislite_v3.phones":1,"inlislite_v3.propinsi":1,"inlislite_v3.publishers":1,"inlislite_v3.quarantined_auth_data":1,"inlislite_v3.quarantined_auth_header":1,"inlislite_v3.quarantined_catalogs":1,"inlislite_v3.quarantined_catalog_ruas":1,"inlislite_v3.quarantined_catalog_subruas":1,"inlislite_v3.quarantined_collections":1,"inlislite_v3.quarantined_pengiriman":1,"inlislite_v3.readinlocation":1,"inlislite_v3.refferenceitems":1,"inlislite_v3.refferences":1,"inlislite_v3.requestcatalog":1,"inlislite_v3.rfid_temp":1,"inlislite_v3.rolemodule":1,"inlislite_v3.roles":1,"inlislite_v3.route":1,"inlislite_v3.sentitems":1,"inlislite_v3.serial_articlefiles":1,"inlislite_v3.serial_articles":1,"inlislite_v3.serial_articles_repeatable":1,"inlislite_v3.session":1,"inlislite_v3.settingcatalogdetail":1,"inlislite_v3.settingparameters":1,"inlislite_v3.smslogs":1,"inlislite_v3.status_anggota":1,"inlislite_v3.stockopname":1,"inlislite_v3.stockopnamedetail":1,"inlislite_v3.sumbangan":1,"inlislite_v3.sumbangan_koleksi":1,"inlislite_v3.survey":1,"inlislite_v3.survey_isian":1,"inlislite_v3.survey_pertanyaan":1,"inlislite_v3.survey_pilihan":1,"inlislite_v3.survey_pilihan_sesi":1,"inlislite_v3.tempnoinduk":1,"inlislite_v3.tujuan_kunjungan":1,"inlislite_v3.user":1,"inlislite_v3.userloclibforcol":1,"inlislite_v3.userloclibforloan":1,"inlislite_v3.userlogs":1,"inlislite_v3.users":1,"inlislite_v3.v_abjadopac":1,"inlislite_v3.v_lap_kriteria_anggota":1,"inlislite_v3.v_lap_kriteria_koleksi":1,"inlislite_v3.v_pertumb_jml_kunjungan":1,"inlislite_v3.v_pertumb_jml_kunjungan_bulanan":1,"inlislite_v3.v_stat_anggota":1,"inlislite_v3.v_stat_colectionloan":1,"inlislite_v3.v_stat_jenis_pendidikan":1,"inlislite_v3.v_stat_jumlah_koleksi":1,"inlislite_v3.v_stat_kelas_subjek":1,"inlislite_v3.v_stat_koleksi_dipinjam_eksemplar":1,"inlislite_v3.v_stat_koleksi_dipinjam_judul":1,"inlislite_v3.v_stat_pendidikan":1,"inlislite_v3.v_stat_rangeumur_kunj":1,"inlislite_v3.v_stat_rangeumur_kunj_bulanan":1,"inlislite_v3.worksheetfielditems":1,"inlislite_v3.worksheetfields":1,"inlislite_v3.worksheets":1}}
[{"":{"inlislite_v3.agama":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.agama":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.applications":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.applications":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_assignment":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_assignment":{"item_name":["inlislite_v3.auth_item","name"]}}},{"":{"inlislite_v3.auth_assignment":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_data":{"Auth_Header_ID":["inlislite_v3.auth_header","ID"]}}},{"":{"inlislite_v3.auth_data":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_data":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_header":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_header":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_header":{"Worksheet_id":["inlislite_v3.worksheets","ID"]}}},{"":{"inlislite_v3.auth_item":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_item":{"rule_name":["inlislite_v3.auth_rule","name"]}}},{"":{"inlislite_v3.auth_item":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_item_child":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_item_child":{"parent":["inlislite_v3.auth_item","name"]}}},{"":{"inlislite_v3.auth_item_child":{"child":["inlislite_v3.auth_item","name"]}}},{"":{"inlislite_v3.auth_item_child":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_rule":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.auth_rule":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.bacaditempat":{"collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.bacaditempat":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.bacaditempat":{"Location_Id":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.bacaditempat":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.bibidavailable":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.bibidavailable":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.bookinglogs":{"memberId":["inlislite_v3.members","MemberNo"]}}},{"":{"inlislite_v3.bookmark":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.bookmark":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.branchs":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.branchs":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.cardformats":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.cardformats":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalog_ruas":{"CatalogId":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.catalog_ruas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalog_ruas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalog_subruas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalog_subruas":{"RuasID":["inlislite_v3.catalog_ruas","ID"]}}},{"":{"inlislite_v3.catalog_subruas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogfiles":{"Catalog_id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.catalogfiles":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogfiles":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.catalogfiles":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogs":{"Branch_id":["inlislite_v3.branchs","ID"]}}},{"":{"inlislite_v3.catalogs":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogs":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.catalogs":{"QUARANTINEDBY":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogs":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogs":{"Worksheet_id":["inlislite_v3.worksheets","ID"]}}},{"":{"inlislite_v3.catalogstaging":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.catalogstaging":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.checkpoint_locations":{"Location_ID":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.checkpoint_locations":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.checkpoint_locations":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectioncategorys":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectioncategorys":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectioncategorysdefault":{"CollectionCategory_id":["inlislite_v3.collectioncategorys","ID"]}}},{"":{"inlislite_v3.collectioncategorysdefault":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectioncategorysdefault":{"JenisAnggota_id":["inlislite_v3.jenis_anggota","id"]}}},{"":{"inlislite_v3.collectioncategorysdefault":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectioncategorysloanhari":{"Category_id":["inlislite_v3.collectioncategorys","ID"]}}},{"":{"inlislite_v3.collectioncategorysloanhari":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectioncategorysloanhari":{"Peminjaman_hari_id":["inlislite_v3.peraturan_peminjaman_hari","ID"]}}},{"":{"inlislite_v3.collectioncategorysloanhari":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionloanextends":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.collectionloanextends":{"CollectionLoan_id":["inlislite_v3.collectionloans","ID"]}}},{"":{"inlislite_v3.collectionloanextends":{"CollectionLoanItem_id":["inlislite_v3.collectionloanitems","ID"]}}},{"":{"inlislite_v3.collectionloanextends":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionloanextends":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.collectionloanextends":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionloanitems":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.collectionloanitems":{"CollectionLoan_id":["inlislite_v3.collectionloans","ID"]}}},{"":{"inlislite_v3.collectionloanitems":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionloanitems":{"member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.collectionloanitems":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionloans":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.collectionloans":{"Branch_id":["inlislite_v3.branchs","ID"]}}},{"":{"inlislite_v3.collectionloans":{"LocationLibrary_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.collectionloans":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionloans":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionlocations":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionlocations":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionmedias":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionmedias":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionmedias":{"Worksheet_id":["inlislite_v3.worksheets","ID"]}}},{"":{"inlislite_v3.collectionrules":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionrules":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionrulesitems":{"CollectionRules_id":["inlislite_v3.collectionrules","ID"]}}},{"":{"inlislite_v3.collectionrulesitems":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionrulesitems":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collections":{"deposit_kode_wilayah_ID":["inlislite_v3.deposit_kode_wilayah","ID"]}}},{"":{"inlislite_v3.collections":{"Branch_id":["inlislite_v3.branchs","ID"]}}},{"":{"inlislite_v3.collections":{"Catalog_id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.collections":{"Category_id":["inlislite_v3.collectioncategorys","ID"]}}},{"":{"inlislite_v3.collections":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collections":{"Currency":["inlislite_v3.currency","Currency"]}}},{"":{"inlislite_v3.collections":{"deposit_ws_ID":["inlislite_v3.deposit_ws","ID"]}}},{"":{"inlislite_v3.collections":{"JILIDCREATEBY":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collections":{"Location_id":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.collections":{"Location_Library_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.collections":{"Media_id":["inlislite_v3.collectionmedias","ID"]}}},{"":{"inlislite_v3.collections":{"Partner_id":["inlislite_v3.partners","ID"]}}},{"":{"inlislite_v3.collections":{"QUARANTINEDBY":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collections":{"Rule_id":["inlislite_v3.collectionrules","ID"]}}},{"":{"inlislite_v3.collections":{"Source_id":["inlislite_v3.collectionsources","ID"]}}},{"":{"inlislite_v3.collections":{"Status_id":["inlislite_v3.collectionstatus","ID"]}}},{"":{"inlislite_v3.collections":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionsources":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionsources":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionstatus":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.collectionstatus":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.colloclib":{"Col_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.colloclib":{"LocLib_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.colloclib":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.colloclib":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.currency":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.currency":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.departments":{"ParentID":["inlislite_v3.departments","ID"]}}},{"":{"inlislite_v3.departments":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.departments":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.deposit_group_ws":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.deposit_group_ws":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.deposit_kelompok_penerbit":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.deposit_kode_wilayah":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.deposit_kode_wilayah":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.deposit_taksiran_harga":{"ID_collections":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.deposit_ws":{"id_deposit_kelompok_penerbit_ws":["inlislite_v3.deposit_kelompok_penerbit","ID"]}}},{"":{"inlislite_v3.deposit_ws":{"ID_deposit_kode_wilayah":["inlislite_v3.deposit_kode_wilayah","ID"]}}},{"":{"inlislite_v3.deposit_ws":{"id_group_deposit_group_ws":["inlislite_v3.deposit_group_ws","id_group"]}}},{"":{"inlislite_v3.djkn_data":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.djkn_data":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.djkn_data":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.favorite":{"Catalog_Id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.favorite":{"Member_Id":["inlislite_v3.members","MemberNo"]}}},{"":{"inlislite_v3.fielddatas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fielddatas":{"Field_id":["inlislite_v3.fields","ID"]}}},{"":{"inlislite_v3.fielddatas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fieldgroups":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fieldgroups":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fieldindicator1s":{"Field_id":["inlislite_v3.fields","ID"]}}},{"":{"inlislite_v3.fieldindicator1s":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fieldindicator1s":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fieldindicator2s":{"Field_id":["inlislite_v3.fields","ID"]}}},{"":{"inlislite_v3.fieldindicator2s":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fieldindicator2s":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fields":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.fields":{"Group_id":["inlislite_v3.fieldgroups","ID"]}}},{"":{"inlislite_v3.fields":{"Format_id":["inlislite_v3.formats","ID"]}}},{"":{"inlislite_v3.fields":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.formats":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.formats":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.groupguesses":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.groupguesses":{"Location_ID":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.groupguesses":{"LocationLoans_ID":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.groupguesses":{"TujuanKunjungan_ID":["inlislite_v3.tujuan_kunjungan","ID"]}}},{"":{"inlislite_v3.groupguesses":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.historydata":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.historydata":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.historydata":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.holidays":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.holidays":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_anggota":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_anggota":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_denda":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_denda":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_kelamin":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_kelamin":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_pelanggaran":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_pelanggaran":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_permohonan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_permohonan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_perpustakaan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.jenis_perpustakaan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.judul_koleksi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.judul_koleksi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kabupaten":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kabupaten":{"PropinsiID":["inlislite_v3.propinsi","ID"]}}},{"":{"inlislite_v3.kabupaten":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kata_sandang":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kata_sandang":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kelas_siswa":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kelas_siswa":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kelompok_pelanggaran":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kelompok_pelanggaran":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.keranjang_anggota":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.keranjang_anggota":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.keranjang_anggota":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.keranjang_katalog":{"Catalog_id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.keranjang_katalog":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.keranjang_katalog":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.keranjang_koleksi":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.keranjang_koleksi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.keranjang_koleksi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kriteria_koleksi":{"catalog_id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.kriteria_koleksi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.kriteria_koleksi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.letter":{"PUBLISHER_ID":["inlislite_v3.deposit_ws","ID"]}}},{"":{"inlislite_v3.letter":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.letter":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.letter_detail":{"SUB_TYPE_COLLECTION":["inlislite_v3.collectionmedias","ID"]}}},{"":{"inlislite_v3.letter_detail":{"LETTER_ID":["inlislite_v3.letter","ID"]}}},{"":{"inlislite_v3.library":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.library":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.librarysearchcriteria":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.librarysearchcriteria":{"LIBRARYID":["inlislite_v3.library","ID"]}}},{"":{"inlislite_v3.librarysearchcriteria":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.location_library":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.location_library":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.location_library_default":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.location_library_default":{"JenisAnggota_id":["inlislite_v3.jenis_anggota","id"]}}},{"":{"inlislite_v3.location_library_default":{"Location_Library_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.location_library_default":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.locations":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.locations":{"LocationLibrary_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.locations":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.lockers":{"loker_id":["inlislite_v3.master_loker","ID"]}}},{"":{"inlislite_v3.lockers":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.lockers":{"id_jamin_idt":["inlislite_v3.master_jenis_identitas","id"]}}},{"":{"inlislite_v3.lockers":{"id_pelanggaran_locker":["inlislite_v3.master_pelanggaran_locker","ID"]}}},{"":{"inlislite_v3.lockers":{"id_jamin_uang":["inlislite_v3.master_uang_jaminan","ID"]}}},{"":{"inlislite_v3.lockers":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.logsdownload":{"catalogfilesID":["inlislite_v3.catalogfiles","ID"]}}},{"":{"inlislite_v3.logsdownload":{"User_id":["inlislite_v3.members","MemberNo"]}}},{"":{"inlislite_v3.logsdownload_article":{"articlefilesID":["inlislite_v3.serial_articlefiles","ID"]}}},{"":{"inlislite_v3.logsdownload_article":{"User_id":["inlislite_v3.members","MemberNo"]}}},{"":{"inlislite_v3.mailserver":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.mailserver":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.masa_berlaku_anggota":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.masa_berlaku_anggota":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_djkn":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_djkn":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_edisi_serial":{"Catalog_id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.master_fakultas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_fakultas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_jenis_identitas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_jenis_identitas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_jurusan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_jurusan":{"id_fakultas":["inlislite_v3.master_fakultas","id"]}}},{"":{"inlislite_v3.master_jurusan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_kelas_besar":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_kelas_besar":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_kependudukan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_kependudukan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_loker":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_loker":{"locations_id":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.master_loker":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_pekerjaan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_pekerjaan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_pendidikan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_pendidikan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_program_studi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_program_studi":{"id_jurusan":["inlislite_v3.master_jurusan","id"]}}},{"":{"inlislite_v3.master_program_studi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_range_umur":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_range_umur":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_status_perkawinan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.master_status_perkawinan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.member_fields":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.member_fields":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.member_perpanjangan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.member_perpanjangan":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.member_perpanjangan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberguesses":{"TujuanKunjungan_Id":["inlislite_v3.tujuan_kunjungan","ID"]}}},{"":{"inlislite_v3.memberguesses":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberguesses":{"JenisKelamin_id":["inlislite_v3.jenis_kelamin","ID"]}}},{"":{"inlislite_v3.memberguesses":{"Location_Id":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.memberguesses":{"LOCATIONLOANS_ID":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.memberguesses":{"MasaBerlaku_id":["inlislite_v3.masa_berlaku_anggota","id"]}}},{"":{"inlislite_v3.memberguesses":{"Profesi_id":["inlislite_v3.master_pekerjaan","id"]}}},{"":{"inlislite_v3.memberguesses":{"PendidikanTerakhir_id":["inlislite_v3.master_pendidikan","id"]}}},{"":{"inlislite_v3.memberguesses":{"Status_id":["inlislite_v3.status_anggota","id"]}}},{"":{"inlislite_v3.memberguesses":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberloanauthorizecategory":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.memberloanauthorizecategory":{"CategoryLoan_id":["inlislite_v3.collectioncategorys","ID"]}}},{"":{"inlislite_v3.memberloanauthorizecategory":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberloanauthorizecategory":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberloanauthorizelocation":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberloanauthorizelocation":{"LocationLoan_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.memberloanauthorizelocation":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.memberloanauthorizelocation":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberrules":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.memberrules":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members":{"Branch_id":["inlislite_v3.branchs","ID"]}}},{"":{"inlislite_v3.members":{"Agama_id":["inlislite_v3.agama","ID"]}}},{"":{"inlislite_v3.members":{"Job_id":["inlislite_v3.master_pekerjaan","id"]}}},{"":{"inlislite_v3.members":{"Sex_id":["inlislite_v3.jenis_kelamin","ID"]}}},{"":{"inlislite_v3.members":{"UnitKerja_id":["inlislite_v3.departments","ID"]}}},{"":{"inlislite_v3.members":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members":{"EducationLevel_id":["inlislite_v3.master_pendidikan","id"]}}},{"":{"inlislite_v3.members":{"Fakultas_id":["inlislite_v3.master_fakultas","id"]}}},{"":{"inlislite_v3.members":{"IdentityType_id":["inlislite_v3.master_jenis_identitas","id"]}}},{"":{"inlislite_v3.members":{"JenisAnggota_id":["inlislite_v3.jenis_anggota","id"]}}},{"":{"inlislite_v3.members":{"JenisPermohonan_id":["inlislite_v3.jenis_permohonan","ID"]}}},{"":{"inlislite_v3.members":{"JenjangPendidikan_id":["inlislite_v3.master_jenjang_pendidikan","ID"]}}},{"":{"inlislite_v3.members":{"Jurusan_id":["inlislite_v3.master_jurusan","id"]}}},{"":{"inlislite_v3.members":{"Kelas_id":["inlislite_v3.kelas_siswa","id"]}}},{"":{"inlislite_v3.members":{"ProgramStudi_id":["inlislite_v3.master_program_studi","id"]}}},{"":{"inlislite_v3.members":{"MaritalStatus_id":["inlislite_v3.master_status_perkawinan","id"]}}},{"":{"inlislite_v3.members":{"StatusAnggota_id":["inlislite_v3.status_anggota","id"]}}},{"":{"inlislite_v3.members":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_form":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_form":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_form":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_form":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_form_list":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_form_list":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_form_list":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_form_list":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_info_form":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_info_form":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_info_form":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_info_form":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_loan_form":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_loan_form":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_loan_form":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_loan_form":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_loanreturn_form":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_loanreturn_form":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_loanreturn_form":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_loanreturn_form":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_online_form":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_online_form":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_online_form":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_online_form":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_online_form_edit":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.members_online_form_edit":{"Member_Field_id":["inlislite_v3.member_fields","id"]}}},{"":{"inlislite_v3.members_online_form_edit":{"Jenis_Perpustakaan_id":["inlislite_v3.jenis_perpustakaan","ID"]}}},{"":{"inlislite_v3.members_online_form_edit":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.membersonline":{"BranchId":["inlislite_v3.branchs","ID"]}}},{"":{"inlislite_v3.membersonline":{"LocationLoanId":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.membersonline":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.membersonline":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.menu":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.menu":{"parent":["inlislite_v3.menu","id"]}}},{"":{"inlislite_v3.menu":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.migration":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.migration":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.modules":{"Application_id":["inlislite_v3.applications","ID"]}}},{"":{"inlislite_v3.modules":{"ParentID":["inlislite_v3.modules","ID"]}}},{"":{"inlislite_v3.modules":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.modules":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.opacfields":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.opacfields":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.opaclogs":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.opaclogs":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.opaclogs":{"User_id":["inlislite_v3.members","MemberNo"]}}},{"":{"inlislite_v3.opaclogs_keyword":{"OpaclogsId":["inlislite_v3.opaclogs","ID"]}}},{"":{"inlislite_v3.partners":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.partners":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"CollectionLoanItem_id":["inlislite_v3.collectionloanitems","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"CollectionLoan_id":["inlislite_v3.collectionloans","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"JenisDenda_id":["inlislite_v3.jenis_denda","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"JenisPelanggaran_id":["inlislite_v3.jenis_pelanggaran","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.pelanggaran":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.pengiriman":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.pengiriman":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.pengiriman_koleksi":{"PengirimanID":["inlislite_v3.pengiriman","ID"]}}},{"":{"inlislite_v3.pengiriman_koleksi":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.pengiriman_koleksi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.pengiriman_koleksi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.peraturan_peminjaman_hari":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.peraturan_peminjaman_hari":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.peraturan_peminjaman_tanggal":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.peraturan_peminjaman_tanggal":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.propinsi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.propinsi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.publishers":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.publishers":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_auth_data":{"Auth_Header_ID":["inlislite_v3.quarantined_auth_header","ID"]}}},{"":{"inlislite_v3.quarantined_auth_data":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_auth_data":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_auth_header":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_auth_header":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalog_ruas":{"CatalogId":["inlislite_v3.quarantined_catalogs","ID"]}}},{"":{"inlislite_v3.quarantined_catalog_ruas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalog_ruas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalog_subruas":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalog_subruas":{"RuasID":["inlislite_v3.quarantined_catalog_ruas","ID"]}}},{"":{"inlislite_v3.quarantined_catalog_subruas":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalogs":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalogs":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.quarantined_catalogs":{"QUARANTINEDBY":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_catalogs":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_collections":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_collections":{"QUARANTINEDBY":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_collections":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_pengiriman":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.quarantined_pengiriman":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.readinlocation":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.readinlocation":{"LocationId":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.readinlocation":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.refferenceitems":{"Refference_id":["inlislite_v3.refferences","ID"]}}},{"":{"inlislite_v3.refferenceitems":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.refferenceitems":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.refferences":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.refferences":{"Format_id":["inlislite_v3.formats","ID"]}}},{"":{"inlislite_v3.refferences":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.requestcatalog":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.requestcatalog":{"MemberID":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.requestcatalog":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.rfid_temp":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.rfid_temp":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.rolemodule":{"Module_id":["inlislite_v3.modules","ID"]}}},{"":{"inlislite_v3.rolemodule":{"Role_id":["inlislite_v3.roles","ID"]}}},{"":{"inlislite_v3.rolemodule":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.rolemodule":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.roles":{"Application_id":["inlislite_v3.applications","ID"]}}},{"":{"inlislite_v3.roles":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.roles":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.sentitems":{"CollectionLoanItem_id":["inlislite_v3.collectionloanitems","ID"]}}},{"":{"inlislite_v3.serial_articlefiles":{"Articles_id":["inlislite_v3.serial_articles","id"]}}},{"":{"inlislite_v3.serial_articles":{"Catalog_id":["inlislite_v3.catalogs","ID"]}}},{"":{"inlislite_v3.serial_articles":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.serial_articles":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.serial_articles_repeatable":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.serial_articles_repeatable":{"serial_article_ID":["inlislite_v3.serial_articles","id"]}}},{"":{"inlislite_v3.serial_articles_repeatable":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.settingcatalogdetail":{"Field_id":["inlislite_v3.fields","ID"]}}},{"":{"inlislite_v3.settingcatalogdetail":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.settingcatalogdetail":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.settingparameters":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.settingparameters":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.status_anggota":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.status_anggota":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.stockopname":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.stockopname":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"CollectionID":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"PrevCollectionRuleID":["inlislite_v3.collectionrules","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"CurrentCollectionRuleID":["inlislite_v3.collectionrules","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"PrevStatusID":["inlislite_v3.collectionstatus","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"CurrentStatusID":["inlislite_v3.collectionstatus","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"PrevLocationID":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"CurrentLocationID":["inlislite_v3.locations","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"StockOpnameID":["inlislite_v3.stockopname","ID"]}}},{"":{"inlislite_v3.stockopnamedetail":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.sumbangan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.sumbangan":{"Member_id":["inlislite_v3.members","ID"]}}},{"":{"inlislite_v3.sumbangan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.sumbangan_koleksi":{"Collection_id":["inlislite_v3.collections","ID"]}}},{"":{"inlislite_v3.sumbangan_koleksi":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.sumbangan_koleksi":{"Sumbangan_id":["inlislite_v3.sumbangan","ID"]}}},{"":{"inlislite_v3.sumbangan_koleksi":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey_isian":{"Survey_Pertanyaan_id":["inlislite_v3.survey_pertanyaan","ID"]}}},{"":{"inlislite_v3.survey_pertanyaan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey_pertanyaan":{"Survey_id":["inlislite_v3.survey","ID"]}}},{"":{"inlislite_v3.survey_pertanyaan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey_pilihan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey_pilihan":{"Survey_Pertanyaan_id":["inlislite_v3.survey_pertanyaan","ID"]}}},{"":{"inlislite_v3.survey_pilihan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.survey_pilihan_sesi":{"Survey_Pilihan_id":["inlislite_v3.survey_pilihan","ID"]}}},{"":{"inlislite_v3.tempnoinduk":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.tempnoinduk":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.tujuan_kunjungan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.tujuan_kunjungan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.user":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.user":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userloclibforcol":{"LocLib_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.userloclibforcol":{"User_id":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userloclibforcol":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userloclibforcol":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userloclibforloan":{"LocLib_id":["inlislite_v3.location_library","ID"]}}},{"":{"inlislite_v3.userloclibforloan":{"User_id":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userloclibforloan":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userloclibforloan":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userlogs":{"User_id":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userlogs":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.userlogs":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.users":{"Branch_id":["inlislite_v3.branchs","ID"]}}},{"":{"inlislite_v3.users":{"Department_id":["inlislite_v3.departments","ID"]}}},{"":{"inlislite_v3.users":{"Role_id":["inlislite_v3.roles","ID"]}}},{"":{"inlislite_v3.users":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.users":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.worksheetfielditems":{"WorksheetField_id":["inlislite_v3.worksheetfields","ID"]}}},{"":{"inlislite_v3.worksheetfielditems":{"Refference_id":["inlislite_v3.refferences","ID"]}}},{"":{"inlislite_v3.worksheetfielditems":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.worksheetfielditems":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.worksheetfields":{"Field_id":["inlislite_v3.fields","ID"]}}},{"":{"inlislite_v3.worksheetfields":{"Worksheet_id":["inlislite_v3.worksheets","ID"]}}},{"":{"inlislite_v3.worksheetfields":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.worksheetfields":{"UpdateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.worksheets":{"Format_id":["inlislite_v3.formats","ID"]}}},{"":{"inlislite_v3.worksheets":{"CreateBy":["inlislite_v3.users","ID"]}}},{"":{"inlislite_v3.worksheets":{"UpdateBy":["inlislite_v3.users","ID"]}}}]
[]
-1
1
Belum ada nama *
vShow/Hide tables list View in fullscreen New page Buka halaman Simpan halaman Save page as Delete pages Buat tabel Buat relasi Pilih kolom untuk ditampilkan Muat ulang Bantuan Tautan angular / Tautan langsung Lekatkan kepada kisi vSmall/Big All Toggle small/big Toggle relation lines Export schema > Pindahkan Menu > Pin text
v inlislite_v3 agama
*ID : int(11)
*Name : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 applications
*ID : int(11)
*Code : varchar(100)
*Name : varchar(255)
*URL : varchar(255)
*WhenDownMessageError : varchar(255)
*IsPublish : bit(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 app_installed
*ID : int(11)
*ActivationCode : varchar(255)
*PerpustakaanName : text
*CreateDate : datetime
*CreateTerminal : varchar(100)
*Type : varchar(100)
v inlislite_v3 auth_assignment
*item_name : varchar(64)
*user_id : varchar(64)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*created_at : varchar(45)
*updated_at : varchar(45)
v inlislite_v3 auth_data
*ID : int(11)
*Auth_Header_ID : int(11)
*Tag : varchar(3)
*Indicator1 : char(1)
*Indicator2 : char(1)
*Value : varchar(700)
*DataItem : varchar(700)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 auth_header
*ID : int(11)
*Worksheet_id : int(11)
*Auth_ID : varchar(20)
*MARC_LOC : text
*ISTILAH_DIGUNAKAN : text
*ISTILAH_TDK_DIGUNAKAN : text
*ISTILAH_TERKAIT : text
*TANGGALPEMBAHASAN : varchar(45)
*QUARANTINEDBY : int(11)
*QUARANTINEDDATE : datetime
*QUARANTINEDTERMINAL : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 auth_item
*name : varchar(64)
*type : int(11)
*description : text
*rule_name : varchar(64)
*data : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*created_at : varchar(45)
*updated_at : varchar(45)
v inlislite_v3 auth_item_child
*parent : varchar(64)
*child : varchar(64)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 auth_rule
*name : varchar(64)
*data : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 bacaditempat
*ID : double
*NoPengunjung : varchar(50)
*collection_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Member_id : double
*Location_Id : int(11)
*Is_return : enum('0','1')
v inlislite_v3 bacaditempat_locations
*ID : int(11)
*IP_PC : varchar(100)
*Location_ID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 backup
*ID : int(11)
*BackupType : varchar(20)
*FileName : varchar(255)
*FileSize : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
v inlislite_v3 bibidavailable
*BIBID : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 bookinglogs
*memberId : varchar(50)
*collectionId : double
*bookingDate : datetime
*bookingExpired : datetime
v inlislite_v3 bookmark
*ID : double
*Sesi : text
*Value : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 branchs
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 cardformats
*ID : int(11)
*Name : varchar(100)
*Width : int(11)
*Height : int(11)
*FontName : varchar(30)
*FontSize : int(11)
*FormatTeks : text
*FormatTeksNoAuthor : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 catalogfiles
*ID : int(11)
*Catalog_id : double
*FileURL : varchar(255)
*FileFlash : varchar(255)
*IsPublish : tinyint(4)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*IsFromMember : bit(1)
*Member_id : double
v inlislite_v3 catalogs
*ID : double
*ControlNumber : varchar(50)
*BIBID : varchar(50)
*Title : varchar(700)
*Author : varchar(700)
*Edition : varchar(255)
*Publisher : varchar(255)
*PublishLocation : varchar(255)
*PublishYear : varchar(255)
*Publikasi : varchar(700)
*Subject : varchar(700)
*PhysicalDescription : varchar(255)
*ISBN : varchar(700)
*CallNumber : varchar(700)
*Note : text
*Languages : varchar(255)
*DeweyNo : varchar(255)
*ApproveDateOPAC : datetime
*IsOPAC : tinyint(4)
*IsBNI : bit(1)
*IsKIN : bit(1)
*IsRDA : bit(1)
*CoverURL : varchar(255)
*Branch_id : int(11)
*Worksheet_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*MARC_LOC : text
*PRESERVASI_ID : varchar(20)
*QUARANTINEDBY : int(11)
*QUARANTINEDDATE : datetime
*QUARANTINEDTERMINAL : varchar(100)
*Member_id : double
*KIILastUploadDate : datetime
v inlislite_v3 catalogstaging
*ID : int(11)
*Title : varchar(700)
*Author : varchar(700)
*Publishment : varchar(255)
*Edition : varchar(255)
*MARC_LOC : text
*Worksheet_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 catalog_ruas
*ID : double
*CatalogId : double
*Tag : varchar(3)
*Indicator1 : char(1)
*Indicator2 : char(1)
*Value : text
*Sequence : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 catalog_subruas
*ID : double
*RuasID : double
*SubRuas : varchar(10)
*Value : text
*Sequence : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 checkpoint_locations
*ID : int(11)
*IP_PC : varchar(100)
*Location_ID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 collectioncategorys
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 collectioncategorysdefault
*ID : int(11)
*CollectionCategory_id : int(11)
*JenisAnggota_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 collectioncategorysloanhari
*DataID : int(11)
*Category_id : int(11)
*Peminjaman_hari_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 collectionloanextends
*id : int(11)
*CollectionLoan_id : varchar(255)
*CollectionLoanItem_id : double
*Collection_id : double
*Member_id : double
*DateExtend : datetime
*DueDateExtend : datetime
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 collectionloanitems
*ID : double
*CollectionLoan_id : varchar(255)
*LoanDate : datetime
*DueDate : datetime
*ActualReturn : datetime
*LateDays : int(11)
*LoanStatus : varchar(50)
*Collection_id : double
*member_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 collectionloans
*ID : varchar(255)
*CollectionCount : int(11)
*LateCount : int(11)
*ExtendCount : int(11)
*LoanCount : int(11)
*ReturnCount : int(11)
*Member_id : double
*Branch_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
*LocationLibrary_id : int(11)
v inlislite_v3 collectionlocations
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*Description : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 collectionmedias
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*Worksheet_id : int(11)
*KodeBahanPustaka : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 collectionrules
*ID : int(11)
*Name : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 collectionrulesitems
*CollectionRules_id : int(11)
*StartDay : int(11)
*EndDay : int(11)
*SuspendDays : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 collections
*ID : double
*NomorBarcode : varchar(50)
*NoInduk : varchar(50)
*Currency : varchar(30)
*RFID : varchar(50)
*Price : decimal(10,0)
*PriceType : varchar(45)
*TanggalPengadaan : datetime
*CallNumber : varchar(255)
*Branch_id : int(11)
*Catalog_id : double
*Partner_id : int(11)
*Location_id : int(11)
*Rule_id : int(11)
*Category_id : int(11)
*Media_id : int(11)
*Source_id : int(11)
*Status_id : int(11)
*Location_Library_id : int(11)
*Keterangan_Sumber : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*IsVerified : bit(1)
*QUARANTINEDBY : int(11)
*QUARANTINEDDATE : date
*QUARANTINEDTERMINAL : varchar(100)
*ISREFERENSI : bit(1)
*EDISISERIAL : varchar(255)
*NOJILID : int(11)
*TANGGAL_TERBIT_EDISI_SERIAL : date
*BAHAN_SERTAAN : varchar(255)
*KETERANGAN_LAIN : varchar(255)
*TGLENTRYJILID : date
*IDJILID : varchar(20)
*NOMORPANGGILJILID : varchar(100)
*ISOPAC : tinyint(4)
*JILIDCREATEBY : int(11)
*KIILastUploadDate : datetime
*BookingMemberID : varchar(50)
*BookingExpiredDate : datetime
*IsDeposit : int(1)
*NomorDeposit : varchar(21)
*ThnTerbitDeposit : int(11)
*deposit_ws_ID : int(11)
*deposit_kode_wilayah_ID : int(11)
*Nomor_Regis : varchar(11)
v inlislite_v3 collectionsources
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 collectionstatus
*ID : int(11)
*Name : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 colloclib
*Col_id : double
*LocLib_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 currency
*Currency : varchar(20)
*Description : varchar(200)
*Sort_ID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 daemons
*Start : text
*Info : text
v inlislite_v3 departments
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*Description : varchar(255)
*IsActive : bit(1)
*ParentID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 deposit_group_ws
*id_group : int(11)
*group_name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(50)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(50)
v inlislite_v3 deposit_kelompok_penerbit
*ID : int(11)
*Name : varchar(111)
*CreateBy : int(11)
*CreateDate : datetime
v inlislite_v3 deposit_kode_wilayah
*ID : int(11)
*nama_wilayah : varchar(255)
*kode_wilayah : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(50)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(50)
v inlislite_v3 deposit_taksiran_harga
*ID : int(11)
*ID_collections : double
*cover : varchar(65)
*muka_buku : varchar(65)
*hard_cover : varchar(65)
*penjilidan : varchar(65)
*jumlah_halaman : int(11)
*jenis_kertas_buku : varchar(25)
*ukuran_buku : varchar(6)
*kondisi_buku : varchar(10)
*kondisi_usang : varchar(25)
*full_color : varchar(9)
v inlislite_v3 deposit_ws
*ID : int(11)
*jenis_penerbit : varchar(55)
*id_group_deposit_group_ws : int(11)
*id_deposit_kelompok_penerbit_ws : int(11)
*nama_penerbit : varchar(55)
*alamat1 : varchar(65)
*alamat2 : varchar(65)
*alamat3 : varchar(65)
*kabupaten : varchar(65)
*ID_deposit_kode_wilayah : int(11)
*kode_pos : int(11)
*no_telp1 : int(11)
*no_telp2 : int(11)
*no_telp3 : int(11)
*no_fax : int(11)
*email : char(30)
*contact_person : char(50)
*no_contact : int(11)
*koleksi_per_tahun : int(11)
*keterangan : varchar(50)
*status : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*UpdateBy : int(11)
*UpdateDate : datetime
v inlislite_v3 djkn_data
*ID : int(11)
*Collection_id : double
*Cover : varchar(100)
*Finishing_Cover : varchar(100)
*Finishing_HardCover : varchar(100)
*Binding : varchar(100)
*Total_Page : varchar(20)
*Paper_Type : varchar(100)
*Book_Size : varchar(100)
*Condition_Book : varchar(100)
*Conditions_Outdated : varchar(100)
*FULL_COLOR : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(45)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(45)
v inlislite_v3 favorite
*id : double
*Catalog_Id : double
*Member_Id : varchar(50)
*Createdate : datetime
v inlislite_v3 fielddatas
*Field_id : int(11)
*Code : varchar(10)
*Name : varchar(255)
*Delimiter : varchar(5)
*SortNo : int(11)
*Repeatable : bit(1)
*IsShow : bit(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 fieldgroups
*ID : int(11)
*Name : varchar(20)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 fieldindicator1s
*Field_id : int(11)
*Code : varchar(10)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 fieldindicator2s
*Field_id : int(11)
*Code : varchar(10)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 fields
*ID : int(11)
*Tag : varchar(3)
*Name : varchar(100)
*Fixed : bit(1)
*Enabled : bit(1)
*Length : int(11)
*Repeatable : bit(1)
*Mandatory : bit(1)
*IsCustomable : bit(1)
*Format_id : int(11)
*Group_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*DEFAULTSUBTAG : varchar(12)
*ISSUBSERIAL : bit(1)
v inlislite_v3 formats
*ID : int(11)
*Code : varchar(10)
*Name : varchar(20)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 gammu
*Version : int(11)
v inlislite_v3 groupguesses
*ID : int(11)
*NamaKetua : varchar(255)
*NomerTelponKetua : varchar(20)
*AsalInstansi : varchar(255)
*AlamatInstansi : varchar(255)
*CountPersonel : int(11)
*CountPNS : int(11)
*CountPSwasta : int(11)
*CountPeneliti : int(11)
*CountGuru : int(11)
*CountDosen : int(11)
*CountPensiunan : int(11)
*CountTNI : int(11)
*CountWiraswasta : int(11)
*CountPelajar : int(11)
*CountMahasiswa : int(11)
*CountLainnya : int(11)
*CountSD : int(11)
*CountSMP : int(11)
*CountSMA : int(11)
*CountD1 : int(11)
*CountD2 : int(11)
*CountD3 : int(11)
*CountS1 : int(11)
*CountS2 : int(11)
*CountS3 : int(11)
*CountLaki : int(11)
*CountPerempuan : int(11)
*TujuanKunjungan_ID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*LocationLoans_ID : int(11)
*Location_ID : int(11)
*TeleponInstansi : varchar(20)
*EmailInstansi : varchar(255)
*Information : varchar(255)
*NoPengunjung : varchar(50)
v inlislite_v3 historydata
*ID : bigint(20)
*Action : varchar(10)
*TableName : varchar(45)
*IDRef : varchar(45)
*Note : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Member_id : double
v inlislite_v3 holidays
*ID : int(11)
*Dates : datetime
*Names : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 inbox
*UpdatedInDB : timestamp
*ReceivingDateTime : timestamp
*Text : text
*SenderNumber : varchar(20)
*Coding : enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression')
*UDH : text
*SMSCNumber : varchar(20)
*Class : int(11)
*TextDecoded : text
*ID : int(10) unsigned
*RecipientID : text
*Processed : enum('false','true')
v inlislite_v3 item_koleksi
*periode : varchar(6)
*bulan : int(2)
*tahun : int(4)
*jumlah_eksemplar : bigint(21)
v inlislite_v3 jenis_anggota
*id : int(11)
*jenisanggota : varchar(50)
*MasaBerlakuAnggota : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*BiayaPendaftaran : decimal(10,0)
*BiayaPerpanjangan : decimal(10,0)
*UploadDokumenKeanggotaanOnline : bit(1)
*MaxPinjamKoleksi : int(11)
*MaxLoanDays : int(11)
*DendaType : varchar(45)
*DendaTenorJumlah : double
*DendaTenorSatuan : varchar(45)
*DendaPerTenor : decimal(10,0)
*DendaTenorMultiply : int(11)
*SuspendMember : bit(1)
*WarningLoanDueDay : int(11)
*SuspendType : varchar(45)
*SuspendTenorJumlah : double
*SuspendTenorSatuan : varchar(45)
*DaySuspend : int(11)
*SuspendTenorMultiply : int(11)
*DayPerpanjang : int(11)
*CountPerpanjang : int(11)
*KIILastUploadDate : datetime
v inlislite_v3 jenis_denda
*ID : int(11)
*Code : varchar(50)
*Name : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 jenis_kelamin
*ID : int(11)
*Name : varchar(20)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 jenis_pelanggaran
*ID : int(11)
*JenisPelanggaran : varchar(50)
*Keterangan : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 jenis_permohonan
*ID : int(11)
*Name : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 jenis_perpustakaan
*ID : int(11)
*Name : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 judul_koleksi
*no : int(11)
*judul_pernyataan : varchar(255)
*ed_cet : varchar(100)
*kota : varchar(100)
*penerbit : varchar(255)
*tahun : int(11)
*no_induk : varchar(100)
*no_class : varchar(50)
*no_panggil : varchar(50)
*pengarang : varchar(255)
*kolasi : text
*catatan : varchar(255)
*bibliografi : varchar(255)
*indeks : varchar(255)
*isbn : varchar(100)
*subjek1 : varchar(255)
*subjek2 : varchar(255)
*subjek3 : varchar(255)
*subjek4 : varchar(255)
*tet1 : varchar(255)
*tet2 : varchar(255)
*tet3 : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 kabupaten
*ID : int(11) unsigned
*NamaKab : varchar(50)
*PropinsiID : int(5)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 kata_sandang
*ID : int(11)
*Tag : varchar(3)
*Name : varchar(100)
*JumlahKarakter : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 kelas_siswa
*id : int(11)
*namakelassiswa : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 kelompok_pelanggaran
*ID : int(11)
*Name : varchar(50)
*Jumlah : int(11)
*Warna : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*SuspendMember : tinyint(3) unsigned
v inlislite_v3 keranjang_anggota
*ID : int(11)
*Member_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 keranjang_katalog
*ID : int(11)
*Catalog_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 keranjang_koleksi
*ID : int(11)
*Collection_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 kriteria_koleksi
*ID : int(11)
*jns_kriteria : varchar(255)
*catalog_id : double
*title : varchar(255)
*author : varchar(255)
*alamat_image : varchar(500)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*PublishYear : varchar(25)
*Jumlah : int(11)
*worksheet_name : varchar(100)
*isLKD : varchar(10)
v inlislite_v3 letter
*ID : int(11)
*TYPE_OF_DELIVERY : varchar(21)
*LETTER_DATE : date
*LETTER_NUMBER : varchar(35)
*ACCEPT_DATE : date
*SENDER : varchar(155)
*PHONE : int(11)
*INTENDED_TO : varchar(155)
*IS_PRINTED : int(4)
*CreateDate : datetime
*CreateBy : int(11)
*CreateTerminal : varchar(111)
*UpdateDate : datetime
*UpdateBy : int(11)
*UpdateTerminal : varchar(111)
*PUBLISHER_ID : int(11)
*LETTER_NUMBER_UT : varchar(45)
*IS_SENDEDEMAIL : int(4)
*IS_NOTE : int(4)
*LANG : varchar(20)
v inlislite_v3 letter_detail
*ID : int(11)
*SUB_TYPE_COLLECTION : int(11)
*TITLE : varchar(255)
*QUANTITY : int(11)
*COPY : int(11)
*PRICE : varchar(100)
*LETTER_ID : int(111)
*COLLECTION_TYPE_ID : int(11)
*REMARK : varchar(255)
*AUTHOR : varchar(155)
*PUBLISHER : varchar(50)
*PUBLISHER_ADDRESS : varchar(255)
*ISBN : varchar(25)
*PUBLISH_YEAR : varchar(15)
*PUBLISHER_CITY : varchar(25)
*ISBN_STATUS : varchar(55)
*KD_PENERBIT_DTL : varchar(25)
v inlislite_v3 library
*ID : int(11)
*NAME : varchar(50)
*URL : varchar(255)
*PORT : varchar(10)
*DATABASENAME : varchar(50)
*RECORDSYNTAX : varchar(20)
*FULLNAME : varchar(255)
*PROTOCOL : varchar(45)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 librarysearchcriteria
*ID : int(11)
*LIBRARYID : int(11)
*CRITERIANAME : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 locations
*ID : int(11)
*Code : varchar(20)
*Name : varchar(255)
*Description : varchar(255)
*ISPUSTELING : bit(1)
*IsPrintBarcode : bit(1)
*IsGenerateVisitorNumber : bit(1)
*IsInformationSought : bit(1)
*IsVisitsDestination : bit(1)
*LocationLibrary_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 location_library
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*Address : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 location_library_default
*ID : int(11)
*Location_Library_id : int(11)
*JenisAnggota_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTeminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 lockers
*ID : int(11)
*No_pinjaman : varchar(255)
*no_member : varchar(45)
*no_identitas : varchar(50)
*jenis_jaminan : varchar(20)
*id_jamin_idt : int(11)
*id_jamin_uang : int(11)
*loker_id : int(11)
*tanggal_pinjam : datetime
*tanggal_kembali : datetime
*id_pelanggaran_locker : int(11)
*denda : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 logsdownload
*id : bigint(30)
*User_id : varchar(50)
*ip : varchar(15)
*catalogfilesID : int(11)
*isLKD : tinyint(1)
*waktu : datetime
v inlislite_v3 logsdownload_article
*id : bigint(30)
*User_id : varchar(50)
*ip : varchar(15)
*articlefilesID : int(11)
*waktu : datetime
v inlislite_v3 mailserver
*ID : int(11)
*Modul : varchar(50)
*Host : varchar(50)
*Port : int(11)
*CredentialMail : varchar(50)
*CredentialPassword : varchar(50)
*EnableSsl : bit(1)
*MailFrom : varchar(50)
*MailDisplayName : varchar(50)
*IsActive : bit(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 masa_berlaku_anggota
*id : int(11)
*jumlah : int(20)
*satuan : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 master_counter_barcode
*tahun : year(4)
*value : int(111)
v inlislite_v3 master_djkn
*ID : int(11)
*Option_id : varchar(20)
*Option_Name : varchar(100)
*Value : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(45)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(45)
v inlislite_v3 master_edisi_serial
*id : double
*tgl_edisi_serial : date
*no_edisi_serial : varchar(111)
*Catalog_id : double
*CreateBy : int(11)
*UpdateBy : int(11)
v inlislite_v3 master_fakultas
*id : int(11)
*Nama : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 master_jam_buka
*ID : int(11)
*hari : varchar(50)
*jam_buka : time
*jam_tutup : time
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_jenis_identitas
*id : int(11)
*Nama : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*IsNIK : bit(1)
*KIILastUploadDate : datetime
v inlislite_v3 master_jenjang_pendidikan
*ID : int(11)
*jenjang_pendidikan : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : date
*UpdateTerminal : varchar(100)
v inlislite_v3 master_jurusan
*id : int(11)
*id_fakultas : int(11)
*Nama : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 master_kelas_besar
*ID : int(11)
*kdKelas : varchar(3)
*namakelas : varchar(255)
*warna : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_kependudukan
*id : int(11)
*nomorkk : varchar(50)
*nik : varchar(50)
*namalengkap : varchar(100)
*nama_ibu : varchar(100)
*al1 : varchar(255)
*rt : varchar(50)
*rw : varchar(50)
*kodekec : varchar(50)
*kodekel : varchar(50)
*nama_kec : varchar(100)
*nama_kel : varchar(100)
*nama_kab : varchar(100)
*nama_prov : varchar(100)
*alamat : varchar(255)
*lhrtempat : varchar(50)
*lhrtanggal : varchar(50)
*ttl : varchar(50)
*umur : varchar(50)
*jk : int(11)
*jenis : varchar(50)
*status : int(11)
*sts : varchar(50)
*hub : varchar(50)
*agama : int(50)
*agm : varchar(50)
*pendidikan : varchar(50)
*pekerjaan : varchar(50)
*klain_fisik : varchar(50)
*aktalhr : varchar(50)
*aktakawin : varchar(50)
*aktacerai : varchar(50)
*nocacat : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_loker
*ID : int(11)
*No : varchar(255)
*Name : varchar(255)
*locations_id : int(11)
*status : varchar(20)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_pekerjaan
*id : int(11)
*Pekerjaan : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 master_pelanggaran_locker
*ID : int(11)
*jenis_pelanggaran : varchar(50)
*denda : decimal(10,0)
*deskripsi : text
*CreateBy : varchar(100)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : varchar(100)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_pendidikan
*id : int(11)
*Nama : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 master_program_studi
*id : int(11)
*id_jurusan : int(11)
*Nama : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 master_range_umur
*id : int(11)
*umur1 : int(11)
*umur2 : int(11)
*Keterangan : varchar(255)
*NoUrut : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_status_perkawinan
*id : int(11)
*Nama : varchar(30)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 master_uang_jaminan
*ID : int(11)
*No : varchar(255)
*Name : varchar(255)
*CreateBy : varchar(100)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : varchar(100)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 memberguesses
*ID : int(11)
*NoAnggota : varchar(50)
*Nama : varchar(100)
*Status_id : int(11)
*MasaBerlaku_id : int(11)
*Profesi_id : int(11)
*PendidikanTerakhir_id : int(11)
*JenisKelamin_id : int(11)
*Alamat : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Deskripsi : varchar(255)
*LOCATIONLOANS_ID : int(11)
*Location_Id : int(11)
*TujuanKunjungan_Id : int(11)
*Information : varchar(255)
*NoPengunjung : varchar(50)
v inlislite_v3 memberloanauthorizecategory
*DataID : bigint(20)
*Member_id : double
*CategoryLoan_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 memberloanauthorizelocation
*DataID : bigint(20)
*Member_id : double
*LocationLoan_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 memberrules
*ID : int(11)
*NameCategory : varchar(50)
*Contents : text
*isPublish : bit(1)
*SortNum : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 members
*ID : double
*MemberNo : varchar(50)
*Fullname : varchar(255)
*PlaceOfBirth : varchar(255)
*DateOfBirth : datetime
*Address : varchar(255)
*AddressNow : varchar(255)
*Phone : varchar(100)
*InstitutionName : varchar(255)
*InstitutionAddress : varchar(255)
*InstitutionPhone : varchar(255)
*IdentityType_id : int(11)
*IdentityNo : varchar(100)
*EducationLevel_id : int(11)
*Sex_id : int(11)
*MaritalStatus_id : int(11)
*Job_id : int(11)
*RegisterDate : datetime
*EndDate : datetime
*MotherMaidenName : varchar(100)
*Email : varchar(100)
*JenisPermohonan_id : int(11)
*JenisAnggota_id : int(11)
*StatusAnggota_id : int(11)
*LoanReturnLateCount : int(11)
*Branch_id : int(11)
*PhotoUrl : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*NoHp : varchar(100)
*NamaDarurat : varchar(100)
*TelpDarurat : varchar(100)
*AlamatDarurat : varchar(255)
*StatusHubunganDarurat : varchar(100)
*City : varchar(255)
*Province : varchar(255)
*CityNow : varchar(255)
*ProvinceNow : varchar(255)
*Kecamatan : varchar(100)
*Kelurahan : varchar(100)
*RT : varchar(50)
*RW : varchar(50)
*KecamatanNow : varchar(100)
*KelurahanNow : varchar(100)
*RTNow : varchar(50)
*RWNow : varchar(50)
*Kelas_id : int(11)
*TahunAjaran : varchar(50)
*Agama_id : int(11)
*Fakultas_id : int(11)
*Jurusan_id : int(11)
*ProgramStudi_id : int(11)
*JenjangPendidikan_id : int(11)
*UnitKerja_id : int(11)
*KeteranganLain : varchar(255)
*IsLunasBiayaPendaftaran : bit(1)
*BiayaPendaftaran : decimal(10,0)
*TanggalBebasPustaka : datetime
*KIILastUploadDate : datetime
v inlislite_v3 membersonline
*ID : int(9)
*NoAnggota : varchar(50)
*NickName : varchar(100)
*Password : varchar(100)
*Email : varchar(100)
*BranchId : int(11)
*LocationLoanId : int(11)
*Status : varchar(100)
*Activation_Code : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*auth_key : varchar(100)
v inlislite_v3 members_form
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 members_form_list
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 members_info_form
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 members_loanreturn_form
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 members_loan_form
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 members_online_form
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 members_online_form_edit
*ID : int(11)
*Member_Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Jenis_Perpustakaan_id : int(11)
v inlislite_v3 member_fields
*id : int(11)
*name : varchar(255)
*mandatory : bit(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 member_perpanjangan
*ID : double
*Member_id : double
*Tanggal : datetime
*Biaya : decimal(10,0)
*IsLunas : bit(1)
*Keterangan : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 menu
*id : int(11)
*name : varchar(128)
*parent : int(11)
*route : varchar(256)
*order : int(11)
*data : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateTerminal : varchar(100)
*UpdateDate : datetime
v inlislite_v3 migration
*version : varchar(180)
*apply_time : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateTerminal : varchar(100)
*UpdateDate : datetime
v inlislite_v3 modelhistory
*id : bigint(20)
*date : datetime
*table : varchar(255)
*field_name : varchar(255)
*field_id : varchar(255)
*old_value : text
*new_value : text
*type : smallint(6)
*user_id : varchar(255)
v inlislite_v3 modules
*ID : int(11)
*Name : varchar(100)
*URL : varchar(255)
*SortNo : int(11)
*IsPublish : bit(1)
*ClassName : varchar(50)
*IsHeader : bit(1)
*ModuleLevel : int(11)
*Application_id : int(11)
*ParentID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 notif_sms_gateway
*ID : int(11)
*member_id : int(11)
*number_HP : int(20)
*collectionloanitem_id : int(11)
*send_message_text : text
*criteria_message : varchar(20)
*send_date : datetime
*send_status : varchar(10)
v inlislite_v3 notif_sms_gateway_hist
*ID : int(11)
*member_id : int(11)
*number_HP : int(20)
*collectionloanitem_id : int(11)
*send_message_text : text
*criteria_message : varchar(20)
*send_date : datetime
*send_status : varchar(10)
v inlislite_v3 opacfields
*ID : decimal(10,0)
*TAG : varchar(255)
*NAME : varchar(255)
*Column4 : varchar(255)
*Column5 : varchar(255)
*Column6 : varchar(255)
*Column7 : varchar(255)
*Column8 : varchar(255)
*Column9 : varchar(255)
*Column10 : varchar(255)
*Column11 : varchar(255)
*Column12 : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 opaclogs
*ID : int(11)
*User_id : varchar(50)
*ip : varchar(15)
*jenis_pencarian : text
*keyword : text
*jenis_bahan : varchar(50)
*waktu : datetime
*url : text
*isLKD : tinyint(4)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Target_Pembaca : varchar(50)
*Bahasa : varchar(50)
*Bentuk_Karya : varchar(50)
v inlislite_v3 opaclogs_keyword
*Id : int(11)
*OpaclogsId : int(11)
*Field : varchar(20)
*Keyword : text
v inlislite_v3 opac_counter
*hit_id : int(11)
*ip_address : varchar(30)
*city : varchar(100)
*region_name : varchar(100)
*country : varchar(100)
*lat : varchar(100)
*long : varchar(100)
*create_at : datetime
*update_at : datetime
v inlislite_v3 outbox
*UpdatedInDB : timestamp
*InsertIntoDB : timestamp
*SendingDateTime : timestamp
*SendBefore : time
*SendAfter : time
*Text : text
*DestinationNumber : varchar(20)
*Coding : enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression')
*UDH : text
*Class : int(11)
*TextDecoded : text
*ID : int(10) unsigned
*MultiPart : enum('false','true')
*RelativeValidity : int(11)
*SenderID : varchar(255)
*SendingTimeOut : timestamp
*DeliveryReport : enum('default','yes','no')
*CreatorID : text
v inlislite_v3 outbox_multipart
*Text : text
*Coding : enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression')
*UDH : text
*Class : int(11)
*TextDecoded : text
*ID : int(10) unsigned
*SequencePosition : int(11)
v inlislite_v3 partners
*ID : int(11)
*Name : varchar(255)
*Address : varchar(255)
*Phone : varchar(100)
*Fax : varchar(100)
*Province : varchar(255)
*City : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 pbk
*ID : int(11)
*GroupID : int(11)
*Name : text
*Number : text
v inlislite_v3 pbk_groups
*Name : text
*ID : int(11)
v inlislite_v3 pelanggaran
*ID : int(11)
*CollectionLoan_id : varchar(255)
*CollectionLoanItem_id : double
*JenisPelanggaran_id : int(11)
*JenisDenda_id : int(11)
*JumlahDenda : decimal(10,0)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*JumlahSuspend : int(11)
*Paid : bit(1)
*Member_id : double
*Collection_id : double
v inlislite_v3 penduduk
*id : int(11)
*Nik : varchar(16)
*Nama : varchar(255)
*Tempat_Lahir : varchar(100)
*Provinsi : varchar(50)
*Kabupaten_Kota : varchar(100)
*Kecamatan : varchar(100)
*Kelurahan_desa : varchar(100)
*TPS : varchar(100)
v inlislite_v3 pengiriman
*ID : int(11)
*JudulKiriman : text
*PenanggungJawab : varchar(100)
*NipPenanggungJawab : varchar(50)
*FromDate : date
*ToDate : date
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 pengiriman_koleksi
*ID : int(11)
*Collection_id : double
*BIBID : varchar(50)
*JUDUL : varchar(4000)
*TAHUNTERBIT : varchar(20)
*CALLNUMBER : varchar(255)
*NOBARCODE : varchar(100)
*NOINDUK : varchar(255)
*QUANTITY : int(10)
*TANGGALKIRIM : date
*PengirimanID : int(11)
*IsCheck : bit(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(50)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(50)
v inlislite_v3 peraturan_peminjaman_hari
*ID : int(11)
*DayIndex : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*MaxPinjamKoleksi : int(11)
*MaxLoanDays : int(11)
*DendaType : varchar(45)
*DendaTenorJumlah : double
*DendaTenorSatuan : varchar(45)
*DendaPerTenor : decimal(10,0)
*DendaTenorMultiply : int(11)
*SuspendMember : bit(1)
*WarningLoanDueDay : int(11)
*SuspendType : varchar(45)
*SuspendTenorJumlah : double
*SuspendTenorSatuan : varchar(45)
*DaySuspend : int(11)
*SuspendTenorMultiply : int(11)
*DayPerpanjang : int(11)
*CountPerpanjang : int(11)
v inlislite_v3 peraturan_peminjaman_tanggal
*ID : int(11)
*TanggalAwal : datetime
*TanggalAkhir : datetime
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*MaxPinjamKoleksi : int(11)
*MaxLoanDays : int(11)
*DendaType : varchar(45)
*DendaTenorJumlah : double
*DendaTenorSatuan : varchar(45)
*DendaPerTenor : decimal(10,0)
*DendaTenorMultiply : int(11)
*SuspendMember : bit(1)
*WarningLoanDueDay : int(11)
*SuspendType : varchar(45)
*SuspendTenorJumlah : double
*SuspendTenorSatuan : varchar(45)
*DaySuspend : int(11)
*SuspendTenorMultiply : int(11)
*DayPerpanjang : int(11)
*CountPerpanjang : int(11)
v inlislite_v3 phones
*ID : text
*UpdatedInDB : timestamp
*InsertIntoDB : timestamp
*TimeOut : timestamp
*Send : enum('yes','no')
*Receive : enum('yes','no')
*IMEI : varchar(35)
*Client : text
*Battery : int(11)
*Signal : int(11)
*Sent : int(11)
*Received : int(11)
v inlislite_v3 propinsi
*ID : int(5)
*NamaPropinsi : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 publishers
*ID : int(11)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 quarantined_auth_data
*ID : int(11)
*Auth_Header_ID : int(11)
*Tag : varchar(3)
*Indicator1 : char(1)
*Indicator2 : char(1)
*Value : text
*DataItem : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 quarantined_auth_header
*ID : int(11)
*Worksheet_id : int(11)
*Auth_ID : varchar(20)
*MARC_LOC : text
*ISTILAH_DIGUNAKAN : text
*ISTILAH_TDK_DIGUNAKAN : text
*ISTILAH_TERKAIT : text
*TANGGALPEMBAHASAN : varchar(45)
*QUARANTINEDBY : int(11)
*QUARANTINEDDATE : datetime
*QUARANTINEDTERMINAL : varchar(100)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 quarantined_catalogs
*ID : double
*ControlNumber : varchar(50)
*BIBID : varchar(50)
*Title : varchar(700)
*Author : varchar(700)
*Edition : varchar(255)
*Publisher : varchar(255)
*PublishLocation : varchar(255)
*PublishYear : varchar(255)
*Publikasi : varchar(700)
*Subject : varchar(700)
*PhysicalDescription : varchar(255)
*ISBN : varchar(700)
*CallNumber : varchar(700)
*Note : text
*Languages : varchar(255)
*DeweyNo : varchar(255)
*ApproveDateOPAC : datetime
*IsOPAC : tinyint(4)
*IsBNI : bit(1)
*IsKIN : bit(1)
*IsRDA : bit(1)
*CoverURL : varchar(255)
*Branch_id : int(11)
*Worksheet_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*MARC_LOC : text
*PRESERVASI_ID : varchar(20)
*QUARANTINEDBY : int(11)
*QUARANTINEDDATE : datetime
*QUARANTINEDTERMINAL : varchar(100)
*Member_id : double
*KIILastUploadDate : datetime
v inlislite_v3 quarantined_catalog_ruas
*ID : double
*CatalogId : double
*Tag : varchar(3)
*Indicator1 : char(1)
*Indicator2 : char(1)
*Value : text
*Sequence : int(10)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 quarantined_catalog_subruas
*ID : double
*RuasID : double
*SubRuas : varchar(10)
*Value : text
*Sequence : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 quarantined_collections
*ID : double
*NomorBarcode : varchar(50)
*NoInduk : varchar(50)
*Currency : varchar(30)
*RFID : varchar(50)
*Price : decimal(10,0)
*PriceType : varchar(45)
*TanggalPengadaan : datetime
*CallNumber : varchar(255)
*Branch_id : int(11)
*Catalog_id : double
*Partner_id : int(11)
*Location_id : int(11)
*Rule_id : int(11)
*Category_id : int(11)
*Media_id : int(11)
*Source_id : int(11)
*Status_id : int(11)
*Location_Library_id : int(11)
*Keterangan_Sumber : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*IsVerified : bit(1)
*QUARANTINEDBY : int(11)
*QUARANTINEDDATE : date
*QUARANTINEDTERMINAL : varchar(100)
*ISREFERENSI : bit(1)
*EDISISERIAL : varchar(255)
*NOJILID : int(11)
*TANGGAL_TERBIT_EDISI_SERIAL : date
*BAHAN_SERTAAN : varchar(255)
*KETERANGAN_LAIN : varchar(255)
*TGLENTRYJILID : date
*IDJILID : varchar(20)
*NOMORPANGGILJILID : varchar(100)
*ISOPAC : tinyint(4)
*JILIDCREATEBY : int(11)
*KIILastUploadDate : datetime
*BookingMemberID : varchar(50)
*BookingExpiredDate : date
*IsDeposit : int(1)
*NomorDeposit : varchar(21)
*ThnTerbitDeposit : int(11)
*deposit_ws_ID : int(11)
*deposit_kode_wilayah_ID : int(11)
*Nomor_Regis : varchar(11)
v inlislite_v3 quarantined_pengiriman
*ID : int(11) unsigned
*TanggalKirim : date
*Collection_ID : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 readinlocation
*ID : double
*MemberNo : varchar(50)
*Nama : varchar(100)
*Status : varchar(50)
*Profesi : varchar(50)
*Pendidikan : varchar(50)
*JenisKelamin : varchar(50)
*Alamat : varchar(255)
*TypeIdCard : varchar(50)
*NoIdCard : varchar(50)
*NoBarcode : varchar(50)
*Title : text
*Author : text
*Publisher : varchar(255)
*ControlNumber : varchar(50)
*LocationId : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 refferenceitems
*RefferenceItemsID : int(11)
*Refference_id : int(11)
*Code : varchar(10)
*Name : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 refferences
*ID : int(11)
*Name : varchar(255)
*Format_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 requestcatalog
*ID : int(10)
*Type : varchar(50)
*Title : varchar(255)
*Subject : varchar(255)
*Author : varchar(255)
*PublishLocation : varchar(255)
*PublishYear : varchar(50)
*Publisher : varchar(50)
*Comments : text
*MemberID : double
*CallNumber : varchar(50)
*ControlNumber : varchar(50)
*DateRequest : datetime
*Status : varchar(20)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*WorksheetID : int(11)
v inlislite_v3 rfid_temp
*rfid_no : varchar(50)
*ip : varchar(50)
*status_alarm : varchar(50)
*serial_number : varchar(50)
*item_type : varchar(45)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 rolemodule
*Role_id : int(11)
*IsView : bit(1)
*IsAdd : bit(1)
*IsEdit : bit(1)
*IsDelete : bit(1)
*IsPrint : bit(1)
*Module_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 roles
*ID : int(11)
*Code : varchar(50)
*Name : varchar(255)
*IsActive : bit(1)
*Application_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*KIILastUploadDate : datetime
v inlislite_v3 route
*name : varchar(64)
*alias : varchar(64)
*type : varchar(64)
*status : smallint(6)
v inlislite_v3 sentitems
*UpdatedInDB : timestamp
*InsertIntoDB : timestamp
*SendingDateTime : timestamp
*DeliveryDateTime : timestamp
*Text : text
*DestinationNumber : varchar(20)
*Coding : enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression')
*UDH : text
*SMSCNumber : varchar(20)
*Class : int(11)
*TextDecoded : text
*ID : int(10) unsigned
*SenderID : varchar(255)
*SequencePosition : int(11)
*Status : enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error')
*StatusError : int(11)
*TPMR : int(11)
*RelativeValidity : int(11)
*CreatorID : text
*CollectionLoanItem_id : double
v inlislite_v3 serial_articlefiles
*ID : int(11)
*Articles_id : double
*FileURL : varchar(255)
*FileFlash : varchar(255)
*sizeFile : varchar(255)
*IsPublish : tinyint(4)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*IsFromMember : bit(1)
*Member_id : double
v inlislite_v3 serial_articles
*id : double
*Article_type : varchar(255)
*Title : varchar(700)
*Content : text
*Creator : varchar(700)
*Contributor : varchar(700)
*StartPage : int(11)
*Pages : int(11)
*Subject : varchar(700)
*DDC : varchar(255)
*Call_Number : varchar(255)
*EDISISERIAL : varchar(255)
*TANGGAL_TERBIT_EDISI_SERIAL : date
*Catalog_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*ISOPAC : bit(1)
*Abstract : text
v inlislite_v3 serial_articles_repeatable
*ID : bigint(20)
*serial_article_ID : double
*article_field : varchar(50)
*value : varchar(111)
*CreateBy : int(11)
*UpdateBy : int(11)
v inlislite_v3 session
*id : char(40)
*expire : int(11)
*data : blob
v inlislite_v3 settingcatalogdetail
*ID : int(11)
*Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 settingparameters
*ID : int(11)
*Name : varchar(50)
*Value : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 smslogs
*ID : int(11)
*recieverID : double
*phoneNumber : varchar(20)
*Text : text
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 status_anggota
*id : int(11)
*Nama : varchar(30)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 stockopname
*ID : int(11)
*ProjectName : varchar(100)
*TglMulai : datetime
*Tahun : int(11)
*Koordinator : varchar(100)
*Keterangan : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 stockopnamedetail
*ID : double
*StockOpnameID : int(11)
*CollectionID : double
*PrevLocationID : int(11)
*CurrentLocationID : int(11)
*PrevStatusID : int(11)
*CurrentStatusID : int(11)
*PrevCollectionRuleID : int(11)
*CurrentCollectionRuleID : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 sumbangan
*ID : int(11)
*Member_id : double
*Jumlah : decimal(10,0)
*Keterangan : varchar(45)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 sumbangan_koleksi
*ID : int(11)
*Sumbangan_id : int(11)
*Collection_id : double
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 survey
*ID : int(11)
*NamaSurvey : varchar(200)
*TanggalMulai : datetime
*TanggalSelesai : datetime
*IsActive : bit(1)
*NomorUrut : int(11)
*TargetSurvey : int(11)
*HasilSurveyShow : int(11)
*RedaksiAwal : text
*RedaksiAkhir : text
*Keterangan : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 survey_isian
*ID : int(11)
*Survey_Pertanyaan_id : int(11)
*Sesi : varchar(255)
*MemberNo : varchar(50)
*Isian : text
v inlislite_v3 survey_pertanyaan
*ID : int(11)
*Survey_id : int(11)
*Pertanyaan : text
*JenisPertanyaan : varchar(20)
*Orientation : varchar(20)
*IsMandatory : bit(1)
*IsCanMultipleAnswer : bit(1)
*NoUrut : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 survey_pilihan
*ID : int(11)
*Survey_Pertanyaan_id : int(11)
*Pilihan : text
*ChoosenCount : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 survey_pilihan_sesi
*ID : int(11)
*Survey_Pilihan_id : int(11)
*MemberNo : varchar(50)
*Sesi : varchar(255)
v inlislite_v3 tempnoinduk
*ID : double
*NoInduk : varchar(50)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 tujuan_kunjungan
*ID : int(11)
*Code : varchar(100)
*TujuanKunjungan : varchar(255)
*Member : tinyint(1)
*NonMember : tinyint(1)
*Rombongan : tinyint(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 user
*id : int(11)
*username : varchar(255)
*auth_key : varchar(32)
*password_hash : varchar(255)
*password_reset_token : varchar(255)
*email : varchar(255)
*status : smallint(6)
*created_at : int(11)
*updated_at : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 userloclibforcol
*User_id : int(11)
*LocLib_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 userloclibforloan
*User_id : int(11)
*LocLib_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 userlogs
*User_id : int(11)
*Name : varchar(255)
*Description : varchar(255)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 users
*ID : int(11)
*username : varchar(50)
*password : varchar(255)
*auth_key : varchar(32)
*password_hash : varchar(255)
*password_reset_token : varchar(255)
*status : smallint(10)
*PhotoUrl : varchar(255)
*Fullname : varchar(255)
*EmailAddress : varchar(255)
*IsActive : bit(1)
*SesID : varchar(255)
*MaxDateSesID : datetime
*ActivationCode : varchar(255)
*LoginAttemp : int(11)
*LastSubmtLogin : datetime
*LastSuccess : datetime
*Department_id : int(11)
*Branch_id : int(11)
*Role_id : int(11)
*IsCanResetUserPassword : bit(1)
*IsCanResetMemberPassword : bit(1)
*IsAdvanceEntryCatalog : bit(1)
*IsAdvanceEntryCollection : bit(1)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*created_at : int(11)
*updated_at : int(11)
*KIILastUploadDate : datetime
v inlislite_v3 v_abjadopac
*A : varchar(1)
v inlislite_v3 v_lap_kriteria_anggota
*kriteria : varchar(14)
*id_dtl_anggota : varchar(255)
*dtl_anggota : varchar(255)
v inlislite_v3 v_lap_kriteria_koleksi
*kriteria : varchar(19)
*id_dtl_kriteria : text
*dtl_kriteria : text
v inlislite_v3 v_pertumb_jml_kunjungan
*kriteria : varchar(10)
*tahun : bigint(20)
*jumlah : bigint(21)
v inlislite_v3 v_pertumb_jml_kunjungan_bulanan
*kriteria : varchar(10)
*tahun : bigint(20)
*bulan : bigint(20)
*jumlah : decimal(32,0)
v inlislite_v3 v_stat_anggota
*tahun : int(4)
*bulan : int(2)
*jumlah : bigint(21)
*jenisanggota : varchar(50)
*IDjenisanggota : int(11)
v inlislite_v3 v_stat_colectionloan
*tahun : int(4)
*bulan : int(1)
*jumlah_judul : int(2)
*jumlah_eksemplar : int(3)
*jumlah_dijital : int(2)
v inlislite_v3 v_stat_jenis_pendidikan
*Keterangan : varchar(50)
*Jumlah : bigint(21)
*Tahun : varchar(4)
*bulan : int(2)
v inlislite_v3 v_stat_jumlah_koleksi
*bulan : int(2)
*tahun : int(4)
*jumlah_judul : bigint(21)
*jumlah_eksemplar : bigint(21)
*jumlah_dijital : bigint(21)
v inlislite_v3 v_stat_kelas_subjek
*Keterangan : varchar(255)
*Jumlah : int(11)
*Tahun : int(4)
v inlislite_v3 v_stat_koleksi_dipinjam_eksemplar
*tahun : int(4)
*bulan : int(2)
*jumlah_eksemplar : bigint(21)
v inlislite_v3 v_stat_koleksi_dipinjam_judul
*tahun : int(4)
*bulan : int(2)
*jumlah_judul : bigint(21)
v inlislite_v3 v_stat_pendidikan
*Nama : varchar(50)
*Jumlah : int(11)
*Tahun : int(4)
v inlislite_v3 v_stat_rangeumur_kunj
*Keterangan : varchar(200)
*Tahun : varchar(4)
*Jumlah : bigint(21)
v inlislite_v3 v_stat_rangeumur_kunj_bulanan
*Keterangan : varchar(200)
*Tahun : varchar(4)
*bulan : int(2)
*Jumlah : bigint(21)
v inlislite_v3 worksheetfielditems
*WorksheetField_id : int(11)
*Name : varchar(255)
*RefferenceMode : varchar(20)
*StartPosition : int(11)
*Length : int(11)
*DefaultValue : varchar(255)
*IdemTag : varchar(255)
*IdemStartPosition : int(11)
*Refference_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
v inlislite_v3 worksheetfields
*ID : int(11)
*Field_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*Worksheet_id : int(11)
*IsAkuisisi : bit(1)
*ISDEPOSIT : bit(1)
*ISDETAILKOLEKSI_PENGOLAHAN : bit(1)
*ISDETAILKOLEKSI_AKUISISI : bit(1)
v inlislite_v3 worksheets
*ID : int(11)
*Name : varchar(100)
*Format_id : int(11)
*CreateBy : int(11)
*CreateDate : datetime
*CreateTerminal : varchar(100)
*UpdateBy : int(11)
*UpdateDate : datetime
*UpdateTerminal : varchar(100)
*NoUrut : int(11)
*DEPOSITFORMAT_CODE : varchar(5)
*ISSERIAL : tinyint(1)
*ISMUSIK : bit(1)
*ISKARTOGRAFI : bit(1)
*CODE : varchar(10)
*Keterangan : varchar(255)
*MaxPinjamKoleksi : int(11)
*MaxLoanDays : int(11)
*DendaType : varchar(45)
*DendaTenorJumlah : decimal(10,0)
*DendaTenorSatuan : varchar(45)
*DendaPerTenor : decimal(10,0)
*DendaTenorMultiply : int(11)
*SuspendMember : bit(1)
*WarningLoanDueDay : int(11)
*SuspendType : varchar(45)
*SuspendTenorJumlah : double
*SuspendTenorSatuan : varchar(45)
*DaySuspend : int(11)
*SuspendTenorMultiply : int(11)
*DayPerpanjang : int(11)
*CountPerpanjang : int(11)
*IsBerisiArtikel : bit(1)