facture facture_role role client delaipenalite

CLEFACTURE: float CLEFACTURE: float COMPTE: varchar(255) CLECLIENT: float CLEDELAIPENALITE: int
IDFACTURE: varchar(255) IDFACTURE: varchar(255) REF_FACTURE: varchar(255) CIN: varchar(255) DATE_DEBUT: date
NORDRE: varchar(255) NORDRE: varchar(255) IDFACTURE: varchar(255) NOM_PRENOM: varchar(255)
DATE_FIN: date
CODE_CLIENT: varchar(255) CODE_CLIENT: varchar(255) NORDRE: varchar(255) NOM: varchar(255) DELAI: int
NOM_PRENOM: varchar(255) NOM_PRENOM: varchar(255) CODE: varchar(255) PRENOM: varchar(255)
TERMINER: tinyint
CIN: varchar(255) CIN: varchar(255) NOM_PRENOM: varchar(255) TELEPHONE1: varchar(255)
DATE_C: date
TIT_FON: varchar(255) TIT_FON: varchar(255) CIN: varchar(255) TELEPHONE2: varchar(255)
DATE_M: date
CMV: varchar(255) CMV: varchar(255) TIT_FON: varchar(255) ADRESSE: varchar(255)
SECTEUR: varchar(255) SECTEUR: varchar(255) CMV: varchar(255) VILLE: varchar(255)
NOMBRE_HEURE: double NOMBRE_HEURE: varchar(255) SECTEUR: varchar(255) DATE_C: date
VOLUME_M3: double VOLUME_M3: double NOMBRE_HEURE: varchar(255) DATE_M: date
MONTANT_G: double MONTANT_G: double VOLUME_ M3: varchar(255) LISTENOIR: tinyint cmv
MONTANT_ABHM: double MONTANT_ABHM: double NET_HT: varchar(255)
CLECMV: int
NET_TTC: double NET_TTC: double MONTANT_TVA: varchar(255)
CMV: varchar(255)
MONTANT_TVA: double MONTANT_TVA: double NET_TTC: varchar(255)
COMPTE: varchar(255)
NET_HT: double NET_HT: double MONTANT_ABHM: varchar(255) clientcmv DATE_C: date
SEMESTRE: varchar(255) SEMESTRE: varchar(255) MONTANT_G: varchar(255)
CLECLIENTCMV: float DATE_M: date
DATE_EM: date DATE_EM: date semestre: varchar(255)
CLECLIENT: float
REF_FACTURE: varchar(255) REF_FACTURE: text date_em: varchar(255)
CLECMV: int
VALIDER: tinyint VALIDER: tinyint
CODE_CLIENT: varchar(255)
PAYER: tinyint PAYER: tinyint
TIT_FON: varchar(255)
PAYER_PARTIEL: tinyint PAYER_PARTIEL: tinyint
SECTEUR: varchar(255)
ANNULER: tinyint ANNULER: tinyint
DATE_C: date
CLECLIENT: float CLECLIENT: float
DATE_M: date
EXONERATION: tinyint EXONERATION: tinyint
AMENDEMENT: double AMENDEMENT: double
TAUX_PENALITE: double TAUX_PENALITE: double

regisseur amendement
CLEREGISSEUR: float connexion CLEAMENDEMENT: float
CIN: varchar(255) CLECONNEXION: float CLECLIENT: float
NOM: varchar(255) USER: varchar(255) CLEFACTURE: float
PRENOM: varchar(255) DATE_CON: date TAUX: double
TELEPHONE1: varchar(255) DATE_DECON: date DATE_AMENDEMENT: date
TELEPHONE2: varchar(255) HEUR_CON: time DATE_C: date
ADRESSE: varchar(255) HEUR_DECON: time DATE_M: date
VILLE: varchar(255) ETAT: tinyint
PASSWORD: varchar(255) CLEREGISSEUR: float
DATE_C: date
DATE_M: date

tauxpenalite
CLETAUX: int
TAUXPENALITE: double
TAUXAMENDEMENT: double
DELAIPENALITE: int
AUGMENTATION_DELAIPENALITE: tinyint
DATE_C: date
DATE_M: date