1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
CREATE TABLE FORMULE (
REQUETE_CODE CHAR(20) ,
FIELD_NOM CHAR(20),
FORMULE VARCHAR(255) )
CREATE TABLE CLIENT (
CLIENT_CODE CHAR(20) ,
CLIENT_NOM CHAR(20) )
CREATE TABLE FACTURE (
FACTURE_NUM SMALLINT,
FACTURE_DATE DATE,
CLIENT_CODE CHAR(20) ,
FACTURE_MONTANT NUMERIC(15,2) )
CREATE TABLE AVOIR (
AVOIR_NUM SMALLINT,
AVOIR_DATE DATE,
CLIENT_CODE CHAR(20) ,
AVOIR_MONTANT NUMERIC(15,2) )
CREATE TABLE REMISE (
REMISE_NUM SMALLINT,
REMISE_DATE DATE,
CLIENT_CODE CHAR(20) ,
REMISE_MONTANT NUMERIC(15,2) ) |
Partager