CREATE TABLE `psi_projects` (
  `prj_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `prj_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `prj_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prj_year_approved` int(10) unsigned DEFAULT '2015',
  `prj_objective` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_expected_output` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_product_line` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_cost_setup` double unsigned DEFAULT '0',
  `prj_cost_gia` double unsigned DEFAULT '0',
  `prj_cost_rollout` double unsigned DEFAULT '0',
  `prj_cost_benefactor` double unsigned DEFAULT '0',
  `prj_cost_other` double unsigned DEFAULT '0',
  `prj_fund_release_date` date DEFAULT NULL,
  `prj_intervention` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `prj_longitude` double unsigned DEFAULT '0',
  `prj_latitude` double unsigned DEFAULT '0',
  `prj_elevation` double unsigned DEFAULT '0',
  `prj_type_id` bigint(20) unsigned DEFAULT '0',
  `prj_status_id` bigint(20) unsigned DEFAULT '0',
  `prj_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ru_id` bigint(20) unsigned DEFAULT '0',
  `province_id` bigint(20) unsigned DEFAULT '0',
  `city_id` bigint(20) unsigned DEFAULT '0',
  `barangay_id` bigint(20) unsigned DEFAULT '0',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `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,
  `prj_refund_period_from` date DEFAULT NULL,
  `prj_refund_period_to` date DEFAULT NULL,
  `prj_province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `prj_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `prj_barangay` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `prj_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sector_id` bigint(20) unsigned DEFAULT '0',
  `prj_pis_total_assets_land` decimal(65,3) unsigned DEFAULT '0.000',
  `prj_pis_total_assets_building` decimal(65,3) unsigned DEFAULT '0.000',
  `prj_pis_total_assets_equipment` decimal(65,3) unsigned DEFAULT '0.000',
  `prj_pis_total_assets_working_capital` decimal(65,3) unsigned DEFAULT '0.000',
  `prj_pis_total_employment` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_regular_male` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_regular_female` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_regular_pwd` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_regular_senior` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_part_time_male` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_part_time_female` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_part_time_pwd` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_ch_part_time_senior` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_regular_male` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_regular_female` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_regular_pwd` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_regular_senior` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_part_time_male` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_part_time_female` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_part_time_pwd` int(10) unsigned DEFAULT '0',
  `prj_pis_dir_sh_part_time_senior` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_backward_male` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_backward_female` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_backward_pwd` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_backward_senior` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_forward_male` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_forward_female` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_forward_pwd` int(10) unsigned DEFAULT '0',
  `prj_pis_indir_forward_senior` int(10) unsigned DEFAULT '0',
  `prj_pis_volume_production_local` decimal(65,3) DEFAULT '0.000',
  `prj_pis_volume_production_export` decimal(65,3) DEFAULT '0.000',
  `prj_pis_gross_sales_local` decimal(65,3) DEFAULT '0.000',
  `prj_pis_gross_sales_export` decimal(65,3) DEFAULT '0.000',
  `prj_pis_countries_of_destination` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_process` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_equipment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_quality_control` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_packaging_labeling` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_post_harvest` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_marketing` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_training` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_consultancy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_others` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_conceptualization` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_pis_assistance_proposal_preparation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_cost_benefactor_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_fundingsource_local` tinyint(1) unsigned DEFAULT '0',
  `prj_fundingsource_external` tinyint(1) unsigned DEFAULT '0',
  `prj_duration_from` date DEFAULT NULL,
  `prj_duration_to` date DEFAULT NULL,
  `prj_startup_assistance` tinyint(1) unsigned DEFAULT '0',
  `prj_cofunded_nga` tinyint(1) unsigned DEFAULT '0',
  `prj_cofunded_lgu` tinyint(1) unsigned DEFAULT '0',
  `prj_cost_nga` double unsigned DEFAULT '0',
  `prj_cost_lgu` double unsigned DEFAULT '0',
  `prj_cost_local` double unsigned DEFAULT '0',
  `prj_cost_external` double unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`prj_id`)
) ENGINE=InnoDB AUTO_INCREMENT=722 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

