Page History
...
CREATE TABLE IF NOT EXISTS DosageDrug (
DosageDrugPID BIGINT(15) AUTO_INCREMENT NOT NULL PRIMARY KEY,
releaseNumber BIGINT(15) NOT NULL,
drugId BIGINT(11) NOT NULL,
dosageUnitCode BIGINT(11) NOT NULL,
drugName VARCHAR(200) NOT NULL,
ModifiedDate DATETIME NOT NULL,
ValidFrom DATETIME NOT NULL,
ValidTo DATETIME NOT NULL,
CreatedDate DATETIME NOT NULL,
INDEX (DosageDrugPID, ModifiedDate),
INDEX (drugId, ValidTo, ValidFrom)
) ENGINE=InnoDB COLLATE=utf8_bin;
Tabel:
...
...
Tabel:Â DosageStructure
...
CREATE TABLE IF NOT EXISTS DosageVersion (
DosageVersionPID BIGINT(15) AUTO_INCREMENT NOT NULL PRIMARY KEY,
daDate DATE NOT NULL, -- @ID // TODO: Should the id not be the releaseNumber? :S
lmsDate DATE NOT NULL,
releaseDate DATE NOT NULL,
releaseNumber BIGINT(15) NOT NULL,
ModifiedDate DATETIME NOT NULL,
ValidFrom DATETIME NOT NULL,
ValidTo DATETIME NOT NULL,
CreatedDate DATETIME NOT NULL,
INDEX (DosageVersionPID, ModifiedDate),
INDEX (releaseDate, ValidTo, ValidFrom)
) ENGINE=InnoDB COLLATE=utf8_bin;
Tabel:Â DrugDosageStructureRelation
CREATE TABLE IF NOT EXISTS DrugDosageStructureRelation (
DrugDosageStructureRelationPID BIGINT(15) AUTO_INCREMENT NOT NULL PRIMARY KEY,
id VARCHAR(200) NOT NULL,
drugId BIGINT(11) NOT NULL,
dosageStructureCode BIGINT(11) NOT NULL,
releaseNumber BIGINT(15) NOT NULL,
ModifiedDate DATETIME NOT NULL,
ValidFrom DATETIME NOT NULL,
ValidTo DATETIME NOT NULL,
CreatedDate DATETIME NOT NULL,
INDEX (DrugDosageStructureRelationPID, ModifiedDate),
INDEX (id, ValidTo, ValidFrom)
) ENGINE=InnoDB COLLATE=utf8_bin;
...