Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: simpedak_db
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
simpedak_db.accreditation_document
simpedak_db.accreditation_event
simpedak_db.accreditation_event_category
simpedak_db.accreditation_event_document
simpedak_db.accreditation_instrument
simpedak_db.accreditation_instrument_chapter
simpedak_db.accreditation_instrument_class
simpedak_db.accreditation_instrument_standard
simpedak_db.accreditation_instrument_view
simpedak_db.accreditation_pps
simpedak_db.accreditation_pps_detail
simpedak_db.accreditation_status
simpedak_db.accreditation_transaction
simpedak_db.accreditation_transaction_chapter
simpedak_db.browsereg
simpedak_db.competency
simpedak_db.config
simpedak_db.filemanager
simpedak_db.hsi_module
simpedak_db.hsi_module_detail
simpedak_db.hsi_module_item
simpedak_db.hsi_module_result
simpedak_db.hsi_module_sublist
simpedak_db.hsi_module_sublist_detail
simpedak_db.hsi_module_sublist_sublist
simpedak_db.hsi_update_log
simpedak_db.institution
simpedak_db.institution_group
simpedak_db.kalmut_devopvarmutu
simpedak_db.kalmut_jeniskalkulasi
simpedak_db.kalmut_katalogmutu
simpedak_db.kalmut_katalogmutu_deskripsi
simpedak_db.kalmut_katalogmutu_unit
simpedak_db.kalmut_kategorimutu
simpedak_db.kalmut_modules
simpedak_db.kalmut_pengaksesunit
simpedak_db.kalmut_quality_indicator_group
simpedak_db.kalmut_regactivity_period_perunit
simpedak_db.kalmut_registeredunit
simpedak_db.kalmut_regqualityunit
simpedak_db.kalmut_sheet_mutu1_dtl
simpedak_db.kalmut_sheet_mutu1_dtl_summary
simpedak_db.kalmut_sheet_mutu1_hsl
simpedak_db.kalmut_sheet_mutu1_mst
simpedak_db.kalmut_unitpelayanan
simpedak_db.kalmut_user_group_access
simpedak_db.local_quality_indicator
simpedak_db.local_quality_indicator_document
simpedak_db.local_quality_indicator_group
simpedak_db.local_quality_indicator_result
simpedak_db.local_quality_indicator_result_recapitulation
simpedak_db.local_quality_indicator_variable
simpedak_db.location_city
simpedak_db.location_district
simpedak_db.location_province
simpedak_db.location_village
simpedak_db.master_institution_department
simpedak_db.modules
simpedak_db.quality_indicator
simpedak_db.quality_indicator_document
simpedak_db.quality_indicator_group
simpedak_db.quality_indicator_result
simpedak_db.quality_indicator_result_recapitulation
simpedak_db.quality_indicator_variable
simpedak_db.sidokaf_accreditation_event
simpedak_db.sidokaf_accreditation_institution_document
simpedak_db.sidokaf_accreditation_transaction
simpedak_db.sidokaf_accreditation_transaction_chapter
simpedak_db.user_access
simpedak_db.user_group
simpedak_db.user_group_access
simpedak_db.user_group_access_detil
simpedak_db.user_log
simpedak_db.user_profile
Number of tables: 74
v simpedak_db accreditation_document
* document_id : int
* document_event_id : int
* document_name : varchar(100)
* document_file_name : varchar(150)
* document_profile_id : varchar(6)
* document_insert_by : varchar(6)
* document_insert_date : datetime
* document_approval_status : char(1)
* document_record_status : char(1)
v simpedak_db accreditation_event
* event_id : int
* event_category_id : int
* event_partnership_id : char(2)
* event_barcode : varchar(7)
* event_name : text
* event_topic_group : varchar(200)
* event_institution_group_id : char(2)
* event_institution_ownership_id : char(2)
* event_institution_code_old : char(11)
* event_institution_code : varchar(11)
* event_institution_name : varchar(250)
* event_institution_id : varchar(6)
* event_location_id : int
* event_province_code : varchar(3)
* event_province_name : varchar(25)
* event_city_code : int
* event_city_name : varchar(25)
* event_certificate_date : varchar(25)
* event_address_other : varchar(150)
* event_start_date_plan : date
* event_end_date_plan : date
* event_start_date : date
* event_end_date : date
* event_note : text
* event_package_id : varchar(10)
* event_package_chapter_id : varchar(20)
* event_is_webinar : int
* event_is_ecertificate : char(1)
* event_workshop_capacity : int
* event_price : varchar(20)
* event_funds_source : char(1)
* event_price_personal : decimal(12,2)
* event_is_internal : int
* event_dinkesCity_is_approved : char(1)
* event_dinkesCity_approve_date : datetime
* event_dinkesCity_approve_by : int
* event_dinkesProv_is_approved : char(1)
* event_dinkesProv_approve_date : datetime
* event_dinkesProv_approve_by : varchar(6)
* event_is_approved : int
* event_approve_date : datetime
* event_approve_by : char(5)
* event_reply_letter_number : varchar(10)
* event_reply_letter_date : date
* event_document_amount : int
* event_billing_pic : varchar(50)
* event_billing_pic_phone : varchar(15)
* event_institution_letter_number : varchar(30)
* event_institution_letter_date : date
* event_invoice_number : varchar(10)
* event_billing_price : decimal(12,2)
* event_billing_ticket : decimal(12,2)
* event_billing_transport : decimal(12,2)
* event_billing_close_status : int
* event_billing_close_date : date
* event_billing_code_transaction : varchar(13)
* event_accreditation_id_reference : int
* event_id_reference : int
* event_accreditation_version : char(4)
* event_hospital_pic : int
* event_surveyor_amount : char(2)
* event_participant_amount : varchar(5)
* event_pic_name : varchar(200)
* event_pic_phone : varchar(100)
* event_instrument_status : int
* event_signed_file : varchar(150)
* event_signed_name : varchar(100)
* event_institution_evaluation1_status : char(1)
* event_institution_evaluation1_update_date : datetime
* event_institution_evaluation2_status : char(1)
* event_institution_evaluation2_update_date : datetime
* event_surveior_evaluation_status : char(1)
* event_surveior_evaluation_update_date : datetime
* event_order_id : varchar(3)
* event_operator_id : int
* event_insert_date : datetime
* event_insert_by : char(6)
* event_update_date : datetime
* event_update_by : char(6)
* event_delete_date : datetime
* event_delete_by : char(6)
* event_record_status : char(1)
* event_survey_id : int
v simpedak_db accreditation_event_category
* category_id : int
* category_code : varchar(5)
* category_name : varchar(50)
* category_price : varchar(20)
* category_version : year
* category_post_date : datetime
* category_user_id : int
* category_record_status : char(1)
v simpedak_db accreditation_event_document
* document_id : int
* document_event_id : int
* document_type : varchar(2)
* document_name : varchar(100)
* document_file_name : varchar(150)
* document_insert_by : char(6)
* document_insert_date : datetime
* document_update_by : char(6)
* document_update_date : datetime
* document_delete_by : char(6)
* document_delete_date : datetime
* document_approval_status : char(1)
* document_record_status : char(1)
v simpedak_db accreditation_instrument
* instrument_id : int
* instrument_reference_code : varchar(15)
* instrument_order_id : int
* instrument_name : text
* instrument_objective : text
* instrument_material : text
* instrument_document : text
* instrument_maximum_score : int
* instrument_standard_id : int
* instrument_chapter_id : int
* instrument_class_id : int
* instrument_version : year
* instrument_institution_group_id : int
* instrument_r : text
* instrument_d : text
* instrument_o : text
* instrument_w : text
* instrument_s : text
* instrument_update : datetime
* instrument_user_id : int
* instrument_record_status : char(1)
v simpedak_db accreditation_instrument_chapter
* chapter_id : int
* chapter_class_id : int
* chapter_institution_group_id : varchar(2)
* chapter_code : varchar(10)
* chapter_name : varchar(75)
* chapter_maximum_score : int
* chapter_type : varchar(15)
* chapter_package : int
* chapter_progsus : int
* chapter_package_order : int
* chapter_specialize_id : char(1)
* chapter_version : year
* chapter_post_date : datetime
* chapter_user_id : int
* chapter_record_status : char(1)
v simpedak_db accreditation_instrument_class
* class_id : int
* class_name : varchar(50)
* class_maximum_score : int
* class_version : year
* class_post_date : datetime
* class_user_id : int
* class_record_status : char(1)
v simpedak_db accreditation_instrument_standard
* standard_id : int
* standard_chapter_id : int
* standard_code : varchar(20)
* standard_focus : varchar(100)
* standard_name : text
* standard_objective : text
* standard_maximum_score : int
* standard_version : year
* standard_post_date : datetime
* standard_user_id : int
* standard_record_status : char(1)
v simpedak_db accreditation_instrument_view
* instrument_id : int
* instrument_reference_code : varchar(15)
* instrument_order_id : int
* instrument_name : text
* instrument_objective : text
* instrument_material : text
* instrument_document : text
* instrument_maximum_score : int
* instrument_standard_id : varchar(20)
* standard_name : text
* instrument_standard_code : varchar(20)
* standard_code : varchar(20)
* standard_id : int
* instrument_chapter_id : int
* chapter_code : varchar(10)
* chapter_name : varchar(75)
* chapter_maximum_score : int
* chapter_progsus : int
* chapter_package : int
* chapter_package_order : int
* instrument_r : text
* instrument_d : text
* instrument_o : text
* instrument_w : text
* instrument_s : text
* instrument_class_id : int
* class_name : varchar(50)
* instrument_version : year
* instrument_institution_group_id : int
* instrument_record_status : char(1)
v simpedak_db accreditation_pps
* pps_id : int
* pps_transaction_id : int
* pps_event_id : int
* pps_institution_code : int
* pps_chapter_id : int
* pps_instrument_id : int
* pps_reference_code : varchar(100)
* pps_surveyor_score : varchar(5)
* pps_fact_and_analysis : text
* pps_recommendation : text
* pps_tl : varchar(1)
* pps_document : varchar(255)
* pps_update_date : datetime
* pps_update_by : int
* pps_metode : text
* pps_indicator : text
* pps_time : varchar(50)
* pps_pic : varchar(50)
* pps_feedback : text
* pps_feedback_by : varchar(50)
* pps_description : text
* pps_record_status : varchar(1)
v simpedak_db accreditation_pps_detail
* detail_id : int
* detail_pps_id : int
* detail_document : varchar(255)
* detail_update_date : datetime
* detail_update_by : int
* detail_description : varchar(200)
* detail_record_status : varchar(1)
v simpedak_db accreditation_status
* status_id : int
* status_name : varchar(30)
* status_version : year
* status_picture : varchar(50)
* status_post_date : datetime
* status_user_id : int
* status_order : int
* status_record_status : char(1)
v simpedak_db accreditation_transaction
* transaction_id : int
* transaction_accreditation_id : int
* transaction_event_id : int
* transaction_instrument_id : int
* transaction_chapter_id : int
* transaction_class_id : int
* transaction_standard_id : int
* transaction_institution_id : int
* transaction_institution_score : varchar(3)
* transaction_institution_update_date : datetime
* transaction_institution_update_by : int
* transaction_institution_is_approved : int
* transaction_institution_approve_date : datetime
* transaction_surveyor_update_by : char(5)
* transaction_surveyor_score : varchar(3)
* transaction_surveyor_fact_and_analysis : text
* transaction_surveyor_recommendation : text
* transaction_surveyor_need_to_discussed : int
* transaction_surveyor_update_date : datetime
* transaction_counselor_update_by : char(5)
* transaction_counselor_score : varchar(3)
* transaction_counselor_fact_and_analysis : text
* transaction_counselor_note : text
* transaction_counselor_message : text
* transaction_evaluation_x1 : char(1)
* transaction_evaluation_x2 : char(1)
* transaction_evaluation_x3 : char(1)
* transaction_counselor_update_date : datetime
* transaction_counselor_is_approved : int
* transaction_counselor_approved_date : date
* transaction_remedial_surveyor_update_by : char(5)
* transaction_remedial_surveyor_score : varchar(3)
* transaction_remedial_surveyor_fact_and_analysis : text
* transaction_remedial_surveyor_recommendation : text
* transaction_remedial_surveyor_update_date : datetime
* transaction_final_score : varchar(3)
* transaction_is_evaluated : int
* transaction_is_discussed : int
* transaction_verification_1 : varchar(10)
* transaction_verification_1_recommendation : text
* transaction_verification_1_insert_by : varchar(6)
* transaction_verification_1_insert_date : datetime
* transaction_verification_2 : varchar(10)
* transaction_verification_2_recommendation : text
* transaction_verification_2_insert_by : varchar(6)
* transaction_verification_2_insert_date : datetime
* transaction_record_status : char(1)
* transaction_period : year
v simpedak_db accreditation_transaction_chapter
* trans_id : int
* trans_event_id : int
* trans_chapter_id : int
* trans_institution_code_old : varchar(11)
* trans_institution_group_id : int
* trans_institution_code : varchar(11)
* trans_institution_score : varchar(5)
* trans_institution_date : datetime
* trans_surveyor_update_by : int
* trans_remedial_surveyor_score : float
* trans_surveyor_score : float
* trans_remedial_surveyor_date : datetime
* trans_surveyor_date : datetime
* trans_counselor_update_by : int
* trans_counselor_score : float
* trans_counselor_date : datetime
* trans_remedial_surveyor_update_by : int
* trans_final_score_0 : int
* trans_final_score_5 : int
* trans_final_score_10 : int
* trans_final_score : float
* trans_final_is_tdd : int
* trans_verification_1 : char(1)
* trans_verification_2 : char(1)
* trans_status_id : char(2)
* trans_surveyor_value : text
* trans_remedial_surveyor_value : text
* trans_counselor_value : text
* trans_insert_date : datetime
* trans_insert_by : int
* trans_record_status : enum('A','D')
v simpedak_db browsereg
* rowid : int
* cp2reffcode0 : double
* regunit_unitid : char(10)
* namaunit : varchar(255)
* status : int
* flddisable : bit(1)
v simpedak_db competency
* competency_id : int
* competency_category_id : int
* competency_category : varchar(16)
* competency_sub_category_id : varchar(4)
* competency_sub_category : varchar(25)
* competency_specialize_id : varchar(6)
* competency_specialize : varchar(20)
* competency_sub_specialize_id : varchar(8)
* competency_sub_specialize : varchar(30)
v simpedak_db config
* config_id : int
* config_attribute : varchar(25)
* config_operator : varchar(10)
* config_value : varchar(16)
v simpedak_db filemanager
* filemanager_id : int
* filemanager_profile_id : int
* filemanager_rootDir : char(200)
* filemanager_readonly : int
* filemanager_userDir : char(200)
* filemanager_hideDirNames : char(200)
* filemanager_enableUpload : int
* filemanager_enableDownload : int
* filemanager_enableBulkDownload : int
* filemanager_enableEdit : int
* filemanager_enableDelete : int
* filemanager_enableRestore : int
* filemanager_enableRename : int
* filemanager_enablePermissions : int
* filemanager_enableMove : int
* filemanager_enableCopy : int
* filemanager_enableNewDir : int
* filemanager_enableSearch : int
* filemanager_institution_code : varchar(11)
* filemanager_post_date : datetime
* filemanager_record_status : char(1)
v simpedak_db hsi_module
* module_id : int
* module_name : varchar(255)
* last_updated : datetime
v simpedak_db hsi_module_detail
* module_id : int
* sublist_id : int
* last_updated : datetime
v simpedak_db hsi_module_item
* item_id : int
* item_title : varchar(255)
* security_lv_low : varchar(255)
* security_lv_medium : varchar(255)
* security_lv_high : varchar(255)
* additional_note : varchar(255)
* item_hazard : varchar(255)
* item_weight : double
* last_updated : datetime
v simpedak_db hsi_module_result
* result_id : int
* institution_code : int
* json_result : text
* created_at : datetime
* result_inserted_by : varchar(6)
* result_updated_by : varchar(6)
* result_updated_date : datetime
* result_record_status : varchar(1)
* result_deleted_by : varchar(6)
* result_deleted_date : datetime
v simpedak_db hsi_module_sublist
* sublist_id : int
* sublist_name : varchar(255)
* last_updated : datetime
v simpedak_db hsi_module_sublist_detail
* sublist_id : int
* item_id : int
* last_updated : datetime
v simpedak_db hsi_module_sublist_sublist
* sublist_sublist_id : int
* sublist_sublist_name : varchar(255)
v simpedak_db hsi_update_log
* update_id : int
* update_time : datetime
v simpedak_db institution
* institution_id : int
* institution_group_id : char(2)
* institution_code : varchar(15)
* institution_registration_code : varchar(15)
* institution_name : varchar(36)
* institution_province_code : varchar(2)
* institution_city_code : varchar(5)
* institution_address : varchar(250)
* institution_district_code : varchar(7)
* institution_district_name : varchar(31)
* institution_city_name : varchar(26)
* institution_province_name : varchar(19)
* institution_care_code : int
* institution_area_characteristic_code : int
* institution_publication_date : date
* institution_type : varchar(14)
* institution_class : varchar(2)
* institution_ownership_id : varchar(2)
* institution_ownership_name : varchar(30)
* institution_director : varchar(100)
* institution_director_email : varchar(100)
* institution_email : varchar(100)
* institution_specialize : varchar(5)
* institution_is_education : char(1)
* institution_is_partnership : int
* institution_partnership_ed : date
* institution_total_bed : varchar(5)
* institution_start_date : date
* institution_operational_number : varchar(100)
* institution_operational_date_end : date
* institution_ipal_number : varchar(100)
* institution_ipal_date_end : date
* institution_waste_number : varchar(100)
* institution_waste_date_end : date
* institution_distance : varchar(250)
* institution_other_information : text
* institution_longitude : varchar(30)
* institution_latitude : varchar(30)
* institution_accreditation_status : int
* institution_accreditation_status_date : date
* institution_accreditation_expired : date
* institution_insert_date : datetime
* institution_insert_by : varchar(6)
* institution_update_date : datetime
* institution_update_by : varchar(6)
* institution_delete_date : datetime
* institution_delete_by : varchar(6)
* institution_record_status : char(1)
v simpedak_db institution_group
* group_id : int
* group_name : varchar(25)
* group_record_status : char(1)
v simpedak_db kalmut_devopvarmutu
* recid : double
* idtopikmutu : double(5,0)
* indicator_id : int
* vardescription : varchar(255)
* varnama : varchar(15)
* varposisi : varchar(15)
* mcmmutu : varchar(11)
v simpedak_db kalmut_jeniskalkulasi
* rowid : int
* jeniskalkulasi : varchar(10)
v simpedak_db kalmut_katalogmutu
* rowid : int
* kodeunit : varchar(11)
* idtopikmutu : double(5,0)
* indicator_id : int
* indicator_uuid : varchar(100)
* indicator_category_id : int
* judulsheet : text
* jenispengerjaan : varchar(100)
* chart1 : varchar(100)
* chart2 : varchar(100)
* jumlahvb : int
* formulatype : varchar(10)
* formula : text
* tobenchmark : int
* judultopik : text
* share2 : varchar(11)
* status : int
* flddisable : bit(1)
* idtopikmutu_map : int
* namaimut_map : text
* temp0 : varchar(1)
* catatan_mapping : varchar(25)
* editimutkars : int
v simpedak_db kalmut_katalogmutu_deskripsi
* rowid : int
* idtopikmutu : double(5,0)
* indicator_id : int
* indicator_uuid : varchar(100)
* ruanglingkup : varchar(120)
* dimensimutu : varchar(120)
* latarbelakang : varchar(200)
* alasanpemilihan : varchar(200)
* tipeindikator_s : char(1)
* tipeindikator_p : char(1)
* tipeindikator_h : char(1)
* tujuan : varchar(200)
* defop : text
* metodepengumpulandata : varchar(200)
* freqdatacollect : varchar(30)
* periodeanalisis : varchar(30)
* jumlahvarmutu : int
* nominator : text
* denominator : text
* jumlahvb : int
* formulatype : varchar(10)
* formula : tinytext
* satuan : varchar(30)
* sumberdata : varchar(200)
* standar : varchar(60)
* target : varchar(60)
* collectorpenanggungjawab : varchar(100)
* mcmmutu : varchar(11)
v simpedak_db kalmut_katalogmutu_unit
* rowid : int
* kodeunit : varchar(11)
* mcmmutu : varchar(11)
* idtopikmutu : double(5,0)
* indicator_id : int
* judultopik : varchar(150)
* judulsheet : varchar(100)
* jenispengerjaan : varchar(100)
* chart1 : varchar(100)
* chart2 : varchar(100)
* jumlahvb : int
* formulatype : varchar(10)
* formula : tinytext
* tobenchmark : int
v simpedak_db kalmut_kategorimutu
* rowid : int
* KategoriMutu : varchar(30)
v simpedak_db kalmut_modules
* modules_id : int
* modules_category : int
* modules_title : varchar(50)
* modules_description : varchar(50)
* modules_is_display : char(1)
* modules_parent : int
* modules_position : char(5)
* modules_icon : varchar(30)
* modules_record_status : char(1)
v simpedak_db kalmut_pengaksesunit
* rowid : double
* profile_fullname : varchar(100)
* user_name : varchar(50)
* user_profile_id : varchar(6)
* accessedunit : char(10)
* accessedtime : datetime
* acces_del : char(1)
* acces_add : char(1)
* acces_edit : char(1)
v simpedak_db kalmut_quality_indicator_group
* group_id : int
* group_indicator_id : varchar(5)
* group_department_id : varchar(5)
* group_institution_code : varchar(11)
* group_period : varchar(4)
* group_type : char(1)
* group_record_status : char(1)
v simpedak_db kalmut_regactivity_period_perunit
* rowid : double
* parentid_reffcode1 : double
* periode : int
* cp2reffcode2 : double
v simpedak_db kalmut_registeredunit
* rowid : int
* cp2reffcode0 : double
* user_id : int
* regunit_institution_code : varchar(11)
* regunit_unitid : char(10)
* regunit_regdate : datetime
* regunit_regbyprofemail : varchar(100)
* activitynotes : varchar(100)
v simpedak_db kalmut_regqualityunit
* rowid : double
* parentid_reffcode0 : double
* idtopikmutu : double(3,0)
* judultopik : varchar(150)
* cp2reffcode1 : double
v simpedak_db kalmut_sheet_mutu1_dtl
* recid : double(9,0)
* parent_recid : double
* idtopikmutu : double(5,0)
* indicator_id : int
* namavariabel : varchar(15)
* posisivariabel : varchar(15)
* day1 : double(5,0)
* day2 : double(5,0)
* day3 : double(5,0)
* day4 : double(5,0)
* day5 : double(5,0)
* day6 : double(5,0)
* day7 : double(5,0)
* day8 : double(5,0)
* day9 : double(5,0)
* day10 : double(5,0)
* day11 : double(5,0)
* day12 : double(5,0)
* day13 : double(5,0)
* day14 : double(5,0)
* day15 : double(5,0)
* day16 : double(5,0)
* day17 : double(5,0)
* day18 : double(5,0)
* day19 : double(5,0)
* day20 : double(5,0)
* day21 : double(5,0)
* day22 : double(5,0)
* day23 : double(5,0)
* day24 : double(5,0)
* day25 : double(5,0)
* day26 : double(5,0)
* day27 : double(5,0)
* day28 : double(5,0)
* day29 : double(5,0)
* day30 : double(5,0)
* day31 : double(5,0)
* totentry : double(6,2)
v simpedak_db kalmut_sheet_mutu1_dtl_summary
* recid : double(9,0)
* parent_recid : double
* idtopikmutu : double(5,0)
* indicator_id : int
* day1 : double(6,2)
* day2 : double(6,2)
* day3 : double(6,2)
* day4 : double(6,2)
* day5 : double(6,2)
* day6 : double(6,2)
* day7 : double(6,2)
* day8 : double(6,2)
* day9 : double(6,2)
* day10 : double(6,2)
* day11 : double(6,2)
* day12 : double(6,2)
* day13 : double(6,2)
* day14 : double(6,2)
* day15 : double(6,2)
* day16 : double(6,2)
* day17 : double(6,2)
* day18 : double(6,2)
* day19 : double(6,2)
* day20 : double(6,2)
* day21 : double(6,2)
* day22 : double(6,2)
* day23 : double(6,2)
* day24 : double(6,2)
* day25 : double(6,2)
* day26 : double(6,2)
* day27 : double(6,2)
* day28 : double(6,2)
* day29 : double(6,2)
* day30 : double(6,2)
* day31 : double(6,2)
* totentry : double(6,2)
* rerata : double(6,2)
* satuan : varchar(30)
* standar : varchar(60)
* target : varchar(60)
* tobenchmark : int
v simpedak_db kalmut_sheet_mutu1_hsl
* rowid : double(11,0)
* periodethn : int
* kodeunit : char(10)
* idtopikmutu : double(5,0)
* indicator_id : int
* Jan : double(6,2)
* Feb : double(6,2)
* Mar : double(6,2)
* Apr : double(6,2)
* Mei : double(6,2)
* Jun : double(6,2)
* Jul : double(6,2)
* Ags : double(6,2)
* Sep : double(6,2)
* Okt : double(6,2)
* Nop : double(6,2)
* Des : double(6,2)
v simpedak_db kalmut_sheet_mutu1_mst
* recid : double(9,0)
* cp2reffcode2 : double
* tglinput : datetime
* periode_bln : int
* periode_thn : int
* idtopikmutu : double(5,0)
* indicator_id : int
* judulindikator : varchar(150)
* user_id : int
* user_fullname : varchar(100)
* user_email : varchar(100)
* user_institution_code : varchar(10)
* user_institution_name : varchar(200)
* profileindikator : varchar(255)
* totVariabelBebas : int
* totN : double(6,2)
* totD : double(6,2)
* totOutput : double(6,2)
* totrerata : double(6,2)
* totSatuan : varchar(30)
* hitrec : double(6,0)
* unitmutu : char(10)
* indicator_category_id : int
* day_of_month : int
* last_filled : int
* lastaccesedinfo : varchar(200)
* insert_by : varchar(100)
* lastupdate_by : varchar(100)
* lasttransf_by : varchar(100)
v simpedak_db kalmut_unitpelayanan
* rowid : int
* kodeunit : char(10)
* namaunit : varchar(255)
* jnspelayanan : varchar(2)
* status : int
* flddisable : bit(1)
* kodeunit_map_rs : char(10)
* namaunit_map_rs : varchar(255)
* temp0 : varchar(1)
* catatan_mapping : varchar(25)
v simpedak_db kalmut_user_group_access
* access_id : int
* access_group_id : varchar(2)
* access_module_id : int
* access_add : varchar(1)
* access_delete : varchar(1)
* access_update : varchar(1)
* access_view : varchar(1)
* access_report : varchar(1)
* access_post_date : datetime
* access_record_status : char(1)
v simpedak_db local_quality_indicator
* indicator_id : int
* indicator_institution_code : varchar(11)
* indicator_name_id : int
* indicator_definition : text
* indicator_criteria_inclusive : text
* indicator_criteria_exclusive : text
* indicator_element : text
* indicator_source_of_data : varchar(100)
* indicator_type : varchar(50)
* indicator_value_standard : int
* indicator_monitoring_area : varchar(200)
* indicator_frequency : char(1)
* indicator_target : char(5)
* indicator_category_id : int
* indicator_iscomplete : int
* indicator_factors : varchar(5)
* indicator_units : varchar(10)
* indicator_lcl : varchar(15)
* indicator_ucl : varchar(15)
* indicator_valid_date : date
* indicator_last_updated : datetime
* indicator_order_number : int
* indicator_record_status : char(1)
v simpedak_db local_quality_indicator_document
* document_id : int
* document_result_id : int
* document_name : varchar(100)
* document_file_name : varchar(150)
* document_insert_by : varchar(6)
* document_department_id : varchar(20)
* document_institution_code : varchar(11)
* document_insert_date : datetime
* document_approval_status : char(1)
* document_record_status : char(1)
v simpedak_db local_quality_indicator_group
* group_id : int
* group_indicator_id : varchar(5)
* group_department_id : varchar(5)
* group_institution_code : varchar(11)
* group_period : varchar(4)
* group_type : char(1)
* group_record_status : char(1)
v simpedak_db local_quality_indicator_result
* result_id : int
* result_indicator_id : int
* result_institution_code : varchar(11)
* result_department_id : varchar(20)
* result_numerator_value : varchar(10)
* result_denumerator_value : varchar(10)
* result_document_amount : int
* result_period : date
* result_insert_date : datetime
* result_record_status : char(1)
* result_insert_by : varchar(6)
* result_update_date : datetime
* result_update_by : varchar(6)
* result_delete_date : datetime
* result_delete_by : varchar(6)
v simpedak_db local_quality_indicator_result_recapitulation
* recapitulation_id : int
* recapitulation_indicator_id : int
* recapitulation_institution_code : varchar(11)
* recapitulation_department_id : varchar(5)
* recapitulation_period : year
* recapitulation_jan_numerator : int
* recapitulation_jan_denumerator : int
* recapitulation_jan_post_date : date
* recapitulation_feb_numerator : int
* recapitulation_feb_denumerator : int
* recapitulation_feb_post_date : date
* recapitulation_mar_numerator : int
* recapitulation_mar_denumerator : int
* recapitulation_mar_post_date : date
* recapitulation_apr_numerator : int
* recapitulation_apr_denumerator : int
* recapitulation_apr_post_date : date
* recapitulation_may_numerator : int
* recapitulation_may_denumerator : int
* recapitulation_may_post_date : date
* recapitulation_jun_numerator : int
* recapitulation_jun_denumerator : int
* recapitulation_jun_post_date : date
* recapitulation_jul_numerator : int
* recapitulation_jul_denumerator : int
* recapitulation_jul_post_date : date
* recapitulation_aug_numerator : int
* recapitulation_aug_denumerator : int
* recapitulation_aug_post_date : date
* recapitulation_sep_numerator : int
* recapitulation_sep_denumerator : int
* recapitulation_sep_post_date : date
* recapitulation_oct_numerator : int
* recapitulation_oct_denumerator : int
* recapitulation_oct_post_date : date
* recapitulation_nov_numerator : int
* recapitulation_nov_denumerator : int
* recapitulation_nov_post_date : date
* recapitulation_dec_numerator : int
* recapitulation_dec_denumerator : int
* recapitulation_dec_post_date : date
* recapitulation_post_date : datetime
* recapitulation_record_status : char(1)
v simpedak_db local_quality_indicator_variable
* variable_id : int
* variable_institution_code : varchar(11)
* variable_indicator_id : int
* variable_name : text
* variable_type : char(1)
* variable_unit_name : char(10)
* variable_last_updated : datetime
* variable_record_status : char(1)
v simpedak_db location_city
* city_id : int
* city_province_code : varchar(2)
* city_province_name : varchar(50)
* city_code : varchar(5)
* city_name : varchar(50)
v simpedak_db location_district
* district_id : int
* district_city_code : varchar(4)
* district_code : varchar(7)
* district_name : varchar(50)
v simpedak_db location_province
* province_id : int
* province_code : varchar(2)
* province_name : varchar(40)
* province_abbreviation : varchar(15)
* province_regional : varchar(150)
* province_hsac : varchar(10)
* province_record_status : char(1)
v simpedak_db location_village
* village_id : int
* village_district_code : varchar(7)
* village_code : varchar(10)
* village_name : varchar(30)
* village_postcode : char(5)
v simpedak_db master_institution_department
* department_id : int
* department_name : varchar(50)
* department_description : text
* department_institution_code : varchar(11)
* department_record_status : char(1)
v simpedak_db modules
* modules_id : int
* modules_category : int
* modules_title : varchar(50)
* modules_description : varchar(50)
* modules_is_display : char(1)
* modules_parent : int
* modules_position : char(5)
* modules_icon : varchar(20)
* modules_order_number : varchar(3)
* modules_record_status : char(1)
v simpedak_db quality_indicator
* indicator_id : int
* indicator_uuid : varchar(100)
* indicator_name_id : int
* indicator_definition : text
* indicator_criteria_inclusive : text
* indicator_criteria_exclusive : text
* indicator_element : text
* indicator_source_of_data : varchar(100)
* indicator_type : varchar(50)
* indicator_value_standard : int
* indicator_monitoring_area : varchar(200)
* indicator_frequency : char(1)
* indicator_target : char(5)
* indicator_category_id : int
* indicator_iscomplete : int
* indicator_factors : varchar(5)
* indicator_units : varchar(10)
* indicator_lcl : varchar(15)
* indicator_ucl : varchar(15)
* indicator_valid_date : date
* indicator_last_updated : datetime
* indicator_order_number : int
* indicator_record_status : char(1)
v simpedak_db quality_indicator_document
* document_id : int
* document_result_id : int
* document_name : varchar(100)
* document_file_name : varchar(150)
* document_insert_by : varchar(6)
* document_department_id : varchar(20)
* document_institution_code : varchar(11)
* document_insert_date : datetime
* document_approval_status : char(1)
* document_record_status : char(1)
v simpedak_db quality_indicator_group
* group_id : int
* group_indicator_id : varchar(5)
* group_department_id : varchar(5)
* group_institution_code : varchar(11)
* group_period : varchar(4)
* group_type : char(1)
* group_record_status : char(1)
v simpedak_db quality_indicator_result
* result_id : int
* result_indicator_id : int
* result_institution_code : varchar(11)
* result_department_id : varchar(20)
* result_numerator_value : varchar(10)
* result_denumerator_value : varchar(10)
* result_document_amount : int
* result_period : date
* result_insert_date : datetime
* result_record_status : char(1)
* result_insert_by : varchar(6)
* result_update_date : datetime
* result_update_by : varchar(6)
* result_delete_date : datetime
* result_delete_by : varchar(6)
v simpedak_db quality_indicator_result_recapitulation
* recapitulation_id : int
* recapitulation_indicator_id : int
* recapitulation_institution_code : varchar(11)
* recapitulation_department_id : varchar(5)
* recapitulation_period : year
* recapitulation_jan_numerator : int
* recapitulation_jan_denumerator : int
* recapitulation_jan_post_date : date
* recapitulation_feb_numerator : int
* recapitulation_feb_denumerator : int
* recapitulation_feb_post_date : date
* recapitulation_mar_numerator : int
* recapitulation_mar_denumerator : int
* recapitulation_mar_post_date : date
* recapitulation_apr_numerator : int
* recapitulation_apr_denumerator : int
* recapitulation_apr_post_date : date
* recapitulation_may_numerator : int
* recapitulation_may_denumerator : int
* recapitulation_may_post_date : date
* recapitulation_jun_numerator : int
* recapitulation_jun_denumerator : int
* recapitulation_jun_post_date : date
* recapitulation_jul_numerator : int
* recapitulation_jul_denumerator : int
* recapitulation_jul_post_date : date
* recapitulation_aug_numerator : int
* recapitulation_aug_denumerator : int
* recapitulation_aug_post_date : date
* recapitulation_sep_numerator : int
* recapitulation_sep_denumerator : int
* recapitulation_sep_post_date : date
* recapitulation_oct_numerator : int
* recapitulation_oct_denumerator : int
* recapitulation_oct_post_date : date
* recapitulation_nov_numerator : int
* recapitulation_nov_denumerator : int
* recapitulation_nov_post_date : date
* recapitulation_dec_numerator : int
* recapitulation_dec_denumerator : int
* recapitulation_dec_post_date : date
* recapitulation_post_date : datetime
* recapitulation_record_status : char(1)
v simpedak_db quality_indicator_variable
* variable_id : int
* variable_uuid : varchar(100)
* variable_indicator_id : int
* variable_name : text
* variable_type : char(1)
* variable_unit_name : char(10)
* variable_last_updated : datetime
* variable_record_status : char(1)
v simpedak_db sidokaf_accreditation_event
* event_id : int
* event_accreditation_version : varchar(4)
* event_category_id : int
* event_name : text
* event_institution_group_id : char(2)
* event_institution_code : char(11)
* event_institution_name : varchar(250)
* event_province_code : varchar(3)
* event_province_name : varchar(25)
* event_city_code : int
* event_city_name : varchar(25)
* event_start_date_plan : date
* event_end_date_plan : date
* event_start_date : date
* event_end_date : date
* event_insert_date : datetime
* event_insert_by : char(6)
* event_update_date : datetime
* event_update_by : char(6)
* event_delete_date : datetime
* event_delete_by : char(6)
* event_record_status : char(1)
v simpedak_db sidokaf_accreditation_institution_document
* document_id : int
* document_event_id : int
* document_institution_code : varchar(11)
* document_instrument_id : int
* document_instrument_reference_code : varchar(50)
* document_type : varchar(2)
* document_name : varchar(100)
* document_file_name : varchar(250)
* document_insert_by : int
* document_insert_date : datetime
* document_update_date : datetime
* document_update_by : varchar(6)
* document_delete_date : datetime
* document_delete_by : varchar(6)
* document_approval_status : char(1)
* document_record_status : char(1)
v simpedak_db sidokaf_accreditation_transaction
* transaction_id : int
* transaction_accreditation_id : int
* transaction_event_id : int
* transaction_instrument_id : int
* transaction_chapter_id : int
* transaction_instrument_reference_code : varchar(50)
* transaction_standard_id : int
* transaction_institution_code : varchar(11)
* transaction_institution_score : varchar(3)
* transaction_institution_update_date : datetime
* transaction_institution_update_by : int
* transaction_institution_is_approved : int
* transaction_institution_approve_date : datetime
* transaction_surveyor_update_by : char(5)
* transaction_surveyor_score : varchar(3)
* transaction_surveyor_fact_and_analysis : text
* transaction_surveyor_recommendation : text
* transaction_surveyor_need_to_discussed : int
* transaction_surveyor_update_date : datetime
* transaction_counselor_update_by : char(5)
* transaction_counselor_score : varchar(3)
* transaction_counselor_fact_and_analysis : text
* transaction_counselor_note : text
* transaction_counselor_message : text
* transaction_evaluation_x1 : char(1)
* transaction_evaluation_x2 : char(1)
* transaction_evaluation_x3 : char(1)
* transaction_counselor_update_date : datetime
* transaction_counselor_is_approved : int
* transaction_counselor_approved_date : date
* transaction_remedial_surveyor_update_by : char(5)
* transaction_remedial_surveyor_score : varchar(3)
* transaction_remedial_surveyor_fact_and_analysis : text
* transaction_remedial_surveyor_recommendation : text
* transaction_remedial_surveyor_update_date : datetime
* transaction_final_score : varchar(3)
* transaction_is_evaluated : int
* transaction_is_discussed : int
* transaction_verification_1 : varchar(10)
* transaction_verification_1_recommendation : text
* transaction_verification_1_insert_by : varchar(6)
* transaction_verification_1_insert_date : datetime
* transaction_verification_2 : varchar(10)
* transaction_verification_2_recommendation : text
* transaction_verification_2_insert_by : varchar(6)
* transaction_verification_2_insert_date : datetime
* transaction_document_amount : int
* transaction_record_status : char(1)
* transaction_period : year
v simpedak_db sidokaf_accreditation_transaction_chapter
* trans_id : int
* trans_event_id : int
* trans_chapter_id : int
* trans_institution_code : varchar(11)
* trans_institution_score : varchar(5)
* trans_institution_date : datetime
* trans_surveyor_score : float
* trans_surveyor_value : text
* trans_surveyor_update_by : int
* trans_surveyor_date : datetime
* trans_remedial_surveyor_score : float
* trans_remedial_surveyor_value : text
* trans_remedial_surveyor_update_by : int
* trans_remedial_surveyor_date : datetime
* trans_counselor_score : float
* trans_counselor_value : text
* trans_counselor_update_by : int
* trans_counselor_date : datetime
* trans_final_score_0 : int
* trans_final_score_5 : int
* trans_final_score_10 : int
* trans_final_is_tdd : char(1)
* trans_final_score : float
* trans_verification_1 : char(1)
* trans_verification_2 : char(1)
* trans_status_id : char(2)
* trans_insert_date : datetime
* trans_insert_by : int
* trans_record_status : char(1)
v simpedak_db user_access
* access_id : int
* access_user_id : int
* access_module_id : int
* access_add : int
* access_delete : int
* access_update : int
* access_view : int
* access_report : int
* access_showhidecolumns : int
* access_export : int
* access_approve : int
* access_insert_date : datetime
* access_record_status : char(1)
v simpedak_db user_group
* group_id : int
* group_name : varchar(50)
* group_health_care : char(1)
* group_application_type : int
* group_record_status : char(1)
v simpedak_db user_group_access
* access_id : int
* access_group_id : varchar(2)
* access_module_id : int
* access_add : varchar(1)
* access_delete : varchar(1)
* access_update : varchar(1)
* access_view : varchar(1)
* access_report : varchar(1)
* access_showhidecolumns : int
* access_export : int
* access_approve : int
* access_post_date : datetime
* access_record_status : char(1)
v simpedak_db user_group_access_detil
* detil_id : int
* detil_profile_id : varchar(10)
* detil_employee_id : varchar(10)
* detil_group_id : varchar(10)
* detil_subgroup_id : varchar(10)
* detil_start_date : date
* detil_end_date : date
* detil_description : varchar(250)
* detil_notes : varchar(250)
* detil_update_date : datetime
* detil_update_by : varchar(10)
* detil_record_status : char(1)
* detil_insert_date : datetime
* detil_insert_by : varchar(10)
v simpedak_db user_log
* log_id : int
* log_ip : varchar(32)
* log_hostname : varchar(100)
* log_profile_id : varchar(6)
* log_last_login : datetime
* log_session : char(32)
* log_last_activity : varchar(250)
* log_logout : datetime
* log_is_type : enum('no','yes')
* log_record_status : char(1)
v simpedak_db user_profile
* profile_id : int
* profile_group_id : char(20)
* profile_subgroup_id : varchar(50)
* profile_operator_id : int
* profile_fullname : varchar(100)
* profile_employee_id : varchar(25)
* profile_birth_place : varchar(50)
* profile_dob : date
* profile_gender : int
* profile_religion : int
* profile_address : varchar(300)
* profile_city_code : char(5)
* profile_city_name : varchar(30)
* profile_district_code : char(7)
* profile_village_code : char(10)
* profile_postcode : varchar(5)
* profile_living_address : varchar(300)
* profile_living_city_code : char(5)
* profile_living_province_code : char(2)
* profile_living_district_code : char(7)
* profile_living_village_code : char(10)
* profile_living_postcode : varchar(5)
* profile_province_code : char(2)
* profile_province_name : varchar(30)
* profile_handphone1 : char(20)
* profile_handphone2 : char(20)
* profile_email : varchar(100)
* profile_gmail : varchar(100)
* profile_npwp : varchar(25)
* profile_fullname_npwp : varchar(50)
* profile_bank : varchar(50)
* profile_bank_account : varchar(25)
* profile_bank_account_holder : varchar(50)
* profile_competency_id : varchar(8)
* profile_nationality_id : varchar(20)
* profile_str_id : varchar(50)
* profile_str_expired : date
* profile_sip_id : varchar(50)
* profile_sip_expired : date
* profile_spk_id : varchar(50)
* profile_spk_expired : date
* profile_rkk_id : varchar(50)
* profile_rkk_expired : date
* profile_work_type : char(1)
* profile_work_status : int
* profile_work_position : int
* profile_work_date : date
* profile_workshop_partnership_id : int
* profile_department_id : varchar(10)
* profile_signs : char(36)
* profile_specialize_id : char(1)
* profile_major : char(1)
* profile_insert_by : varchar(5)
* profile_insert_date : datetime
* profile_update_by : varchar(5)
* profile_update_date : datetime
* profile_delete_date : datetime
* profile_delete_by : int
* profile_institution_code : varchar(11)
* profile_institution_name : varchar(200)
* profile_institution_ownership_id : char(2)
* profile_institution_province_code : varchar(50)
* profile_institution_city_code : varchar(10)
* profile_institution_group_id : varchar(10)
* profile_regional_city_code : varchar(6)
* profile_batch : char(4)
* profile_bpjs_number : varchar(25)
* profile_toefl_score : varchar(5)
* profile_photo : varchar(250)
* profile_grade_code : varchar(2)
* profile_password : varchar(32)
* profile_last_change_password : datetime
* profile_online_status : int
* profile_disable : int
* profile_disable_reason : int
* profile_note : varchar(250)
* profile_last_login : datetime
* profile_partnership_code : varchar(32)
* profile_partnership_ed : date
* profile_record_status : char(1)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship