Create table.mysqli

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)
);