Error 1005 - MySql

metalicarus1
(usa Ubuntu)

Enviado em 06/11/2016 - 12:49h

Olá! Estou com um probleminha na construção de minhas tabelas, na verdade, todas estão sendo construídas, no entanto a tabela CONSULTA enciste em dar erro kkk

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';



CREATE SCHEMA IF NOT EXISTS `clinica_veterinaria` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

USE `clinica_veterinaria` ;



-- -----------------------------------------------------

-- Table `clinica_veterinaria`.`funcionario`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `clinica_veterinaria`.`funcionario` (

  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

  `nome` VARCHAR(45) NOT NULL,

  `enderco` VARCHAR(45) NOT NULL,

  `cpf` VARCHAR(45) NOT NULL,

  `rg` VARCHAR(45) NOT NULL,

  `data_adm` DATE NOT NULL,

  PRIMARY KEY (`id`))

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





-- -----------------------------------------------------

-- Table `clinica_veterinaria`.`veterinario`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `clinica_veterinaria`.`veterinario` (

  `funcionario_id` INT UNSIGNED NOT NULL,

  `crmv` INT NOT NULL,

  PRIMARY KEY (`funcionario_id`),

  CONSTRAINT `fk_veterinario_funcionario`

    FOREIGN KEY (`funcionario_id`)

    REFERENCES `clinica_veterinaria`.`funcionario` (`id`)

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





-- -----------------------------------------------------

-- Table `clinica_veterinaria`.`medicamento`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `clinica_veterinaria`.`medicamento` (

  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

  `nome` VARCHAR(45) NOT NULL,

  `composicao` VARCHAR(45) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE INDEX `id_UNIQUE` (`id` ASC))

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





-- -----------------------------------------------------

-- Table `clinica_veterinaria`.`dono`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `clinica_veterinaria`.`dono` (

  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

  `nome` VARCHAR(45) NOT NULL,

  `endereco` VARCHAR(45) NOT NULL,

  `cpf` VARCHAR(45) NOT NULL,

  `telefone` VARCHAR(45) NOT NULL,

  `telefone1` VARCHAR(45) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE INDEX `id_UNIQUE` (`id` ASC))

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





-- -----------------------------------------------------

-- Table `clinica_veterinaria`.`animal`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `clinica_veterinaria`.`animal` (

  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

  `nome` VARCHAR(45) NOT NULL,

  `especie` VARCHAR(45) NOT NULL,

  `raca` VARCHAR(45) NOT NULL,

  `dono_id` INT UNSIGNED NOT NULL,

  PRIMARY KEY (`id`, `dono_id`),

  INDEX `fk_animal_dono1_idx` (`dono_id` ASC),

  UNIQUE INDEX `id_UNIQUE` (`id` ASC),

  CONSTRAINT `fk_animal_dono1`

    FOREIGN KEY (`dono_id`)

    REFERENCES `clinica_veterinaria`.`dono` (`id`)

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





-- -----------------------------------------------------

-- Table `clinica_veterinaria`.`consulta`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `clinica_veterinaria`.`consulta` (

  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

  `data` DATE NOT NULL,

  `diagnostico` VARCHAR(45) NOT NULL,

  `tratamento` VARCHAR(45) NOT NULL,

  `medicamento_id` INT UNSIGNED NOT NULL,

  `animal_id` INT UNSIGNED NOT NULL,

  `animal_dono_id` INT UNSIGNED NOT NULL,

  `veterinario_funcionario_id` INT UNSIGNED NOT NULL,

  PRIMARY KEY (`id`, `medicamento_id`, `animal_id`, `animal_dono_id`, `veterinario_funcionario_id`),

  INDEX `fk_consulta_medicamento1_idx` (`medicamento_id` ASC),

  INDEX `fk_consulta_animal1_idx` (`animal_id` ASC, `animal_dono_id` ASC),

  INDEX `fk_consulta_veterinario1_idx` (`veterinario_funcionario_id` ASC),

  CONSTRAINT `fk_consulta_medicamento1`

    FOREIGN KEY (`medicamento_id`)

    REFERENCES `clinica_veterinaria`.`medicamento` (`id`)

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_consulta_animal1`

    FOREIGN KEY (`animal_id` , `animal_dono_id`)

    REFERENCES `clinica_veterinaria`.`animal` (`id` , `dono_id`)

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_consulta_veterinario1`

    FOREIGN KEY (`veterinario_funcionario_id`)

    REFERENCES `clinica_veterinaria`.`veterinario` (`funcionario_id`)

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;