assistance.sql

CREATE TABLE assistance(

    num_id VARCHAR(200) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nom VARCHAR(200) NOT NULL,
    prenom VARCHAR(200) NOT NULL,
    sexe VARCHAR(2) NOT NULL

    num_fact VARCHAR(200) NOT NULL,
    FOREIGN KEY (num_fact) REFERENCES facture (num_fact)

);