CREATE TABLE CLIENT (
    Numcli NUMBER (7) NOt NULL,
    Nom VARCHAR(15) NOT NULL,
    Prenom VARCHAR(15) NOT NULL,
    Tel VARCHAR(12),
    Adresse VARCHAR(20),
    Ville VARCHAR(15),
    Pays VARCHAR(15),
    CONSTRAINT cle_client PRIMARY KEY (Numcli));
    
    -------------
    

CREATE TABLE PRODUIT(
    Numprod NUMBER (7) NOT NULL,
    Designation VARCHAR (15) NOT NULL,
    Description VARCHAR (30),
    Prix NUMBER(11,2),
    QteStock NUMBER (7),
    CONSTRAINT cle_produit PRIMARY KEY (Numprod));

--------------

CREATE TABLE COMMANDE(
    Numcom NUMBER (7) NOT NULL,
    Numero NUMBER (7),
    Datecom DATE,
    Datelivrai DATE,
    CONSTRAINT cle_commande PRIMARY KEY (Numcom),
    CONSTRAINT cleetr_commande FOREIGN KEY (Numcli) REFERENCES CLIENT(Numcli));