CREATE TABLE `psi_calibrations` (
  `cal_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cal_month` int(10) unsigned DEFAULT '0',
  `cal_year` int(10) unsigned DEFAULT '0',
  `cal_no_tests` int(10) unsigned DEFAULT '0',
  `cal_no_tests_paid` int(10) unsigned DEFAULT '0',
  `cal_no_tests_free` int(10) unsigned DEFAULT '0',
  `cal_no_calibrations` int(10) unsigned DEFAULT '0',
  `cal_no_tests_received` int(11) unsigned DEFAULT '0',
  `cal_petrochemical_in` int(10) unsigned DEFAULT '0',
  `cal_calibration_in` int(10) unsigned DEFAULT '0',
  `cal_halal_in` int(10) unsigned DEFAULT '0',
  `cal_no_tests_referred` int(11) DEFAULT '0',
  `cal_petrochemical_referred` int(10) unsigned DEFAULT '0',
  `cal_calibration_referred` int(10) unsigned DEFAULT '0',
  `cal_halal_referred` int(10) unsigned DEFAULT '0',
  `cal_no_tests_sent` int(10) unsigned DEFAULT '0',
  `cal_no_clients` int(10) unsigned DEFAULT '0',
  `cal_no_clients_free` int(10) unsigned DEFAULT '0',
  `cal_no_firms` int(10) unsigned DEFAULT '0',
  `cal_no_tests_on_time` int(10) unsigned DEFAULT '0',
  `cal_no_additional_members` int(11) unsigned DEFAULT '0',
  `cal_passed_test_parameters` int(11) unsigned DEFAULT '0',
  `cal_passed_profeciency_certification` int(11) unsigned DEFAULT '0',
  `cal_income` decimal(65,3) unsigned DEFAULT '0.000',
  `cal_income_gross` decimal(65,3) unsigned DEFAULT '0.000',
  `cal_value_service` decimal(65,3) unsigned DEFAULT '0.000',
  `cal_cost` decimal(65,3) unsigned DEFAULT '0.000',
  `lab_id` bigint(20) unsigned DEFAULT '0',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `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 (`cal_id`)
) ENGINE=InnoDB AUTO_INCREMENT=337 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

