Print view - phpMyAdmin 4.9.0.1

accreditation_document

Column	Type	Null	Default
document_id (Primary)	int	No
document_event_id	int	No
document_name	varchar(100)	Yes	NULL
document_file_name	varchar(150)	No
document_profile_id	varchar(6)	No
document_insert_by	varchar(6)	No
document_insert_date	datetime	No
document_approval_status	char(1)	No	A
document_record_status	char(1)	No	A

Indexes

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

accreditation_event

Column	Type	Null	Default	Comments
event_id (Primary)	int	No
event_category_id	int	No
event_partnership_id	char(2)	No
event_barcode	varchar(7)	Yes	NULL
event_name	text	No
event_topic_group	varchar(200)	No
event_institution_group_id	char(2)	No
event_institution_ownership_id	char(2)	No
event_institution_code_old	char(11)	No
event_institution_code	varchar(11)	No
event_institution_name	varchar(250)	No
event_institution_id	varchar(6)	No
event_location_id	int	No
event_province_code	varchar(3)	Yes	NULL
event_province_name	varchar(25)	No
event_city_code	int	Yes	NULL
event_city_name	varchar(25)	No
event_certificate_date	varchar(25)	Yes	NULL
event_address_other	varchar(150)	Yes	NULL
event_start_date_plan	date	Yes	NULL
event_end_date_plan	date	Yes	NULL
event_start_date	date	Yes	NULL
event_end_date	date	Yes	NULL
event_note	text	Yes	NULL
event_package_id	varchar(10)	No		Paket Bimbingan
event_package_chapter_id	varchar(20)	No
event_is_webinar	int	Yes	NULL
event_is_ecertificate	char(1)	No	0
event_workshop_capacity	int	No	450
event_price	varchar(20)	Yes	NULL
event_funds_source	char(1)	No		Usulan Dana: 1: DAK
event_price_personal	decimal(12,2)	Yes	NULL
event_is_internal	int	Yes	NULL
event_dinkesCity_is_approved	char(1)	Yes	NULL
event_dinkesCity_approve_date	datetime	Yes	NULL
event_dinkesCity_approve_by	int	Yes	NULL
event_dinkesProv_is_approved	char(1)	Yes	NULL
event_dinkesProv_approve_date	datetime	Yes	NULL
event_dinkesProv_approve_by	varchar(6)	Yes	NULL
event_is_approved	int	Yes	NULL
event_approve_date	datetime	Yes	NULL
event_approve_by	char(5)	No
event_reply_letter_number	varchar(10)	Yes	NULL
event_reply_letter_date	date	No
event_document_amount	int	No	0	Jumlah Dokumen yang diupload
event_billing_pic	varchar(50)	Yes	NULL
event_billing_pic_phone	varchar(15)	Yes	NULL
event_institution_letter_number	varchar(30)	Yes	NULL
event_institution_letter_date	date	Yes	NULL
event_invoice_number	varchar(10)	No
event_billing_price	decimal(12,2)	Yes	NULL
event_billing_ticket	decimal(12,2)	Yes	NULL
event_billing_transport	decimal(12,2)	Yes	NULL
event_billing_close_status	int	Yes	0
event_billing_close_date	date	Yes	NULL
event_billing_code_transaction	varchar(13)	Yes	NULL
event_accreditation_id_reference	int	Yes	NULL	Nomor Accreditation_ID yang akan remedial
event_id_reference	int	Yes	NULL
event_accreditation_version	char(4)	No
event_hospital_pic	int	Yes	NULL
event_surveyor_amount	char(2)	No	0	Jumlah surveior yang terjadwal
event_participant_amount	varchar(5)	No
event_pic_name	varchar(200)	Yes	NULL
event_pic_phone	varchar(100)	Yes	NULL
event_instrument_status	int	No	0
event_signed_file	varchar(150)	Yes	NULL	Status pengisian laporan self assessment
event_signed_name	varchar(100)	Yes	NULL
event_institution_evaluation1_status	char(1)	No		evaluasi institusi terhadap surveior dan sebelum nilai keluar
event_institution_evaluation1_update_date	datetime	No
event_institution_evaluation2_status	char(1)	No		Evaluasi institusi setelah nilai keluar
event_institution_evaluation2_update_date	datetime	No
event_surveior_evaluation_status	char(1)	No		Evaluasi Surveior 360 derajat
event_surveior_evaluation_update_date	datetime	No
event_order_id	varchar(3)	No
event_operator_id	int	Yes	NULL	ID Penyelenggara
event_insert_date	datetime	No
event_insert_by	char(6)	No
event_update_date	datetime	No
event_update_by	char(6)	No
event_delete_date	datetime	No
event_delete_by	char(6)	No
event_record_status	char(1)	No
event_survey_id	int	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	event_id	3	A	No
event_institution_code	BTREE	No	No	event_institution_code_old	1	A	No
event_institution_code_2	BTREE	No	No	event_institution_code	1	A	No

accreditation_event_category

Column	Type	Null	Default
category_id (Primary)	int	No
category_code	varchar(5)	Yes	NULL
category_name	varchar(50)	No
category_price	varchar(20)	Yes	NULL
category_version	year	No
category_post_date	datetime	No
category_user_id	int	No
category_record_status	char(1)	No

Indexes

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

accreditation_event_document

Column	Type	Null	Default
document_id (Primary)	int	No
document_event_id	int	No
document_type	varchar(2)	No
document_name	varchar(100)	Yes	NULL
document_file_name	varchar(150)	No
document_insert_by	char(6)	No
document_insert_date	datetime	No
document_update_by	char(6)	No
document_update_date	datetime	No
document_delete_by	char(6)	No
document_delete_date	datetime	No
document_approval_status	char(1)	No	A
document_record_status	char(1)	No	A

Indexes

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

accreditation_instrument

Column	Type	Null	Default	Comments
instrument_id (Primary)	int	No
instrument_reference_code	varchar(15)	No
instrument_order_id	int	No
instrument_name	text	No
instrument_objective	text	No
instrument_material	text	No
instrument_document	text	No
instrument_maximum_score	int	No	10
instrument_standard_id	int	No
instrument_chapter_id	int	No
instrument_class_id	int	No
instrument_version	year	No
instrument_institution_group_id	int	Yes	NULL	1=KARS;2=FKTP;3=Klinik;4=Praktek Dokter
instrument_r	text	Yes	NULL
instrument_d	text	Yes	NULL
instrument_o	text	Yes	NULL
instrument_w	text	Yes	NULL
instrument_s	text	Yes	NULL
instrument_update	datetime	No
instrument_user_id	int	No
instrument_record_status	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	instrument_id	5527	A	No

accreditation_instrument_chapter

Column	Type	Null	Default
chapter_id (Primary)	int	No
chapter_class_id	int	No
chapter_institution_group_id	varchar(2)	No
chapter_code	varchar(10)	No
chapter_name	varchar(75)	No
chapter_maximum_score	int	No
chapter_type	varchar(15)	Yes	NULL
chapter_package	int	Yes	NULL
chapter_progsus	int	Yes	NULL
chapter_package_order	int	Yes	NULL
chapter_specialize_id	char(1)	No
chapter_version	year	No
chapter_post_date	datetime	No
chapter_user_id	int	No
chapter_record_status	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	chapter_id	80	A	No

accreditation_instrument_class

Column	Type	Null
class_id (Primary)	int	No
class_name	varchar(50)	No
class_maximum_score	int	No
class_version	year	No
class_post_date	datetime	No
class_user_id	int	No
class_record_status	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	class_id	9	A	No

accreditation_instrument_standard

Column	Type	Null	Default
standard_id (Primary)	int	No
standard_chapter_id	int	No
standard_code	varchar(20)	No
standard_focus	varchar(100)	Yes	NULL
standard_name	text	No
standard_objective	text	No
standard_maximum_score	int	No	0
standard_version	year	No
standard_post_date	datetime	No
standard_user_id	int	No
standard_record_status	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	standard_id	1459	A	No

