-- SQL dump of `dhis2_datavalues`
-- Generated: 2026-06-04T15:43:54+00:00

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `dhis2_datavalues`;
CREATE TABLE `dhis2_datavalues` (
  `dataElement` varchar(64) NOT NULL,
  `period` varchar(32) NOT NULL,
  `orgUnit` varchar(64) NOT NULL,
  `categoryOptionCombo` varchar(64) NOT NULL,
  `attributeOptionCombo` varchar(64) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `storedBy` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `lastUpdated` datetime DEFAULT NULL,
  `comment_txt` text DEFAULT NULL,
  `followUp` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`dataElement`,`period`,`orgUnit`,`categoryOptionCombo`,`attributeOptionCombo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Rows: 0

SET FOREIGN_KEY_CHECKS=1;
-- End of dump
