CREATE TABLE `psi_project_pis` (
  `prjpis_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `prj_id` bigint(20) unsigned DEFAULT '0',
  `prjpis_year` int(10) unsigned DEFAULT '2017',
  `quarter_id` int(10) unsigned DEFAULT '1',
  `sem_id` bigint(20) unsigned DEFAULT '1',
  `prjpis_total_assets_land` decimal(65,3) unsigned DEFAULT '0.000',
  `prjpis_total_assets_building` decimal(65,3) unsigned DEFAULT '0.000',
  `prjpis_total_assets_equipment` decimal(65,3) unsigned DEFAULT '0.000',
  `prjpis_total_assets_working_capital` decimal(65,3) unsigned DEFAULT '0.000',
  `prjpis_total_employment` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_regular_male` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_regular_female` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_regular_pwd` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_regular_senior` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_part_time_male` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_part_time_female` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_part_time_pwd` int(10) unsigned DEFAULT '0',
  `prjpis_dir_ch_part_time_senior` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_regular_male` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_regular_female` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_regular_pwd` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_regular_senior` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_part_time_male` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_part_time_female` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_part_time_pwd` int(10) unsigned DEFAULT '0',
  `prjpis_dir_sh_part_time_senior` int(10) unsigned DEFAULT '0',
  `prjpis_indir_backward_male` int(10) unsigned DEFAULT '0',
  `prjpis_indir_backward_female` int(10) unsigned DEFAULT '0',
  `prjpis_indir_backward_pwd` int(10) unsigned DEFAULT '0',
  `prjpis_indir_backward_senior` int(10) unsigned DEFAULT '0',
  `prjpis_indir_forward_male` int(10) unsigned DEFAULT '0',
  `prjpis_indir_forward_female` int(10) unsigned DEFAULT '0',
  `prjpis_indir_forward_pwd` int(10) unsigned DEFAULT '0',
  `prjpis_indir_forward_senior` int(10) unsigned DEFAULT '0',
  `prjpis_volume_production_local` decimal(65,3) DEFAULT '0.000',
  `prjpis_volume_production_export` decimal(65,3) DEFAULT '0.000',
  `prjpis_gross_sales_local` decimal(65,3) DEFAULT '0.000',
  `prjpis_gross_sales_export` decimal(65,3) DEFAULT '0.000',
  `prjpis_countries_of_destination` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_process` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_equipment` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_quality_control` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_packaging_labeling` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_post_harvest` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_marketing` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_training_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_consultancy_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_others_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  `prjform_id` bigint(20) unsigned DEFAULT '0',
  `prjpis_assistance_training` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_consultancy` tinyint(1) unsigned DEFAULT '0',
  `prjpis_assistance_process_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_quality_control_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_post_harvest_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_marketing_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjpis_assistance_others` tinyint(1) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`prjpis_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2237 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

