CREATE TABLE `psi_intervention` (
  `interven_id` int(11) NOT NULL AUTO_INCREMENT,
  `proj_id` int(11) DEFAULT NULL,
  `interven_type_id` int(11) DEFAULT NULL,
  `start_date` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conducted_by` text COLLATE utf8mb4_unicode_ci,
  `equipment_id` int(11) DEFAULT NULL,
  `training_id` int(11) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL,
  `consult_id` int(11) DEFAULT NULL,
  `work_done` text COLLATE utf8mb4_unicode_ci,
  `interven_amt` float DEFAULT NULL,
  `receipt_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_receipt` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `encoder` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`interven_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_intervention (interven_id, proj_id, interven_type_id, start_date, end_date, conducted_by, equipment_id, training_id, package_id, consult_id, work_done, interven_amt, receipt_no, date_receipt, remarks, encoder, date_encoded, updater, last_updated, region_id, synched, sync_date) VALUES
(1, 4, 4, '03/04/2014', '03/04/2015', 'Rackie', 0, 0, 0, 0, 'Testing456789', '9000', 'GH78978', '0000-00-00', 'testing', 'Solejaena Herrera', '2014-03-23 22:08:05', 'Solejaena Herrera', '2014-03-24 00:40:03', 6, 0, NULL);
