CREATE TABLE CLIENT (
  numcli TINYINT PRIMARY KEY,
  nom VARCHAR(32),
  localite VARCHAR(30),
  cat VARCHAR(2),
  solde FLOAT
);

CREATE TABLE PRODUIT (
  numpro TINYINT PRIMARY KEY,
  designation VARCHAR(60),
  prix FLOAT,
  qtestock INT
);

CREATE TABLE COMMANDE (
  numcom TINYINT PRIMARY KEY,
  numcli TINYINT,
  datecom DATE,
  FOREIGN KEY COMMANDE(numcli) REFERENCES CLIENT(numcli)
);

CREATE TABLE DETAIL(
  numcom TINYINT,
  numpro TINYINT,
  qtecom INT,
  PRIMARY KEY (numcom, numpro),
  FOREIGN KEY DETAIL(numcom) REFERENCES COMMANDE(numcom),
  FOREIGN KEY DETAIL(numpro) REFERENCES PRODUIT(numpro)
);