141iNTup

1CREATE TABLE IF NOT EXISTS locacao (
2codigo INT NOT NULL PRIMARY KEY,
3codigo_cliente INT NOT NULL,
4codigo_veiculo INT NOT NULL,
5FOREIGN KEY (codigo_cliente) REFERENCES (codigo),
6FOREIGN KEY (codigo_veiculo) REFERENCES (codigo),
7km_saida DOUBLE NOT NULL,
8hora_saida TIME NOT NULL,
9data_saide DATE NOT NULL,
10km_entrada DOUBLE,
11hora_entrada TIME,
12data_entrega DATE
13);https://paiza.io/
14
15
16
17CREATE TABLE IF NOT EXISTS cliente_email (
18codigo_cliente INT NOT NULL PRIMARY KEY,
19email VARCHAR(200) INT NOT NULL PRIMARY KEY,
20FOREIGN KEY (codigo_cliente) REFERENCES(codigo),
21FOREIGN KEY (email) REFERENCES (codigo)
22);