3s4w8tzV

1-- -----------------------------------------------------
2-- Table `hospital`.`hospital`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `hospital`.`hospital` (
5  `hospital_id` INT NOT NULL AUTO_INCREMENT,
6  `hospital_name` VARCHAR(45) NOT NULL,
7  `hospital_address` VARCHAR(45) NOT NULL,
8  `hospital_phone1` VARCHAR(11) NOT NULL,
9  `hospital_phone2` VARCHAR(11) NULL,
10  `CRM_director` VARCHAR(45) NOT NULL,
11  PRIMARY KEY (`hospital_id`),
12  UNIQUE INDEX `hospital_id_UNIQUE` (`hospital_id` ASC))
13ENGINE = InnoDB;
14
15-- -----------------------------------------------------
16-- Table `hospital`.`employee`
17-- -----------------------------------------------------
18CREATE TABLE IF NOT EXISTS `hospital`.`employee` (
19  `employee_id` INT NOT NULL AUTO_INCREMENT,
20  `employee_name` VARCHAR(45) NOT NULL,
21  `funcao` VARCHAR(45) NOT NULL,
22  `shift` VARCHAR(10) NOT NULL,
23  `salary` INT NOT NULL,
24  `hospital_id` INT NOT NULL,
25  PRIMARY KEY (`employee_id`),
26  UNIQUE INDEX `employee_id_UNIQUE` (`employee_id` ASC),
27  INDEX `fk_employee_hospital_idx` (`hospital_id` ASC),
28  CONSTRAINT `fk_employee_hospital`
29    FOREIGN KEY (`hospital_id`)
30    REFERENCES `hospital`.`hospital` (`hospital_id`)
31    ON DELETE NO ACTION
32    ON UPDATE NO ACTION)
33ENGINE = InnoDB;