- Filme
- COD (int, pk)
- nome(varchar 20, not null)
- nascimento(datetime, not null)
- obs(tinybit, not null)
- obs2(int, fk, not null)
I thought of something of the type
create table filme (
COD int PRIMARY KEY AUTO_INCREMENT,
nome varchar(200) NOT NULL,
nascimento datetime NOT NULL,
obs tinyint NOT NULL,
obs2 int NOT NULL
)
I do not know how to create fk ... how do i create an int fk?