CREATE TABLE SITUACAO (
id_situacao INTEGER NOT NULL PRIMARY KEY,
situacao VARCHAR(10),
id_socio INTEGER DEFAULT NULL,
FOREIGN KEY(id_socio) REFERENCES SOCIO(id_socio));
CREATE TABLE SOCIO (
id_socio INTEGER NOT NULL PRIMARY KEY,
nome VARCHAR(256),
cpf VARCHAR(11),
email VARCHAR(256),
id_situacao INTEGER,
FOREIGN KEY(id_situacao) REFERENCES SITUACAO(id_situacao));
CREATE TABLE CARRO (
id_carro INTEGER NOT NULL PRIMARY KEY,
modelo VARCHAR(128),
cor VARCHAR(64),
placa VARCHAR(10),
id_socio INTEGER,
id_marca INTEGER,
FOREIGN KEY(id_socio) REFERENCES SOCIO(id_socio),
FOREIGN KEY(id_marca) REFERENCES MARCA(id_marca));