accreditation_instrument_view

Table comments: VIEW

Column	Type	Null	Default	Comments
instrument_id	int	No	0
instrument_reference_code	varchar(15)	No
instrument_order_id	int	No
instrument_name	text	No
instrument_objective	text	No
instrument_material	text	No
instrument_document	text	No
instrument_maximum_score	int	No	10
instrument_standard_id	varchar(20)	Yes	NULL
standard_name	text	Yes	NULL
instrument_standard_code	varchar(20)	Yes	NULL
standard_code	varchar(20)	Yes	NULL
standard_id	int	Yes	0
instrument_chapter_id	int	No
chapter_code	varchar(10)	Yes	NULL
chapter_name	varchar(75)	Yes	NULL
chapter_maximum_score	int	Yes	NULL
chapter_progsus	int	Yes	NULL
chapter_package	int	Yes	NULL
chapter_package_order	int	Yes	NULL
instrument_r	text	Yes	NULL
instrument_d	text	Yes	NULL
instrument_o	text	Yes	NULL
instrument_w	text	Yes	NULL
instrument_s	text	Yes	NULL
instrument_class_id	int	No
class_name	varchar(50)	Yes	NULL
instrument_version	year	No
instrument_institution_group_id	int	Yes	NULL	1=KARS;2=FKTP;3=Klinik;4=Praktek Dokter
instrument_record_status	char(1)	No

accreditation_pps

