Error Code: 1215. Cannot add Foreign key Constraint

Question

Error Code: 1215. Cannot add Foreign key Constraint

Asked 8 years, 1 month ago

Viewed 3,011 times

2

Can anyone help me? I can’t create this foreign key.

Just follow my code:

CREATE DATABASE escola2;
   USE escola2;

   CREATE TABLE IF NOT EXISTS aluno (
    matricula INT,
    nome VARCHAR(25),
    sobrenome VARCHAR(30),
    cod_curso VARCHAR(20),
    periodo INT
) ENGINE=InnoDB AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS professor (
    codigo INT,
    nome VARCHAR(25),
    sobrenome VARCHAR(30),
    curso_ministrado VARCHAR(30),
    setor VARCHAR(30),
    salario DECIMAL(8,2)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;

CREATE TABLE estado_civil(
    id_estado INT NOT NULL auto_increment PRIMARY KEY,
    estado VARCHAR(20) NOT NULL,
    id_funcionario INT NOT NULL,
    foreign key(id_estado) references aluno(matricula)
);

Which database? the answer below has helped ?

– Marco Souza

2016/11/17 at 13:18
By syntax ENGINE=InnoDB, i would say it’s Mysql or Mariadb. Anyway, in fact, the tags should have specified which database manager was used.

– Haroldo_OK

2016/11/17 at 15:04
2

Victor Santos, instead of editing the title of his question to solved accepted Victor Safusa’s answer (below the vote marker)

– Anthony Accioly

2016/11/17 at 15:23

1 answer

Browser other questions tagged mysql sql

You are not signed in. Login or sign up in order to post.

by Victor Stafusa • **63,338** points · Answer 1 · 2016-11-17T12:46:40+00:00

Try to do so:

CREATE DATABASE escola2;
USE escola2;

CREATE TABLE IF NOT EXISTS aluno (
    matricula INT NOT NULL auto_increment PRIMARY KEY,
    nome VARCHAR(25),
    sobrenome VARCHAR(30),
    cod_curso VARCHAR(20),
    periodo INT
) ENGINE=InnoDB AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS professor (
    codigo INT NOT NULL auto_increment PRIMARY KEY,
    nome VARCHAR(25),
    sobrenome VARCHAR(30),
    curso_ministrado VARCHAR(30),
    setor VARCHAR(30),
    salario DECIMAL(8,2)
) ENGINE=InnoDB AUTO_INCREMENT=1;

CREATE TABLE estado_civil (
    id_estado INT NOT NULL auto_increment PRIMARY KEY,
    estado VARCHAR(20) NOT NULL,
    id_funcionario INT NOT NULL,
    foreign key(id_estado) references aluno(matricula)
) ENGINE=InnoDB AUTO_INCREMENT=1;

The problem seems to me it was because you had not defined the primary keys of aluno and professor.