CREATE TABLE appartement ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, numero_appartement VARCHAR(30) NOT NULL, nom_locataire VARCHAR(30) NOT NULL, prenom_locataire VARCHAR(30) NOT NULL ); CREATE TABLE finance ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, id_appartement INT(6) UNSIGNED, date_payement DATE, montant_entree DECIMAL(10,2), montant_sortie DECIMAL(10,2), FOREIGN KEY (id_appartement) REFERENCES appartement(id) );
Comments
0 B
|0 👍
/0 👎
0 B
|👍
/👎