· 6 years ago · Sep 16, 2019, 11:20 PM
1CREATE TABLE IF NOT EXISTS veiculo (
2codigo INT NOT NULL PRIMARY KEY,
3placa char(7) NOT NULL UNIQUE,
4FOREIGN KEY (codigo_modelo) REFERENCES x
5);
6
7
8
9CREATE TABLE IF NOT EXISTS cliente_telefone (
10codigo_cliente INT NOT NULL,
11telefone DOUBLE NOT NULL,
12PRIMARY KEY (codigo_cliente, telefone),
13FOREIGN KEY (codigo_cliente) REFERENCES x,
14FOREIGN KEY (telefone) REFERENCES x,
15);