CREATE TABLE `psi_cooperators` (
  `coop_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coop_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_p_fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_p_mname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_p_lname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `coop_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_fax` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_year_established` int(10) unsigned DEFAULT '0',
  `ot_id` bigint(20) DEFAULT '0',
  `loc_id` bigint(20) 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,
  `coop_reg_dti` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_reg_sec` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_reg_cda` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_reg_others` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `coop_reg_dti_date` date DEFAULT NULL,
  `coop_reg_sec_date` date DEFAULT NULL,
  `coop_reg_cda_date` date DEFAULT NULL,
  `coop_products` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `coop_brief` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ot_cat1_id` bigint(20) unsigned DEFAULT '0',
  `ot_cat2_id` bigint(20) unsigned DEFAULT '0',
  `ot_cat3_id` bigint(20) unsigned DEFAULT '0',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `coop_p_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `coop_p_gender` 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 (`coop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

