CREATE TABLE `psi_fora` (
  `fr_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `fr_requesting_party` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fr_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fr_sectors` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fr_start` datetime DEFAULT NULL,
  `fr_end` datetime DEFAULT NULL,
  `fr_duration` double unsigned DEFAULT '0',
  `fr_location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fr_longitude` double unsigned DEFAULT '0',
  `fr_latitude` double unsigned DEFAULT '0',
  `fr_elevation` double unsigned DEFAULT '0',
  `fr_cost` double unsigned DEFAULT '0',
  `fr_csf` double unsigned DEFAULT '0',
  `fr_no_feminine` int(10) unsigned DEFAULT '0',
  `fr_no_masculine` int(10) unsigned DEFAULT '0',
  `fr_no_pwd` int(10) unsigned DEFAULT '0',
  `fr_no_seniors` int(10) unsigned DEFAULT '0',
  `fr_no_firms` int(10) unsigned DEFAULT '0',
  `fr_no_participants` int(10) unsigned DEFAULT '0',
  `fr_type_id` bigint(20) unsigned DEFAULT '0',
  `fr_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prj_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,
  `fr_no_po` int(10) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `sp_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',
  PRIMARY KEY (`fr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=963 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

