1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| CREATE TABLE `t_ordo_ligne` (
`nIdOrdonnance` INT(10) UNSIGNED NOT NULL,
`nNumeroLigne` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`nIdPatient` INT(10) UNSIGNED NULL DEFAULT NULL,
`nIdAntecedent` INT(10) UNSIGNED NULL DEFAULT NULL,
`sLibelle` VARCHAR(100) NOT NULL DEFAULT '',
`sPosologie` VARCHAR(255) NOT NULL DEFAULT '',
`nAld` TINYINT(4) NOT NULL DEFAULT '0',
`bUrgence` TINYINT(1) NOT NULL DEFAULT '0',
`bADomicile` TINYINT(1) NOT NULL DEFAULT '0',
`bDimJF` TINYINT(1) NOT NULL DEFAULT '0',
`bNS` TINYINT(1) NOT NULL DEFAULT '0',
`bNPD` TINYINT(1) NOT NULL DEFAULT '0',
`bDCI` TINYINT(1) NOT NULL DEFAULT '0',
`bDopant` TINYINT(1) NOT NULL DEFAULT '0',
`bTLC` TINYINT(1) NOT NULL DEFAULT '0',
`nTypeOrdo` TINYINT(4) NOT NULL,
`nEtatEnreg` TINYINT(1) NOT NULL DEFAULT '1',
`sResumePoso` TEXT NOT NULL,
`nPrix` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
`nNonSubstituable` TINYINT(4) NOT NULL DEFAULT '0',
`nFrequence` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`rQuantite` DECIMAL(10,3) UNSIGNED NOT NULL DEFAULT '0.000',
`nNbJour` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`nNbUnite` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`sCodeCIP` VARCHAR(255) NOT NULL DEFAULT '',
`nRMO` TINYINT(4) NOT NULL DEFAULT '0',
`nRenouvellement` TINYINT(4) NOT NULL DEFAULT '0',
`sDateFin` VARCHAR(8) NOT NULL DEFAULT '',
`sCodePosologie` VARCHAR(20) NOT NULL DEFAULT '',
`sDateSuppression` VARCHAR(8) NOT NULL DEFAULT '',
`sAction` VARCHAR(16) NOT NULL DEFAULT 'A 20080101000000',
`sDH_REPLIC` DATETIME NULL DEFAULT '2010-01-01 00:00:00',
INDEX `NDX_t_ordo_ligne_nNumeroLigne` (`nNumeroLigne`),
INDEX `FK_ordo_ligne_nIdPatient` (`nIdPatient`),
INDEX `FK_ordo_ligne_nIdOrdonnance_ordonnance` (`nIdOrdonnance`),
CONSTRAINT `FK_ordo_ligne_nIdOrdonnance_ordonnance` FOREIGN KEY (`nIdOrdonnance`) REFERENCES `t_ordonnance` (`nIdOrdonnance`),
CONSTRAINT `FK_ordo_ligne_nIdPatient` FOREIGN KEY (`nIdPatient`) REFERENCES `t_patient` (`nIdPatient`)
) |
Partager