1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE IF NOT EXISTS `db_patient`.`tl_pat_visite` (
`id_tl_pat_visite` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`patient_id_patient` INT UNSIGNED NOT NULL,
`patient_cabinet_id_cabinet` INT UNSIGNED NOT NULL,
`tl_pat_visite_dte` TIMESTAMP NOT NULL DEFAULT current_timestamp,
`tl_pat_visite_note` MEDIUMBLOB NULL,
PRIMARY KEY (`id_tl_pat_visite`, `patient_id_patient`, `patient_cabinet_id_cabinet`),
INDEX `fk_tl_pat_visite_patient1_idx` (`patient_id_patient` ASC, `patient_cabinet_id_cabinet` ASC),
CONSTRAINT `fk_tl_pat_visite_patient1`
FOREIGN KEY (`patient_id_patient` , `patient_cabinet_id_cabinet`)
REFERENCES `db_patient`.`patient` (`id_patient` , `cabinet_id_cabinet`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB; |
