CREATE TABLE `psi_kpi_targets` (
  `kpitar_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kpitar_date` date DEFAULT NULL,
  `kpitar_q1` int(10) DEFAULT '0',
  `kpitar_q2` int(10) DEFAULT '0',
  `kpitar_q3` int(10) DEFAULT '0',
  `kpitar_q4` int(10) DEFAULT '0',
  `kpitar_approved` tinyint(3) unsigned DEFAULT '0',
  `kpitar_for` bigint(20) unsigned DEFAULT '0',
  `kpiind_id` bigint(20) unsigned DEFAULT '0',
  `kpitar_approved_1` tinyint(3) unsigned DEFAULT '0',
  `kpitar_approved_2` tinyint(3) unsigned DEFAULT '0',
  `kpitar_approved_3` tinyint(3) unsigned DEFAULT '0',
  `kpitar_approved_4` tinyint(3) unsigned DEFAULT '0',
  `kpitar_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `kpitar_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `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,
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`kpitar_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2580 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