Column	Type	Null	Default
pps_id (Primary)	int	No
pps_transaction_id	int	No
pps_event_id	int	No
pps_institution_code	int	No
pps_chapter_id	int	No
pps_instrument_id	int	No
pps_reference_code	varchar(100)	No
pps_surveyor_score	varchar(5)	No
pps_fact_and_analysis	text	No
pps_recommendation	text	No
pps_tl	varchar(1)	Yes	NULL
pps_document	varchar(255)	Yes	NULL
pps_update_date	datetime	No	CURRENT_TIMESTAMP
pps_update_by	int	No	0
pps_metode	text	No
pps_indicator	text	No
pps_time	varchar(50)	No
pps_pic	varchar(50)	No
pps_feedback	text	No
pps_feedback_by	varchar(50)	No
pps_description	text	No
pps_record_status	varchar(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	pps_id	151	A	No

accreditation_pps_detail

Column	Type	Null	Default
detail_id (Primary)	int	No
detail_pps_id	int	No
detail_document	varchar(255)	Yes	NULL
detail_update_date	datetime	No	CURRENT_TIMESTAMP
detail_update_by	int	No	0
detail_description	varchar(200)	No
detail_record_status	varchar(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	detail_id	655	A	No

accreditation_status

Column	Type	Null	Default
status_id (Primary)	int	No
status_name	varchar(30)	No
status_version	year	No
status_picture	varchar(50)	Yes	NULL
status_post_date	datetime	No
status_user_id	int	No
status_order	int	Yes	NULL
status_record_status	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	status_id	7	A	No

accreditation_transaction

Column	Type	Null	Default
transaction_id (Primary)	int	No
transaction_accreditation_id	int	No
transaction_event_id	int	No
transaction_instrument_id	int	No
transaction_chapter_id	int	Yes	NULL
transaction_class_id	int	Yes	NULL
transaction_standard_id	int	Yes	NULL
transaction_institution_id	int	No
transaction_institution_score	varchar(3)	Yes	NULL
transaction_institution_update_date	datetime	Yes	NULL
transaction_institution_update_by	int	Yes	NULL
transaction_institution_is_approved	int	Yes	NULL
transaction_institution_approve_date	datetime	Yes	NULL
transaction_surveyor_update_by	char(5)	Yes	NULL
transaction_surveyor_score	varchar(3)	Yes	0
transaction_surveyor_fact_and_analysis	text	Yes	NULL
transaction_surveyor_recommendation	text	Yes	NULL
transaction_surveyor_need_to_discussed	int	Yes	NULL
transaction_surveyor_update_date	datetime	Yes	NULL
transaction_counselor_update_by	char(5)	Yes	NULL
transaction_counselor_score	varchar(3)	Yes	0
transaction_counselor_fact_and_analysis	text	Yes	NULL
transaction_counselor_note	text	Yes	NULL
transaction_counselor_message	text	Yes	NULL
transaction_evaluation_x1	char(1)	No
transaction_evaluation_x2	char(1)	No
transaction_evaluation_x3	char(1)	No
transaction_counselor_update_date	datetime	Yes	NULL
transaction_counselor_is_approved	int	Yes	NULL
transaction_counselor_approved_date	date	Yes	NULL
transaction_remedial_surveyor_update_by	char(5)	Yes	NULL
transaction_remedial_surveyor_score	varchar(3)	Yes	NULL
transaction_remedial_surveyor_fact_and_analysis	text	Yes	NULL
transaction_remedial_surveyor_recommendation	text	Yes	NULL
transaction_remedial_surveyor_update_date	datetime	Yes	NULL
transaction_final_score	varchar(3)	Yes	0
transaction_is_evaluated	int	Yes	NULL
transaction_is_discussed	int	Yes	NULL
transaction_verification_1	varchar(10)	Yes	NULL
transaction_verification_1_recommendation	text	Yes	NULL
transaction_verification_1_insert_by	varchar(6)	No
transaction_verification_1_insert_date	datetime	No
transaction_verification_2	varchar(10)	Yes	NULL
transaction_verification_2_recommendation	text	Yes	NULL
transaction_verification_2_insert_by	varchar(6)	No
transaction_verification_2_insert_date	datetime	No
transaction_record_status	char(1)	No
transaction_period	year	No

Indexes

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

accreditation_transaction_chapter

Column	Type	Null	Default	Comments
trans_id (Primary)	int	No
trans_event_id	int	No
trans_chapter_id	int	No
trans_institution_code_old	varchar(11)	No
trans_institution_group_id	int	No
trans_institution_code	varchar(11)	Yes	NULL
trans_institution_score	varchar(5)	Yes	NULL
trans_institution_date	datetime	Yes	NULL
trans_surveyor_update_by	int	Yes	NULL
trans_remedial_surveyor_score	float	Yes	NULL
trans_surveyor_score	float	Yes	NULL
trans_remedial_surveyor_date	datetime	Yes	NULL
trans_surveyor_date	datetime	Yes	NULL
trans_counselor_update_by	int	Yes	NULL
trans_counselor_score	float	Yes	NULL
trans_counselor_date	datetime	Yes	NULL
trans_remedial_surveyor_update_by	int	Yes	NULL
trans_final_score_0	int	No
trans_final_score_5	int	No
trans_final_score_10	int	No
trans_final_score	float	Yes	NULL
trans_final_is_tdd	int	No	0
trans_verification_1	char(1)	Yes	NULL
trans_verification_2	char(1)	Yes	NULL
trans_status_id	char(2)	Yes	NULL	1 = Merah; 2 = Kuning; 3 = Hijau
trans_surveyor_value	text	No
trans_remedial_surveyor_value	text	No
trans_counselor_value	text	No
trans_insert_date	datetime	No
trans_insert_by	int	No
trans_record_status	enum('A', 'D')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	trans_id	58	A	No
trans_institution_code	BTREE	No	No	trans_institution_code_old	1	A	No
trans_institution_code_2	BTREE	No	No	trans_institution_code	1	A	Yes

browsereg

Table comments: VIEW

Column	Type	Null	Default
rowid	int	No	0
cp2reffcode0	double	No
regunit_unitid	char(10)	No
namaunit	varchar(255)	Yes	NULL
status	int	Yes	0
flddisable	bit(1)	Yes	NULL

competency

Column	Type	Null	Default
competency_id (Primary)	int	No
competency_category_id	int	Yes	NULL
competency_category	varchar(16)	Yes	NULL
competency_sub_category_id	varchar(4)	Yes	NULL
competency_sub_category	varchar(25)	Yes	NULL
competency_specialize_id	varchar(6)	Yes	NULL
competency_specialize	varchar(20)	Yes	NULL
competency_sub_specialize_id	varchar(8)	Yes	NULL
competency_sub_specialize	varchar(30)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	competency_id	92	A	No

config

Column	Type	Null
config_id (Primary)	int	No
config_attribute	varchar(25)	No
config_operator	varchar(10)	No
config_value	varchar(16)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	config_id	2	A	No

filemanager

Column	Type	Null	Default
filemanager_id (Primary)	int	No
filemanager_profile_id	int	No
filemanager_rootDir	char(200)	No
filemanager_readonly	int	No	0
filemanager_userDir	char(200)	No
filemanager_hideDirNames	char(200)	No
filemanager_enableUpload	int	No
filemanager_enableDownload	int	No
filemanager_enableBulkDownload	int	No
filemanager_enableEdit	int	No
filemanager_enableDelete	int	No
filemanager_enableRestore	int	No
filemanager_enableRename	int	No
filemanager_enablePermissions	int	No
filemanager_enableMove	int	No
filemanager_enableCopy	int	No
filemanager_enableNewDir	int	No
filemanager_enableSearch	int	No
filemanager_institution_code	varchar(11)	Yes	NULL
filemanager_post_date	datetime	No
filemanager_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	filemanager_id	17	A	No

hsi_module

Column	Type	Null	Default
module_id (Primary)	int	No
module_name	varchar(255)	Yes	NULL
last_updated	datetime	No	CURRENT_TIMESTAMP

Indexes

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

hsi_module_detail

Column	Type	Null	Default	Links to
module_id (Primary)	int	No		hsi_module -> module_id
sublist_id (Primary)	int	No		hsi_module_sublist -> sublist_id
last_updated	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	module_id	3	A	No
PRIMARY	BTREE	Yes	No	sublist_id	23	A	No
sublist_id	BTREE	No	No	sublist_id	23	A	No

hsi_module_item

Column	Type	Null	Default
item_id (Primary)	int	No
item_title	varchar(255)	Yes	NULL
security_lv_low	varchar(255)	Yes	NULL
security_lv_medium	varchar(255)	Yes	NULL
security_lv_high	varchar(255)	Yes	NULL
additional_note	varchar(255)	Yes	NULL
item_hazard	varchar(255)	Yes	NULL
item_weight	double	Yes	NULL
last_updated	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	item_id	151	A	No

hsi_module_result

Column	Type	Null	Default
result_id (Primary)	int	No
institution_code	int	Yes	NULL
json_result	text	Yes	NULL
created_at	datetime	Yes	NULL
result_inserted_by	varchar(6)	Yes	NULL
result_updated_by	varchar(6)	Yes	NULL
result_updated_date	datetime	Yes	NULL
result_record_status	varchar(1)	Yes	A
result_deleted_by	varchar(6)	Yes	NULL
result_deleted_date	datetime	Yes	NULL

Indexes

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

hsi_module_sublist

Column	Type	Null	Default
sublist_id (Primary)	int	No
sublist_name	varchar(255)	Yes	NULL
last_updated	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	sublist_id	23	A	No

hsi_module_sublist_detail

Column	Type	Null	Default	Links to
sublist_id (Primary)	int	No		hsi_module_sublist -> sublist_id
item_id (Primary)	int	No		hsi_module_item -> item_id
last_updated	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	sublist_id	21	A	No
PRIMARY	BTREE	Yes	No	item_id	151	A	No
item_id	BTREE	No	No	item_id	151	A	No

hsi_module_sublist_sublist

Column	Type	Null	Default	Links to	Comments	MIME
sublist_sublist_id (Primary)	int	No
sublist_sublist_name	varchar(255)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	sublist_sublist_id	10	A	No

hsi_update_log

Column	Type	Null	Default	Links to	Comments	MIME
update_id (Primary)	int	No
update_time	datetime	No

Indexes

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

institution

Column	Type	Null	Default	Comments
institution_id (Primary)	int	No
institution_group_id	char(2)	No
institution_code	varchar(15)	Yes	NULL
institution_registration_code	varchar(15)	Yes	NULL
institution_name	varchar(36)	Yes	NULL
institution_province_code	varchar(2)	No
institution_city_code	varchar(5)	No
institution_address	varchar(250)	Yes	NULL
institution_district_code	varchar(7)	No
institution_district_name	varchar(31)	Yes	NULL
institution_city_name	varchar(26)	Yes	NULL
institution_province_name	varchar(19)	Yes	NULL
institution_care_code	int	No		Kode Pelayanan: 1=Rawat Inap; 2+Non Rawat Inap
institution_area_characteristic_code	int	No		1=Perkotaan;2=Pedesaan;3=Terpencil;4=Sangat terpencil
institution_publication_date	date	No
institution_type	varchar(14)	Yes	NULL
institution_class	varchar(2)	Yes	NULL
institution_ownership_id	varchar(2)	Yes	NULL
institution_ownership_name	varchar(30)	Yes	NULL
institution_director	varchar(100)	Yes	NULL
institution_director_email	varchar(100)	Yes	NULL
institution_email	varchar(100)	Yes	NULL
institution_specialize	varchar(5)	Yes	NULL
institution_is_education	char(1)	Yes	NULL
institution_is_partnership	int	Yes	0
institution_partnership_ed	date	Yes	NULL
institution_total_bed	varchar(5)	Yes	NULL
institution_start_date	date	Yes	NULL
institution_operational_number	varchar(100)	Yes	NULL
institution_operational_date_end	date	Yes	NULL
institution_ipal_number	varchar(100)	Yes	NULL
institution_ipal_date_end	date	Yes	NULL
institution_waste_number	varchar(100)	Yes	NULL
institution_waste_date_end	date	Yes	NULL
institution_distance	varchar(250)	Yes	NULL
institution_other_information	text	Yes	NULL
institution_longitude	varchar(30)	Yes	NULL
institution_latitude	varchar(30)	Yes	NULL
institution_accreditation_status	int	Yes	NULL
institution_accreditation_status_date	date	Yes	NULL
institution_accreditation_expired	date	Yes	NULL
institution_insert_date	datetime	Yes	NULL
institution_insert_by	varchar(6)	Yes	NULL
institution_update_date	datetime	Yes	NULL
institution_update_by	varchar(6)	Yes	NULL
institution_delete_date	datetime	Yes	NULL
institution_delete_by	varchar(6)	Yes	NULL
institution_record_status	char(1)	No	A

Indexes

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

institution_group

Column	Type	Null	Default
group_id (Primary)	int	No
group_name	varchar(25)	No
group_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	group_id	6	A	No

kalmut_devopvarmutu

Column	Type	Null	Default
recid (Primary)	double	No
idtopikmutu	double(5,0)	No
indicator_id	int	Yes	NULL
vardescription	varchar(255)	Yes	NULL
varnama	varchar(15)	Yes	NULL
varposisi	varchar(15)	Yes	NULL
mcmmutu	varchar(11)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	recid	221	A	No

kalmut_jeniskalkulasi

Column	Type	Null	Default	Links to	Comments	MIME
rowid (Primary)	int	No
jeniskalkulasi	varchar(10)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rowid	2	A	No

kalmut_katalogmutu

Column	Type	Null	Default	Comments
rowid (Primary)	int	No
kodeunit	varchar(11)	Yes	NULL
idtopikmutu (Primary)	double(5,0)	No
indicator_id	int	Yes	NULL
indicator_uuid	varchar(100)	Yes	NULL
indicator_category_id	int	Yes	NULL	deprecated
judulsheet	text	Yes	NULL
jenispengerjaan	varchar(100)	Yes	NULL
chart1	varchar(100)	Yes	NULL
chart2	varchar(100)	Yes	NULL
jumlahvb	int	Yes	NULL
formulatype	varchar(10)	Yes	NULL
formula	text	Yes	NULL
tobenchmark	int	Yes	NULL
judultopik	text	Yes	NULL
share2	varchar(11)	Yes	NULL
status	int	Yes	0
flddisable	bit(1)	Yes	NULL
idtopikmutu_map	int	No
namaimut_map	text	No
temp0	varchar(1)	Yes	NULL
catatan_mapping	varchar(25)	Yes	NULL
editimutkars	int	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rowid	110	A	No
PRIMARY	BTREE	Yes	No	idtopikmutu	110	A	No

kalmut_katalogmutu_deskripsi

Column	Type	Null	Default
rowid (Primary)	int	No
idtopikmutu (Primary)	double(5,0)	No
indicator_id	int	Yes	NULL
indicator_uuid	varchar(100)	Yes	NULL
ruanglingkup	varchar(120)	Yes	NULL
dimensimutu	varchar(120)	Yes	NULL
latarbelakang	varchar(200)	Yes	NULL
alasanpemilihan	varchar(200)	Yes	NULL
tipeindikator_s	char(1)	Yes	NULL
tipeindikator_p	char(1)	Yes	NULL
tipeindikator_h	char(1)	Yes	NULL
tujuan	varchar(200)	Yes	NULL
defop	text	Yes	NULL
metodepengumpulandata	varchar(200)	Yes	NULL
freqdatacollect	varchar(30)	Yes	NULL
periodeanalisis	varchar(30)	Yes	NULL
jumlahvarmutu	int	Yes	NULL
nominator	text	Yes	NULL
denominator	text	Yes	NULL
jumlahvb	int	Yes	NULL
formulatype	varchar(10)	Yes	NULL
formula	tinytext	Yes	NULL
satuan	varchar(30)	Yes	NULL
sumberdata	varchar(200)	Yes	NULL
standar	varchar(60)	Yes	NULL
target	varchar(60)	Yes	NULL
collectorpenanggungjawab	varchar(100)	Yes	NULL
mcmmutu	varchar(11)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rowid	110	A	No
PRIMARY	BTREE	Yes	No	idtopikmutu	110	A	No

kalmut_katalogmutu_unit

Column	Type	Null	Default
rowid (Primary)	int	No
kodeunit (Primary)	varchar(11)	No
mcmmutu	varchar(11)	No
idtopikmutu (Primary)	double(5,0)	No
indicator_id	int	Yes	NULL
judultopik	varchar(150)	Yes	NULL
judulsheet	varchar(100)	Yes	NULL
jenispengerjaan	varchar(100)	Yes	NULL
chart1	varchar(100)	Yes	NULL
chart2	varchar(100)	Yes	NULL
jumlahvb	int	Yes	NULL
formulatype	varchar(10)	Yes	NULL
formula	tinytext	Yes	NULL
tobenchmark	int	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	rowid	94	A	No
				kodeunit	94	A	No
				idtopikmutu	94	A	No

kalmut_kategorimutu

Column	Type	Null	Default	Links to	Comments	MIME
rowid (Primary)	int	No
KategoriMutu	varchar(30)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rowid	5	A	No

kalmut_modules

Column	Type	Null	Default	Comments
modules_id (Primary)	int	No
modules_category	int	No		1 = KARS; 2 = FKTP
modules_title	varchar(50)	No
modules_description	varchar(50)	No
modules_link	varchar(100)	No	#
modules_is_display	char(1)	No	0
modules_parent	int	No
modules_position	char(5)	No
modules_icon	varchar(30)	No
modules_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	modules_id	2	A	No

kalmut_pengaksesunit

Column	Type	Null	Default
rowid (Primary)	double	No
profile_fullname	varchar(100)	No
user_name	varchar(50)	No
user_profile_id	varchar(6)	No
accessedunit	char(10)	No
accessedtime	datetime	Yes	NULL
acces_del	char(1)	Yes	NULL
acces_add	char(1)	Yes	NULL
acces_edit	char(1)	Yes	NULL

Indexes

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

kalmut_quality_indicator_group

Column	Type	Null	Default	Comments
group_id (Primary)	int	No
group_indicator_id	varchar(5)	No
group_department_id	varchar(5)	No
group_institution_code	varchar(11)	Yes	NULL
group_period	varchar(4)	Yes	NULL
group_type	char(1)	No		1 = Nasional; 2= Lokal
group_record_status	char(1)	No	A

Indexes

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

kalmut_regactivity_period_perunit

Column	Type	Null
rowid (Primary)	double	No
parentid_reffcode1	double	No
periode	int	No
cp2reffcode2 (Primary)	double	No

Indexes

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

kalmut_registeredunit

Column	Type	Null	Default
rowid (Primary)	int	No
cp2reffcode0	double	No
user_id	int	Yes	NULL
regunit_institution_code	varchar(11)	No
regunit_unitid	char(10)	No
regunit_regdate	datetime	No
regunit_regbyprofemail	varchar(100)	Yes	NULL
activitynotes	varchar(100)	Yes	NULL

Indexes

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

kalmut_regqualityunit

Column	Type	Null	Default
rowid (Primary)	double	No
parentid_reffcode0	double	No
idtopikmutu	double(3,0)	No
judultopik	varchar(150)	Yes	NULL
cp2reffcode1 (Primary)	double	No

Indexes

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

kalmut_sheet_mutu1_dtl

Column	Type	Null	Default
recid (Primary)	double(9,0)	No
parent_recid	double	Yes	NULL
idtopikmutu	double(5,0)	Yes	NULL
indicator_id	int	Yes	NULL
namavariabel	varchar(15)	Yes	NULL
posisivariabel	varchar(15)	Yes	NULL
day1	double(5,0)	Yes	0
day2	double(5,0)	Yes	0
day3	double(5,0)	Yes	0
day4	double(5,0)	Yes	0
day5	double(5,0)	Yes	0
day6	double(5,0)	Yes	0
day7	double(5,0)	Yes	0
day8	double(5,0)	Yes	0
day9	double(5,0)	Yes	0
day10	double(5,0)	Yes	0
day11	double(5,0)	Yes	0
day12	double(5,0)	Yes	0
day13	double(5,0)	Yes	0
day14	double(5,0)	Yes	0
day15	double(5,0)	Yes	0
day16	double(5,0)	Yes	0
day17	double(5,0)	Yes	0
day18	double(5,0)	Yes	0
day19	double(5,0)	Yes	0
day20	double(5,0)	Yes	0
day21	double(5,0)	Yes	0
day22	double(5,0)	Yes	0
day23	double(5,0)	Yes	0
day24	double(5,0)	Yes	0
day25	double(5,0)	Yes	0
day26	double(5,0)	Yes	0
day27	double(5,0)	Yes	0
day28	double(5,0)	Yes	0
day29	double(5,0)	Yes	0
day30	double(5,0)	Yes	0
day31	double(5,0)	Yes	0
totentry	double(6,2)	Yes	0.00

Indexes

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

kalmut_sheet_mutu1_dtl_summary

Column	Type	Null	Default
recid (Primary)	double(9,0)	No
parent_recid	double	Yes	NULL
idtopikmutu	double(5,0)	Yes	NULL
indicator_id	int	Yes	NULL
day1	double(6,2)	Yes	0.00
day2	double(6,2)	Yes	0.00
day3	double(6,2)	Yes	0.00
day4	double(6,2)	Yes	0.00
day5	double(6,2)	Yes	0.00
day6	double(6,2)	Yes	0.00
day7	double(6,2)	Yes	0.00
day8	double(6,2)	Yes	0.00
day9	double(6,2)	Yes	0.00
day10	double(6,2)	Yes	0.00
day11	double(6,2)	Yes	0.00
day12	double(6,2)	Yes	0.00
day13	double(6,2)	Yes	0.00
day14	double(6,2)	Yes	0.00
day15	double(6,2)	Yes	0.00
day16	double(6,2)	Yes	0.00
day17	double(6,2)	Yes	0.00
day18	double(6,2)	Yes	0.00
day19	double(6,2)	Yes	0.00
day20	double(6,2)	Yes	0.00
day21	double(6,2)	Yes	0.00
day22	double(6,2)	Yes	0.00
day23	double(6,2)	Yes	0.00
day24	double(6,2)	Yes	0.00
day25	double(6,2)	Yes	0.00
day26	double(6,2)	Yes	0.00
day27	double(6,2)	Yes	0.00
day28	double(6,2)	Yes	0.00
day29	double(6,2)	Yes	0.00
day30	double(6,2)	Yes	0.00
day31	double(6,2)	Yes	0.00
totentry	double(6,2)	Yes	0.00
rerata	double(6,2)	Yes	0.00
satuan	varchar(30)	Yes	NULL
standar	varchar(60)	Yes	0
target	varchar(60)	Yes	0
tobenchmark	int	Yes	NULL

Indexes

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

kalmut_sheet_mutu1_hsl

Column	Type	Null	Default
rowid (Primary)	double(11,0)	No
periodethn	int	No
kodeunit	char(10)	No
idtopikmutu	double(5,0)	No
indicator_id	int	Yes	NULL
Jan	double(6,2)	Yes	0.00
Feb	double(6,2)	Yes	0.00
Mar	double(6,2)	Yes	0.00
Apr	double(6,2)	Yes	0.00
Mei	double(6,2)	Yes	0.00
Jun	double(6,2)	Yes	0.00
Jul	double(6,2)	Yes	0.00
Ags	double(6,2)	Yes	0.00
Sep	double(6,2)	Yes	0.00
Okt	double(6,2)	Yes	0.00
Nop	double(6,2)	Yes	0.00
Des	double(6,2)	Yes	0.00

Indexes

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

kalmut_sheet_mutu1_mst

Column	Type	Null	Default	Comments
recid (Primary)	double(9,0)	No
cp2reffcode2	double	No
tglinput	datetime	Yes	NULL
periode_bln	int	Yes	NULL
periode_thn	int	Yes	NULL
idtopikmutu	double(5,0)	Yes	NULL
indicator_id	int	Yes	NULL
judulindikator	varchar(150)	Yes	NULL
user_id	int	Yes	NULL
user_fullname	varchar(100)	No
user_email	varchar(100)	Yes	NULL
user_institution_code	varchar(10)	Yes	NULL
user_institution_name	varchar(200)	Yes	NULL
profileindikator	varchar(255)	Yes	NULL
totVariabelBebas	int	Yes	NULL
totN	double(6,2)	Yes	NULL
totD	double(6,2)	Yes	NULL
totOutput	double(6,2)	Yes	NULL
totrerata	double(6,2)	Yes	NULL
totSatuan	varchar(30)	Yes
hitrec	double(6,0)	Yes	NULL
unitmutu	char(10)	No
indicator_category_id	int	Yes	NULL	deprecated
day_of_month	int	Yes	NULL
last_filled	int	Yes	NULL
lastaccesedinfo	varchar(200)	No
insert_by	varchar(100)	Yes	NULL
lastupdate_by	varchar(100)	Yes	NULL
lasttransf_by	varchar(100)	Yes	NULL

Indexes

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

kalmut_unitpelayanan

Column	Type	Null	Default
rowid (Primary)	int	No
kodeunit (Primary)	char(10)	No
namaunit	varchar(255)	Yes	NULL
jnspelayanan	varchar(2)	Yes	NULL
status	int	Yes	0
flddisable	bit(1)	Yes	NULL
kodeunit_map_rs	char(10)	No
namaunit_map_rs	varchar(255)	No
temp0	varchar(1)	Yes	NULL
catatan_mapping	varchar(25)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rowid	33	A	No
PRIMARY	BTREE	Yes	No	kodeunit	33	A	No

kalmut_user_group_access

Column	Type	Null	Default
access_id (Primary)	int	No
access_group_id	varchar(2)	No
access_module_id	int	No
access_add	varchar(1)	No	0
access_delete	varchar(1)	No	0
access_update	varchar(1)	No	0
access_view	varchar(1)	No	0
access_report	varchar(1)	No	0
access_post_date	datetime	No
access_record_status	char(1)	No	A

Indexes

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

local_quality_indicator

Column	Type	Null	Default	Comments
indicator_id (Primary)	int	No
indicator_institution_code	varchar(11)	Yes	NULL
indicator_name_id	int	Yes	NULL
indicator_definition	text	No
indicator_criteria_inclusive	text	Yes	NULL
indicator_criteria_exclusive	text	Yes	NULL
indicator_element	text	No
indicator_source_of_data	varchar(100)	No
indicator_type	varchar(50)	No
indicator_value_standard	int	Yes	NULL
indicator_monitoring_area	varchar(200)	No
indicator_frequency	char(1)	No
indicator_target	char(5)	Yes	0
indicator_category_id	int	Yes	NULL	deprecated
indicator_iscomplete	int	No	0
indicator_factors	varchar(5)	No		Faktor Pengali
indicator_units	varchar(10)	No		Satuan
indicator_lcl	varchar(15)	Yes	NULL
indicator_ucl	varchar(15)	Yes	NULL
indicator_valid_date	date	Yes	NULL
indicator_last_updated	datetime	Yes	NULL
indicator_order_number	int	Yes	NULL
indicator_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	indicator_id	29	A	No

local_quality_indicator_document

Column	Type	Null	Default
document_id (Primary)	int	No
document_result_id	int	No
document_name	varchar(100)	Yes	NULL
document_file_name	varchar(150)	No
document_insert_by	varchar(6)	No
document_department_id	varchar(20)	Yes	NULL
document_institution_code	varchar(11)	No
document_insert_date	datetime	No
document_approval_status	char(1)	No	A
document_record_status	char(1)	No	A

Indexes

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

local_quality_indicator_group

Column	Type	Null	Default	Comments
group_id (Primary)	int	No
group_indicator_id	varchar(5)	No
group_department_id	varchar(5)	No
group_institution_code	varchar(11)	Yes	NULL
group_period	varchar(4)	Yes	NULL
group_type	char(1)	No		1 = Nasional; 2= Lokal
group_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	group_id	57	A	No

local_quality_indicator_result

Column	Type	Null	Default
result_id (Primary)	int	No
result_indicator_id	int	No
result_institution_code	varchar(11)	No
result_department_id	varchar(20)	Yes	NULL
result_numerator_value	varchar(10)	Yes	NULL
result_denumerator_value	varchar(10)	Yes	NULL
result_document_amount	int	Yes	NULL
result_period	date	No
result_insert_date	datetime	No
result_record_status	char(1)	No	A
result_insert_by	varchar(6)	No
result_update_date	datetime	Yes	NULL
result_update_by	varchar(6)	Yes	NULL
result_delete_date	datetime	Yes	NULL
result_delete_by	varchar(6)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	result_id	7178	A	No

local_quality_indicator_result_recapitulation

Column	Type	Null	Default
recapitulation_id (Primary)	int	No
recapitulation_indicator_id	int	Yes	NULL
recapitulation_institution_code	varchar(11)	Yes	NULL
recapitulation_department_id	varchar(5)	No
recapitulation_period	year	Yes	NULL
recapitulation_jan_numerator	int	Yes	NULL
recapitulation_jan_denumerator	int	Yes	NULL
recapitulation_jan_post_date	date	Yes	NULL
recapitulation_feb_numerator	int	Yes	NULL
recapitulation_feb_denumerator	int	Yes	NULL
recapitulation_feb_post_date	date	Yes	NULL
recapitulation_mar_numerator	int	Yes	NULL
recapitulation_mar_denumerator	int	Yes	NULL
recapitulation_mar_post_date	date	Yes	NULL
recapitulation_apr_numerator	int	Yes	NULL
recapitulation_apr_denumerator	int	Yes	NULL
recapitulation_apr_post_date	date	Yes	NULL
recapitulation_may_numerator	int	Yes	NULL
recapitulation_may_denumerator	int	Yes	NULL
recapitulation_may_post_date	date	Yes	NULL
recapitulation_jun_numerator	int	Yes	NULL
recapitulation_jun_denumerator	int	Yes	NULL
recapitulation_jun_post_date	date	Yes	NULL
recapitulation_jul_numerator	int	Yes	NULL
recapitulation_jul_denumerator	int	Yes	NULL
recapitulation_jul_post_date	date	Yes	NULL
recapitulation_aug_numerator	int	Yes	NULL
recapitulation_aug_denumerator	int	Yes	NULL
recapitulation_aug_post_date	date	Yes	NULL
recapitulation_sep_numerator	int	Yes	NULL
recapitulation_sep_denumerator	int	Yes	NULL
recapitulation_sep_post_date	date	Yes	NULL
recapitulation_oct_numerator	int	Yes	NULL
recapitulation_oct_denumerator	int	Yes	NULL
recapitulation_oct_post_date	date	Yes	NULL
recapitulation_nov_numerator	int	Yes	NULL
recapitulation_nov_denumerator	int	Yes	NULL
recapitulation_nov_post_date	date	Yes	NULL
recapitulation_dec_numerator	int	Yes	NULL
recapitulation_dec_denumerator	int	Yes	NULL
recapitulation_dec_post_date	date	Yes	NULL
recapitulation_post_date	datetime	No
recapitulation_record_status	char(1)	Yes	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	recapitulation_id	23	A	No

local_quality_indicator_variable

Column	Type	Null	Default	Comments
variable_id (Primary)	int	No
variable_institution_code	varchar(11)	Yes	NULL
variable_indicator_id	int	No
variable_name	text	No
variable_type	char(1)	No		N=Numerator;D=Denumerator
variable_unit_name	char(10)	No
variable_last_updated	datetime	Yes	NULL
variable_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	variable_id	63	A	No

location_city

Column	Type	Null	Default
city_id (Primary)	int	No
city_province_code	varchar(2)	No
city_province_name	varchar(50)	No
city_code (Primary)	varchar(5)	No
city_name	varchar(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	city_id		A	No
PRIMARY	BTREE	Yes	No	city_code	514	A	No
kode	BTREE	No	No	city_code	514	A	No

location_district

Column	Type	Null	Default
district_id (Primary)	int	No
district_city_code	varchar(4)	No
district_code (Primary)	varchar(7)	No
district_name	varchar(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	district_id		A	No
PRIMARY	BTREE	Yes	No	district_code	6175	A	No
kode	BTREE	No	No	district_code	6175	A	No

location_province

Column	Type	Null	Default
province_id (Primary)	int	No
province_code (Primary)	varchar(2)	No
province_name	varchar(40)	No
province_abbreviation	varchar(15)	Yes	NULL
province_regional	varchar(150)	No
province_hsac	varchar(10)	Yes	NULL
province_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	province_id	34	A	No
PRIMARY	BTREE	Yes	No	province_code	34	A	No
kode	BTREE	No	No	province_code	34	A	No

location_village

Column	Type	Null	Default
village_id (Primary)	int	No
village_district_code	varchar(7)	No
village_code (Primary)	varchar(10)	No
village_name	varchar(30)	Yes	NULL
village_postcode	char(5)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	village_id	68993	A	No
PRIMARY	BTREE	Yes	No	village_code	70804	A	No
kode	BTREE	No	No	village_code	70948	A	No

master_institution_department

Column	Type	Null	Default
department_id (Primary)	int	No
department_name	varchar(50)	No
department_description	text	No
department_institution_code	varchar(11)	No
department_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	department_id	32	A	No

modules

Column	Type	Null	Default	Comments
modules_id (Primary)	int	No
modules_category	int	No		1 = KARS; 2 = FKTP
modules_title	varchar(50)	No
modules_description	varchar(50)	No
modules_link	varchar(100)	No	#
modules_is_display	char(1)	No	0
modules_parent	int	No
modules_position	char(5)	No
modules_icon	varchar(20)	No
modules_order_number	varchar(3)	Yes	NULL
modules_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	modules_id	35	A	No

quality_indicator

Column	Type	Null	Default	Comments
indicator_id (Primary)	int	No
indicator_uuid	varchar(100)	Yes	NULL
indicator_name_id	int	Yes	NULL
indicator_definition	text	No
indicator_criteria_inclusive	text	Yes	NULL
indicator_criteria_exclusive	text	Yes	NULL
indicator_element	text	No
indicator_source_of_data	varchar(100)	No
indicator_type	varchar(50)	No
indicator_value_standard	int	Yes	NULL
indicator_monitoring_area	varchar(200)	No
indicator_frequency	char(1)	No
indicator_target	char(5)	Yes	0
indicator_category_id	int	Yes	NULL	deprecated
indicator_iscomplete	int	No	0
indicator_factors	varchar(5)	No		Faktor Pengali
indicator_units	varchar(10)	No		Satuan
indicator_lcl	varchar(15)	Yes	NULL
indicator_ucl	varchar(15)	Yes	NULL
indicator_valid_date	date	Yes	NULL
indicator_last_updated	datetime	Yes	NULL
indicator_order_number	int	Yes	NULL
indicator_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	indicator_id	102	A	No

quality_indicator_document

Column	Type	Null	Default
document_id (Primary)	int	No
document_result_id	int	No
document_name	varchar(100)	Yes	NULL
document_file_name	varchar(150)	No
document_insert_by	varchar(6)	No
document_department_id	varchar(20)	Yes	NULL
document_institution_code	varchar(11)	No
document_insert_date	datetime	No
document_approval_status	char(1)	No	A
document_record_status	char(1)	No	A

Indexes

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

quality_indicator_group

Column	Type	Null	Default	Comments
group_id (Primary)	int	No
group_indicator_id	varchar(5)	No
group_department_id	varchar(5)	No
group_institution_code	varchar(11)	Yes	NULL
group_period	varchar(4)	Yes	NULL
group_type	char(1)	No		1 = Nasional; 2= Lokal
group_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	group_id	42	A	No

quality_indicator_result

Column	Type	Null	Default
result_id (Primary)	int	No
result_indicator_id	int	No
result_institution_code	varchar(11)	No
result_department_id	varchar(20)	Yes	NULL
result_numerator_value	varchar(10)	Yes	NULL
result_denumerator_value	varchar(10)	Yes	NULL
result_document_amount	int	Yes	NULL
result_period	date	No
result_insert_date	datetime	No
result_record_status	char(1)	No	A
result_insert_by	varchar(6)	No
result_update_date	datetime	Yes	NULL
result_update_by	varchar(6)	Yes	NULL
result_delete_date	datetime	Yes	NULL
result_delete_by	varchar(6)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	result_id	3085	A	No

quality_indicator_result_recapitulation

Column	Type	Null	Default
recapitulation_id (Primary)	int	No
recapitulation_indicator_id	int	Yes	NULL
recapitulation_institution_code	varchar(11)	Yes	NULL
recapitulation_department_id	varchar(5)	No
recapitulation_period	year	Yes	NULL
recapitulation_jan_numerator	int	Yes	NULL
recapitulation_jan_denumerator	int	Yes	NULL
recapitulation_jan_post_date	date	Yes	NULL
recapitulation_feb_numerator	int	Yes	NULL
recapitulation_feb_denumerator	int	Yes	NULL
recapitulation_feb_post_date	date	Yes	NULL
recapitulation_mar_numerator	int	Yes	NULL
recapitulation_mar_denumerator	int	Yes	NULL
recapitulation_mar_post_date	date	Yes	NULL
recapitulation_apr_numerator	int	Yes	NULL
recapitulation_apr_denumerator	int	Yes	NULL
recapitulation_apr_post_date	date	Yes	NULL
recapitulation_may_numerator	int	Yes	NULL
recapitulation_may_denumerator	int	Yes	NULL
recapitulation_may_post_date	date	Yes	NULL
recapitulation_jun_numerator	int	Yes	NULL
recapitulation_jun_denumerator	int	Yes	NULL
recapitulation_jun_post_date	date	Yes	NULL
recapitulation_jul_numerator	int	Yes	NULL
recapitulation_jul_denumerator	int	Yes	NULL
recapitulation_jul_post_date	date	Yes	NULL
recapitulation_aug_numerator	int	Yes	NULL
recapitulation_aug_denumerator	int	Yes	NULL
recapitulation_aug_post_date	date	Yes	NULL
recapitulation_sep_numerator	int	Yes	NULL
recapitulation_sep_denumerator	int	Yes	NULL
recapitulation_sep_post_date	date	Yes	NULL
recapitulation_oct_numerator	int	Yes	NULL
recapitulation_oct_denumerator	int	Yes	NULL
recapitulation_oct_post_date	date	Yes	NULL
recapitulation_nov_numerator	int	Yes	NULL
recapitulation_nov_denumerator	int	Yes	NULL
recapitulation_nov_post_date	date	Yes	NULL
recapitulation_dec_numerator	int	Yes	NULL
recapitulation_dec_denumerator	int	Yes	NULL
recapitulation_dec_post_date	date	Yes	NULL
recapitulation_post_date	datetime	No
recapitulation_record_status	char(1)	Yes	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	recapitulation_id	12	A	No

quality_indicator_variable

Column	Type	Null	Default	Comments
variable_id (Primary)	int	No
variable_uuid	varchar(100)	Yes	NULL
variable_indicator_id	int	No
variable_name	text	No
variable_type	char(1)	No		N=Numerator;D=Denumerator
variable_unit_name	char(10)	No
variable_last_updated	datetime	Yes	NULL
variable_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	variable_id	208	A	No

sidokaf_accreditation_event

Column	Type	Null	Default	Comments
event_id (Primary)	int	No
event_accreditation_version	varchar(4)	No
event_category_id	int	No
event_name	text	No
event_institution_group_id	char(2)	Yes	NULL	1= Rumah Sakit;2 = Puskesmas; 3=Klinik; 4=Praktek Dokter mandiri
event_institution_code	char(11)	Yes	NULL
event_institution_name	varchar(250)	Yes	NULL
event_province_code	varchar(3)	Yes	NULL
event_province_name	varchar(25)	Yes	NULL
event_city_code	int	Yes	NULL
event_city_name	varchar(25)	Yes	NULL
event_start_date_plan	date	Yes	NULL
event_end_date_plan	date	Yes	NULL
event_start_date	date	Yes	NULL
event_end_date	date	Yes	NULL
event_insert_date	datetime	No
event_insert_by	char(6)	No
event_update_date	datetime	Yes	NULL
event_update_by	char(6)	Yes	NULL
event_delete_date	datetime	Yes	NULL
event_delete_by	char(6)	Yes	NULL
event_record_status	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	event_id	5	A	No

sidokaf_accreditation_institution_document

Column	Type	Null	Default
document_id (Primary)	int	No
document_event_id	int	No
document_institution_code	varchar(11)	Yes	NULL
document_instrument_id	int	Yes	NULL
document_instrument_reference_code	varchar(50)	Yes	NULL
document_type	varchar(2)	Yes	NULL
document_name	varchar(100)	Yes	NULL
document_file_name	varchar(250)	Yes	NULL
document_insert_by	int	Yes	NULL
document_insert_date	datetime	Yes	NULL
document_update_date	datetime	Yes	NULL
document_update_by	varchar(6)	Yes	NULL
document_delete_date	datetime	Yes	NULL
document_delete_by	varchar(6)	Yes	NULL
document_approval_status	char(1)	No	A
document_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	document_id	6471	A	No

sidokaf_accreditation_transaction

Column	Type	Null	Default
transaction_id (Primary)	int	No
transaction_accreditation_id	int	Yes	NULL
transaction_event_id	int	No
transaction_instrument_id	int	No
transaction_chapter_id	int	Yes	NULL
transaction_instrument_reference_code	varchar(50)	Yes	NULL
transaction_standard_id	int	Yes	NULL
transaction_institution_code	varchar(11)	No
transaction_institution_score	varchar(3)	Yes	NULL
transaction_institution_update_date	datetime	Yes	NULL
transaction_institution_update_by	int	Yes	NULL
transaction_institution_is_approved	int	Yes	NULL
transaction_institution_approve_date	datetime	Yes	NULL
transaction_surveyor_update_by	char(5)	Yes	NULL
transaction_surveyor_score	varchar(3)	Yes	0
transaction_surveyor_fact_and_analysis	text	Yes	NULL
transaction_surveyor_recommendation	text	Yes	NULL
transaction_surveyor_need_to_discussed	int	Yes	NULL
transaction_surveyor_update_date	datetime	Yes	NULL
transaction_counselor_update_by	char(5)	Yes	NULL
transaction_counselor_score	varchar(3)	Yes	0
transaction_counselor_fact_and_analysis	text	Yes	NULL
transaction_counselor_note	text	Yes	NULL
transaction_counselor_message	text	Yes	NULL
transaction_evaluation_x1	char(1)	Yes	NULL
transaction_evaluation_x2	char(1)	Yes	NULL
transaction_evaluation_x3	char(1)	Yes	NULL
transaction_counselor_update_date	datetime	Yes	NULL
transaction_counselor_is_approved	int	Yes	NULL
transaction_counselor_approved_date	date	Yes	NULL
transaction_remedial_surveyor_update_by	char(5)	Yes	NULL
transaction_remedial_surveyor_score	varchar(3)	Yes	NULL
transaction_remedial_surveyor_fact_and_analysis	text	Yes	NULL
transaction_remedial_surveyor_recommendation	text	Yes	NULL
transaction_remedial_surveyor_update_date	datetime	Yes	NULL
transaction_final_score	varchar(3)	Yes	0
transaction_is_evaluated	int	Yes	NULL
transaction_is_discussed	int	Yes	NULL
transaction_verification_1	varchar(10)	Yes	NULL
transaction_verification_1_recommendation	text	Yes	NULL
transaction_verification_1_insert_by	varchar(6)	Yes	NULL
transaction_verification_1_insert_date	datetime	Yes	NULL
transaction_verification_2	varchar(10)	Yes	NULL
transaction_verification_2_recommendation	text	Yes	NULL
transaction_verification_2_insert_by	varchar(6)	Yes	NULL
transaction_verification_2_insert_date	datetime	Yes	NULL
transaction_document_amount	int	No	0
transaction_record_status	char(1)	No
transaction_period	year	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	transaction_id	5212	A	No

sidokaf_accreditation_transaction_chapter

Column	Type	Null	Default	Comments
trans_id (Primary)	int	No
trans_event_id	int	No
trans_chapter_id	int	No
trans_institution_code	varchar(11)	No
trans_institution_score	varchar(5)	Yes	NULL
trans_institution_date	datetime	Yes	NULL
trans_surveyor_score	float	Yes	NULL
trans_surveyor_value	text	Yes	NULL
trans_surveyor_update_by	int	Yes	NULL
trans_surveyor_date	datetime	Yes	NULL
trans_remedial_surveyor_score	float	Yes	NULL
trans_remedial_surveyor_value	text	Yes	NULL
trans_remedial_surveyor_update_by	int	Yes	NULL
trans_remedial_surveyor_date	datetime	Yes	NULL
trans_counselor_score	float	Yes	NULL
trans_counselor_value	text	Yes	NULL
trans_counselor_update_by	int	Yes	NULL
trans_counselor_date	datetime	Yes	NULL
trans_final_score_0	int	Yes	NULL
trans_final_score_5	int	Yes	NULL
trans_final_score_10	int	Yes	NULL
trans_final_is_tdd	char(1)	No	0
trans_final_score	float	Yes	NULL
trans_verification_1	char(1)	Yes	NULL
trans_verification_2	char(1)	Yes	NULL
trans_status_id	char(2)	Yes	NULL	1 = Merah; 2 = Kuning; 3 = Hijau
trans_insert_date	datetime	No
trans_insert_by	int	No
trans_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	trans_id	112	A	No

user_access

Column	Type	Null	Default
access_id (Primary)	int	No
access_user_id	int	No
access_module_id	int	No
access_add	int	No	0
access_delete	int	No	0
access_update	int	No	0
access_view	int	No	0
access_report	int	No	0
access_showhidecolumns	int	No	0
access_export	int	No	0
access_approve	int	No	0
access_insert_date	datetime	No
access_record_status	char(1)	No	A

Indexes

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

user_group

Column	Type	Null	Default	Comments
group_id (Primary)	int	No
group_name	varchar(50)	No
group_health_care	char(1)	No		1 = Pemberi Asuhan (Dokter, Perawat, Bidan, Dietisien, Farmasi); 0 = Penunjang
group_application_type	int	No		1=KARS;2=FKTP;3=Klinik;4=Praktek Dokter
group_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	group_id	5	A	No

user_group_access

Column	Type	Null	Default	Comments
access_id (Primary)	int	No
access_group_id	varchar(2)	No		1:Admin;5:Puskesmas; 6:Surveior;
access_module_id	int	No
access_add	varchar(1)	No	0
access_delete	varchar(1)	No	0
access_update	varchar(1)	No	0
access_view	varchar(1)	No	0
access_report	varchar(1)	No	0
access_showhidecolumns	int	No	0
access_export	int	No	0
access_approve	int	No	0
access_post_date	datetime	No
access_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	access_id	157	A	No

user_group_access_detil

Column	Type	Null	Default
detil_id (Primary)	int	No
detil_profile_id	varchar(10)	No
detil_employee_id	varchar(10)	No
detil_group_id	varchar(10)	No
detil_subgroup_id	varchar(10)	No
detil_start_date	date	No
detil_end_date	date	No
detil_description	varchar(250)	No
detil_notes	varchar(250)	No
detil_update_date	datetime	No
detil_update_by	varchar(10)	No
detil_record_status	char(1)	No	A
detil_insert_date	datetime	No
detil_insert_by	varchar(10)	No

Indexes

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

user_log

Column	Type	Null	Default
log_id (Primary)	int	No
log_ip	varchar(32)	Yes	NULL
log_hostname	varchar(100)	Yes	NULL
log_profile_id	varchar(6)	No
log_last_login	datetime	Yes	NULL
log_session	char(32)	Yes	NULL
log_last_activity	varchar(250)	Yes	NULL
log_logout	datetime	Yes	NULL
log_is_type	enum('no', 'yes')	No
log_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	log_id	5540	A	No

user_profile

Column	Type	Null	Default	Comments
profile_id (Primary)	int	No
profile_group_id	char(20)	No
profile_subgroup_id	varchar(50)	No
profile_operator_id	int	Yes	NULL
profile_fullname	varchar(100)	No
profile_employee_id	varchar(25)	Yes	NULL
profile_birth_place	varchar(50)	Yes	NULL
profile_dob	date	Yes	NULL
profile_gender	int	Yes	NULL
profile_religion	int	Yes	NULL
profile_address	varchar(300)	Yes	NULL
profile_city_code	char(5)	Yes	NULL
profile_city_name	varchar(30)	Yes	NULL
profile_district_code	char(7)	Yes	NULL
profile_village_code	char(10)	Yes	NULL
profile_postcode	varchar(5)	Yes	NULL
profile_living_address	varchar(300)	Yes	NULL
profile_living_city_code	char(5)	Yes	NULL
profile_living_province_code	char(2)	Yes	NULL
profile_living_district_code	char(7)	Yes	NULL
profile_living_village_code	char(10)	Yes	NULL
profile_living_postcode	varchar(5)	Yes	NULL
profile_province_code	char(2)	Yes	NULL
profile_province_name	varchar(30)	Yes	NULL
profile_handphone1	char(20)	Yes	NULL
profile_handphone2	char(20)	Yes	NULL
profile_email	varchar(100)	Yes	NULL
profile_gmail	varchar(100)	Yes	NULL
profile_npwp	varchar(25)	Yes	NULL
profile_fullname_npwp	varchar(50)	Yes	NULL
profile_bank	varchar(50)	Yes	NULL
profile_bank_account	varchar(25)	Yes	NULL
profile_bank_account_holder	varchar(50)	Yes	NULL
profile_competency_id	varchar(8)	Yes	NULL
profile_nationality_id	varchar(20)	Yes	NULL
profile_str_id	varchar(50)	Yes	NULL
profile_str_expired	date	Yes	NULL
profile_sip_id	varchar(50)	Yes	NULL
profile_sip_expired	date	Yes	NULL
profile_spk_id	varchar(50)	Yes	NULL
profile_spk_expired	date	Yes	NULL
profile_rkk_id	varchar(50)	Yes	NULL
profile_rkk_expired	date	Yes	NULL
profile_work_type	char(1)	Yes	NULL
profile_work_status	int	Yes	NULL
profile_work_position	int	Yes	NULL
profile_work_date	date	Yes	NULL
profile_workshop_partnership_id	int	Yes	NULL
profile_department_id	varchar(10)	Yes	NULL
profile_signs	char(36)	Yes	NULL
profile_specialize_id	char(1)	Yes	NULL
profile_major	char(1)	Yes	NULL	1:Dokter;2:Dokter Gigi;3:SKM;4:Bidan;5:Perawat dan nakes lainnya
profile_insert_by	varchar(5)	No
profile_insert_date	datetime	No
profile_update_by	varchar(5)	Yes	NULL
profile_update_date	datetime	Yes	NULL
profile_delete_date	datetime	Yes	NULL
profile_delete_by	int	Yes	NULL
profile_institution_code	varchar(11)	Yes	NULL
profile_institution_name	varchar(200)	Yes	NULL
profile_institution_ownership_id	char(2)	Yes	NULL
profile_institution_province_code	varchar(50)	Yes	NULL	Province tempat kerja
profile_institution_city_code	varchar(10)	Yes	NULL	Kab//Kota tempat kerja
profile_institution_group_id	varchar(10)	Yes	NULL	5 = Puskesmas; 12 = Klinik; 13=Praktek Dokter Mandiri
profile_regional_city_code	varchar(6)	Yes	NULL
profile_batch	char(4)	Yes	NULL
profile_bpjs_number	varchar(25)	Yes	NULL
profile_toefl_score	varchar(5)	Yes	NULL
profile_photo	varchar(250)	Yes	NULL
profile_grade_code	varchar(2)	Yes	NULL
profile_password	varchar(32)	Yes	NULL
profile_last_change_password	datetime	Yes	NULL
profile_online_status	int	No	0
profile_disable	int	No	0	0 = Active; 1=Disable
profile_disable_reason	int	Yes	NULL
profile_note	varchar(250)	Yes	NULL
profile_last_login	datetime	Yes	NULL
profile_partnership_code	varchar(32)	Yes	NULL	Status Penanggunjawab yang bisa dihubungu
profile_partnership_ed	date	Yes	NULL
profile_record_status	char(1)	No	A

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	profile_id	72	A	No