teqeSucC

1CREATE TABLE IF NOT EXISTS `sysfood`.`funcionario` (
2  `cpf` BIGINT(11) NOT NULL,
3  `nome` VARCHAR(80) NOT NULL,
4  `salario` DECIMAL(10,2) NOT NULL,
5  `data_contratacao` DATE NOT NULL,
6  `cargo` INT(11) NOT NULL,
7  `supervisor` BIGINT(11) NULL,
8  UNIQUE INDEX `cpf_UNIQUE` (`cpf` ASC),
9  PRIMARY KEY (`cpf`),
10  INDEX `fk_supervisor` (`supervisor` ASC),
11  CONSTRAINT `fk_supervisor`
12    FOREIGN KEY (`supervisor`)
13    REFERENCES `sysfood`.`funcionario` (`cpf`)
14    ON DELETE RESTRICT)
15ENGINE = InnoDB;
16	
17CREATE TABLE IF NOT EXISTS `sysfood`.`entregador` (
18  `disponibilidade` TINYINT(1) NOT NULL DEFAULT '1',
19  `funcionario_cpf` BIGINT(11) NOT NULL,
20  PRIMARY KEY (`funcionario_cpf`),
21  UNIQUE INDEX `Funcionario_Cpf_UNIQUE` (`funcionario_cpf` ASC),
22  CONSTRAINT `fk_funcionario_cpf`
23    FOREIGN KEY (`funcionario_cpf`)
24    REFERENCES `sysfood`.`funcionario` (`cpf`)
25    ON DELETE CASCADE
26    ON UPDATE NO ACTION)
27ENGINE = InnoDB;