51XGBUvJ

1
2
3Create database BDhospital;
4
5Use BDhospital;
6
7
8
9CREATE TABLE IF NOT EXISTS `BDhospital`.`pedido` (
10  `key` INT NOT NULL AUTO_INCREMENT,
11  `utente_name`VARCHAR(50) NOT NULL,
12  `morada` VARCHAR(50),
13  `telefone` INT,
14  `medico_name`VARCHAR(50) NOT NULL,
15  `data` VARCHAR(50) NOT NULL,
16  `hora` VARCHAR(50) NOT NULL,
17  `estado` INT NOT NULL,
18  `observacao` VARCHAR(300) NOT NULL,
19  `descricao` VARCHAR(300) NOT NULL,
20  `relatorio` VARCHAR(300) NOT NULL,
21  PRIMARY KEY (`key`))
22ENGINE = InnoDB;
23
24
25	CREATE TABLE IF NOT EXISTS `BDhospital`.`worklist` (
26	  `id` INT NOT NULL AUTO_INCREMENT,
27	  `utente_name`VARCHAR(50) NOT NULL,
28	  `morada` VARCHAR(50),
29	  `telefone` INT,
30	  `medico_name`VARCHAR(50) NOT NULL,
31	  `data` VARCHAR(50) NOT NULL,
32	  `hora` VARCHAR(50) NOT NULL,
33	  `observacao` VARCHAR(300) NOT NULL,
34	  `descricao` VARCHAR(300) NOT NULL,
35	  PRIMARY KEY (`id`))
36	ENGINE = InnoDB;
37    
38    
39insert into pedido values (1,'nome','morada',00111,'nome_medico','9999-12-31','10:00',0,'obs','desc','relatorio') ;