MAILING_ADMIN (
ID: Int64,
IDExpediteur: TSQLUtilisateur,
DateCreation: TDateTime,
NbEnvoi: Integer,
Sujet: RawUTF8,
Corps: RawUTF8,
ID: Int64.1
)
MAILING_UTILISATEUR (
ID: Int64,
IDExpediteur: TSQLUtilisateur,
ID: Int64.1,
SUID: RawUTF8,
IDAdresse: TSQLAdresse,
ID: Int64.2,
_IDMailing: TSQLMailing_Admin,
_IDUtilisateur: TSQLUtilisateur,
DateDernierEnvoi : TDateTime,
MsgErreur : RawUTF8
)
FILE (
ID: Int64,
IDLiaison: Integer,
TypeLiaison: Integer,
TypeFichier: Integer,
FILEBLOB: TSQLRawBlob
)
SAUVEGARDE (
ID: Int64,
IDStructure: TSQLStructure,
Mail: RawUTF8,
VersionLogeas: RawUTF8,
NomSauvergarde: RawUTF8,
DateSVG: TDateTime,
NomBase:RawUTF8,
AnneeExercice: Inetger,
NumLicence:RawUTF8
)
REQ_SQL (
ID:Int64,
TypeReq:TTypeReqSQL,
Nom:RawUTF8,
Req:RawUTF8
)
PISTE_AUDIT_SYN (
ID: Int64,
CreatedDate: TCreateTime,
CreatedUtilisateur: Integer,
Action: RawUTF8,
Code: Integer,
Description: RawUTF8,
TableID:RawUTF8,
DataNewJson: RawUTF8
)
UTILISATEUR (
ID: Int64,
SUID: RawUTF8,
IDAdresse: TSQLAdresse,
IsActive: Boolean,
Civilite: RawUTF8,
Nom: RawUTF8,
Prenom: RawUTF8,
Email: RawUTF8,
Profession: RawUTF8,
DateDerniereConnexion: TDateTime,
DateDerniereModif: TDateTime,
Archive: Boolean,
LogonName: RawUTF8,
DisplayName: RawUTF8,
PasswordHashHexa: RawUTF8,
GroupRights: TSQLAuthGroup,
Data: TSQLRawBlob
)
TYPESTRUCTURE (
ID: Int64,
Nom: RawUTF8
)
UTILISATEUR_GROUPE (
ID: Int64,
SUID: RawUTF8,
IDAdresse: TSQLAdresse,
ID: Int64.1,
SUID: RawUTF8.1,
IDStructure: TSQLStructure,
ID: Int64.2,
IDUtilisateur: TSQLUtilisateur,
IDGroupe: TSQLGroupe,
IsAdminGroupe: Boolean
)
ADRESSE (
ID: Int64,
SUID: RawUTF8,
Pays: RawUTF8,
CP: RawUTF8,
Ville: RawUTF8,
add1: RawUTF8,
add2: RawUTF8,
add3: RawUTF8,
LieuDit: RawUTF8,
Tel: RawUTF8,
TelPortable: RawUTF8,
ID: Int64.1,
SUID: RawUTF8.1,
IDAdresse: TSQLAdresse,
ID: Int64.2,
SUID: RawUTF8.2,
IDTypeStructure: TSQLTypeStructure,
IDRegroupement: TSQLStructure,
IDAdresse: TSQLAdresse.1
)
STRUCTURE (
ID: Int64,
SUID: RawUTF8,
IDTypeStructure: TSQLTypeStructure,
IDRegroupement: TSQLStructure,
IDAdresse: TSQLAdresse,
Nom: RawUTF8,
Email: RawUTF8,
NumInterne: RawUTF8,
NumCompteTiers: RawUTF8,
Archive: Boolean,
AdresseSite: RawUTF8,
HebergeurLogeas: Boolean,
MembreTouselle: Boolean,
ID: Int64.1,
IDStructure: TSQLStructure,
IDTypeLicence: TSQLTypeLicence,
IDUtilisateur: TSQLUtilisateur,
ID: Int64.2,
IDStructure: TSQLStructure.1,
ID: Int64.3,
SUID: RawUTF8.1,
IDTypeStructure: TSQLTypeStructure.1,
IDRegroupement: TSQLStructure.1,
IDAdresse: TSQLAdresse.1,
ID: Int64.4,
IDStructure: TSQLStructure.2,
ID: Int64.5,
SUID: RawUTF8.2,
IDStructure: TSQLStructure.3,
IDLicence: TSQLLicence,
ID: Int64.6,
ID: Int64.7,
SUID: RawUTF8.3,
IDStructure: TSQLStructure.4
)
FACTURE (
ID: Int64,
IDFacturation: TSQLFacturation,
DateEmission: TDateTime,
Montant: Currency,
FactureEmise: Boolean
)
GROUPE (
ID: Int64,
SUID: RawUTF8,
IDStructure: TSQLStructure,
Nom: RawUTF8,
TypeGroupe: Integer,
Archive: Boolean
)
FACTURATION (
ID: Int64,
IDStructure: TSQLStructure,
Prix: Currency,
NumCompteComptable: Integer,
MoisFacture: Integer,
DateFinFacturation: TDate,
ID: Int64.1,
IDFacturation: TSQLFacturation
)
BASE_GROUPE (
ID: Int64,
SUID: RawUTF8,
IDStructure: TSQLStructure,
IDLicence: TSQLLicence,
ID: Int64.1,
SUID: RawUTF8.1,
IDStructure: TSQLStructure.1,
ID: Int64.2,
IDBase: TSQLBase,
IDGroupe: TSQLGroupe,
Revu: Boolean,
IsObligatoire: Boolean
)
BASE (
ID: Int64,
SUID: RawUTF8,
IDStructure: TSQLStructure,
IDLicence: TSQLLicence,
Nom: RawUTF8,
DateDerniereUtilisation: TDateTime,
CheminBaseDeDonnee: RawUTF8,
IsLocked: Boolean,
MsgLocked: RawUTF8,
Archive: Boolean
)
LICENCE (
ID: Int64,
IDStructure: TSQLStructure,
IDTypeLicence: TSQLTypeLicence,
IDUtilisateur: TSQLUtilisateur,
DateAchat: TDate,
NumLicenceV6: RawUTF8,
NumLicenceV7: RawUTF8,
NumLicenceV8: RawUTF8,
NumLicenceV9: RawUTF8,
Archive: Boolean,
ID: Int64.1,
SUID: RawUTF8,
IDStructure: TSQLStructure.1,
IDLicence: TSQLLicence
)
TYPELICENCE (
ID: Int64,
Nom: RawUTF8,
NbrUserSimultane: Integer,
NbrUserAutorise: Integer,
NbrBaseAutoriseEnLigne: Integer,
ID: Int64.1,
IDStructure: TSQLStructure,
IDTypeLicence: TSQLTypeLicence,
IDUtilisateur: TSQLUtilisateur
)