· 8 years ago · Jul 01, 2018, 11:36 AM
1CREATE TABLE IF NOT EXISTS `Horario_medico` (
2 `rut_medico` varchar(10) NOT NULL,
3 `fecha` date NOT NULL DEFAULT '0000-00-00',
4 `hora_inicio` datetime NOT NULL DEFAULT '00:00:00',
5 `numero_bloques` int(2) NOT NULL DEFAULT 1,
6 PRIMARY KEY (`rut_medico`, `fecha`)
7 FOREIGN KEY (`rut_medico`) REFERENCES `Medico`(`rut`),
8 CHECK (`hora_inicio` >= '08:00:00')
9) ENGINE = InnoDB;