table|psi_activities
activity_type_id bigint(20) unsigned NULL DEFAULT '0'
activity_title varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
activity_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
activity_target_date date NULL DEFAULT NULL
activity_date_accomplished date NULL DEFAULT NULL
activity_csf double unsigned NULL DEFAULT '0'
activity_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
activity_no_participants int(10) unsigned NULL DEFAULT '0'
activity_no_male int(10) unsigned NULL DEFAULT '0'
activity_no_female int(10) unsigned NULL DEFAULT '0'
activity_no_pwd int(10) unsigned NULL DEFAULT '0'
activity_no_senior int(10) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
activity_no_articles bigint(20) unsigned NULL DEFAULT '1'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
ug_id bigint(20) unsigned NULL DEFAULT '0'
province_id bigint(20) unsigned NULL DEFAULT '0'
city_id bigint(20) unsigned NULL DEFAULT '0'
barangay_id bigint(20) unsigned NULL DEFAULT '0'
activity_longitude double unsigned NULL DEFAULT '0'
activity_latitude double unsigned NULL DEFAULT '0'
activity_elevation double unsigned NULL DEFAULT '0'
activity_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
table|psi_activity_types
activity_type_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_agencies
agency_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_acronym varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
agency_contact varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_email varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_phone varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_website varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
agency_mobile varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded date NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated date NULL DEFAULT NULL
agency_longitude varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '121.223697066307'
agency_latitude varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '14.1722468782053'
agency_gmap_key varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'AIzaSyCMDx-ejfVStxIBhfqtBuLj98OV79kqbdY'
agency_fb_appid varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '1685702521726852'
agency_region_id bigint(20) unsigned NULL DEFAULT '6'
agency_use_osm tinyint(3) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_barangays
city_id bigint(20) unsigned NULL DEFAULT '0'
district_id bigint(20) NULL DEFAULT '0'
barangay_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '0'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
table|psi_business_activities
ba_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_calibrations
cal_month int(10) unsigned NULL DEFAULT '0'
cal_year int(10) unsigned NULL DEFAULT '0'
cal_no_tests int(10) unsigned NULL DEFAULT '0'
cal_no_tests_paid int(10) unsigned NULL DEFAULT '0'
cal_no_tests_free int(10) unsigned NULL DEFAULT '0'
cal_no_calibrations int(10) unsigned NULL DEFAULT '0'
cal_no_tests_received int(11) unsigned NULL DEFAULT '0'
cal_petrochemical_in int(10) unsigned NULL DEFAULT '0'
cal_calibration_in int(10) unsigned NULL DEFAULT '0'
cal_halal_in int(10) unsigned NULL DEFAULT '0'
cal_no_tests_referred int(11) NULL DEFAULT '0'
cal_petrochemical_referred int(10) unsigned NULL DEFAULT '0'
cal_calibration_referred int(10) unsigned NULL DEFAULT '0'
cal_halal_referred int(10) unsigned NULL DEFAULT '0'
cal_no_tests_sent int(10) unsigned NULL DEFAULT '0'
cal_no_clients int(10) unsigned NULL DEFAULT '0'
cal_no_clients_free int(10) unsigned NULL DEFAULT '0'
cal_no_firms int(10) unsigned NULL DEFAULT '0'
cal_no_tests_on_time int(10) unsigned NULL DEFAULT '0'
cal_no_additional_members int(11) unsigned NULL DEFAULT '0'
cal_passed_test_parameters int(11) unsigned NULL DEFAULT '0'
cal_passed_profeciency_certification int(11) unsigned NULL DEFAULT '0'
cal_income decimal(65,3) unsigned NULL DEFAULT '0.000'
cal_income_gross decimal(65,3) unsigned NULL DEFAULT '0.000'
cal_value_service decimal(65,3) unsigned NULL DEFAULT '0.000'
cal_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
lab_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_cities
region_id bigint(20) unsigned NULL DEFAULT '0'
province_id bigint(20) unsigned NULL DEFAULT '0'
city_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
district_id bigint(20) unsigned NULL DEFAULT '0'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
table|psi_collaborators
col_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
col_abbr varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
ot_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_consultancies
con_start date NULL DEFAULT NULL
con_end date NULL DEFAULT NULL
con_type_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
coop_id bigint(20) unsigned NULL DEFAULT '0'
sp_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
con_no_participants int(10) unsigned NULL DEFAULT '0'
con_no_firms int(10) unsigned NULL DEFAULT '0'
con_no_po int(10) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
con_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
table|psi_consultancy_documents
con_id bigint(20) unsigned NULL DEFAULT '0'
condoc_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
condoc_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
condoc_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_consultancy_types
con_type_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_coop_sectors
coop_id bigint(20) unsigned NULL DEFAULT '0'
sector_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_cooperators
coop_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_p_fname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_p_mname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_p_lname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
coop_phone varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_fax varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_mobile varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_email varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_website varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_year_established int(10) unsigned NULL DEFAULT '0'
ot_id bigint(20) NULL DEFAULT '0'
loc_id bigint(20) NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
coop_reg_dti varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_reg_sec varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_reg_cda varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_reg_others text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
coop_reg_dti_date date NULL DEFAULT NULL
coop_reg_sec_date date NULL DEFAULT NULL
coop_reg_cda_date date NULL DEFAULT NULL
coop_products text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
coop_brief text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ot_cat1_id bigint(20) unsigned NULL DEFAULT '0'
ot_cat2_id bigint(20) unsigned NULL DEFAULT '0'
ot_cat3_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
coop_p_position varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
coop_p_gender tinyint(1) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_course_categories
course_cat_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_courses
course_cat_id bigint(20) unsigned NULL DEFAULT '0'
course_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
course_yearcount int(11) unsigned NULL DEFAULT '4'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_csf_ratings
csrat_date date NULL DEFAULT NULL
csrat_no_customers int(10) unsigned NULL DEFAULT '0'
csrat_rating int(11) NULL DEFAULT '0'
csrat_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
csrat_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
csrat_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_distributions
dist_label varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_districts
district_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '0'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
table|psi_draftlevels
draftlevel_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_drrm
drrm_date date NULL DEFAULT NULL
drrm_installed int(10) unsigned NULL DEFAULT '0'
drrm_maintained int(10) unsigned NULL DEFAULT '0'
drrm_activities int(10) unsigned NULL DEFAULT '0'
drrm_devices int(10) unsigned NULL DEFAULT '0'
drrm_iec int(10) unsigned NULL DEFAULT '0'
drrm_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
drrm_collaborations int(10) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_equipment
eqp_specs text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
eqp_qty int(10) unsigned NULL DEFAULT '0'
eqp_amount_approved decimal(65,3) unsigned NULL DEFAULT '0.000'
eqp_amount_acquired decimal(65,3) unsigned NULL DEFAULT '0.000'
eqp_property_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
eqp_date_acquired date NULL DEFAULT NULL
eqp_receipt_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
eqp_receipt_date date NULL DEFAULT NULL
eqp_warranty varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
eqp_date_tagged date NULL DEFAULT NULL
eqp_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
brand_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
sp_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
imp_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_equipment_brands
brand_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_expertise
expertise_type varchar(30) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_fora
fr_requesting_party text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
fr_title text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
fr_sectors text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
fr_start datetime NULL DEFAULT NULL
fr_end datetime NULL DEFAULT NULL
fr_duration double unsigned NULL DEFAULT '0'
fr_location text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
fr_longitude double unsigned NULL DEFAULT '0'
fr_latitude double unsigned NULL DEFAULT '0'
fr_elevation double unsigned NULL DEFAULT '0'
fr_cost double unsigned NULL DEFAULT '0'
fr_csf double unsigned NULL DEFAULT '0'
fr_no_feminine int(10) unsigned NULL DEFAULT '0'
fr_no_masculine int(10) unsigned NULL DEFAULT '0'
fr_no_pwd int(10) unsigned NULL DEFAULT '0'
fr_no_seniors int(10) unsigned NULL DEFAULT '0'
fr_no_firms int(10) unsigned NULL DEFAULT '0'
fr_no_participants int(10) unsigned NULL DEFAULT '0'
fr_type_id bigint(20) unsigned NULL DEFAULT '0'
fr_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
fr_no_po int(10) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
sp_id bigint(20) unsigned NULL DEFAULT '0'
province_id bigint(20) unsigned NULL DEFAULT '0'
city_id bigint(20) unsigned NULL DEFAULT '0'
barangay_id bigint(20) unsigned NULL DEFAULT '0'
table|psi_fora_collaborators
fr_id bigint(20) unsigned NULL DEFAULT '0'
col_id bigint(20) unsigned NULL DEFAULT '0'
fcol_timestamp timestamp NULL DEFAULT 'CURRENT_TIMESTAMP'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_fora_document_types
fdoctype_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_fora_documents
frdoc_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
frdoc_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
frdoc_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
fdoctype_id bigint(20) unsigned NULL DEFAULT '0'
fr_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_fora_types
fr_type_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_gender
gen_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_gmap_counter
ctr_value bigint(20) unsigned NULL DEFAULT '0'
ctr_date datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_hub_types
hubt_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_improvements
imp_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_innovation_hubs
hub_date date NULL DEFAULT NULL
hub_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
hub_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
hub_longitude double NULL DEFAULT '0'
hub_latitude double NULL DEFAULT '0'
hub_elevation double NULL DEFAULT '0'
hub_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
province_id bigint(20) unsigned NULL DEFAULT '0'
city_id bigint(20) unsigned NULL DEFAULT '0'
barangay_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
hubt_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_international_collaborations
intc_date date NULL DEFAULT NULL
intc_description text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
intc_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_iso
iso_date date NULL DEFAULT NULL
iso_maintained tinyint(3) unsigned NULL DEFAULT NULL
iso_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_iso_rates
isor_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_iso_types
isotype_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_kpi_fin_indicators
kpifini_pos int(10) unsigned NULL DEFAULT '0'
kpifini_letter varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
kpifini_number varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpifini_label text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpifini_show_type tinyint(3) unsigned NULL DEFAULT '0'
kpifini_indent tinyint(3) unsigned NULL DEFAULT '0'
kpifini_subcat tinyint(3) unsigned NULL DEFAULT '0'
kpifini_label_only tinyint(1) unsigned NULL DEFAULT '0'
kpifini_acc_format tinyint(1) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_fin_values
kpifinv_date date NULL DEFAULT NULL
kpifinv_target double unsigned NULL DEFAULT '0'
kpifinv_q1 double NULL DEFAULT '0'
kpifinv_q2 double NULL DEFAULT '0'
kpifinv_q3 double NULL DEFAULT '0'
kpifinv_q4 double NULL DEFAULT '0'
kpifinv_acc double NULL DEFAULT '0'
kpifinv_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpifini_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
kpifinv_approved tinyint(3) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_indicators
kpiind_pos int(10) unsigned NULL DEFAULT '0'
kpiind_letter varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
kpiind_number varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpiind_label text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpiind_value_format tinyint(3) unsigned NULL DEFAULT '0'
kpiind_indent tinyint(3) unsigned NULL DEFAULT '0'
kpiind_row_format tinyint(3) unsigned NULL DEFAULT '0'
kpiind_label_only tinyint(3) unsigned NULL DEFAULT '0'
kpiind_acc_format tinyint(3) unsigned NULL DEFAULT '0'
kpiind_regional tinyint(3) unsigned NULL DEFAULT '0'
kpiind_provincial tinyint(3) unsigned NULL DEFAULT '0'
kpiind_municipal tinyint(3) unsigned NULL DEFAULT '0'
kpiind_notarget tinyint(3) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_ip_indicators
kpiipi_pos int(10) unsigned NULL DEFAULT '0'
kpiipi_letter varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
kpiipi_number varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpiipi_label text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpiipi_show_type tinyint(3) unsigned NULL DEFAULT '0'
kpiipi_indent tinyint(3) unsigned NULL DEFAULT '0'
kpiipi_subcat tinyint(3) unsigned NULL DEFAULT '0'
kpiipi_label_only tinyint(1) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_ip_values
kpiipv_date date NULL DEFAULT NULL
kpiipv_target int(10) unsigned NULL DEFAULT '0'
kpiipv_q1 int(10) NULL DEFAULT '0'
kpiipv_q2 int(10) NULL DEFAULT '0'
kpiipv_q3 int(10) NULL DEFAULT '0'
kpiipv_q4 int(10) NULL DEFAULT '0'
kpiipv_acc int(10) NULL DEFAULT '0'
kpiipv_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpiipi_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
kpiipv_approved tinyint(3) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_lag_indicators
kpilagi_pos int(10) unsigned NULL DEFAULT '0'
kpilagi_letter varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
kpilagi_number varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpilagi_label text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpilagi_show_type tinyint(3) unsigned NULL DEFAULT '0'
kpilagi_indent tinyint(3) unsigned NULL DEFAULT '0'
kpilagi_subcat tinyint(3) unsigned NULL DEFAULT '0'
kpilagi_label_only tinyint(1) unsigned NULL DEFAULT '0'
kpilagi_acc_format tinyint(1) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_lag_values
kpilagv_date date NULL DEFAULT NULL
kpilagv_target int(10) unsigned NULL DEFAULT '0'
kpilagv_q1 int(10) NULL DEFAULT '0'
kpilagv_q2 int(10) NULL DEFAULT '0'
kpilagv_q3 int(10) NULL DEFAULT '0'
kpilagv_q4 int(10) NULL DEFAULT '0'
kpilagv_acc int(10) NULL DEFAULT '0'
kpilagv_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
kpilagi_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
kpilagv_approved tinyint(3) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_kpi_targets
kpitar_date date NULL DEFAULT NULL
kpitar_q1 int(10) NULL DEFAULT '0'
kpitar_q2 int(10) NULL DEFAULT '0'
kpitar_q3 int(10) NULL DEFAULT '0'
kpitar_q4 int(10) NULL DEFAULT '0'
kpitar_approved tinyint(3) unsigned NULL DEFAULT '0'
kpitar_for bigint(20) unsigned NULL DEFAULT '0'
kpiind_id bigint(20) unsigned NULL DEFAULT '0'
kpitar_approved_1 tinyint(3) unsigned NULL DEFAULT '0'
kpitar_approved_2 tinyint(3) unsigned NULL DEFAULT '0'
kpitar_approved_3 tinyint(3) unsigned NULL DEFAULT '0'
kpitar_approved_4 tinyint(3) unsigned NULL DEFAULT '0'
kpitar_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
kpitar_key varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_laboratories
lab_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
lab_abbr varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_library
lib_month int(11) unsigned NULL DEFAULT NULL
lib_year int(11) unsigned NULL DEFAULT NULL
lib_user_count bigint(20) unsigned NULL DEFAULT NULL
lib_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
lib_starbooks int(11) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_non_profit
nonp_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_notification_days
nd_date date NULL DEFAULT NULL
table|psi_notifications
not_title varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
not_msg text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
not_readers text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
not_date date NULL DEFAULT NULL
not_type varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
ug_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_organization_types
ot_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_organization_types_cat1
ot_cat1_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_organization_types_cat2
ot_cat2_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_organization_types_cat3
ot_cat3_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_package_types
pkg_type_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_packaging
pkg_date date NULL DEFAULT NULL
pkg_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_product_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_brand_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_product_description text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_competitors text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_competitor_1 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_competitor_2 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_competitor_3 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_competitor_4 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_competitor_5 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_competitor_6 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_selling_point tinyint(1) unsigned NULL DEFAULT '0'
pkg_selling_point_others text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_performance text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_distribution tinyint(1) unsigned NULL DEFAULT '0'
pkg_ingredients text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_volume varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_packaging_material varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_label_size varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_preferred_colors varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_other_details text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_market_location text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pkg_market_products_sold bigint(20) unsigned NULL DEFAULT '0'
pkg_market_date_established date NULL DEFAULT NULL
pkg_sales_before_intervention double unsigned NULL DEFAULT '0'
pkg_sales_after_intervention double unsigned NULL DEFAULT '0'
pkg_employment_after_direct bigint(20) unsigned NULL DEFAULT '0'
pkg_employment_after_indirect bigint(20) unsigned NULL DEFAULT '0'
pkg_employment_after_months_employed bigint(20) unsigned NULL DEFAULT '0'
pkg_avg_productivity_improvement double unsigned NULL DEFAULT '0'
coop_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
pkg_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pkg_no_new_markets int(10) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
pkg_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
table|psi_packaging_designs
design_date datetime NULL DEFAULT NULL
design_description text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
draftlevel_id bigint(20) unsigned NULL DEFAULT '1'
pkg_id bigint(20) unsigned NULL DEFAULT '0'
design_image1 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
design_image2 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
design_filename1 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
design_filename2 varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_album_photos
photo_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
photo_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
photo_desc text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
album_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_albums
album_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
album_desc text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
album_event_date date NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
date_encoded datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_beneficiaries
prj_id bigint(20) unsigned NULL DEFAULT '0'
coop_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_calibrations
cal_month int(10) unsigned NULL DEFAULT '0'
cal_year int(10) unsigned NULL DEFAULT '0'
cal_no_parameters int(10) unsigned NULL DEFAULT '0'
cal_parameters text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
cal_no_tests_free bigint(20) unsigned NULL DEFAULT '0'
cal_no_products int(10) unsigned NULL DEFAULT '0'
cal_products text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
cal_income decimal(65,3) unsigned NULL DEFAULT '0.000'
cal_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
cal_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
ug_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
lab_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_collaborators
prj_id bigint(20) unsigned NULL DEFAULT '0'
col_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_document_types
doctype_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_documents
doc_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
doc_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
doc_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
doctype_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_forms
prjform_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_liquidation
liq_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
liq_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
liq_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
liqtype_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_liquidation_types
liqtype_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_monitoring
prj_id bigint(20) unsigned NULL DEFAULT '0'
prjmon_year int(10) unsigned NULL DEFAULT '2015'
quarter_id int(10) unsigned NULL DEFAULT '1'
sem_id bigint(20) unsigned NULL DEFAULT '1'
prjmon_total_assets_land decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_total_assets_building decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_total_assets_equipment decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_total_assets_working_capital decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_total_employment int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_regular_male int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_regular_female int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_regular_pwd int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_regular_senior int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_part_time_male int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_part_time_female int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_part_time_pwd int(10) unsigned NULL DEFAULT '0'
prjmon_dir_ch_part_time_senior int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_regular_male int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_regular_female int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_regular_pwd int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_regular_senior int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_part_time_male int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_part_time_female int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_part_time_pwd int(10) unsigned NULL DEFAULT '0'
prjmon_dir_sh_part_time_senior int(10) unsigned NULL DEFAULT '0'
prjmon_indir_backward_male int(10) unsigned NULL DEFAULT '0'
prjmon_indir_backward_female int(10) unsigned NULL DEFAULT '0'
prjmon_indir_backward_pwd int(10) unsigned NULL DEFAULT '0'
prjmon_indir_backward_senior int(10) unsigned NULL DEFAULT '0'
prjmon_indir_forward_male int(10) unsigned NULL DEFAULT '0'
prjmon_indir_forward_female int(10) unsigned NULL DEFAULT '0'
prjmon_indir_forward_pwd int(10) unsigned NULL DEFAULT '0'
prjmon_indir_forward_senior int(10) unsigned NULL DEFAULT '0'
prjmon_volume_production_local decimal(65,3) NULL DEFAULT '0.000'
prjmon_volume_production_export decimal(65,3) NULL DEFAULT '0.000'
prjmon_gross_sales_local decimal(65,3) NULL DEFAULT '0.000'
prjmon_gross_sales_export decimal(65,3) NULL DEFAULT '0.000'
prjmon_countries_of_destination text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_assistance_process tinyint(1) unsigned NULL DEFAULT '0'
prjmon_assistance_equipment tinyint(1) unsigned NULL DEFAULT '0'
prjmon_assistance_quality_control tinyint(1) unsigned NULL DEFAULT '0'
prjmon_assistance_packaging_labeling tinyint(1) unsigned NULL DEFAULT '0'
prjmon_assistance_post_harvest tinyint(1) unsigned NULL DEFAULT '0'
prjmon_assistance_marketing tinyint(1) unsigned NULL DEFAULT '0'
prjmon_assistance_training text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_assistance_consultancy text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_assistance_others text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_problems_met text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_actions_taken text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_improvement_action_plan text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_status_of_funds text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_reasons_for_termination text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_final_obligation text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_impact_of_intervention text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_final_recommendation text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_expected_output text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_actual_accomplishment text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_output_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_liquidation_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_liquidation_used decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_liquidation_date date NULL DEFAULT NULL
prjmon_liquidation_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_refund_amount decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_refund_schedule_from date NULL DEFAULT NULL
prjmon_refund_schedule_to date NULL DEFAULT NULL
prjmon_refund_amount_due decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_refund_date date NULL DEFAULT NULL
prjmon_refund_refunded decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_refund_unsettled decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_refund_delay_date date NULL DEFAULT NULL
prjmon_setup_amount decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_funds_release_date date NULL DEFAULT NULL
prjmon_refund_period_from date NULL DEFAULT NULL
prjmon_refund_period_to date NULL DEFAULT NULL
prjmon_termination_date date NULL DEFAULT NULL
prjmon_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_effectivity date NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
prjform_id bigint(20) unsigned NULL DEFAULT '0'
prjmon_volume_product_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prjmon_volume_of_production decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_volume_gross_sales decimal(65,3) unsigned NULL DEFAULT '0.000'
prjmon_emp_total bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_male bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_female bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_pwd bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_indirect_forward_male bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_indirect_forward_female bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_indirect_backward_male bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_indirect_backward_female bigint(20) unsigned NULL DEFAULT '0'
prjmon_market_existing text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_market_new text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_improvement_production_efficiency text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_emp_senior bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_in_total bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_in_male bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_in_female bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_in_pwd bigint(20) unsigned NULL DEFAULT '0'
prjmon_emp_in_senior bigint(20) unsigned NULL DEFAULT '0'
prjmon_improvement_production_actual_accomplishment text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjmon_improvement_production_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
prjmon_average_productivity decimal(65,0) NULL DEFAULT '0'
table|psi_project_pis
prj_id bigint(20) unsigned NULL DEFAULT '0'
prjpis_year int(10) unsigned NULL DEFAULT '2017'
quarter_id int(10) unsigned NULL DEFAULT '1'
sem_id bigint(20) unsigned NULL DEFAULT '1'
prjpis_total_assets_land decimal(65,3) unsigned NULL DEFAULT '0.000'
prjpis_total_assets_building decimal(65,3) unsigned NULL DEFAULT '0.000'
prjpis_total_assets_equipment decimal(65,3) unsigned NULL DEFAULT '0.000'
prjpis_total_assets_working_capital decimal(65,3) unsigned NULL DEFAULT '0.000'
prjpis_total_employment int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_regular_male int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_regular_female int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_regular_pwd int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_regular_senior int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_part_time_male int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_part_time_female int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_part_time_pwd int(10) unsigned NULL DEFAULT '0'
prjpis_dir_ch_part_time_senior int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_regular_male int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_regular_female int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_regular_pwd int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_regular_senior int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_part_time_male int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_part_time_female int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_part_time_pwd int(10) unsigned NULL DEFAULT '0'
prjpis_dir_sh_part_time_senior int(10) unsigned NULL DEFAULT '0'
prjpis_indir_backward_male int(10) unsigned NULL DEFAULT '0'
prjpis_indir_backward_female int(10) unsigned NULL DEFAULT '0'
prjpis_indir_backward_pwd int(10) unsigned NULL DEFAULT '0'
prjpis_indir_backward_senior int(10) unsigned NULL DEFAULT '0'
prjpis_indir_forward_male int(10) unsigned NULL DEFAULT '0'
prjpis_indir_forward_female int(10) unsigned NULL DEFAULT '0'
prjpis_indir_forward_pwd int(10) unsigned NULL DEFAULT '0'
prjpis_indir_forward_senior int(10) unsigned NULL DEFAULT '0'
prjpis_volume_production_local decimal(65,3) NULL DEFAULT '0.000'
prjpis_volume_production_export decimal(65,3) NULL DEFAULT '0.000'
prjpis_gross_sales_local decimal(65,3) NULL DEFAULT '0.000'
prjpis_gross_sales_export decimal(65,3) NULL DEFAULT '0.000'
prjpis_countries_of_destination text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_process tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_equipment tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_quality_control tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_packaging_labeling tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_post_harvest tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_marketing tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_training_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_consultancy_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_others_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
prjform_id bigint(20) unsigned NULL DEFAULT '0'
prjpis_assistance_training tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_consultancy tinyint(1) unsigned NULL DEFAULT '0'
prjpis_assistance_process_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_quality_control_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_post_harvest_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_marketing_text text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prjpis_assistance_others tinyint(1) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_process
proc_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
proc_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
proc_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
satt_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_production
production_volume decimal(65,3) unsigned NULL DEFAULT '0.000'
production_gross decimal(65,3) unsigned NULL DEFAULT '0.000'
prj_id bigint(20) unsigned NULL DEFAULT '0'
prjmon_id bigint(20) unsigned NULL DEFAULT '0'
prod_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_products
prod_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prod_unit varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
unit_id int(10) unsigned NULL DEFAULT '1'
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_sats
sat_date date NULL DEFAULT NULL
sat_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sat_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sat_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
satt_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_sectors
prj_id bigint(20) unsigned NULL DEFAULT '0'
sector_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_sites
prj_site_date date NULL DEFAULT NULL
prj_site_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_site_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_site_longitude double NULL DEFAULT '0'
prj_site_latitude double NULL DEFAULT '0'
prj_site_elevation double NULL DEFAULT '0'
brand_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
province_id bigint(20) unsigned NULL DEFAULT '0'
city_id bigint(20) unsigned NULL DEFAULT '0'
barangay_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_status
prj_status_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_status_history
psh_date datetime NULL DEFAULT NULL
prj_status_id bigint(20) unsigned NULL DEFAULT '0'
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_tna
tna_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
tna_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
tna_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_project_types
prj_type_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_project_videos
vid_date date NULL DEFAULT NULL
vid_title varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
vid_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
vid_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
vid_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_projects
prj_title varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prj_code varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_year_approved int(10) unsigned NULL DEFAULT '2015'
prj_objective text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_expected_output text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_product_line text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_cost_setup double unsigned NULL DEFAULT '0'
prj_cost_gia double unsigned NULL DEFAULT '0'
prj_cost_rollout double unsigned NULL DEFAULT '0'
prj_cost_benefactor double unsigned NULL DEFAULT '0'
prj_cost_other double unsigned NULL DEFAULT '0'
prj_fund_release_date date NULL DEFAULT NULL
prj_intervention varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prj_longitude double unsigned NULL DEFAULT '0'
prj_latitude double unsigned NULL DEFAULT '0'
prj_elevation double unsigned NULL DEFAULT '0'
prj_type_id bigint(20) unsigned NULL DEFAULT '0'
prj_status_id bigint(20) unsigned NULL DEFAULT '0'
prj_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ru_id bigint(20) unsigned NULL DEFAULT '0'
province_id bigint(20) unsigned NULL DEFAULT '0'
city_id bigint(20) unsigned NULL DEFAULT '0'
barangay_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
prj_refund_period_from date NULL DEFAULT NULL
prj_refund_period_to date NULL DEFAULT NULL
prj_province varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prj_city varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prj_barangay varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
prj_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
sector_id bigint(20) unsigned NULL DEFAULT '0'
prj_pis_total_assets_land decimal(65,3) unsigned NULL DEFAULT '0.000'
prj_pis_total_assets_building decimal(65,3) unsigned NULL DEFAULT '0.000'
prj_pis_total_assets_equipment decimal(65,3) unsigned NULL DEFAULT '0.000'
prj_pis_total_assets_working_capital decimal(65,3) unsigned NULL DEFAULT '0.000'
prj_pis_total_employment int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_regular_male int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_regular_female int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_regular_pwd int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_regular_senior int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_part_time_male int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_part_time_female int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_part_time_pwd int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_ch_part_time_senior int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_regular_male int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_regular_female int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_regular_pwd int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_regular_senior int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_part_time_male int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_part_time_female int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_part_time_pwd int(10) unsigned NULL DEFAULT '0'
prj_pis_dir_sh_part_time_senior int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_backward_male int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_backward_female int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_backward_pwd int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_backward_senior int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_forward_male int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_forward_female int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_forward_pwd int(10) unsigned NULL DEFAULT '0'
prj_pis_indir_forward_senior int(10) unsigned NULL DEFAULT '0'
prj_pis_volume_production_local decimal(65,3) NULL DEFAULT '0.000'
prj_pis_volume_production_export decimal(65,3) NULL DEFAULT '0.000'
prj_pis_gross_sales_local decimal(65,3) NULL DEFAULT '0.000'
prj_pis_gross_sales_export decimal(65,3) NULL DEFAULT '0.000'
prj_pis_countries_of_destination text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_process text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_equipment text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_quality_control text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_packaging_labeling text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_post_harvest text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_marketing text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_training text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_consultancy text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_others text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_conceptualization text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_pis_assistance_proposal_preparation text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_cost_benefactor_desc text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_fundingsource_local tinyint(1) unsigned NULL DEFAULT '0'
prj_fundingsource_external tinyint(1) unsigned NULL DEFAULT '0'
prj_duration_from date NULL DEFAULT NULL
prj_duration_to date NULL DEFAULT NULL
prj_startup_assistance tinyint(1) unsigned NULL DEFAULT '0'
prj_cofunded_nga tinyint(1) unsigned NULL DEFAULT '0'
prj_cofunded_lgu tinyint(1) unsigned NULL DEFAULT '0'
prj_cost_nga double unsigned NULL DEFAULT '0'
prj_cost_lgu double unsigned NULL DEFAULT '0'
prj_cost_local double unsigned NULL DEFAULT '0'
prj_cost_external double unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_promotion_types
prompt_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_provinces
region_id bigint(20) unsigned NULL DEFAULT '0'
province_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
table|psi_quarters
quarter_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_rcp
rcp_date date NULL DEFAULT NULL
rcp_implemented int(10) unsigned NULL DEFAULT '0'
rcp_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_referrals
ref_date date NULL DEFAULT NULL
ref_count int(10) unsigned NULL DEFAULT '0'
ref_customer varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ref_information text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ref_action text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ref_referred int(10) unsigned NULL DEFAULT '0'
ref_referral_to text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ref_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
ref_cost decimal(65,3) unsigned NULL DEFAULT '0.000'
table|psi_regions
region_code varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_repayment_checks
rep_check_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
rep_check_date date NULL DEFAULT NULL
rep_check_amount decimal(63,3) unsigned NULL DEFAULT '0.000'
rep_check_used tinyint(1) unsigned NULL DEFAULT '0'
rep_check_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
rep_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded date NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated date NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_repayments
rep_start_year int(10) unsigned NULL DEFAULT '0'
rep_start_month int(10) unsigned NULL DEFAULT '1'
rep_amount decimal(65,3) unsigned NULL DEFAULT '0.000'
rep_month_count int(10) unsigned NULL DEFAULT '36'
rep_otb_paid tinyint(1) unsigned NULL DEFAULT '0'
rep_monthly_payment decimal(65,3) unsigned NULL DEFAULT '0.000'
rep_ub_amount decimal(65,3) unsigned NULL DEFAULT '0.000'
rep_ub_receipt_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
rep_ub_check_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
rep_ub_check_date date NULL DEFAULT NULL
rep_add_amount decimal(65,3) unsigned NULL DEFAULT '0.000'
rep_add_check_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
rep_add_check_date date NULL DEFAULT NULL
rep_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
prj_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
rep_otb decimal(65,3) unsigned NULL DEFAULT '0.000'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_repayments_payment_types
pay_type_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_repayments_payments
pay_year int(10) unsigned NULL DEFAULT '2015'
pay_month int(10) unsigned NULL DEFAULT '1'
pay_count int(10) unsigned NULL DEFAULT '1'
pay_level int(10) unsigned NULL DEFAULT '1'
pay_amount_due decimal(65,3) NULL DEFAULT '0.000'
pay_amount_paid decimal(65,3) unsigned NULL DEFAULT '0.000'
pay_amount_date_paid date NULL DEFAULT NULL
pay_check_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pay_check_date date NULL DEFAULT NULL
pay_receipt_no varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
pay_type_id bigint(20) unsigned NULL DEFAULT '0'
pay_otb tinyint(1) unsigned NULL DEFAULT '0'
pay_penalty_amount_due decimal(65,3) unsigned NULL DEFAULT '0.000'
pay_penalty_amount_paid decimal(65,3) unsigned NULL DEFAULT '0.000'
pay_penalty_date_paid date NULL DEFAULT NULL
pay_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
pay_overdue_amount_due decimal(65,3) unsigned NULL DEFAULT '0.000'
pay_overdue_amount_paid decimal(65,3) unsigned NULL DEFAULT '0.000'
pay_overdue_date_paid date NULL DEFAULT NULL
rep_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_rnd_sectors
rndsec_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_rndagenda
rndagenda_date date NULL DEFAULT NULL
rndagenda_formulated int(10) unsigned NULL DEFAULT '0'
rndagenda_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_rndprj
rndprj_date date NULL DEFAULT NULL
rndprj_title varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
rndprj_description text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
rndprj_evaluated tinyint(1) unsigned NULL DEFAULT '0'
rndprj_endorsed tinyint(1) unsigned NULL DEFAULT '0'
rndprj_inhouse tinyint(1) unsigned NULL DEFAULT '0'
rndprj_implemented tinyint(1) unsigned NULL DEFAULT '0'
rndprj_colaborative tinyint(1) unsigned NULL DEFAULT '0'
rndprj_colaborators text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
rndprj_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
rndsec_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_sattypes
satt_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_scholarship_monitoring
scholar_mon_year_from int(10) unsigned NULL DEFAULT '0'
scholar_mon_year_to int(10) unsigned NULL DEFAULT '0'
scholar_mon_no_examinees int(10) unsigned NULL DEFAULT '0'
scholar_mon_no_qualifiers int(10) unsigned NULL DEFAULT '0'
scholar_mon_no_ongoing int(10) unsigned NULL DEFAULT '0'
scholar_mon_no_graduates int(10) unsigned NULL DEFAULT '0'
scholar_mon_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
scholar_mon_no_pshs int(10) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_scholarship_programs
scholar_prog_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_prog_desc text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_scholarship_status
scholar_stat_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_stat_abbr varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_scholarship_status_history
schst_date datetime NULL DEFAULT NULL
scholar_stat_id bigint(20) unsigned NULL DEFAULT '0'
scholar_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded date NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated date NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_scholarships
scholar_fname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_mname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_lname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_suffix varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_mobile varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_email varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
scholar_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
scholar_year_award int(10) unsigned NULL DEFAULT '0'
scholar_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
scholar_stat_id bigint(20) unsigned NULL DEFAULT '0'
scholar_prog_id bigint(20) unsigned NULL DEFAULT '0'
school_id bigint(20) unsigned NULL DEFAULT '0'
course_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_schools
school_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
school_acronym varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
school_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
school_coordinator varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
school_email varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
school_phone varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
school_mobile varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_sectors
sector_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_sellingpoints
sp_label varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_semesters
sem_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_service_provider_services
sp_id bigint(20) unsigned NULL DEFAULT '0'
service_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_service_providers
sp_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_other_service varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_designation varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_fname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_mname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_lname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_address text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
sp_expertise text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
sp_product_line varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_phone varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_mobile varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_email varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
sp_website varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_services
service_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_suc_assistance
suca_date date NULL DEFAULT NULL
suca_assistance text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
suca_no_ipr int(11) NULL DEFAULT '0'
suca_ipr text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
suca_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
school_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_technologies
tech_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_technologies_promoted
tech_id bigint(20) unsigned NULL DEFAULT '0'
prom_id bigint(20) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_technology_adoptions
adopt_date date NULL DEFAULT NULL
tech_id bigint(20) unsigned NULL DEFAULT '0'
coop_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
adopt_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
adopt_no_products int(11) NULL DEFAULT '0'
adopt_products text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
adopt_commercialized tinyint(3) unsigned NULL DEFAULT '0'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_technology_adoptions_documents
adopt_id bigint(20) unsigned NULL DEFAULT '0'
adoptdoc_file varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
adoptdoc_filename varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
adoptdoc_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_technology_promotions
prom_date date NULL DEFAULT NULL
tech_id bigint(20) unsigned NULL DEFAULT '0'
ug_id bigint(20) unsigned NULL DEFAULT '0'
prompt_id bigint(20) unsigned NULL DEFAULT '0'
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
coop_id bigint(20) unsigned NULL DEFAULT '0'
prom_remarks text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_units
unit_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
table|psi_user_log
log_date datetime NULL DEFAULT NULL
log_page_title varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
log_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
log_url varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
log_msg varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
log_referer text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
log_usergroup varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
log_querystring varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
log_agent text CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL
log_ip varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_user_rights
ur_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
date_encoded datetime NULL DEFAULT NULL
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
last_updated datetime NULL DEFAULT NULL
table|psi_usergroup_rights
ug_id bigint(20) unsigned NULL DEFAULT '0'
ur_id bigint(20) unsigned NULL DEFAULT '0'
ugr_view tinyint(1) unsigned NULL DEFAULT '1'
ugr_add tinyint(1) unsigned NULL DEFAULT '1'
ugr_edit tinyint(1) unsigned NULL DEFAULT '1'
ugr_delete tinyint(1) unsigned NULL DEFAULT '1'
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
table|psi_usergroups
ug_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
ug_is_admin tinyint(1) unsigned NULL DEFAULT '0'
ug_display_name varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
province_id bigint(20) unsigned NULL DEFAULT '0'
ug_parent_id bigint(20) unsigned NULL DEFAULT '0'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
ug_unit_head bigint(20) unsigned NULL DEFAULT '0'
table|psi_users
u_username varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_password varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_lname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_fname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_mname varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_mobile varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_email varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
u_access_type bigint(20) NULL DEFAULT '0'
u_enabled tinyint(1) unsigned NULL DEFAULT '1'
ug_id bigint(20) unsigned NULL DEFAULT '0'
u_phash varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
region_id bigint(20) unsigned NULL DEFAULT '6'
synched tinyint(1) unsigned NULL DEFAULT '0'
sync_date datetime NULL DEFAULT NULL
date_encoded datetime NULL DEFAULT NULL
last_updated datetime NULL DEFAULT NULL
encoder varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
updater varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
remember_token varchar(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT ''
remember_expiry datetime NULL DEFAULT NULL