CLIENT (NoClient, Nom, Adresse, Ville, Reduction)
	Primary key (NoClient)

FACTURE (NoFact, NoClient, Date, Reduction)
	Primary key (NoFact)
	Foreign Key(NoClient) references CLIENT

COMMANDE (NoFact, NoLigne, RefArt, Qte)
	Primary key (NoFact, NoLigne)
	Foreign Key(NoFact) references FACTURE

ARTICLE	(RefArt, Libellé, PU, TVA)
	Primary key (RefArt)

PAIEMENT(NoFact, NoPaiement, Paiement)
	Primary key (NoFact, NoPaiement)
	Foreign Key(NoFact) references FACTURE

Close this window