fWaAVGVP

1Create database BDhospital;
2
3Use BDhospital;
4
5CREATE TABLE IF NOT EXISTS `BDhospital`.`utente` (
6  `utente_key` INT NOT NULL AUTO_INCREMENT,
7  `name` VARCHAR(50) NOT NULL,
8  `morada` VARCHAR(50),
9  `telefone` INT,
10  PRIMARY KEY (`utente_key`))
11ENGINE = InnoDB;
12
13CREATE TABLE IF NOT EXISTS `BDhospital`.`medico` (
14  `medico_key` INT NOT NULL AUTO_INCREMENT,
15  `name` VARCHAR(50) NOT NULL,
16  PRIMARY KEY (`medico_key`))
17ENGINE = InnoDB;
18
19
20CREATE TABLE IF NOT EXISTS `BDhospital`.`pedido` (
21  `key` INT NOT NULL AUTO_INCREMENT,
22  `medico_key` INT NOT NULL,
23  `utente_key`INT NOT NULL,
24  `data` VARCHAR(50) NOT NULL,
25  `hora` VARCHAR(50) NOT NULL,
26  `estado` INT not NULL,
27  `observacao` VARCHAR(300) NOT NULL,
28  `descricao` VARCHAR(300) NOT NULL,
29  PRIMARY KEY (`key`),
30  FOREIGN KEY(medico_key) REFERENCES medico(medico_key),
31  FOREIGN KEY(utente_key) REFERENCES utente(utente_key))
32ENGINE = InnoDB;
33
34CREATE TABLE IF NOT EXISTS `BDhospital`.`worklist` (
35  `key` INT NOT NULL AUTO_INCREMENT,
36  `medico_key` INT NOT NULL,
37  `utente_key`INT NOT NULL,
38  `data` VARCHAR(50) NOT NULL,
39  `hora` VARCHAR(50) NOT NULL,
40  `descricao` VARCHAR(300) NOT NULL,
41  PRIMARY KEY (`key`),
42ENGINE = InnoDB;