--
--  database structure creation
--

CREATE TABLE Actor (
	ActID CHAR(16) NOT NULL,
	ActCivID CHAR(16),
	ActFstName VARCHAR(30),
	ActName VARCHAR(50),
	ActCode VARCHAR(20),
	ActFunction VARCHAR(30),
	ActPhone VARCHAR(20),
	ActMobile VARCHAR(20),
	ActFax VARCHAR(20),
	ActMail VARCHAR(100),
	ActStaID CHAR(16),
	ActSitID CHAR(16),
	ActAdeID CHAR(16),
	ActNumEmployee VARCHAR(10),
	ActDeptID CHAR(16),
	ActLogin VARCHAR(100),
	ActPwd VARCHAR(100),
	ActEnd INTEGER,
	ActAim INTEGER,
	ActPinWap VARCHAR(8),
	ActManager CHAR(16),
	ActBackup CHAR(16),
	ActAssistant CHAR(16),
	ActPicID CHAR(16),
	ActPicFileName VARCHAR(255),
	ActDecisionProfile CHAR(16),
	ActDecProfAdm INTEGER,
	ActAd1 VARCHAR(50),
	ActAd2 VARCHAR(50),
	ActAd3 VARCHAR(50),
	ActZip VARCHAR(50),
	ActCity VARCHAR(50),
	ActCtrID CHAR(16),
	ActCotID CHAR(16),
	ActDashID CHAR(16),
	ActLastSyncDate TIMESTAMP,
	ActNotes TEXT,
	ActSyncType CHAR(16),
	ActSyncModel CHAR(16),
	ActLngPrinc CHAR(16),
	ActCoeffPondComCost NUMERIC,
	ActCtiAccess INTEGER,
	ActWinLogin VARCHAR(250),
	ActTzoID CHAR(16),
	ActMobileLogin VARCHAR(4),
	ActTymID CHAR(16),
	ActCAWon NUMERIC,
	ActCALost NUMERIC,
	ActDoneBus INTEGER,
	ActWonBus INTEGER,
	ActRunBus INTEGER,
	ActVolWon NUMERIC,
	ActValWon NUMERIC,
	ActCCANumAgent_ VARCHAR(20),
	ActCCAProcGroup_ VARCHAR(20),
	ActCCAPassword_ VARCHAR(20),
	ActVocalcomUserID_ VARCHAR(25),
	ActVocalcomPwd_ VARCHAR(25),
	ActVocalcomStation_ VARCHAR(25),
	ActGenesysPhoneQueue_ VARCHAR(100),
	ActGenesysPhonePasscode_ VARCHAR(100),
	ActGenesysPhoneLogin_ VARCHAR(100),
	ActGenesysPlaceName_ VARCHAR(100),
	ActGenesysAgentName_ VARCHAR(100),
	ActCTIPwd_ VARCHAR(32),
	ActRememberCookieExpiration TIMESTAMP,
	ActRememberCookieID VARCHAR(36),
	ActLdapName TEXT,
	ActC3TAgentLogin_ VARCHAR(100),
	ActC3TAgentPassword_ VARCHAR(100),
	ActPartitionID CHAR(16),
	ActEmpSta CHAR(16),
	ActLastPwdUpd TIMESTAMP,
	ActPwdInitToken TEXT,
	ActLastPwdInitTokenUpd TIMESTAMP,
	ActMobilePin VARCHAR(100),
	ActMobileEnable INTEGER,
	ActMobileNbFailedAuth INTEGER,
	ActCreID CHAR(16) NOT NULL,
	ActModID CHAR(16) NOT NULL,
	ActCrDt TIMESTAMP NOT NULL,
	ActUpd TIMESTAMP NOT NULL,
	ActMbm INTEGER,
	ActMbs INTEGER,
	PRIMARY KEY (ActID)
);

CREATE TABLE Attachment (
	AttID CHAR(16) NOT NULL,
	AttFile BYTEA,
	AttObjID VARCHAR(16),
	AttContentType VARCHAR(120),
	AttFileName VARCHAR(255),
	AttDesc VARCHAR(255),
	AttIcon CHAR(16),
	AttCreID CHAR(16) NOT NULL,
	AttModID CHAR(16) NOT NULL,
	AttCrDt TIMESTAMP NOT NULL,
	AttUpd TIMESTAMP NOT NULL,
	AttMbm INTEGER,
	AttMbs INTEGER,
	PRIMARY KEY (AttID)
);

CREATE TABLE AutoDisplayZone (
	AdzID CHAR(16) NOT NULL,
	AdzName VARCHAR(50),
	AdzLabelCode VARCHAR(10),
	AdzObjID CHAR(16),
	AdzCols INTEGER,
	AdzWidth VARCHAR(100),
	AdzNotes TEXT,
	AdzCode VARCHAR(50),
	AdzCreID CHAR(16) NOT NULL,
	AdzModID CHAR(16) NOT NULL,
	AdzCrDt TIMESTAMP NOT NULL,
	AdzUpd TIMESTAMP NOT NULL,
	AdzMbm INTEGER,
	AdzMbs INTEGER,
	PRIMARY KEY (AdzID)
);

CREATE TABLE Base (
	BasID CHAR(16) NOT NULL,
	BasCounter INTEGER,
	BasLabel VARCHAR(128),
	BasCreID CHAR(16) NOT NULL,
	BasModID CHAR(16) NOT NULL,
	BasCrDt TIMESTAMP NOT NULL,
	BasUpd TIMESTAMP NOT NULL,
	BasMbm INTEGER,
	BasMbs INTEGER,
	PRIMARY KEY (BasID)
);

CREATE TABLE CounterFactory (
	CntID CHAR(16) NOT NULL,
	CntColumn VARCHAR(20),
	CntCounter INTEGER,
	CntCreID CHAR(16) NOT NULL,
	CntModID CHAR(16) NOT NULL,
	CntCrDt TIMESTAMP NOT NULL,
	CntUpd TIMESTAMP NOT NULL,
	CntMbm INTEGER,
	CntMbs INTEGER,
	PRIMARY KEY (CntID)
);

CREATE TABLE Dashboard (
	DshID CHAR(16) NOT NULL,
	DshName VARCHAR(100),
	DshType CHAR(16),
	DshDefault INTEGER,
	DshCode VARCHAR(30),
	DshActor CHAR(16),
	DshCrOrder INTEGER,
	DshCreID CHAR(16) NOT NULL,
	DshModID CHAR(16) NOT NULL,
	DshCrDt TIMESTAMP NOT NULL,
	DshUpd TIMESTAMP NOT NULL,
	DshMbm INTEGER,
	DshMbs INTEGER,
	PRIMARY KEY (DshID)
);

CREATE TABLE DashboardPage (
	DspID CHAR(16) NOT NULL,
	DspHeight INTEGER,
	DspPage CHAR(16),
	DspWidth INTEGER,
	DspX INTEGER,
	DspY INTEGER,
	DspDshID CHAR(16),
	DspCreID CHAR(16) NOT NULL,
	DspModID CHAR(16) NOT NULL,
	DspCrDt TIMESTAMP NOT NULL,
	DspUpd TIMESTAMP NOT NULL,
	DspMbm INTEGER,
	DspMbs INTEGER,
	PRIMARY KEY (DspID)
);

CREATE TABLE DataExtraction (
	DexID CHAR(16) NOT NULL,
	DexTitle VARCHAR(300),
	DexCode VARCHAR(30),
	DexSQL TEXT,
	DexDestinationFile VARCHAR(300),
	DexNote TEXT,
	DexColumnSeparator VARCHAR(10),
	DexDateFormat VARCHAR(30),
	DexHourFormat VARCHAR(30),
	DexIntegerFormat VARCHAR(30),
	DexFloatFormat VARCHAR(30),
	DexColumnDelimitor VARCHAR(10),
	DexHeaderLine INTEGER,
	DexCreID CHAR(16) NOT NULL,
	DexModID CHAR(16) NOT NULL,
	DexCrDt TIMESTAMP NOT NULL,
	DexUpd TIMESTAMP NOT NULL,
	DexMbm INTEGER,
	DexMbs INTEGER,
	PRIMARY KEY (DexID)
);

CREATE TABLE Department (
	DptID CHAR(16) NOT NULL,
	DptCode VARCHAR(12),
	DptTitle VARCHAR(100),
	DptType CHAR(16),
	DptEnt CHAR(16),
	DptObjCA NUMERIC,
	DptCAPrev NUMERIC,
	DptBudgMktObj NUMERIC,
	DptBudgMktPrev NUMERIC,
	DptPrtGrpe NUMERIC,
	DptPrtGrpeType INTEGER,
	DptPrtGrpePrev NUMERIC,
	DptPrtGrpePrevType INTEGER,
	DptNotes TEXT,
	DptCreID CHAR(16) NOT NULL,
	DptModID CHAR(16) NOT NULL,
	DptCrDt TIMESTAMP NOT NULL,
	DptUpd TIMESTAMP NOT NULL,
	DptMbm INTEGER,
	DptMbs INTEGER,
	PRIMARY KEY (DptID)
);

CREATE TABLE DIExecution (
	DieID CHAR(16) NOT NULL,
	DieModelID CHAR(16),
	DieLog TEXT,
	DieFlag CHAR(16),
	DieArchiveID CHAR(16),
	DieFileID CHAR(16),
	DieFileName VARCHAR(100),
	DieLastImportDate TIMESTAMP,
	DieCreID CHAR(16) NOT NULL,
	DieModID CHAR(16) NOT NULL,
	DieCrDt TIMESTAMP NOT NULL,
	DieUpd TIMESTAMP NOT NULL,
	DieMbm INTEGER,
	DieMbs INTEGER,
	PRIMARY KEY (DieID)
);

CREATE TABLE DIModel (
	DimID CHAR(16) NOT NULL,
	DimCode VARCHAR(10),
	DimTitle VARCHAR(200),
	DimContent TEXT,
	DimOrigin CHAR(16),
	DimCreID CHAR(16) NOT NULL,
	DimModID CHAR(16) NOT NULL,
	DimCrDt TIMESTAMP NOT NULL,
	DimUpd TIMESTAMP NOT NULL,
	DimMbm INTEGER,
	DimMbs INTEGER,
	PRIMARY KEY (DimID)
);

CREATE TABLE DITranscode (
	DitID CHAR(16) NOT NULL,
	DitCode VARCHAR(50),
	DitKey VARCHAR(200),
	DitValue VARCHAR(200),
	DitCreID CHAR(16) NOT NULL,
	DitModID CHAR(16) NOT NULL,
	DitCrDt TIMESTAMP NOT NULL,
	DitUpd TIMESTAMP NOT NULL,
	DitMbm INTEGER,
	DitMbs INTEGER,
	PRIMARY KEY (DitID)
);

CREATE TABLE EntIdentical (
	EidID CHAR(16) NOT NULL,
	EidIsNotDbl INTEGER,
	EidPoids INTEGER,
	EidExtID TEXT,
	EidOtherInfo VARCHAR(1000),
	EidEntID1 CHAR(16),
	EidEntID2 CHAR(16),
	EidCreID CHAR(16) NOT NULL,
	EidModID CHAR(16) NOT NULL,
	EidCrDt TIMESTAMP NOT NULL,
	EidUpd TIMESTAMP NOT NULL,
	EidMbm INTEGER,
	EidMbs INTEGER,
	PRIMARY KEY (EidID)
);

CREATE TABLE ExternalNotification (
	ExnID CHAR(16) NOT NULL,
	ExnSynID TEXT,
	ExnURL TEXT,
	ExnSubscr INTEGER,
	ExnType INTEGER,
	ExnObjectType INTEGER,
	ExnActID CHAR(16),
	ExnSymID CHAR(16),
	ExnLastTriggered TIMESTAMP,
	ExnSubscrID VARCHAR(500),
	ExnCreID CHAR(16) NOT NULL,
	ExnModID CHAR(16) NOT NULL,
	ExnCrDt TIMESTAMP NOT NULL,
	ExnUpd TIMESTAMP NOT NULL,
	ExnMbm INTEGER,
	ExnMbs INTEGER,
	PRIMARY KEY (ExnID)
);

CREATE TABLE Field (
	FldID CHAR(16) NOT NULL,
	FldObjID CHAR(16),
	FldSql VARCHAR(100),
	FldDisplay VARCHAR(100),
	FldDisplayLabel VARCHAR(10),
	FldFltID CHAR(16),
	FldNum INTEGER,
	FldStd INTEGER,
	FldTabID CHAR(16),
	FldSize INTEGER,
	FldControl VARCHAR(3),
	FldMultival INTEGER,
	FldFobID CHAR(16),
	FldOwner INTEGER,
	FldCriteria INTEGER,
	FldDelPolicy INTEGER,
	FldAlterTable INTEGER,
	FldModificationLogged INTEGER,
	FldDisplayPolicy CHAR(16),
	FldIndexPolicy CHAR(16),
	FldCreID CHAR(16) NOT NULL,
	FldModID CHAR(16) NOT NULL,
	FldCrDt TIMESTAMP NOT NULL,
	FldUpd TIMESTAMP NOT NULL,
	FldMbm INTEGER,
	FldMbs INTEGER,
	PRIMARY KEY (FldID)
);

CREATE TABLE FlOption (
	OptID CHAR(16) NOT NULL,
	OptName VARCHAR(200),
	OptGroup CHAR(16),
	OptType CHAR(16),
	OptComment TEXT,
	OptValue TEXT,
	OptCreID CHAR(16) NOT NULL,
	OptModID CHAR(16) NOT NULL,
	OptCrDt TIMESTAMP NOT NULL,
	OptUpd TIMESTAMP NOT NULL,
	OptMbm INTEGER,
	OptMbs INTEGER,
	PRIMARY KEY (OptID)
);

CREATE TABLE FlTask (
	TskID CHAR(16) NOT NULL,
	TskName VARCHAR(128),
	TskParameters VARCHAR(512),
	TskJavaObject VARCHAR(512),
	TskOutput TEXT,
	TskRepetition CHAR(16),
	TskStartTime TIMESTAMP,
	TskStartDate TIMESTAMP,
	TskEndTime TIMESTAMP,
	TskEndDate TIMESTAMP,
	TskInterval INTEGER,
	TskInstance CHAR(16),
	TskDayOfMonth INTEGER,
	TskMonthOfYear INTEGER,
	TskPriority INTEGER,
	TskNotes TEXT,
	TskBase CHAR(16),
	TskCreID CHAR(16) NOT NULL,
	TskModID CHAR(16) NOT NULL,
	TskCrDt TIMESTAMP NOT NULL,
	TskUpd TIMESTAMP NOT NULL,
	TskMbm INTEGER,
	TskMbs INTEGER,
	PRIMARY KEY (TskID)
);

CREATE TABLE FlTaskLog (
	TslID CHAR(16) NOT NULL,
	TslStarted TIMESTAMP,
	TslEnded TIMESTAMP,
	TslUnfinished TEXT,
	TslBody TEXT,
	TslTskID CHAR(16),
	TslStatus INTEGER,
	TslCreID CHAR(16) NOT NULL,
	TslModID CHAR(16) NOT NULL,
	TslCrDt TIMESTAMP NOT NULL,
	TslUpd TIMESTAMP NOT NULL,
	TslMbm INTEGER,
	TslMbs INTEGER,
	PRIMARY KEY (TslID)
);

CREATE TABLE History (
	HisID CHAR(16) NOT NULL,
	HisType INTEGER,
	HisDate TIMESTAMP,
	HisActID CHAR(16),
	HisPerID CHAR(16),
	HisSilID CHAR(16),
	HisJouID CHAR(16),
	HisName VARCHAR(250),
	HisDataType VARCHAR(50),
	HisParentID CHAR(16),
	HisDescription TEXT,
	HisOldTextValue VARCHAR(255),
	HisOldLongTextValue TEXT,
	HisOldFobValue VARCHAR(16),
	HisOldRefValue CHAR(16),
	HisOldDateTimeValue TIMESTAMP,
	HisOldIntValue BIGINT,
	HisOldFloatValue NUMERIC,
	HisNewTextValue VARCHAR(255),
	HisNewLongTextValue TEXT,
	HisNewFobValue VARCHAR(16),
	HisNewRefValue CHAR(16),
	HisNewDateTimeValue TIMESTAMP,
	HisNewIntValue BIGINT,
	HisNewFloatValue NUMERIC,
	HisObjectID VARCHAR(16),
	HisCreID CHAR(16) NOT NULL,
	HisModID CHAR(16) NOT NULL,
	HisCrDt TIMESTAMP NOT NULL,
	HisUpd TIMESTAMP NOT NULL,
	HisMbm INTEGER,
	HisMbs INTEGER,
	PRIMARY KEY (HisID)
);

CREATE TABLE InformationPanel (
	InpID CHAR(16) NOT NULL,
	InpIssuerID CHAR(16),
	InpDate TIMESTAMP,
	InpCatID CHAR(16),
	InpTypID CHAR(16),
	InpSubject VARCHAR(50),
	InpContent TEXT,
	InpFromDate TIMESTAMP,
	InpToDate TIMESTAMP,
	InpCoWorkerLimitation INTEGER,
	InpBackupLimitation INTEGER,
	InpAssistantLimitation INTEGER,
	InpCreID CHAR(16) NOT NULL,
	InpModID CHAR(16) NOT NULL,
	InpCrDt TIMESTAMP NOT NULL,
	InpUpd TIMESTAMP NOT NULL,
	InpMbm INTEGER,
	InpMbs INTEGER,
	PRIMARY KEY (InpID)
);

CREATE TABLE Label (
	LblID CHAR(16) NOT NULL,
	LblCodeMsg VARCHAR(10),
	LblCodeLng CHAR(16),
	LblLabel TEXT,
	LblLabelMore TEXT,
	LblCreID CHAR(16) NOT NULL,
	LblModID CHAR(16) NOT NULL,
	LblCrDt TIMESTAMP NOT NULL,
	LblUpd TIMESTAMP NOT NULL,
	LblMbm INTEGER,
	LblMbs INTEGER,
	PRIMARY KEY (LblID)
);

CREATE TABLE LinkZoneField (
	LzfID CHAR(16) NOT NULL,
	LzfAdzID CHAR(16),
	LzfFldID CHAR(16),
	LzfPreText VARCHAR(10),
	LzfPostText VARCHAR(10),
	LzfPosition INTEGER,
	LzfUrl VARCHAR(255),
	LzfHrefAttribute VARCHAR(255),
	LzfDefaultAttribute INTEGER,
	LzfEditTagAttributes TEXT,
	LzfReadTagAttributes TEXT,
	LzfCreID CHAR(16) NOT NULL,
	LzfModID CHAR(16) NOT NULL,
	LzfCrDt TIMESTAMP NOT NULL,
	LzfUpd TIMESTAMP NOT NULL,
	LzfMbm INTEGER,
	LzfMbs INTEGER,
	PRIMARY KEY (LzfID)
);

CREATE TABLE List (
	LstID CHAR(16) NOT NULL,
	LstCode VARCHAR(10),
	LstName VARCHAR(100),
	LstLabel VARCHAR(10),
	LstObjID CHAR(16),
	LstContent TEXT,
	LstDispCrit VARCHAR(30),
	LstCreID CHAR(16) NOT NULL,
	LstModID CHAR(16) NOT NULL,
	LstCrDt TIMESTAMP NOT NULL,
	LstUpd TIMESTAMP NOT NULL,
	LstMbm INTEGER,
	LstMbs INTEGER,
	PRIMARY KEY (LstID)
);

CREATE TABLE MatchCodeFields (
	McfID CHAR(16) NOT NULL,
	McfFldID CHAR(16),
	McfPoids INTEGER,
	McfWfaID CHAR(16),
	McfMcrID CHAR(16),
	McfNum INTEGER,
	McfCreID CHAR(16) NOT NULL,
	McfModID CHAR(16) NOT NULL,
	McfCrDt TIMESTAMP NOT NULL,
	McfUpd TIMESTAMP NOT NULL,
	McfMbm INTEGER,
	McfMbs INTEGER,
	PRIMARY KEY (McfID)
);

CREATE TABLE MatchCodeRules (
	McrID CHAR(16) NOT NULL,
	McrObjID CHAR(16),
	McrSuspThreshold INTEGER,
	McrCertThreshold INTEGER,
	McrCreID CHAR(16) NOT NULL,
	McrModID CHAR(16) NOT NULL,
	McrCrDt TIMESTAMP NOT NULL,
	McrUpd TIMESTAMP NOT NULL,
	McrMbm INTEGER,
	McrMbs INTEGER,
	PRIMARY KEY (McrID)
);

CREATE TABLE MatchCodeTemplate (
	McoID CHAR(16) NOT NULL,
	McoObjID CHAR(16),
	McoName VARCHAR(200),
	McoPoids INTEGER,
	McoCreID CHAR(16) NOT NULL,
	McoModID CHAR(16) NOT NULL,
	McoCrDt TIMESTAMP NOT NULL,
	McoUpd TIMESTAMP NOT NULL,
	McoMbm INTEGER,
	McoMbs INTEGER,
	PRIMARY KEY (McoID)
);

CREATE TABLE Menu (
	MenID CHAR(16) NOT NULL,
	MenSfwID CHAR(16),
	MenLabel VARCHAR(250),
	MenTitle VARCHAR(250),
	MenIcon CHAR(16),
	MenIconName VARCHAR(250),
	MenValue INTEGER,
	MenDefault INTEGER,
	MenLocked INTEGER,
	MenTitleIsCode INTEGER,
	MenMainLink TEXT,
	MenMainList CHAR(16),
	MenCreID CHAR(16) NOT NULL,
	MenModID CHAR(16) NOT NULL,
	MenCrDt TIMESTAMP NOT NULL,
	MenUpd TIMESTAMP NOT NULL,
	MenMbm INTEGER,
	MenMbs INTEGER,
	PRIMARY KEY (MenID)
);

CREATE TABLE MenuByRole (
	MbrID CHAR(16) NOT NULL,
	MbrRole CHAR(16),
	MbrMenID CHAR(16),
	MbrCreID CHAR(16) NOT NULL,
	MbrModID CHAR(16) NOT NULL,
	MbrCrDt TIMESTAMP NOT NULL,
	MbrUpd TIMESTAMP NOT NULL,
	MbrMbm INTEGER,
	MbrMbs INTEGER,
	PRIMARY KEY (MbrID)
);

CREATE TABLE MenuElement (
	MelID CHAR(16) NOT NULL,
	MelMenID CHAR(16),
	MelParentID CHAR(16),
	MelPosition INTEGER,
	MelLabelIsCode INTEGER,
	MelIconName VARCHAR(250),
	MelOpensNew INTEGER,
	MelType VARCHAR(16),
	MelLabel VARCHAR(250),
	MelLink VARCHAR(255),
	MelCreID CHAR(16) NOT NULL,
	MelModID CHAR(16) NOT NULL,
	MelCrDt TIMESTAMP NOT NULL,
	MelUpd TIMESTAMP NOT NULL,
	MelMbm INTEGER,
	MelMbs INTEGER,
	PRIMARY KEY (MelID)
);

CREATE TABLE Messages (
	MsgID CHAR(16) NOT NULL,
	MsgSubject VARCHAR(255),
	MsgBody TEXT,
	MsgPriority INTEGER,
	MsgCtyID CHAR(16),
	MsgCty VARCHAR(255),
	MsgCode VARCHAR(16),
	MsgObjID CHAR(16),
	MsgEvtID CHAR(16),
	MsgLngRef CHAR(16),
	MsgType CHAR(16),
	MsgBodyText TEXT,
	MsgCreID CHAR(16) NOT NULL,
	MsgModID CHAR(16) NOT NULL,
	MsgCrDt TIMESTAMP NOT NULL,
	MsgUpd TIMESTAMP NOT NULL,
	MsgMbm INTEGER,
	MsgMbs INTEGER,
	PRIMARY KEY (MsgID)
);

CREATE TABLE MetaDataFieldChange (
	MfcID CHAR(16) NOT NULL,
	MfcMocID CHAR(16),
	MfcFldID CHAR(16),
	MfcOldValue TEXT,
	MfcNewValue TEXT,
	MfcNewFldID VARCHAR(100),
	MfcCreID CHAR(16) NOT NULL,
	MfcModID CHAR(16) NOT NULL,
	MfcCrDt TIMESTAMP NOT NULL,
	MfcUpd TIMESTAMP NOT NULL,
	MfcMbm INTEGER,
	MfcMbs INTEGER,
	PRIMARY KEY (MfcID)
);

CREATE TABLE MetaDataObjectChange (
	MocID CHAR(16) NOT NULL,
	MocObjID CHAR(16),
	MocOrder INTEGER,
	MocNewObjID VARCHAR(50),
	MocMdtID CHAR(16),
	MocIsNew INTEGER,
	MocModifySQL TEXT,
	MocRollbackSQL TEXT,
	MocUpdateDate TIMESTAMP,
	MocError VARCHAR(1000),
	MocPolitique CHAR(16),
	MocRollbackError VARCHAR(1000),
	MocKeyFldValues VARCHAR(500),
	MocCreID CHAR(16) NOT NULL,
	MocModID CHAR(16) NOT NULL,
	MocCrDt TIMESTAMP NOT NULL,
	MocUpd TIMESTAMP NOT NULL,
	MocMbm INTEGER,
	MocMbs INTEGER,
	PRIMARY KEY (MocID)
);

CREATE TABLE MetaDataTransfer (
	MdtID CHAR(16) NOT NULL,
	MdtDescription TEXT,
	MdtName VARCHAR(50),
	MdtTransferEnded TIMESTAMP,
	MdtSource CHAR(16),
	MdtSourceName VARCHAR(50),
	MdtStatus CHAR(16),
	MdtErrorMsg VARCHAR(4000),
	MdtCreID CHAR(16) NOT NULL,
	MdtModID CHAR(16) NOT NULL,
	MdtCrDt TIMESTAMP NOT NULL,
	MdtUpd TIMESTAMP NOT NULL,
	MdtMbm INTEGER,
	MdtMbs INTEGER,
	PRIMARY KEY (MdtID)
);

CREATE TABLE Objects (
	ObjID CHAR(16) NOT NULL,
	ObjSql VARCHAR(50),
	ObjDisplay VARCHAR(50),
	ObjDisplayLabel VARCHAR(10),
	ObjModule VARCHAR(25),
	ObjTyoID VARCHAR(16),
	ObjRadical VARCHAR(3),
	ObjStandard INTEGER,
	ObjTabID VARCHAR(16),
	ObjOwnerRead INTEGER,
	ObjOwnerEdit INTEGER,
	ObjOwnerCreate INTEGER,
	ObjOwnerDelete INTEGER,
	ObjDefaultRead INTEGER,
	ObjDefaultEdit INTEGER,
	ObjDefaultCreate INTEGER,
	ObjDefaultDelete INTEGER,
	ObjDispRead VARCHAR(255),
	ObjDispEdit VARCHAR(255),
	ObjDispCreate VARCHAR(255),
	ObjWhatNextDelete VARCHAR(255),
	ObjWhatNextCreate VARCHAR(255),
	ObjWhatNextEdit VARCHAR(255),
	ObjSelectFields VARCHAR(150),
	ObjSelectDisplay VARCHAR(150),
	ObjToString VARCHAR(150),
	ObjDescription TEXT,
	ObjAjaxSearch TEXT,
	ObjAjaxOrder TEXT,
	ObjAlterTable INTEGER,
	ObjModificationLogged INTEGER,
	ObjAjaxMinChar INTEGER,
	ObjSelectListCode VARCHAR(16),
	ObjCreID CHAR(16) NOT NULL,
	ObjModID CHAR(16) NOT NULL,
	ObjCrDt TIMESTAMP NOT NULL,
	ObjUpd TIMESTAMP NOT NULL,
	ObjMbm INTEGER,
	ObjMbs INTEGER,
	PRIMARY KEY (ObjID)
);

CREATE TABLE Operation (
	OpeID CHAR(16) NOT NULL,
	OpeOpgID CHAR(16),
	OpePosition INTEGER,
	OpeDone TIMESTAMP,
	OpeResult CHAR(16),
	OpeData BYTEA,
	OpeEmail TEXT,
	OpeType CHAR(16),
	OpeExtID VARCHAR(16),
	OpeStatus INTEGER,
	OpeCreID CHAR(16) NOT NULL,
	OpeModID CHAR(16) NOT NULL,
	OpeCrDt TIMESTAMP NOT NULL,
	OpeUpd TIMESTAMP NOT NULL,
	OpeMbm INTEGER,
	OpeMbs INTEGER,
	PRIMARY KEY (OpeID)
);

CREATE TABLE OperationGroup (
	OpgID CHAR(16) NOT NULL,
	OpgType CHAR(16),
	OpgActivation TIMESTAMP,
	OpgData BYTEA,
	OpgCreID CHAR(16) NOT NULL,
	OpgModID CHAR(16) NOT NULL,
	OpgCrDt TIMESTAMP NOT NULL,
	OpgUpd TIMESTAMP NOT NULL,
	OpgMbm INTEGER,
	OpgMbs INTEGER,
	PRIMARY KEY (OpgID)
);

CREATE TABLE Partition (
	PrtID CHAR(16) NOT NULL,
	PrtCode VARCHAR(15),
	PrtName VARCHAR(100),
	PrtMode CHAR(16),
	PrtParentPart CHAR(16),
	PrtCreID CHAR(16) NOT NULL,
	PrtModID CHAR(16) NOT NULL,
	PrtCrDt TIMESTAMP NOT NULL,
	PrtUpd TIMESTAMP NOT NULL,
	PrtMbm INTEGER,
	PrtMbs INTEGER,
	PRIMARY KEY (PrtID)
);

CREATE TABLE PerIdentical (
	PidID CHAR(16) NOT NULL,
	PidIsNotDbl INTEGER,
	PidPoids INTEGER,
	PidExtID TEXT,
	PidOtherInfo VARCHAR(1000),
	PidPerID1 CHAR(16),
	PidPerID2 CHAR(16),
	PidCreID CHAR(16) NOT NULL,
	PidModID CHAR(16) NOT NULL,
	PidCrDt TIMESTAMP NOT NULL,
	PidUpd TIMESTAMP NOT NULL,
	PidMbm INTEGER,
	PidMbs INTEGER,
	PRIMARY KEY (PidID)
);

CREATE TABLE RefLocale (
	RelID CHAR(16) NOT NULL,
	RelRefID CHAR(16),
	RelLngID CHAR(16),
	RelTe1 VARCHAR(250),
	RelTe2 VARCHAR(250),
	RelTe3 VARCHAR(250),
	RelCreID CHAR(16) NOT NULL,
	RelModID CHAR(16) NOT NULL,
	RelCrDt TIMESTAMP NOT NULL,
	RelUpd TIMESTAMP NOT NULL,
	RelMbm INTEGER,
	RelMbs INTEGER,
	PRIMARY KEY (RelID)
);

CREATE TABLE RefValues (
	RefID CHAR(16) NOT NULL,
	RefTabID CHAR(16),
	RefAff VARCHAR(100),
	RefVal VARCHAR(100),
	RefTe1 VARCHAR(250),
	RefTe2 VARCHAR(250),
	RefTe3 VARCHAR(250),
	RefNu1 NUMERIC,
	RefNu2 NUMERIC,
	RefNu3 NUMERIC,
	RefDa1 TIMESTAMP,
	RefDa2 TIMESTAMP,
	RefDa3 TIMESTAMP,
	RefEnd INTEGER,
	RefPos INTEGER,
	RefCreID CHAR(16) NOT NULL,
	RefModID CHAR(16) NOT NULL,
	RefCrDt TIMESTAMP NOT NULL,
	RefUpd TIMESTAMP NOT NULL,
	RefMbm INTEGER,
	RefMbs INTEGER,
	PRIMARY KEY (RefID)
);

CREATE TABLE Requester (
	ReqID CHAR(16) NOT NULL,
	ReqQuery TEXT,
	ReqTyrID CHAR(16),
	ReqLngID CHAR(16),
	ReqCode VARCHAR(10),
	ReqTitle VARCHAR(50),
	ReqRemarks VARCHAR(255),
	ReqParam1 VARCHAR(10),
	ReqLookUp1 VARCHAR(50),
	ReqType1 CHAR(16),
	ReqParam2 VARCHAR(10),
	ReqLookUp2 VARCHAR(50),
	ReqType2 CHAR(16),
	ReqParam3 VARCHAR(10),
	ReqLookUp3 VARCHAR(50),
	ReqType3 CHAR(16),
	ReqParam4 VARCHAR(10),
	ReqLookUp4 VARCHAR(50),
	ReqType4 CHAR(16),
	ReqParam5 VARCHAR(10),
	ReqLookUp5 VARCHAR(50),
	ReqType5 CHAR(16),
	ReqParam6 VARCHAR(10),
	ReqLookUp6 VARCHAR(50),
	ReqType6 CHAR(16),
	ReqParam7 VARCHAR(10),
	ReqLookUp7 VARCHAR(50),
	ReqType7 CHAR(16),
	ReqParam8 VARCHAR(10),
	ReqLookUp8 VARCHAR(50),
	ReqType8 CHAR(16),
	ReqParam9 VARCHAR(10),
	ReqLookUp9 VARCHAR(50),
	ReqType9 CHAR(16),
	ReqObjID CHAR(16),
	ReqPpePerID INTEGER,
	ReqPpeEntID INTEGER,
	ReqPpeSilID INTEGER,
	ReqPpeJouID INTEGER,
	ReqPpeSupID INTEGER,
	ReqPpeFob1 INTEGER,
	ReqPpeFob2 INTEGER,
	ReqPpeFob3 INTEGER,
	ReqPpeFob4 INTEGER,
	ReqPpeFob5 INTEGER,
	ReqPopObj1 CHAR(16),
	ReqPopObj2 CHAR(16),
	ReqPopObj3 CHAR(16),
	ReqPopObj4 CHAR(16),
	ReqPopObj5 CHAR(16),
	ReqCreID CHAR(16) NOT NULL,
	ReqModID CHAR(16) NOT NULL,
	ReqCrDt TIMESTAMP NOT NULL,
	ReqUpd TIMESTAMP NOT NULL,
	ReqMbm INTEGER,
	ReqMbs INTEGER,
	PRIMARY KEY (ReqID)
);

CREATE TABLE Site (
	SitID CHAR(16) NOT NULL,
	SitName VARCHAR(100),
	SitCode VARCHAR(100),
	SitKosID CHAR(16),
	SitAd1 VARCHAR(50),
	SitAd2 VARCHAR(50),
	SitAd3 VARCHAR(50),
	SitZip VARCHAR(10),
	SitCity VARCHAR(32),
	SitCtrID CHAR(16),
	SitPhone VARCHAR(20),
	SitFax VARCHAR(20),
	SitAreID CHAR(16),
	SitActID CHAR(16),
	SitPicID CHAR(16),
	SitPicFileName VARCHAR(255),
	SitCreID CHAR(16) NOT NULL,
	SitModID CHAR(16) NOT NULL,
	SitCrDt TIMESTAMP NOT NULL,
	SitUpd TIMESTAMP NOT NULL,
	SitMbm INTEGER,
	SitMbs INTEGER,
	PRIMARY KEY (SitID)
);

CREATE TABLE SLA (
	SlaID CHAR(16) NOT NULL,
	SlaCode VARCHAR(12),
	SlaLabel VARCHAR(80),
	SlaSssID CHAR(16),
	SlaObjID CHAR(16),
	SlaTzoID CHAR(16),
	SlaBeginHour TIMESTAMP,
	SlaEndHour TIMESTAMP,
	SlaMsgAlarm CHAR(16),
	SlaMsgOver CHAR(16),
	SlaMainFields CHAR(16),
	SlaUrl VARCHAR(150),
	SlaPriority INTEGER,
	SlaField1 CHAR(16),
	SlaField2 CHAR(16),
	SlaField3 CHAR(16),
	SlaMsgDelay CHAR(16),
	SlaMsgFinalAlert CHAR(16),
	SlaMsgDelayAlert CHAR(16),
	SlaMsgOverAlert CHAR(16),
	SlaCreID CHAR(16) NOT NULL,
	SlaModID CHAR(16) NOT NULL,
	SlaCrDt TIMESTAMP NOT NULL,
	SlaUpd TIMESTAMP NOT NULL,
	SlaMbm INTEGER,
	SlaMbs INTEGER,
	PRIMARY KEY (SlaID)
);

CREATE TABLE SLAAlarm (
	SllID CHAR(16) NOT NULL,
	SllObjetID VARCHAR(16),
	SllTalID CHAR(16),
	SllSlsID CHAR(16),
	SllDate TIMESTAMP,
	SllDelayDay INTEGER,
	SllDelayHour INTEGER,
	SllDelayMin INTEGER,
	SllOverDay INTEGER,
	SllOverHour INTEGER,
	SllOverMin INTEGER,
	SllCause CHAR(16),
	SllExecuted INTEGER,
	SllCreID CHAR(16) NOT NULL,
	SllModID CHAR(16) NOT NULL,
	SllCrDt TIMESTAMP NOT NULL,
	SllUpd TIMESTAMP NOT NULL,
	SllMbm INTEGER,
	SllMbs INTEGER,
	PRIMARY KEY (SllID)
);

CREATE TABLE SLAState (
	SlsID CHAR(16) NOT NULL,
	SlsSLAID CHAR(16),
	SlsCode VARCHAR(10),
	SlsLabel VARCHAR(80),
	SlsDelayDay INTEGER,
	SlsDelayHour INTEGER,
	SlsDelayMin INTEGER,
	SlsPrcAlarm INTEGER,
	SlsDelayMaxDay INTEGER,
	SlsDelayMaxHour INTEGER,
	SlsDelayMaxMin INTEGER,
	SlsValue1 CHAR(16),
	SlsValue2 CHAR(16),
	SlsValue3 CHAR(16),
	SlsPrcMaxAlarm INTEGER,
	SlsDelayMinDay INTEGER,
	SlsDelayMinHour INTEGER,
	SlsDelayMinMin INTEGER,
	SlsPrcMinAlarm INTEGER,
	SlsCreID CHAR(16) NOT NULL,
	SlsModID CHAR(16) NOT NULL,
	SlsCrDt TIMESTAMP NOT NULL,
	SlsUpd TIMESTAMP NOT NULL,
	SlsMbm INTEGER,
	SlsMbs INTEGER,
	PRIMARY KEY (SlsID)
);

CREATE TABLE SMSTemplate (
	SmtID CHAR(16) NOT NULL,
	SmtCode VARCHAR(20),
	SmtBody VARCHAR(160),
	SmtCreID CHAR(16) NOT NULL,
	SmtModID CHAR(16) NOT NULL,
	SmtCrDt TIMESTAMP NOT NULL,
	SmtUpd TIMESTAMP NOT NULL,
	SmtMbm INTEGER,
	SmtMbs INTEGER,
	PRIMARY KEY (SmtID)
);

CREATE TABLE Software (
	SfwID CHAR(16) NOT NULL,
	SfwName VARCHAR(250),
	SfwDisplayName VARCHAR(250),
	SfwIcon CHAR(16),
	SfwIconName VARCHAR(250),
	SfwDisplayNameIsCode INTEGER,
	SfwInternalIndex INTEGER,
	SfwPosition INTEGER,
	SfwStandard INTEGER,
	SfwInactive INTEGER,
	SfwHidden INTEGER,
	SfwCode VARCHAR(25),
	SfwCreID CHAR(16) NOT NULL,
	SfwModID CHAR(16) NOT NULL,
	SfwCrDt TIMESTAMP NOT NULL,
	SfwUpd TIMESTAMP NOT NULL,
	SfwMbm INTEGER,
	SfwMbs INTEGER,
	PRIMARY KEY (SfwID)
);

CREATE TABLE Supplier (
	SplID CHAR(16) NOT NULL,
	SplCode VARCHAR(12),
	SplRS VARCHAR(32),
	SplAd1 VARCHAR(32),
	SplAd2 VARCHAR(32),
	SplAd3 VARCHAR(32),
	SplZip VARCHAR(5),
	SplCity VARCHAR(26),
	SplCtrID CHAR(16),
	SplTel VARCHAR(80),
	SplFax VARCHAR(80),
	SplWeb VARCHAR(80),
	SplContact VARCHAR(80),
	SplContactTel VARCHAR(80),
	SplContactMail VARCHAR(80),
	SplAsst VARCHAR(80),
	SplAsstTel VARCHAR(80),
	SplAsstMail VARCHAR(80),
	SplStatut CHAR(16),
	SplNotes TEXT,
	SplCreID CHAR(16) NOT NULL,
	SplModID CHAR(16) NOT NULL,
	SplCrDt TIMESTAMP NOT NULL,
	SplUpd TIMESTAMP NOT NULL,
	SplMbm INTEGER,
	SplMbs INTEGER,
	PRIMARY KEY (SplID)
);

CREATE TABLE Synchronization (
	SynID CHAR(16) NOT NULL,
	SynActID CHAR(16),
	SynEDealID VARCHAR(16),
	SynExternalID VARCHAR(250),
	SynObjectType INTEGER,
	SynExternalHref TEXT,
	SynSeriesID VARCHAR(250),
	SynMeetingID TEXT,
	SynSeriesApptDate TIMESTAMP,
	SynSeriesOccurrenceIndex INTEGER,
	SynCreID CHAR(16) NOT NULL,
	SynModID CHAR(16) NOT NULL,
	SynCrDt TIMESTAMP NOT NULL,
	SynUpd TIMESTAMP NOT NULL,
	SynMbm INTEGER,
	SynMbs INTEGER,
	PRIMARY KEY (SynID)
);

CREATE TABLE SyncModel (
	SymID CHAR(16) NOT NULL,
	SymCode VARCHAR(100),
	SymObjConfig TEXT,
	SymTitle VARCHAR(100),
	SymSyncConfig TEXT,
	SymType CHAR(16),
	SymCreID CHAR(16) NOT NULL,
	SymModID CHAR(16) NOT NULL,
	SymCrDt TIMESTAMP NOT NULL,
	SymUpd TIMESTAMP NOT NULL,
	SymMbm INTEGER,
	SymMbs INTEGER,
	PRIMARY KEY (SymID)
);

CREATE TABLE Tables (
	TabID CHAR(16) NOT NULL,
	TabName VARCHAR(100),
	TabRadical VARCHAR(3),
	TabModule VARCHAR(100),
	TabScreen VARCHAR(100),
	TabT1 VARCHAR(200),
	TabT2 VARCHAR(200),
	TabT3 VARCHAR(200),
	TabN1 VARCHAR(200),
	TabN2 VARCHAR(200),
	TabN3 VARCHAR(200),
	TabD1 VARCHAR(200),
	TabD2 VARCHAR(200),
	TabD3 VARCHAR(200),
	TabCreID CHAR(16) NOT NULL,
	TabModID CHAR(16) NOT NULL,
	TabCrDt TIMESTAMP NOT NULL,
	TabUpd TIMESTAMP NOT NULL,
	TabMbm INTEGER,
	TabMbs INTEGER,
	PRIMARY KEY (TabID)
);

CREATE TABLE TrashReport (
	TrpID CHAR(16) NOT NULL,
	TrpDieID CHAR(16),
	TrpFileName VARCHAR(300),
	TrpImportDate TIMESTAMP,
	TrpXMLModel TEXT,
	TrpObjID CHAR(16),
	TrpPos INTEGER,
	TrpCreID CHAR(16) NOT NULL,
	TrpModID CHAR(16) NOT NULL,
	TrpCrDt TIMESTAMP NOT NULL,
	TrpUpd TIMESTAMP NOT NULL,
	TrpMbm INTEGER,
	TrpMbs INTEGER,
	PRIMARY KEY (TrpID)
);

CREATE TABLE TrashReportLine (
	TrlID CHAR(16) NOT NULL,
	TrlTrpID CHAR(16),
	TrlErrorCodeID CHAR(16),
	TrlErrorField CHAR(16),
	TrlLine TEXT,
	TrlCreID CHAR(16) NOT NULL,
	TrlModID CHAR(16) NOT NULL,
	TrlCrDt TIMESTAMP NOT NULL,
	TrlUpd TIMESTAMP NOT NULL,
	TrlMbm INTEGER,
	TrlMbs INTEGER,
	PRIMARY KEY (TrlID)
);

CREATE TABLE WallUserConfig (
	WucID CHAR(16) NOT NULL,
	WucTypObj CHAR(16),
	WucSe2Id CHAR(16),
	WucActID CHAR(16),
	WucBoolAct INTEGER,
	WucCreID CHAR(16) NOT NULL,
	WucModID CHAR(16) NOT NULL,
	WucCrDt TIMESTAMP NOT NULL,
	WucUpd TIMESTAMP NOT NULL,
	WucMbm INTEGER,
	WucMbs INTEGER,
	PRIMARY KEY (WucID)
);

CREATE TABLE Workflow (
	WkfID CHAR(16) NOT NULL,
	WkfDescription VARCHAR(200),
	WkfContent TEXT,
	WkfObjID CHAR(16),
	WkfStatus CHAR(16),
	WkfName VARCHAR(150),
	WkfMsgID CHAR(16),
	WkfCreID CHAR(16) NOT NULL,
	WkfModID CHAR(16) NOT NULL,
	WkfCrDt TIMESTAMP NOT NULL,
	WkfUpd TIMESTAMP NOT NULL,
	WkfMbm INTEGER,
	WkfMbs INTEGER,
	PRIMARY KEY (WkfID)
);

CREATE TABLE WorkflowAction (
	WfaID CHAR(16) NOT NULL,
	WfaMethod VARCHAR(512),
	WfaName VARCHAR(150),
	WfaDescription TEXT,
	WfaClass VARCHAR(512),
	WfaType CHAR(16),
	WfaCreID CHAR(16) NOT NULL,
	WfaModID CHAR(16) NOT NULL,
	WfaCrDt TIMESTAMP NOT NULL,
	WfaUpd TIMESTAMP NOT NULL,
	WfaMbm INTEGER,
	WfaMbs INTEGER,
	PRIMARY KEY (WfaID)
);

CREATE TABLE XPage (
	XpgID CHAR(16) NOT NULL,
	XpgLabel VARCHAR(20),
	XpgTargetObject CHAR(16),
	XpgPageNum INTEGER,
	XpgClass CHAR(16),
	XpgClassIDFld VARCHAR(15),
	XpgDisplayFld INTEGER,
	XpgFobID VARCHAR(15),
	XpgCreID CHAR(16) NOT NULL,
	XpgModID CHAR(16) NOT NULL,
	XpgCrDt TIMESTAMP NOT NULL,
	XpgUpd TIMESTAMP NOT NULL,
	XpgMbm INTEGER,
	XpgMbs INTEGER,
	PRIMARY KEY (XpgID)
);

CREATE TABLE XPageField (
	XpfID CHAR(16) NOT NULL,
	XpfXPageID CHAR(16),
	XpfFieldName VARCHAR(15),
	XpfFieldType CHAR(16),
	XpfRequired INTEGER,
	XpfIndex INTEGER,
	XpfObjTarget VARCHAR(3),
	XpfFieldSQLName VARCHAR(20),
	XpfCreID CHAR(16) NOT NULL,
	XpfModID CHAR(16) NOT NULL,
	XpfCrDt TIMESTAMP NOT NULL,
	XpfUpd TIMESTAMP NOT NULL,
	XpfMbm INTEGER,
	XpfMbs INTEGER,
	PRIMARY KEY (XpfID)
);

CREATE TABLE XPageSource (
	XpsID CHAR(16) NOT NULL,
	XpsSourceID VARCHAR(30),
	XpsTarget CHAR(16),
	XpsDel CHAR(16),
	XpsEdit CHAR(16),
	XpsQuery TEXT,
	XpsCreID CHAR(16) NOT NULL,
	XpsModID CHAR(16) NOT NULL,
	XpsCrDt TIMESTAMP NOT NULL,
	XpsUpd TIMESTAMP NOT NULL,
	XpsMbm INTEGER,
	XpsMbs INTEGER,
	PRIMARY KEY (XpsID)
);

CREATE TABLE XPageUser (
	XpuID CHAR(16) NOT NULL,
	XpuLoginName CHAR(16),
	XpuEntSource VARCHAR(20),
	XpuActSource VARCHAR(20),
	XpuIntSource VARCHAR(20),
	XpuPerSource VARCHAR(20),
	XpuXp1Source VARCHAR(20),
	XpuXp2Source VARCHAR(20),
	XpuXp3Source VARCHAR(20),
	XpuXp4Source VARCHAR(20),
	XpuXp5Source VARCHAR(20),
	XpuXp6Source VARCHAR(20),
	XpuXp7Source VARCHAR(20),
	XpuXp8Source VARCHAR(20),
	XpuXp9Source VARCHAR(20),
	XpuXp10Source VARCHAR(20),
	XpuCreID CHAR(16) NOT NULL,
	XpuModID CHAR(16) NOT NULL,
	XpuCrDt TIMESTAMP NOT NULL,
	XpuUpd TIMESTAMP NOT NULL,
	XpuMbm INTEGER,
	XpuMbs INTEGER,
	PRIMARY KEY (XpuID)
);

CREATE TABLE ZipCodeEntry (
	ZipID CHAR(16) NOT NULL,
	ZipCode VARCHAR(10),
	ZipCity VARCHAR(40),
	ZipCountry CHAR(16),
	ZipCreID CHAR(16) NOT NULL,
	ZipModID CHAR(16) NOT NULL,
	ZipCrDt TIMESTAMP NOT NULL,
	ZipUpd TIMESTAMP NOT NULL,
	ZipMbm INTEGER,
	ZipMbs INTEGER,
	PRIMARY KEY (ZipID)
);

CREATE TABLE AbstractAction (
	AbsID CHAR(16) NOT NULL,
	AbsCaption VARCHAR(100),
	AbsClassName VARCHAR(255),
	AbsSynchronized INTEGER,
	AbsNbParams INTEGER,
	AbsDescription VARCHAR(255),
	AbsCreID CHAR(16) NOT NULL,
	AbsModID CHAR(16) NOT NULL,
	AbsCrDt TIMESTAMP NOT NULL,
	AbsUpd TIMESTAMP NOT NULL,
	AbsMbm INTEGER,
	AbsMbs INTEGER,
	PRIMARY KEY (AbsID)
);

CREATE TABLE Action (
	AacID CHAR(16) NOT NULL,
	AacCaption VARCHAR(100),
	AacClassName VARCHAR(255),
	AacRulID CHAR(16),
	AacSynchronized INTEGER,
	AacDescription VARCHAR(255),
	AacCreID CHAR(16) NOT NULL,
	AacModID CHAR(16) NOT NULL,
	AacCrDt TIMESTAMP NOT NULL,
	AacUpd TIMESTAMP NOT NULL,
	AacMbm INTEGER,
	AacMbs INTEGER,
	PRIMARY KEY (AacID)
);

CREATE TABLE AutomationLog (
	AulID CHAR(16) NOT NULL,
	AulRulID CHAR(16),
	AulDate TIMESTAMP,
	AulActionID CHAR(16),
	AulDetail VARCHAR(255),
	AulCreID CHAR(16) NOT NULL,
	AulModID CHAR(16) NOT NULL,
	AulCrDt TIMESTAMP NOT NULL,
	AulUpd TIMESTAMP NOT NULL,
	AulMbm INTEGER,
	AulMbs INTEGER,
	PRIMARY KEY (AulID)
);

CREATE TABLE AutomationParameter (
	AupID CHAR(16) NOT NULL,
	AupCaption VARCHAR(100),
	AupTypID CHAR(16),
	AupAbsID CHAR(16),
	AupAacID CHAR(16),
	AupOrigine VARCHAR(255),
	AupNumber INTEGER,
	AupFromRS VARCHAR(255),
	AupCstValue VARCHAR(255),
	AupIsCst INTEGER,
	AupCreID CHAR(16) NOT NULL,
	AupModID CHAR(16) NOT NULL,
	AupCrDt TIMESTAMP NOT NULL,
	AupUpd TIMESTAMP NOT NULL,
	AupMbm INTEGER,
	AupMbs INTEGER,
	PRIMARY KEY (AupID)
);

CREATE TABLE AutomationRequester (
	AurID CHAR(16) NOT NULL,
	AurQuery TEXT,
	AurCaption VARCHAR(255),
	AurRemarks TEXT,
	AurTemID CHAR(16),
	AurAcoID CHAR(16),
	AurCreID CHAR(16) NOT NULL,
	AurModID CHAR(16) NOT NULL,
	AurCrDt TIMESTAMP NOT NULL,
	AurUpd TIMESTAMP NOT NULL,
	AurMbm INTEGER,
	AurMbs INTEGER,
	PRIMARY KEY (AurID)
);

CREATE TABLE AutomationTrigger (
	TrgID CHAR(16) NOT NULL,
	TrgAopID CHAR(16),
	TrgObjID CHAR(16),
	TrgRulID CHAR(16),
	TrgCreID CHAR(16) NOT NULL,
	TrgModID CHAR(16) NOT NULL,
	TrgCrDt TIMESTAMP NOT NULL,
	TrgUpd TIMESTAMP NOT NULL,
	TrgMbm INTEGER,
	TrgMbs INTEGER,
	PRIMARY KEY (TrgID)
);

CREATE TABLE Condition (
	AcoID CHAR(16) NOT NULL,
	AcoCaption VARCHAR(100),
	AcoRulID CHAR(16),
	AcoCreID CHAR(16) NOT NULL,
	AcoModID CHAR(16) NOT NULL,
	AcoCrDt TIMESTAMP NOT NULL,
	AcoUpd TIMESTAMP NOT NULL,
	AcoMbm INTEGER,
	AcoMbs INTEGER,
	PRIMARY KEY (AcoID)
);

CREATE TABLE Process (
	PrsID CHAR(16) NOT NULL,
	PrsName VARCHAR(200),
	PrsCode VARCHAR(10),
	PrsStatus CHAR(16),
	PrsPriority INTEGER,
	PrsDescription TEXT,
	PrsObject CHAR(16),
	PrsLabel VARCHAR(200),
	PrsCategory CHAR(16),
	PrsCreID CHAR(16) NOT NULL,
	PrsModID CHAR(16) NOT NULL,
	PrsCrDt TIMESTAMP NOT NULL,
	PrsUpd TIMESTAMP NOT NULL,
	PrsMbm INTEGER,
	PrsMbs INTEGER,
	PRIMARY KEY (PrsID)
);

CREATE TABLE ProcessInstance (
	PriID CHAR(16) NOT NULL,
	PriExecActID CHAR(16),
	PriStatus CHAR(16),
	PriInstanceDate TIMESTAMP,
	PriErrorMsg TEXT,
	PriProcessObject VARCHAR(16),
	PriProcessObjType CHAR(16),
	PriNbIntTotal INTEGER,
	PriNbIntDone INTEGER,
	PriProcessID CHAR(16),
	PriType CHAR(16),
	PriCreID CHAR(16) NOT NULL,
	PriModID CHAR(16) NOT NULL,
	PriCrDt TIMESTAMP NOT NULL,
	PriUpd TIMESTAMP NOT NULL,
	PriMbm INTEGER,
	PriMbs INTEGER,
	PRIMARY KEY (PriID)
);

CREATE TABLE ProcessTask (
	PtaID CHAR(16) NOT NULL,
	PtaProcessID CHAR(16),
	PtaIntAtvID CHAR(16),
	PtaPeriod INTEGER,
	PtaIntSubject VARCHAR(250),
	PtaIntTimeBeg TIMESTAMP,
	PtaIntTimeEnd TIMESTAMP,
	PtaActorRule CHAR(16),
	PtaActorRuleField VARCHAR(250),
	PtaActorRuleActID CHAR(16),
	PtaIntNote TEXT,
	PtaOther TEXT,
	PtaIntStiID CHAR(16),
	PtaIntDetails TEXT,
	PtaCreID CHAR(16) NOT NULL,
	PtaModID CHAR(16) NOT NULL,
	PtaCrDt TIMESTAMP NOT NULL,
	PtaUpd TIMESTAMP NOT NULL,
	PtaMbm INTEGER,
	PtaMbs INTEGER,
	PRIMARY KEY (PtaID)
);

CREATE TABLE RequesterParameter (
	RepID CHAR(16) NOT NULL,
	RepCaption VARCHAR(100),
	RepTypID CHAR(16),
	RepValue VARCHAR(255),
	RepLookup VARCHAR(255),
	RepAurID CHAR(16),
	RepNumber INTEGER,
	RepCreID CHAR(16) NOT NULL,
	RepModID CHAR(16) NOT NULL,
	RepCrDt TIMESTAMP NOT NULL,
	RepUpd TIMESTAMP NOT NULL,
	RepMbm INTEGER,
	RepMbs INTEGER,
	PRIMARY KEY (RepID)
);

CREATE TABLE Rules (
	RulID CHAR(16) NOT NULL,
	RulCaption VARCHAR(100),
	RulBeginDate TIMESTAMP,
	RulEndDate TIMESTAMP,
	RulLengthTime INTEGER,
	RulModeID CHAR(16),
	RulConstraints VARCHAR(100),
	RulJConstraints VARCHAR(255),
	RulSynchronized INTEGER,
	RulCreID CHAR(16) NOT NULL,
	RulModID CHAR(16) NOT NULL,
	RulCrDt TIMESTAMP NOT NULL,
	RulUpd TIMESTAMP NOT NULL,
	RulMbm INTEGER,
	RulMbs INTEGER,
	PRIMARY KEY (RulID)
);

CREATE TABLE Signature (
	SigID CHAR(16) NOT NULL,
	SigOutDate TIMESTAMP,
	SigRulID CHAR(16),
	SigTargetID VARCHAR(255),
	SigCreID CHAR(16) NOT NULL,
	SigModID CHAR(16) NOT NULL,
	SigCrDt TIMESTAMP NOT NULL,
	SigUpd TIMESTAMP NOT NULL,
	SigMbm INTEGER,
	SigMbs INTEGER,
	PRIMARY KEY (SigID)
);

CREATE TABLE TemplateCondition (
	TemID CHAR(16) NOT NULL,
	TemCaption VARCHAR(100),
	TemCreID CHAR(16) NOT NULL,
	TemModID CHAR(16) NOT NULL,
	TemCrDt TIMESTAMP NOT NULL,
	TemUpd TIMESTAMP NOT NULL,
	TemMbm INTEGER,
	TemMbs INTEGER,
	PRIMARY KEY (TemID)
);

CREATE TABLE DecisionData (
	DdaID CHAR(16) NOT NULL,
	DdaCode VARCHAR(10),
	DdaName VARCHAR(50),
	DdaServer VARCHAR(50),
	DdaDivebook VARCHAR(50),
	DdaDefaultDir VARCHAR(50),
	DdaLogin VARCHAR(50),
	DdaPwd VARCHAR(50),
	DdaDefaultArea VARCHAR(50),
	DdaDefaultTopic VARCHAR(50),
	DdaType CHAR(16),
	DdaStatus CHAR(16),
	DdaPortalUrl VARCHAR(300),
	DdaPortalPage VARCHAR(100),
	DdaObjID CHAR(16),
	DdaReportParams TEXT,
	DdaComment TEXT,
	DdaIcon CHAR(16),
	DdaCreID CHAR(16) NOT NULL,
	DdaModID CHAR(16) NOT NULL,
	DdaCrDt TIMESTAMP NOT NULL,
	DdaUpd TIMESTAMP NOT NULL,
	DdaMbm INTEGER,
	DdaMbs INTEGER,
	PRIMARY KEY (DdaID)
);

CREATE TABLE DecisionFamilyProfile (
	DfpID CHAR(16) NOT NULL,
	DfpFamilyName CHAR(16),
	DfpProfile CHAR(16),
	DfpOrder INTEGER,
	DfpCreID CHAR(16) NOT NULL,
	DfpModID CHAR(16) NOT NULL,
	DfpCrDt TIMESTAMP NOT NULL,
	DfpUpd TIMESTAMP NOT NULL,
	DfpMbm INTEGER,
	DfpMbs INTEGER,
	PRIMARY KEY (DfpID)
);

CREATE TABLE DecisionIndicator (
	DinID CHAR(16) NOT NULL,
	DinIndicatorName TEXT,
	DinDescription TEXT,
	DinVarStep NUMERIC,
	DinBeanName CHAR(16),
	DinParameters TEXT,
	DinVarDirection CHAR(16),
	DinType CHAR(16),
	DinFirstDate TIMESTAMP,
	DinLastDate TIMESTAMP,
	DinPeriod INTEGER,
	DinCreID CHAR(16) NOT NULL,
	DinModID CHAR(16) NOT NULL,
	DinCrDt TIMESTAMP NOT NULL,
	DinUpd TIMESTAMP NOT NULL,
	DinMbm INTEGER,
	DinMbs INTEGER,
	PRIMARY KEY (DinID)
);

CREATE TABLE DecisionIndicatorOrder (
	DioID CHAR(16) NOT NULL,
	DioDinID CHAR(16),
	DioDfpID CHAR(16),
	DioOrder INTEGER,
	DioCreID CHAR(16) NOT NULL,
	DioModID CHAR(16) NOT NULL,
	DioCrDt TIMESTAMP NOT NULL,
	DioUpd TIMESTAMP NOT NULL,
	DioMbm INTEGER,
	DioMbs INTEGER,
	PRIMARY KEY (DioID)
);

CREATE TABLE DecisionIndicatorValue (
	DivID CHAR(16) NOT NULL,
	DivDinID CHAR(16),
	DivActorID CHAR(16),
	DivOldValue NUMERIC,
	DivNewValue NUMERIC,
	DivGap NUMERIC,
	DivCreID CHAR(16) NOT NULL,
	DivModID CHAR(16) NOT NULL,
	DivCrDt TIMESTAMP NOT NULL,
	DivUpd TIMESTAMP NOT NULL,
	DivMbm INTEGER,
	DivMbs INTEGER,
	PRIMARY KEY (DivID)
);

CREATE TABLE HelpDoc (
	HelID CHAR(16) NOT NULL,
	HelTitle VARCHAR(300),
	HelCode VARCHAR(100),
	HelParent CHAR(16),
	HelCreID CHAR(16) NOT NULL,
	HelModID CHAR(16) NOT NULL,
	HelCrDt TIMESTAMP NOT NULL,
	HelUpd TIMESTAMP NOT NULL,
	HelMbm INTEGER,
	HelMbs INTEGER,
	PRIMARY KEY (HelID)
);

CREATE TABLE Paragraph (
	ParID CHAR(16) NOT NULL,
	ParTitle VARCHAR(300),
	ParCode VARCHAR(100),
	ParStyle CHAR(16),
	ParParent CHAR(16),
	ParAttID CHAR(16),
	ParAttFileName VARCHAR(255),
	ParBody TEXT,
	ParOrder INTEGER,
	ParCreID CHAR(16) NOT NULL,
	ParModID CHAR(16) NOT NULL,
	ParCrDt TIMESTAMP NOT NULL,
	ParUpd TIMESTAMP NOT NULL,
	ParMbm INTEGER,
	ParMbs INTEGER,
	PRIMARY KEY (ParID)
);

CREATE TABLE Cart (
	CrtID CHAR(16) NOT NULL,
	CrtSolID CHAR(16),
	CrtStatus CHAR(16),
	CrtActID CHAR(16),
	CrtSentDt TIMESTAMP,
	CrtAttID CHAR(16),
	CrtAttFileName VARCHAR(200),
	CrtCreID CHAR(16) NOT NULL,
	CrtModID CHAR(16) NOT NULL,
	CrtCrDt TIMESTAMP NOT NULL,
	CrtUpd TIMESTAMP NOT NULL,
	CrtMbm INTEGER,
	CrtMbs INTEGER,
	PRIMARY KEY (CrtID)
);

CREATE TABLE Comments (
	CmtID CHAR(16) NOT NULL,
	CmtTitle VARCHAR(200),
	CmtContent TEXT,
	CmtActID CHAR(16),
	CmtType CHAR(16),
	CmtFahID CHAR(16),
	CmtStatus CHAR(16),
	CmtLngID CHAR(16),
	CmtCreID CHAR(16) NOT NULL,
	CmtModID CHAR(16) NOT NULL,
	CmtCrDt TIMESTAMP NOT NULL,
	CmtUpd TIMESTAMP NOT NULL,
	CmtMbm INTEGER,
	CmtMbs INTEGER,
	PRIMARY KEY (CmtID)
);

CREATE TABLE FAQ (
	FaqID CHAR(16) NOT NULL,
	FaqLngID CHAR(16),
	FaqFahID CHAR(16),
	FaqQuestion TEXT,
	FaqResponse TEXT,
	FaqTitle VARCHAR(300),
	FaqCreID CHAR(16) NOT NULL,
	FaqModID CHAR(16) NOT NULL,
	FaqCrDt TIMESTAMP NOT NULL,
	FaqUpd TIMESTAMP NOT NULL,
	FaqMbm INTEGER,
	FaqMbs INTEGER,
	PRIMARY KEY (FaqID)
);

CREATE TABLE FAQHeader (
	FahID CHAR(16) NOT NULL,
	FahActID CHAR(16),
	FahCatID CHAR(16),
	FahCatLev1 CHAR(16),
	FahCatLev2 VARCHAR(250),
	FahCatLev3 VARCHAR(250),
	FahSource CHAR(16),
	FahStatus CHAR(16),
	FahOwnrActID CHAR(16),
	FahNbSent INTEGER,
	FahExpireDt TIMESTAMP,
	FahBeginDt TIMESTAMP,
	FahPrdID CHAR(16),
	FahIsUpFront INTEGER,
	FahTitle VARCHAR(300),
	FahNotes TEXT,
	FahAvgScore NUMERIC,
	FahNbScore INTEGER,
	FahStatusDt TIMESTAMP,
	FahVersion INTEGER,
	FahSameAsFah CHAR(16),
	FahFromFahID CHAR(16),
	FahOriginID VARCHAR(32),
	FahCategory VARCHAR(200),
	FahSubCategory VARCHAR(200),
	FahAudience VARCHAR(200),
	FahModifiedOn TIMESTAMP,
	FahIsRemoved INTEGER,
	FahCreID CHAR(16) NOT NULL,
	FahModID CHAR(16) NOT NULL,
	FahCrDt TIMESTAMP NOT NULL,
	FahUpd TIMESTAMP NOT NULL,
	FahMbm INTEGER,
	FahMbs INTEGER,
	PRIMARY KEY (FahID)
);

CREATE TABLE FAQHeaderTagCode (
	FhtID CHAR(16) NOT NULL,
	FhtFahID CHAR(16),
	FhtTagCode TEXT,
	FhtCreID CHAR(16) NOT NULL,
	FhtModID CHAR(16) NOT NULL,
	FhtCrDt TIMESTAMP NOT NULL,
	FhtUpd TIMESTAMP NOT NULL,
	FhtMbm INTEGER,
	FhtMbs INTEGER,
	PRIMARY KEY (FhtID)
);

CREATE TABLE FAQLink (
	FqlID CHAR(16) NOT NULL,
	FqlFahID1 CHAR(16),
	FqlFahID2 CHAR(16),
	FqlCmnTag INTEGER,
	FqlCreID CHAR(16) NOT NULL,
	FqlModID CHAR(16) NOT NULL,
	FqlCrDt TIMESTAMP NOT NULL,
	FqlUpd TIMESTAMP NOT NULL,
	FqlMbm INTEGER,
	FqlMbs INTEGER,
	PRIMARY KEY (FqlID)
);

CREATE TABLE Score (
	ScoID CHAR(16) NOT NULL,
	ScoFahID CHAR(16),
	ScoValue INTEGER,
	ScoActID CHAR(16),
	ScoCreID CHAR(16) NOT NULL,
	ScoModID CHAR(16) NOT NULL,
	ScoCrDt TIMESTAMP NOT NULL,
	ScoUpd TIMESTAMP NOT NULL,
	ScoMbm INTEGER,
	ScoMbs INTEGER,
	PRIMARY KEY (ScoID)
);

CREATE TABLE Tag (
	TagID CHAR(16) NOT NULL,
	TagCode VARCHAR(16),
	TagText VARCHAR(100),
	TagLngID CHAR(16),
	TagCreID CHAR(16) NOT NULL,
	TagModID CHAR(16) NOT NULL,
	TagCrDt TIMESTAMP NOT NULL,
	TagUpd TIMESTAMP NOT NULL,
	TagMbm INTEGER,
	TagMbs INTEGER,
	PRIMARY KEY (TagID)
);

CREATE TABLE CalcMethod (
	CmeID CHAR(16) NOT NULL,
	CmeCode VARCHAR(100),
	CmeProvider VARCHAR(100),
	CmeClassName VARCHAR(512),
	CmeCreID CHAR(16) NOT NULL,
	CmeModID CHAR(16) NOT NULL,
	CmeCrDt TIMESTAMP NOT NULL,
	CmeUpd TIMESTAMP NOT NULL,
	CmeMbm INTEGER,
	CmeMbs INTEGER,
	PRIMARY KEY (CmeID)
);

CREATE TABLE DynamicFilter (
	DfiID CHAR(16) NOT NULL,
	DfiCode VARCHAR(255),
	DfiClassName VARCHAR(255),
	DfiProvider VARCHAR(255),
	DfiCreID CHAR(16) NOT NULL,
	DfiModID CHAR(16) NOT NULL,
	DfiCrDt TIMESTAMP NOT NULL,
	DfiUpd TIMESTAMP NOT NULL,
	DfiMbm INTEGER,
	DfiMbs INTEGER,
	PRIMARY KEY (DfiID)
);

CREATE TABLE Snapshot (
	SnaID CHAR(16) NOT NULL,
	SnaName VARCHAR(250),
	SnaCmeID CHAR(16),
	SnaAxis1Code VARCHAR(255),
	SnaAxis2Code VARCHAR(255),
	SnaAxis3Code VARCHAR(255),
	SnaPrevRun TIMESTAMP,
	SnaLastRun TIMESTAMP,
	SnaFreq CHAR(16),
	SnaTzoID CHAR(16),
	SnaLngID CHAR(16),
	SnaShsID CHAR(16),
	SnaNotes TEXT,
	SnaCreID CHAR(16) NOT NULL,
	SnaModID CHAR(16) NOT NULL,
	SnaCrDt TIMESTAMP NOT NULL,
	SnaUpd TIMESTAMP NOT NULL,
	SnaMbm INTEGER,
	SnaMbs INTEGER,
	PRIMARY KEY (SnaID)
);

CREATE TABLE SnapshotDisplay (
	SdiID CHAR(16) NOT NULL,
	SdiSnaID CHAR(16),
	SdiSdtID CHAR(16),
	SdiDisplayAxe1 INTEGER,
	SdiDisplayAxe2 INTEGER,
	SdiDisplayAxe3 INTEGER,
	SdiDisplayAxe4 INTEGER,
	SdiGranularity1 CHAR(16),
	SdiGranularity2 CHAR(16),
	SdiGranularity3 CHAR(16),
	SdiGranularity4 CHAR(16),
	SdiFilter1Type CHAR(16),
	SdiFilter1Exclude INTEGER,
	SdiFilter2Type CHAR(16),
	SdiFilter2Exclude INTEGER,
	SdiFilter3Type CHAR(16),
	SdiFilter3Exclude INTEGER,
	SdiFilter4Type CHAR(16),
	SdiFilter4Exclude INTEGER,
	SdiName VARCHAR(100),
	SdiFilter1DfiID CHAR(16),
	SdiFilter2DfiID CHAR(16),
	SdiFilter3DfiID CHAR(16),
	SdiFilter4DfiID CHAR(16),
	SdiHasAxis1QView INTEGER,
	SdiHasAxis2QView INTEGER,
	SdiHasAxis3QView INTEGER,
	SdiHasAxis4QView INTEGER,
	SdiCode VARCHAR(16),
	SdiFmtKeepOneOutOf INTEGER,
	SdiFmtNbDecimal INTEGER,
	SdiFmtMergeTables INTEGER,
	SdiFmtPointLabels INTEGER,
	SdiFmtGreenHcoID CHAR(16),
	SdiFmtRedHcoID CHAR(16),
	SdiFmtGreenValue NUMERIC,
	SdiFmtRedValue NUMERIC,
	SdiCreID CHAR(16) NOT NULL,
	SdiModID CHAR(16) NOT NULL,
	SdiCrDt TIMESTAMP NOT NULL,
	SdiUpd TIMESTAMP NOT NULL,
	SdiMbm INTEGER,
	SdiMbs INTEGER,
	PRIMARY KEY (SdiID)
);

CREATE TABLE SnapshotPanel (
	SpaID CHAR(16) NOT NULL,
	SpaName VARCHAR(255),
	SpaRows INTEGER,
	SpaColumns INTEGER,
	SpaCreID CHAR(16) NOT NULL,
	SpaModID CHAR(16) NOT NULL,
	SpaCrDt TIMESTAMP NOT NULL,
	SpaUpd TIMESTAMP NOT NULL,
	SpaMbm INTEGER,
	SpaMbs INTEGER,
	PRIMARY KEY (SpaID)
);

CREATE TABLE StatRecords (
	SreID CHAR(16) NOT NULL,
	SreSnaID CHAR(16),
	SreValue NUMERIC,
	SreSnapshotTime TIMESTAMP,
	SreSnapshotWeek SMALLINT,
	SreIsCmeRow INTEGER,
	SreAxis1String VARCHAR(255),
	SreAxis1Integer INTEGER,
	SreAxis1Ref CHAR(16),
	SreAxis1Date TIMESTAMP,
	SreAxis1Week SMALLINT,
	SreAxis1Fob VARCHAR(16),
	SreAxis2String VARCHAR(255),
	SreAxis2Integer INTEGER,
	SreAxis2Ref CHAR(16),
	SreAxis2Date TIMESTAMP,
	SreAxis2Week SMALLINT,
	SreAxis2Fob VARCHAR(16),
	SreAxis3String VARCHAR(255),
	SreAxis3Integer INTEGER,
	SreAxis3Ref CHAR(16),
	SreAxis3Date TIMESTAMP,
	SreAxis3Week SMALLINT,
	SreAxis3Fob VARCHAR(16),
	SreSnapshotWYear SMALLINT,
	SreAxis1WYear SMALLINT,
	SreAxis2WYear SMALLINT,
	SreAxis3WYear SMALLINT,
	SreCreID CHAR(16) NOT NULL,
	SreModID CHAR(16) NOT NULL,
	SreCrDt TIMESTAMP NOT NULL,
	SreUpd TIMESTAMP NOT NULL,
	SreMbm INTEGER,
	SreMbs INTEGER,
	PRIMARY KEY (SreID)
);

CREATE TABLE Appetence (
	AptID CHAR(16) NOT NULL,
	AptPerID CHAR(16),
	AptSilID CHAR(16),
	AptQualification CHAR(16),
	AptScore INTEGER,
	AptQualUpd TIMESTAMP,
	AptAlertNb INTEGER,
	AptAlertUpd TIMESTAMP,
	AptReinitUpd TIMESTAMP,
	AptCreID CHAR(16) NOT NULL,
	AptModID CHAR(16) NOT NULL,
	AptCrDt TIMESTAMP NOT NULL,
	AptUpd TIMESTAMP NOT NULL,
	AptMbm INTEGER,
	AptMbs INTEGER,
	PRIMARY KEY (AptID)
);

CREATE TABLE Axis (
	AxeID CHAR(16) NOT NULL,
	AxeCode VARCHAR(100),
	AxeName VARCHAR(250),
	AxeDescription TEXT,
	AxeLastCalculation TIMESTAMP,
	AxeFldID CHAR(16),
	AxeCreID CHAR(16) NOT NULL,
	AxeModID CHAR(16) NOT NULL,
	AxeCrDt TIMESTAMP NOT NULL,
	AxeUpd TIMESTAMP NOT NULL,
	AxeMbm INTEGER,
	AxeMbs INTEGER,
	PRIMARY KEY (AxeID)
);

CREATE TABLE Campaign (
	CpgID CHAR(16) NOT NULL,
	CpgCode VARCHAR(20),
	CpgTitle VARCHAR(100),
	CpgEventEnt INTEGER,
	CpgEventPer INTEGER,
	CpgDateBeg TIMESTAMP,
	CpgDateEnd TIMESTAMP,
	CpgEnd INTEGER,
	CpgAim TEXT,
	CpgTarget TEXT,
	CpgMeans TEXT,
	CpgROIEst INTEGER,
	CpgIndicEst1 NUMERIC,
	CpgIndicReal1 NUMERIC,
	CpgIndicEst2 NUMERIC,
	CpgIndicReal2 NUMERIC,
	CpgIndicEst4 NUMERIC,
	CpgIndicReal4 NUMERIC,
	CpgIndicEst5 NUMERIC,
	CpgIndicReal5 NUMERIC,
	CpgIndicEst3 NUMERIC,
	CpgIndicReal3 NUMERIC,
	CpgLevel CHAR(16),
	CpgIndicLabel1 VARCHAR(100),
	CpgIndicLabel2 VARCHAR(100),
	CpgIndicLabel3 VARCHAR(100),
	CpgIndicLabel4 VARCHAR(100),
	CpgIndicLabel5 VARCHAR(100),
	CpgIndicUnit1 CHAR(16),
	CpgIndicUnit2 CHAR(16),
	CpgIndicUnit3 CHAR(16),
	CpgIndicUnit4 CHAR(16),
	CpgIndicUnit5 CHAR(16),
	CpgEnt CHAR(16),
	CpgDept CHAR(16),
	CpgTargetNo INTEGER,
	CpgUnitNo INTEGER,
	CpgCost NUMERIC,
	CpgYear CHAR(16),
	CpgCreID CHAR(16) NOT NULL,
	CpgModID CHAR(16) NOT NULL,
	CpgCrDt TIMESTAMP NOT NULL,
	CpgUpd TIMESTAMP NOT NULL,
	CpgMbm INTEGER,
	CpgMbs INTEGER,
	PRIMARY KEY (CpgID)
);

CREATE TABLE Categorization (
	CtnID CHAR(16) NOT NULL,
	CtnNumUnits INTEGER,
	CtnCampID CHAR(16),
	CtnStageID CHAR(16),
	CtnFactLn CHAR(16),
	CtnNotes TEXT,
	CtnCreID CHAR(16) NOT NULL,
	CtnModID CHAR(16) NOT NULL,
	CtnCrDt TIMESTAMP NOT NULL,
	CtnUpd TIMESTAMP NOT NULL,
	CtnMbm INTEGER,
	CtnMbs INTEGER,
	PRIMARY KEY (CtnID)
);

CREATE TABLE Competitor (
	CptID CHAR(16) NOT NULL,
	CptName VARCHAR(30),
	CptWeb VARCHAR(100),
	CptIplID CHAR(16),
	CptStckExc VARCHAR(10),
	CptCreID CHAR(16) NOT NULL,
	CptModID CHAR(16) NOT NULL,
	CptCrDt TIMESTAMP NOT NULL,
	CptUpd TIMESTAMP NOT NULL,
	CptMbm INTEGER,
	CptMbs INTEGER,
	PRIMARY KEY (CptID)
);

CREATE TABLE Contribution (
	CtbID CHAR(16) NOT NULL,
	CtbCampID CHAR(16),
	CtbDeptID CHAR(16),
	CtbNumUnits NUMERIC,
	CtbType INTEGER,
	CtbNotes TEXT,
	CtbCreID CHAR(16) NOT NULL,
	CtbModID CHAR(16) NOT NULL,
	CtbCrDt TIMESTAMP NOT NULL,
	CtbUpd TIMESTAMP NOT NULL,
	CtbMbm INTEGER,
	CtbMbs INTEGER,
	PRIMARY KEY (CtbID)
);

CREATE TABLE Criteria (
	CriID CHAR(16) NOT NULL,
	CriName VARCHAR(100),
	CriFobID CHAR(16),
	CriFldID CHAR(16),
	CriOpe CHAR(16),
	CriAnd INTEGER,
	CriNot INTEGER,
	CriParentID CHAR(16),
	CriCreID CHAR(16) NOT NULL,
	CriModID CHAR(16) NOT NULL,
	CriCrDt TIMESTAMP NOT NULL,
	CriUpd TIMESTAMP NOT NULL,
	CriMbm INTEGER,
	CriMbs INTEGER,
	PRIMARY KEY (CriID)
);

CREATE TABLE Criteria2 (
	Cr2ID CHAR(16) NOT NULL,
	Cr2Se2ID CHAR(16),
	Cr2ParentID CHAR(16),
	Cr2FobID CHAR(16),
	Cr2Alias VARCHAR(10),
	Cr2FldID CHAR(16),
	Cr2Ope CHAR(16),
	Cr2And INTEGER,
	Cr2Not INTEGER,
	Cr2Condition CHAR(16),
	Cr2CardOpe CHAR(16),
	Cr2Card INTEGER,
	Cr2IsTemplate INTEGER,
	Cr2TempName VARCHAR(255),
	Cr2TempNameLabel VARCHAR(5),
	Cr2SubGroup VARCHAR(10),
	Cr2CardLabel VARCHAR(5),
	Cr2Se2IDold VARCHAR(16),
	Cr2CreID CHAR(16) NOT NULL,
	Cr2ModID CHAR(16) NOT NULL,
	Cr2CrDt TIMESTAMP NOT NULL,
	Cr2Upd TIMESTAMP NOT NULL,
	Cr2Mbm INTEGER,
	Cr2Mbs INTEGER,
	PRIMARY KEY (Cr2ID)
);

CREATE TABLE Document (
	DocID CHAR(16) NOT NULL,
	DocObjID CHAR(16),
	DocAttID CHAR(16),
	DocAttFileName TEXT,
	DocType CHAR(16),
	DocIsWord INTEGER,
	DocActID CHAR(16),
	DocDate TIMESTAMP,
	DocNotes TEXT,
	DocTitle VARCHAR(255),
	DocCode VARCHAR(16),
	DocIsArchive INTEGER,
	DocCatID CHAR(16),
	DocVersion VARCHAR(20),
	DocLngID CHAR(16),
	DocCreID CHAR(16) NOT NULL,
	DocModID CHAR(16) NOT NULL,
	DocCrDt TIMESTAMP NOT NULL,
	DocUpd TIMESTAMP NOT NULL,
	DocMbm INTEGER,
	DocMbs INTEGER,
	PRIMARY KEY (DocID)
);

CREATE TABLE Editor (
	EdiID CHAR(16) NOT NULL,
	EdiCorpName VARCHAR(100),
	EdiAd1 VARCHAR(100),
	EdiAd2 VARCHAR(100),
	EdiAd3 VARCHAR(100),
	EdiZip VARCHAR(10),
	EdiCity VARCHAR(32),
	EdiCtrID CHAR(16),
	EdiPhone VARCHAR(20),
	EdiFax VARCHAR(20),
	EdiWeb VARCHAR(100),
	EdiCreID CHAR(16) NOT NULL,
	EdiModID CHAR(16) NOT NULL,
	EdiCrDt TIMESTAMP NOT NULL,
	EdiUpd TIMESTAMP NOT NULL,
	EdiMbm INTEGER,
	EdiMbs INTEGER,
	PRIMARY KEY (EdiID)
);

CREATE TABLE EditorialPlanning (
	EdpID CHAR(16) NOT NULL,
	EdpJou CHAR(16),
	EdpSupID CHAR(16),
	EdpDate TIMESTAMP,
	EdpLabel VARCHAR(255),
	EdpCreID CHAR(16) NOT NULL,
	EdpModID CHAR(16) NOT NULL,
	EdpCrDt TIMESTAMP NOT NULL,
	EdpUpd TIMESTAMP NOT NULL,
	EdpMbm INTEGER,
	EdpMbs INTEGER,
	PRIMARY KEY (EdpID)
);

CREATE TABLE Event (
	EvtID CHAR(16) NOT NULL,
	EvtCode VARCHAR(10),
	EvtCategory CHAR(16),
	EvtLabel VARCHAR(250),
	EvtStatus0 VARCHAR(250),
	EvtStatus1 VARCHAR(250),
	EvtStatus2 VARCHAR(250),
	EvtStatus3 VARCHAR(250),
	EvtStatus4 VARCHAR(250),
	EvtStatus5 VARCHAR(250),
	EvtStatus6 VARCHAR(250),
	EvtStatus7 VARCHAR(250),
	EvtStatus8 VARCHAR(250),
	EvtStatus9 VARCHAR(250),
	EvtDate TIMESTAMP,
	EvtEndDate TIMESTAMP,
	EvtIsSalesInvest INTEGER,
	EvtAmountInvest1 NUMERIC,
	EvtAmountInvest0 NUMERIC,
	EvtAmountInvest2 NUMERIC,
	EvtAmountInvest3 NUMERIC,
	EvtAmountInvest4 NUMERIC,
	EvtAmountInvest5 NUMERIC,
	EvtAmountInvest6 NUMERIC,
	EvtAmountInvest7 NUMERIC,
	EvtAmountInvest8 NUMERIC,
	EvtAmountInvest9 NUMERIC,
	EvtAvgAmountInvest NUMERIC,
	EvtWopID CHAR(16),
	EvtRemarks TEXT,
	EvtQuota INTEGER,
	EvtAd1 VARCHAR(50),
	EvtAd2 VARCHAR(50),
	EvtAd3 VARCHAR(50),
	EvtZip VARCHAR(10),
	EvtCity VARCHAR(32),
	EvtCtrID CHAR(16),
	EvtCreID CHAR(16) NOT NULL,
	EvtModID CHAR(16) NOT NULL,
	EvtCrDt TIMESTAMP NOT NULL,
	EvtUpd TIMESTAMP NOT NULL,
	EvtMbm INTEGER,
	EvtMbs INTEGER,
	PRIMARY KEY (EvtID)
);

CREATE TABLE ExpenseCategory (
	ExcID CHAR(16) NOT NULL,
	ExcCampID CHAR(16),
	ExcPosteID CHAR(16),
	ExcDesc VARCHAR(100),
	ExcQuant INTEGER,
	ExcUnitP NUMERIC,
	ExcNotes TEXT,
	ExcCreID CHAR(16) NOT NULL,
	ExcModID CHAR(16) NOT NULL,
	ExcCrDt TIMESTAMP NOT NULL,
	ExcUpd TIMESTAMP NOT NULL,
	ExcMbm INTEGER,
	ExcMbs INTEGER,
	PRIMARY KEY (ExcID)
);

CREATE TABLE Form (
	FrmID CHAR(16) NOT NULL,
	FrmSeqNum INTEGER,
	FrmLabel VARCHAR(250),
	FrmEventID CHAR(16),
	FrmResponderObj CHAR(16),
	FrmCategory CHAR(16),
	FrmDetails TEXT,
	FrmBasicQuestion0 VARCHAR(250),
	FrmBasicQuestion1 VARCHAR(250),
	FrmBasicQuestion2 VARCHAR(250),
	FrmEveStChMode CHAR(16),
	FrmEveAutoSt INTEGER,
	FrmChecksum VARCHAR(2),
	FrmTabMode INTEGER,
	FrmWebIntro TEXT,
	FrmWebHeader TEXT,
	FrmWebFooter TEXT,
	FrmWebConclusion TEXT,
	FrmWebTermsOfUse TEXT,
	FrmIsPublic INTEGER,
	FrmStatus CHAR(16),
	FrmAvailableFromDt TIMESTAMP,
	FrmAvailableToDt TIMESTAMP,
	FrmLngID CHAR(16),
	FrmParStatus CHAR(16),
	FrmParStatusRule CHAR(16),
	FrmPublicURL TEXT,
	FrmCreID CHAR(16) NOT NULL,
	FrmModID CHAR(16) NOT NULL,
	FrmCrDt TIMESTAMP NOT NULL,
	FrmUpd TIMESTAMP NOT NULL,
	FrmMbm INTEGER,
	FrmMbs INTEGER,
	PRIMARY KEY (FrmID)
);

CREATE TABLE FormQuestion (
	FqtID CHAR(16) NOT NULL,
	FqtSeqNum INTEGER,
	FqtCategory CHAR(16),
	FqtLabel VARCHAR(200),
	FqtType CHAR(16),
	FqtInputChk VARCHAR(50),
	FqtRefTable CHAR(16),
	FqtDispType CHAR(16),
	FqtAssociatedText INTEGER,
	FqtInputCheckAT VARCHAR(50),
	FqtColumnsNb INTEGER,
	FqtInputSize INTEGER,
	FqtHasOther INTEGER,
	FqtStoreInObjID CHAR(16),
	FqtStoreInFldID CHAR(16),
	FqtLstAnswer0 VARCHAR(200),
	FqtLstAnswer1 VARCHAR(200),
	FqtLstAnswer2 VARCHAR(200),
	FqtLstAnswer3 VARCHAR(200),
	FqtLstAnswer4 VARCHAR(200),
	FqtLstAnswer5 VARCHAR(200),
	FqtLstAnswer6 VARCHAR(200),
	FqtLstAnswer7 VARCHAR(200),
	FqtLstAnswer8 VARCHAR(200),
	FqtLstAnswer9 VARCHAR(200),
	FqtLstAnswer10 VARCHAR(200),
	FqtLstAnswer11 VARCHAR(200),
	FqtLstAnswer12 VARCHAR(200),
	FqtLstAnswer13 VARCHAR(200),
	FqtLstAnswer14 VARCHAR(200),
	FqtHelpText TEXT,
	FqtToBeValidated INTEGER,
	FqtRequired INTEGER,
	FqtMultivalued INTEGER,
	FqtPossibleValues TEXT,
	FqtIsIdentificationField INTEGER,
	FqtCreID CHAR(16) NOT NULL,
	FqtModID CHAR(16) NOT NULL,
	FqtCrDt TIMESTAMP NOT NULL,
	FqtUpd TIMESTAMP NOT NULL,
	FqtMbm INTEGER,
	FqtMbs INTEGER,
	PRIMARY KEY (FqtID)
);

CREATE TABLE FormResponse (
	FrpID CHAR(16) NOT NULL,
	FrpDate TIMESTAMP,
	FrpFormID CHAR(16),
	FrpPersonID CHAR(16),
	FrpBasicResponse0 INTEGER,
	FrpBasicResponse1 INTEGER,
	FrpStatus CHAR(16),
	FrpBasicResponse2 INTEGER,
	FrpLastQuestionID CHAR(16),
	FrpExpirationDate TIMESTAMP,
	FrpToken TEXT,
	FrpPerToken TEXT,
	FrpCreID CHAR(16) NOT NULL,
	FrpModID CHAR(16) NOT NULL,
	FrpCrDt TIMESTAMP NOT NULL,
	FrpUpd TIMESTAMP NOT NULL,
	FrpMbm INTEGER,
	FrpMbs INTEGER,
	PRIMARY KEY (FrpID)
);

CREATE TABLE FormReturn (
	FrnID CHAR(16) NOT NULL,
	FrnFormID CHAR(16),
	FrnDate TIMESTAMP,
	FrnNbReturn INTEGER,
	FrnCreID CHAR(16) NOT NULL,
	FrnModID CHAR(16) NOT NULL,
	FrnCrDt TIMESTAMP NOT NULL,
	FrnUpd TIMESTAMP NOT NULL,
	FrnMbm INTEGER,
	FrnMbs INTEGER,
	PRIMARY KEY (FrnID)
);

CREATE TABLE GuestList (
	GliID CHAR(16) NOT NULL,
	GliActID CHAR(16),
	GliSguID CHAR(16),
	GliEvtID CHAR(16),
	GliDate TIMESTAMP,
	GliCreID CHAR(16) NOT NULL,
	GliModID CHAR(16) NOT NULL,
	GliCrDt TIMESTAMP NOT NULL,
	GliUpd TIMESTAMP NOT NULL,
	GliMbm INTEGER,
	GliMbs INTEGER,
	PRIMARY KEY (GliID)
);

CREATE TABLE Invoice (
	InvID CHAR(16) NOT NULL,
	InvSupplID CHAR(16),
	InvNumInv VARCHAR(80),
	InvDateInv TIMESTAMP,
	InvPayClass CHAR(16),
	InvEntID CHAR(16),
	InvAmt NUMERIC,
	InvStatus CHAR(16),
	InvDueDate TIMESTAMP,
	InvNotes TEXT,
	InvCreID CHAR(16) NOT NULL,
	InvModID CHAR(16) NOT NULL,
	InvCrDt TIMESTAMP NOT NULL,
	InvUpd TIMESTAMP NOT NULL,
	InvMbm INTEGER,
	InvMbs INTEGER,
	PRIMARY KEY (InvID)
);

CREATE TABLE InvoiceEntry (
	IneID CHAR(16) NOT NULL,
	IneSupplId CHAR(16),
	IneInvId VARCHAR(16),
	IneExpId CHAR(16),
	IneDescr VARCHAR(250),
	IneUnitPrice NUMERIC,
	IneNumUnits INTEGER,
	IneNotes TEXT,
	IneCreID CHAR(16) NOT NULL,
	IneModID CHAR(16) NOT NULL,
	IneCrDt TIMESTAMP NOT NULL,
	IneUpd TIMESTAMP NOT NULL,
	IneMbm INTEGER,
	IneMbs INTEGER,
	PRIMARY KEY (IneID)
);

CREATE TABLE Journalist (
	JouID CHAR(16) NOT NULL,
	JouCivID CHAR(16),
	JouFstName VARCHAR(30),
	JouName VARCHAR(30),
	JouPerAd1 VARCHAR(100),
	JouPerAd2 VARCHAR(100),
	JouPerAd3 VARCHAR(100),
	JouPerZip VARCHAR(10),
	JouPerCity VARCHAR(32),
	JouPerCtrID CHAR(16),
	JouProAd1 VARCHAR(100),
	JouProAd2 VARCHAR(100),
	JouProAd3 VARCHAR(100),
	JouProZip VARCHAR(10),
	JouProCity VARCHAR(32),
	JouProCtrID CHAR(16),
	JouPerPhone VARCHAR(20),
	JouPerFax VARCHAR(20),
	JouPerMobile VARCHAR(20),
	JouPerMail VARCHAR(100),
	JouProPhone VARCHAR(20),
	JouProFax VARCHAR(20),
	JouProMobile VARCHAR(20),
	JouProMail VARCHAR(100),
	JouJfuID CHAR(16),
	JouRemarks TEXT,
	JouPerMailStatus INTEGER,
	JouProMailStatus INTEGER,
	JouPerFaxStatus INTEGER,
	JouProFaxStatus INTEGER,
	JouCreID CHAR(16) NOT NULL,
	JouModID CHAR(16) NOT NULL,
	JouCrDt TIMESTAMP NOT NULL,
	JouUpd TIMESTAMP NOT NULL,
	JouMbm INTEGER,
	JouMbs INTEGER,
	PRIMARY KEY (JouID)
);

CREATE TABLE LinkFormQuestion (
	LfqID CHAR(16) NOT NULL,
	LfqFormID CHAR(16),
	LfqFormQuestionID CHAR(16),
	LfqPosition INTEGER,
	LfqParagraph VARCHAR(250),
	LfqCreID CHAR(16) NOT NULL,
	LfqModID CHAR(16) NOT NULL,
	LfqCrDt TIMESTAMP NOT NULL,
	LfqUpd TIMESTAMP NOT NULL,
	LfqMbm INTEGER,
	LfqMbs INTEGER,
	PRIMARY KEY (LfqID)
);

CREATE TABLE LinkScriptElement (
	LseID CHAR(16) NOT NULL,
	LseScriptID CHAR(16),
	LseScriptElementID CHAR(16),
	LsePosition INTEGER,
	LsePageID CHAR(16),
	LseCreID CHAR(16) NOT NULL,
	LseModID CHAR(16) NOT NULL,
	LseCrDt TIMESTAMP NOT NULL,
	LseUpd TIMESTAMP NOT NULL,
	LseMbm INTEGER,
	LseMbs INTEGER,
	PRIMARY KEY (LseID)
);

CREATE TABLE LinkScriptElementObjection (
	LsoID CHAR(16) NOT NULL,
	LsoScriptElementID CHAR(16),
	LsoObjectionID CHAR(16),
	LsoPosition INTEGER,
	LsoCreID CHAR(16) NOT NULL,
	LsoModID CHAR(16) NOT NULL,
	LsoCrDt TIMESTAMP NOT NULL,
	LsoUpd TIMESTAMP NOT NULL,
	LsoMbm INTEGER,
	LsoMbs INTEGER,
	PRIMARY KEY (LsoID)
);

CREATE TABLE Market (
	MarID CHAR(16) NOT NULL,
	MarDetails TEXT,
	MarSubject VARCHAR(50),
	MarOrigin VARCHAR(50),
	MarMcaID CHAR(16),
	MarCreID CHAR(16) NOT NULL,
	MarModID CHAR(16) NOT NULL,
	MarCrDt TIMESTAMP NOT NULL,
	MarUpd TIMESTAMP NOT NULL,
	MarMbm INTEGER,
	MarMbs INTEGER,
	PRIMARY KEY (MarID)
);

CREATE TABLE Materiel (
	MatID CHAR(16) NOT NULL,
	MatTitle VARCHAR(30),
	MatDate TIMESTAMP,
	MatDetail TEXT,
	MatCreID CHAR(16) NOT NULL,
	MatModID CHAR(16) NOT NULL,
	MatCrDt TIMESTAMP NOT NULL,
	MatUpd TIMESTAMP NOT NULL,
	MatMbm INTEGER,
	MatMbs INTEGER,
	PRIMARY KEY (MatID)
);

CREATE TABLE MeasuringMedia (
	MemID CHAR(16) NOT NULL,
	MemSupID CHAR(16),
	MemDate TIMESTAMP,
	MemNumber VARCHAR(10),
	MemATitle VARCHAR(100),
	MemCptID CHAR(16),
	MemPublicationType INTEGER,
	MemURL TEXT,
	MemPagID CHAR(16),
	MemCode TEXT,
	MemAtyID CHAR(16),
	MemExclusive INTEGER,
	MemCitation INTEGER,
	MemDetails TEXT,
	MemCreID CHAR(16) NOT NULL,
	MemModID CHAR(16) NOT NULL,
	MemCrDt TIMESTAMP NOT NULL,
	MemUpd TIMESTAMP NOT NULL,
	MemMbm INTEGER,
	MemMbs INTEGER,
	PRIMARY KEY (MemID)
);

CREATE TABLE NewsPress (
	NepID CHAR(16) NOT NULL,
	NepTitle VARCHAR(250),
	NepDate TIMESTAMP,
	NepPlace VARCHAR(250),
	NepDetail TEXT,
	NepCreID CHAR(16) NOT NULL,
	NepModID CHAR(16) NOT NULL,
	NepCrDt TIMESTAMP NOT NULL,
	NepUpd TIMESTAMP NOT NULL,
	NepMbm INTEGER,
	NepMbs INTEGER,
	PRIMARY KEY (NepID)
);

CREATE TABLE Note (
	NotID CHAR(16) NOT NULL,
	NotParentID VARCHAR(16),
	NotDate TIMESTAMP,
	NotActID CHAR(16),
	NotCfiID CHAR(16),
	NotContents TEXT,
	NotOrigin VARCHAR(50),
	NotSubject VARCHAR(250),
	NotObjID CHAR(16),
	NotCreID CHAR(16) NOT NULL,
	NotModID CHAR(16) NOT NULL,
	NotCrDt TIMESTAMP NOT NULL,
	NotUpd TIMESTAMP NOT NULL,
	NotMbm INTEGER,
	NotMbs INTEGER,
	PRIMARY KEY (NotID)
);

CREATE TABLE ObjectionArgument (
	ObaID CHAR(16) NOT NULL,
	ObaCode VARCHAR(20),
	ObaObjection VARCHAR(250),
	ObaArgument TEXT,
	ObaLanguage CHAR(16),
	ObaMoreText0 VARCHAR(250),
	ObaMoreText1 VARCHAR(250),
	ObaMoreText2 VARCHAR(250),
	ObaMoreLink0 TEXT,
	ObaMoreLink1 TEXT,
	ObaMoreLink2 TEXT,
	ObaMoreRefDoc0 CHAR(16),
	ObaMoreRefDoc1 CHAR(16),
	ObaMoreRefDoc2 CHAR(16),
	ObaCreID CHAR(16) NOT NULL,
	ObaModID CHAR(16) NOT NULL,
	ObaCrDt TIMESTAMP NOT NULL,
	ObaUpd TIMESTAMP NOT NULL,
	ObaMbm INTEGER,
	ObaMbs INTEGER,
	PRIMARY KEY (ObaID)
);

CREATE TABLE PersonEvent (
	PvtID CHAR(16) NOT NULL,
	PvtPersonID CHAR(16),
	PvtEventID CHAR(16),
	PvtStatus INTEGER,
	PvtFrpID CHAR(16),
	PvtSrpID CHAR(16),
	PvtNote VARCHAR(250),
	PvtTMK CHAR(16),
	PvtActID CHAR(16),
	PvtInsStatus CHAR(16),
	PvtParStatus CHAR(16),
	PvtPerInsRep CHAR(16),
	PvtPerParRep CHAR(16),
	PvtPerParAcc CHAR(16),
	PvtCreID CHAR(16) NOT NULL,
	PvtModID CHAR(16) NOT NULL,
	PvtCrDt TIMESTAMP NOT NULL,
	PvtUpd TIMESTAMP NOT NULL,
	PvtMbm INTEGER,
	PvtMbs INTEGER,
	PRIMARY KEY (PvtID)
);

CREATE TABLE Population (
	PopID CHAR(16) NOT NULL,
	PopSelID CHAR(16),
	PopEntNbr INTEGER,
	PopPerNbr INTEGER,
	PopAddNbr INTEGER,
	PopRmvNbr INTEGER,
	PopName VARCHAR(100),
	PopNonNbr INTEGER,
	PopSilNbr INTEGER,
	PopTotNbr INTEGER,
	PopSjoID CHAR(16),
	PopSupNbr INTEGER,
	PopJouNbr INTEGER,
	PopType INTEGER,
	PopDefault VARCHAR(255),
	PopInProgress INTEGER,
	PopReqID CHAR(16),
	PopParentPopID CHAR(16),
	PopSplitFieldID CHAR(16),
	PopStatus CHAR(16),
	PopObj1 CHAR(16),
	PopObj2 CHAR(16),
	PopObj3 CHAR(16),
	PopObj4 CHAR(16),
	PopAutoDel INTEGER,
	PopObj5 CHAR(16),
	PopDisplay VARCHAR(512),
	PopSe2ID CHAR(16),
	PopFob1Nbr INTEGER,
	PopFob2Nbr INTEGER,
	PopFob3Nbr INTEGER,
	PopFob4Nbr INTEGER,
	PopFob5Nbr INTEGER,
	PopIsPer INTEGER,
	PopIsEnt INTEGER,
	PopIsSil INTEGER,
	PopIsJou INTEGER,
	PopIsSup INTEGER,
	PopEvtID CHAR(16),
	PopGenType CHAR(16),
	PopEmlID CHAR(16),
	PopIsTemp INTEGER,
	PopLstID CHAR(16),
	PopMassEmailingID CHAR(16),
	PopBuildDate TIMESTAMP,
	PopCreID CHAR(16) NOT NULL,
	PopModID CHAR(16) NOT NULL,
	PopCrDt TIMESTAMP NOT NULL,
	PopUpd TIMESTAMP NOT NULL,
	PopMbm INTEGER,
	PopMbs INTEGER,
	PRIMARY KEY (PopID)
);

CREATE TABLE PopulationEntry (
	PpeID CHAR(16) NOT NULL,
	PpePopID CHAR(16),
	PpePerID CHAR(16),
	PpeAdded INTEGER,
	PpeRemoved INTEGER,
	PpeEntID CHAR(16),
	PpeSilID CHAR(16),
	PpeSupID CHAR(16),
	PpeJouID CHAR(16),
	PpeFob1 VARCHAR(16),
	PpeFob2 VARCHAR(16),
	PpeFob3 VARCHAR(16),
	PpeFob4 VARCHAR(16),
	PpeFob5 VARCHAR(16),
	PpeCreID CHAR(16) NOT NULL,
	PpeModID CHAR(16) NOT NULL,
	PpeCrDt TIMESTAMP NOT NULL,
	PpeUpd TIMESTAMP NOT NULL,
	PpeMbm INTEGER,
	PpeMbs INTEGER,
	PRIMARY KEY (PpeID)
);

CREATE TABLE Pricing (
	PrcID CHAR(16) NOT NULL,
	PrcName VARCHAR(250),
	PrcParent CHAR(16),
	PrcNote TEXT,
	PrcCreID CHAR(16) NOT NULL,
	PrcModID CHAR(16) NOT NULL,
	PrcCrDt TIMESTAMP NOT NULL,
	PrcUpd TIMESTAMP NOT NULL,
	PrcMbm INTEGER,
	PrcMbs INTEGER,
	PRIMARY KEY (PrcID)
);

CREATE TABLE PricingLine (
	PrlID CHAR(16) NOT NULL,
	PrlPricing CHAR(16),
	PrlPrdID CHAR(16),
	PrlRopID CHAR(16),
	PrlVariationAbs NUMERIC,
	PrlVariationRel NUMERIC,
	PrlStartDate TIMESTAMP,
	PrlEndDate TIMESTAMP,
	PrlNote TEXT,
	PrlFamilyID CHAR(16),
	PrlCreID CHAR(16) NOT NULL,
	PrlModID CHAR(16) NOT NULL,
	PrlCrDt TIMESTAMP NOT NULL,
	PrlUpd TIMESTAMP NOT NULL,
	PrlMbm INTEGER,
	PrlMbs INTEGER,
	PRIMARY KEY (PrlID)
);

CREATE TABLE Product (
	PrdID CHAR(16) NOT NULL,
	PrdName VARCHAR(250),
	PrdActID CHAR(16),
	PrdRopID CHAR(16),
	PrdCode VARCHAR(10),
	PrdStrength TEXT,
	PrdWeakness TEXT,
	PrdPrice NUMERIC,
	PrdProdCard TEXT,
	PrdStock INTEGER,
	PrdPkgID CHAR(16),
	PrdTvaID CHAR(16),
	PrdFamilyID CHAR(16),
	PrdPicID CHAR(16),
	PrdPicFileName VARCHAR(250),
	PrdPdfID CHAR(16),
	PrdPdfFileName VARCHAR(250),
	PrdPubSince TIMESTAMP,
	PrdPubTo TIMESTAMP,
	PrdTypID CHAR(16),
	PrdTprID CHAR(16),
	PrdCreID CHAR(16) NOT NULL,
	PrdModID CHAR(16) NOT NULL,
	PrdCrDt TIMESTAMP NOT NULL,
	PrdUpd TIMESTAMP NOT NULL,
	PrdMbm INTEGER,
	PrdMbs INTEGER,
	PRIMARY KEY (PrdID)
);

CREATE TABLE ProductFamily (
	PrfID CHAR(16) NOT NULL,
	PrfTitle VARCHAR(250),
	PrfDesc TEXT,
	PrfActID CHAR(16),
	PrfColor CHAR(16),
	PrfCode VARCHAR(30),
	PrfLngID CHAR(16),
	PrfCreID CHAR(16) NOT NULL,
	PrfModID CHAR(16) NOT NULL,
	PrfCrDt TIMESTAMP NOT NULL,
	PrfUpd TIMESTAMP NOT NULL,
	PrfMbm INTEGER,
	PrfMbs INTEGER,
	PRIMARY KEY (PrfID)
);

CREATE TABLE ProductGroupEntry (
	PgeID CHAR(16) NOT NULL,
	PgePrdID CHAR(16),
	PgeGrpPrdID CHAR(16),
	PgeNombre INTEGER,
	PgeCreID CHAR(16) NOT NULL,
	PgeModID CHAR(16) NOT NULL,
	PgeCrDt TIMESTAMP NOT NULL,
	PgeUpd TIMESTAMP NOT NULL,
	PgeMbm INTEGER,
	PgeMbs INTEGER,
	PRIMARY KEY (PgeID)
);

CREATE TABLE QuestionResponse (
	QrsID CHAR(16) NOT NULL,
	QrsLfqID CHAR(16),
	QrsFrpID CHAR(16),
	QrsInstance INTEGER,
	QrsText TEXT,
	QrsPosition INTEGER,
	QrsRefValID CHAR(16),
	QrsMoreText TEXT,
	QrsCreID CHAR(16) NOT NULL,
	QrsModID CHAR(16) NOT NULL,
	QrsCrDt TIMESTAMP NOT NULL,
	QrsUpd TIMESTAMP NOT NULL,
	QrsMbm INTEGER,
	QrsMbs INTEGER,
	PRIMARY KEY (QrsID)
);

CREATE TABLE Script (
	ScrID CHAR(16) NOT NULL,
	ScrSeqNum INTEGER,
	ScrLabel VARCHAR(250),
	ScrEventID CHAR(16),
	ScrResponderObj CHAR(16),
	ScrCategory CHAR(16),
	ScrDetails TEXT,
	ScrEveStChMode CHAR(16),
	ScrEveAutoSt INTEGER,
	ScrChecksum VARCHAR(2),
	ScrJSPPage CHAR(16),
	ScrAverageDuration INTEGER,
	ScrHasNotes INTEGER,
	ScrLanguage CHAR(16),
	ScrParStatus CHAR(16),
	ScrParStatusRule CHAR(16),
	ScrCreID CHAR(16) NOT NULL,
	ScrModID CHAR(16) NOT NULL,
	ScrCrDt TIMESTAMP NOT NULL,
	ScrUpd TIMESTAMP NOT NULL,
	ScrMbm INTEGER,
	ScrMbs INTEGER,
	PRIMARY KEY (ScrID)
);

CREATE TABLE ScriptElement (
	SceID CHAR(16) NOT NULL,
	SceSeqNum INTEGER,
	SceCategory CHAR(16),
	SceLabel VARCHAR(200),
	SceDescription TEXT,
	SceType CHAR(16),
	SceInputChk TEXT,
	SceInputCheckAT TEXT,
	SceRefTable CHAR(16),
	SceDispType CHAR(16),
	SceAssociatedText INTEGER,
	SceColumnsNb INTEGER,
	SceInputSize INTEGER,
	SceHasOther INTEGER,
	SceStoreInObjID CHAR(16),
	SceStoreInFldID CHAR(16),
	SceLstAnswer0 VARCHAR(200),
	SceLstAnswer1 VARCHAR(200),
	SceLstAnswer2 VARCHAR(200),
	SceLstAnswer3 VARCHAR(200),
	SceLstAnswer4 VARCHAR(200),
	SceLstAnswer5 VARCHAR(200),
	SceLstAnswer6 VARCHAR(200),
	SceLstAnswer7 VARCHAR(200),
	SceLstAnswer8 VARCHAR(200),
	SceLstAnswer9 VARCHAR(200),
	SceLstAnswer10 VARCHAR(200),
	SceLstAnswer11 VARCHAR(200),
	SceLstAnswer12 VARCHAR(200),
	SceLstAnswer13 VARCHAR(200),
	SceLstAnswer14 VARCHAR(200),
	SceLanguage CHAR(16),
	SceImage CHAR(16),
	SceHasAnswers INTEGER,
	SceJSPPage CHAR(16),
	SceImageName VARCHAR(200),
	SceCreID CHAR(16) NOT NULL,
	SceModID CHAR(16) NOT NULL,
	SceCrDt TIMESTAMP NOT NULL,
	SceUpd TIMESTAMP NOT NULL,
	SceMbm INTEGER,
	SceMbs INTEGER,
	PRIMARY KEY (SceID)
);

CREATE TABLE ScriptElementResponse (
	SerID CHAR(16) NOT NULL,
	SerLseID CHAR(16),
	SerSrpID CHAR(16),
	SerInstance INTEGER,
	SerText TEXT,
	SerPosition INTEGER,
	SerRefValID CHAR(16),
	SerMoreText TEXT,
	SerCreID CHAR(16) NOT NULL,
	SerModID CHAR(16) NOT NULL,
	SerCrDt TIMESTAMP NOT NULL,
	SerUpd TIMESTAMP NOT NULL,
	SerMbm INTEGER,
	SerMbs INTEGER,
	PRIMARY KEY (SerID)
);

CREATE TABLE ScriptElementTransition (
	SetID CHAR(16) NOT NULL,
	SetLse1ID CHAR(16),
	SetLse2ID CHAR(16),
	SetCriSerID CHAR(16),
	SetCriPerID CHAR(16),
	SetPosition INTEGER,
	SetCreID CHAR(16) NOT NULL,
	SetModID CHAR(16) NOT NULL,
	SetCrDt TIMESTAMP NOT NULL,
	SetUpd TIMESTAMP NOT NULL,
	SetMbm INTEGER,
	SetMbs INTEGER,
	PRIMARY KEY (SetID)
);

CREATE TABLE ScriptPage (
	ScpID CHAR(16) NOT NULL,
	ScpScriptID CHAR(16),
	ScpCode VARCHAR(20),
	ScpTitre VARCHAR(250),
	ScpPosition INTEGER,
	ScpCreID CHAR(16) NOT NULL,
	ScpModID CHAR(16) NOT NULL,
	ScpCrDt TIMESTAMP NOT NULL,
	ScpUpd TIMESTAMP NOT NULL,
	ScpMbm INTEGER,
	ScpMbs INTEGER,
	PRIMARY KEY (ScpID)
);

CREATE TABLE ScriptResponse (
	SrpID CHAR(16) NOT NULL,
	SrpDate TIMESTAMP,
	SrpScriptID CHAR(16),
	SrpPersonID CHAR(16),
	SrpNotes TEXT,
	SrpCreID CHAR(16) NOT NULL,
	SrpModID CHAR(16) NOT NULL,
	SrpCrDt TIMESTAMP NOT NULL,
	SrpUpd TIMESTAMP NOT NULL,
	SrpMbm INTEGER,
	SrpMbs INTEGER,
	PRIMARY KEY (SrpID)
);

CREATE TABLE Segment (
	SegID CHAR(16) NOT NULL,
	SegCode VARCHAR(100),
	SegColor CHAR(16),
	SegAttID VARCHAR(16),
	SegAttFileName VARCHAR(200),
	SegCount INTEGER,
	SegPRP NUMERIC,
	SegRefValue CHAR(16),
	SegAxeID CHAR(16),
	SegCreID CHAR(16) NOT NULL,
	SegModID CHAR(16) NOT NULL,
	SegCrDt TIMESTAMP NOT NULL,
	SegUpd TIMESTAMP NOT NULL,
	SegMbm INTEGER,
	SegMbs INTEGER,
	PRIMARY KEY (SegID)
);

CREATE TABLE Selection (
	SelID CHAR(16) NOT NULL,
	SelName VARCHAR(100),
	SelDefault VARCHAR(255),
	SelPopID CHAR(16),
	SelCriEntID CHAR(16),
	SelCriPerID CHAR(16),
	SelMaxTyp CHAR(16),
	SelMax INTEGER,
	SelCriEvtID CHAR(16),
	SelCode VARCHAR(20),
	SelDescription TEXT,
	SelAxis INTEGER,
	SelAttID CHAR(16),
	SelAttFileName VARCHAR(200),
	SelColor CHAR(16),
	SelVolume INTEGER,
	SelPRP NUMERIC,
	SelLastCalculation TIMESTAMP,
	SelTarget CHAR(16),
	SelCreID CHAR(16) NOT NULL,
	SelModID CHAR(16) NOT NULL,
	SelCrDt TIMESTAMP NOT NULL,
	SelUpd TIMESTAMP NOT NULL,
	SelMbm INTEGER,
	SelMbs INTEGER,
	PRIMARY KEY (SelID)
);

CREATE TABLE Selection2 (
	Se2ID CHAR(16) NOT NULL,
	Se2Code VARCHAR(100),
	Se2Name VARCHAR(250),
	Se2Description TEXT,
	Se2Model CHAR(16),
	Se2Condition INTEGER,
	Se2Cr2ID CHAR(16),
	Se2FctUnique INTEGER,
	Se2Event CHAR(16),
	Se2CreID CHAR(16) NOT NULL,
	Se2ModID CHAR(16) NOT NULL,
	Se2CrDt TIMESTAMP NOT NULL,
	Se2Upd TIMESTAMP NOT NULL,
	Se2Mbm INTEGER,
	Se2Mbs INTEGER,
	PRIMARY KEY (Se2ID)
);

CREATE TABLE SelectionJournalist (
	SjoID CHAR(16) NOT NULL,
	SjoName VARCHAR(100),
	SjoCriSupID CHAR(16),
	SjoCriJouID CHAR(16),
	SjoType CHAR(16),
	SjoCreID CHAR(16) NOT NULL,
	SjoModID CHAR(16) NOT NULL,
	SjoCrDt TIMESTAMP NOT NULL,
	SjoUpd TIMESTAMP NOT NULL,
	SjoMbm INTEGER,
	SjoMbs INTEGER,
	PRIMARY KEY (SjoID)
);

CREATE TABLE SelectionModel (
	SmdID CHAR(16) NOT NULL,
	SmdCode VARCHAR(100),
	SmdName VARCHAR(250),
	SmdNameLabel VARCHAR(5),
	SmdDescr TEXT,
	SmdDescrLabel VARCHAR(5),
	SmdXMLDef TEXT,
	SmdObjID CHAR(16),
	SmdObj1 CHAR(16),
	SmdObj2 CHAR(16),
	SmdObj3 CHAR(16),
	SmdObj4 CHAR(16),
	SmdObj5 CHAR(16),
	SmdDisplay VARCHAR(250),
	SmdXmlOK INTEGER,
	SmdLstID CHAR(16),
	SmdOrigin CHAR(16),
	SmdCreID CHAR(16) NOT NULL,
	SmdModID CHAR(16) NOT NULL,
	SmdCrDt TIMESTAMP NOT NULL,
	SmdUpd TIMESTAMP NOT NULL,
	SmdMbm INTEGER,
	SmdMbs INTEGER,
	PRIMARY KEY (SmdID)
);

CREATE TABLE Stage (
	StgID CHAR(16) NOT NULL,
	StgCpgID CHAR(16),
	StgCode VARCHAR(20),
	StgTitle VARCHAR(100),
	StgDateBeg TIMESTAMP,
	StgDateEnd TIMESTAMP,
	StgEnd INTEGER,
	StgPopID CHAR(16),
	StgContactEst INTEGER,
	StgTarget INTEGER,
	StgContactReal INTEGER,
	StgFixedCostEst NUMERIC,
	StgFixedCostReal NUMERIC,
	StgContactCostEst NUMERIC,
	StgContactCostReal NUMERIC,
	StgIndicEst1 NUMERIC,
	StgIndicReal1 NUMERIC,
	StgIndicEst2 NUMERIC,
	StgIndicReal2 NUMERIC,
	StgIndicEst3 NUMERIC,
	StgIndicReal3 NUMERIC,
	StgDescr TEXT,
	StgEvtID CHAR(16),
	StgIndicEst4 NUMERIC,
	StgIndicReal4 NUMERIC,
	StgIndicEst5 NUMERIC,
	StgIndicReal5 NUMERIC,
	StgIndicUnit1 CHAR(16),
	StgIndicUnit2 CHAR(16),
	StgIndicUnit3 CHAR(16),
	StgIndicUnit4 CHAR(16),
	StgIndicUnit5 CHAR(16),
	StgIndicLabel1 VARCHAR(100),
	StgIndicLabel2 VARCHAR(100),
	StgIndicLabel3 VARCHAR(100),
	StgIndicLabel4 VARCHAR(100),
	StgIndicLabel5 VARCHAR(100),
	StgPos INTEGER,
	StgCreID CHAR(16) NOT NULL,
	StgModID CHAR(16) NOT NULL,
	StgCrDt TIMESTAMP NOT NULL,
	StgUpd TIMESTAMP NOT NULL,
	StgMbm INTEGER,
	StgMbs INTEGER,
	PRIMARY KEY (StgID)
);

CREATE TABLE Support (
	SupID CHAR(16) NOT NULL,
	SupTitle VARCHAR(100),
	SupEdiID CHAR(16),
	SupAd1 VARCHAR(100),
	SupAd2 VARCHAR(100),
	SupAd3 VARCHAR(100),
	SupZip VARCHAR(10),
	SupCity VARCHAR(32),
	SupCtrID CHAR(16),
	SupPhone VARCHAR(20),
	SupFax VARCHAR(20),
	SupWeb VARCHAR(100),
	SupFrqID CHAR(16),
	SupTarID CHAR(16),
	SupSutID CHAR(16),
	SupPageNb INTEGER,
	SupOJD INTEGER,
	SupPrices TEXT,
	SupNegoPrices TEXT,
	SupSpecimenNb INTEGER,
	SupPlanID CHAR(16),
	SupPlanFileName VARCHAR(100),
	SupLogoID CHAR(16),
	SupLogoFileName VARCHAR(100),
	SupPublication VARCHAR(200),
	SupLocking INTEGER,
	SupPutting INTEGER,
	SupRotation INTEGER,
	SupCreID CHAR(16) NOT NULL,
	SupModID CHAR(16) NOT NULL,
	SupCrDt TIMESTAMP NOT NULL,
	SupUpd TIMESTAMP NOT NULL,
	SupMbm INTEGER,
	SupMbs INTEGER,
	PRIMARY KEY (SupID)
);

CREATE TABLE Alert (
	AlrID CHAR(16) NOT NULL,
	AlrActID CHAR(16),
	AlrSubID TEXT,
	AlrMsgID CHAR(16),
	AlrDate TIMESTAMP,
	AlrPriority INTEGER,
	AlrStlID CHAR(16),
	AlrStatusChange TIMESTAMP,
	AlrCreID CHAR(16) NOT NULL,
	AlrModID CHAR(16) NOT NULL,
	AlrCrDt TIMESTAMP NOT NULL,
	AlrUpd TIMESTAMP NOT NULL,
	AlrMbm INTEGER,
	AlrMbs INTEGER,
	PRIMARY KEY (AlrID)
);

CREATE TABLE EMailing (
	EmaID CHAR(16) NOT NULL,
	EmaName VARCHAR(100),
	EmaDate TIMESTAMP,
	EmaPopID CHAR(16),
	EmaHtmlMsgID CHAR(16),
	EmaSender VARCHAR(100),
	EmaStateID CHAR(16),
	EmaSenderID CHAR(16),
	EmaTextMsgID CHAR(16),
	EmaPopTypID CHAR(16),
	EmaTagName CHAR(16),
	EmaReplyTo VARCHAR(100),
	EmaReplyToID CHAR(16),
	EmaInmailServer VARCHAR(250),
	EmaInmailLogin VARCHAR(250),
	EmaInmailProtocol INTEGER,
	EmaInmailPassword VARCHAR(250),
	EmaNbToSend INTEGER,
	EmaSentDate TIMESTAMP,
	EmaNbStatus0 INTEGER,
	EmaNbStatus1 INTEGER,
	EmaNbStatus2 INTEGER,
	EmaNbStatus3 INTEGER,
	EmaNbStatus4 INTEGER,
	EmaNbStatus5 INTEGER,
	EmaCreID CHAR(16) NOT NULL,
	EmaModID CHAR(16) NOT NULL,
	EmaCrDt TIMESTAMP NOT NULL,
	EmaUpd TIMESTAMP NOT NULL,
	EmaMbm INTEGER,
	EmaMbs INTEGER,
	PRIMARY KEY (EmaID)
);

CREATE TABLE EmailingStats (
	EstID CHAR(16) NOT NULL,
	EstEmlDate TIMESTAMP,
	EstEmlStatus CHAR(16),
	EstToken VARCHAR(16),
	EstEmlID CHAR(16),
	EstNbOpened INTEGER,
	EstNbTempError INTEGER,
	EstNbFatalError INTEGER,
	EstNbSent INTEGER,
	EstElnID CHAR(16),
	EstLinkClick INTEGER,
	EstNbTotal INTEGER,
	EstNbSentError INTEGER,
	EstNbUnsubscribed INTEGER,
	EstNbSpam INTEGER,
	EstCreID CHAR(16) NOT NULL,
	EstModID CHAR(16) NOT NULL,
	EstCrDt TIMESTAMP NOT NULL,
	EstUpd TIMESTAMP NOT NULL,
	EstMbm INTEGER,
	EstMbs INTEGER,
	PRIMARY KEY (EstID)
);

CREATE TABLE EMailLink (
	ElnID CHAR(16) NOT NULL,
	ElnEmlID CHAR(16),
	ElnWopID CHAR(16),
	ElnEvtID CHAR(16),
	ElnEvtStatus INTEGER,
	ElnNbCLick INTEGER,
	ElnNbDistinctClick INTEGER,
	ElnPopID CHAR(16),
	ElnURL TEXT,
	ElnText TEXT,
	ElnInsStatus CHAR(16),
	ElnCreID CHAR(16) NOT NULL,
	ElnModID CHAR(16) NOT NULL,
	ElnCrDt TIMESTAMP NOT NULL,
	ElnUpd TIMESTAMP NOT NULL,
	ElnMbm INTEGER,
	ElnMbs INTEGER,
	PRIMARY KEY (ElnID)
);

CREATE TABLE EMailMessage (
	EmmID CHAR(16) NOT NULL,
	EmmMsgID CHAR(16),
	EmmEmlID CHAR(16),
	EmmCreID CHAR(16) NOT NULL,
	EmmModID CHAR(16) NOT NULL,
	EmmCrDt TIMESTAMP NOT NULL,
	EmmUpd TIMESTAMP NOT NULL,
	EmmMbm INTEGER,
	EmmMbs INTEGER,
	PRIMARY KEY (EmmID)
);

CREATE TABLE EMailOutServer (
	EosID CHAR(16) NOT NULL,
	EosName VARCHAR(200),
	EosType CHAR(16),
	EosSmtpAdress VARCHAR(200),
	EosLogin VARCHAR(50),
	EosPwd VARCHAR(50),
	EosSmtpProtocol CHAR(16),
	EosCreID CHAR(16) NOT NULL,
	EosModID CHAR(16) NOT NULL,
	EosCrDt TIMESTAMP NOT NULL,
	EosUpd TIMESTAMP NOT NULL,
	EosMbm INTEGER,
	EosMbs INTEGER,
	PRIMARY KEY (EosID)
);

CREATE TABLE EMailSender (
	EsnID CHAR(16) NOT NULL,
	EsnType CHAR(16),
	EsnStatus CHAR(16),
	EsnActorID CHAR(16),
	EsnName VARCHAR(200),
	EsnEmail VARCHAR(200),
	EsnBounceMailServer VARCHAR(200),
	EsnBounceUser VARCHAR(50),
	EsnBouncePwd VARCHAR(20),
	EsnBounceAccessType CHAR(16),
	EsnDefaultServer CHAR(16),
	EsnFax VARCHAR(20),
	EsnMobile VARCHAR(20),
	EsnCreID CHAR(16) NOT NULL,
	EsnModID CHAR(16) NOT NULL,
	EsnCrDt TIMESTAMP NOT NULL,
	EsnUpd TIMESTAMP NOT NULL,
	EsnMbm INTEGER,
	EsnMbs INTEGER,
	PRIMARY KEY (EsnID)
);

CREATE TABLE EMailSent (
	EmsID CHAR(16) NOT NULL,
	EmsEmaID CHAR(16),
	EmsTyvID VARCHAR(16),
	EmsVisitorID VARCHAR(16),
	EmsEmail VARCHAR(250),
	EmsStatus INTEGER,
	EmsPerID CHAR(16),
	EmsJouID CHAR(16),
	EmsSilID CHAR(16),
	EmsEmlID CHAR(16),
	EmsEmailField VARCHAR(20),
	EmsBounceAddInfo VARCHAR(255),
	EmsBounceReasons CHAR(16),
	EmsCreID CHAR(16) NOT NULL,
	EmsModID CHAR(16) NOT NULL,
	EmsCrDt TIMESTAMP NOT NULL,
	EmsUpd TIMESTAMP NOT NULL,
	EmsMbm INTEGER,
	EmsMbs INTEGER,
	PRIMARY KEY (EmsID)
);

CREATE TABLE EMailSnippet (
	EmtID CHAR(16) NOT NULL,
	EmtName VARCHAR(120),
	EmtLanguage CHAR(16),
	EmtContent TEXT,
	EmtCreID CHAR(16) NOT NULL,
	EmtModID CHAR(16) NOT NULL,
	EmtCrDt TIMESTAMP NOT NULL,
	EmtUpd TIMESTAMP NOT NULL,
	EmtMbm INTEGER,
	EmtMbs INTEGER,
	PRIMARY KEY (EmtID)
);

CREATE TABLE InBoundLog (
	IblID CHAR(16) NOT NULL,
	IblCookie VARCHAR(16),
	IblPageName VARCHAR(100),
	IblDate TIMESTAMP,
	IblRemoteIP VARCHAR(39),
	IblBrowser VARCHAR(250),
	IblDestination VARCHAR(400),
	IblOri VARCHAR(400),
	IblOriID CHAR(16),
	IblWopID CHAR(16),
	IblTyvID VARCHAR(16),
	IblVisitorID VARCHAR(16),
	IblHostName VARCHAR(255),
	IblTimeRange CHAR(16),
	IblCustom TEXT,
	IblPreviousLog CHAR(16),
	IblElnID CHAR(16),
	IblStatus INTEGER,
	IblUtk VARCHAR(8),
	IblMail VARCHAR(50),
	IblName VARCHAR(50),
	IblFstName VARCHAR(50),
	IblEnterprise VARCHAR(50),
	IblNslCode VARCHAR(20),
	IblCivID CHAR(16),
	IblPerID CHAR(16),
	IblSilID CHAR(16),
	IblEmlID CHAR(16),
	IblCreID CHAR(16) NOT NULL,
	IblModID CHAR(16) NOT NULL,
	IblCrDt TIMESTAMP NOT NULL,
	IblUpd TIMESTAMP NOT NULL,
	IblMbm INTEGER,
	IblMbs INTEGER,
	PRIMARY KEY (IblID)
);

CREATE TABLE MailCustomization (
	McsID CHAR(16) NOT NULL,
	McsSubTtle VARCHAR(100),
	McsSubHTML TEXT,
	McsSubConfHTML TEXT,
	McsSubConfMAIL TEXT,
	McsLogo VARCHAR(100),
	McsUnsubTtle VARCHAR(100),
	McsUnSubHTML TEXT,
	McsNoMailTtle TEXT,
	McsNoMailHTML TEXT,
	McsLng VARCHAR(16),
	McsGlblMsg TEXT,
	McsIPExclusion VARCHAR(150),
	McsCreID CHAR(16) NOT NULL,
	McsModID CHAR(16) NOT NULL,
	McsCrDt TIMESTAMP NOT NULL,
	McsUpd TIMESTAMP NOT NULL,
	McsMbm INTEGER,
	McsMbs INTEGER,
	PRIMARY KEY (McsID)
);

CREATE TABLE MassEmailing (
	EmlID CHAR(16) NOT NULL,
	EmlName VARCHAR(120),
	EmlCode VARCHAR(16),
	EmlOwner CHAR(16),
	EmlStatus CHAR(16),
	EmlType CHAR(16),
	EmlDstSelPer CHAR(16),
	EmlDstSelSil CHAR(16),
	EmlDstPopPer CHAR(16),
	EmlDstPopSil CHAR(16),
	EmlDstSubsPer CHAR(16),
	EmlDstSubsSil CHAR(16),
	EmlDstAllPer INTEGER,
	EmlDstAllSil INTEGER,
	EmlTypeDst CHAR(16),
	EmlFltPopPer CHAR(16),
	EmlFltPopSil CHAR(16),
	EmlFltPopOp CHAR(16),
	EmlFltReadEmlID CHAR(16),
	EmlFltReadMsgOp CHAR(16),
	EmlFltLinkEmlID CHAR(16),
	EmlFltLinkElnID CHAR(16),
	EmlFltLinkOp CHAR(16),
	EmlFltSubs CHAR(16),
	EmlFltSubsOp CHAR(16),
	EmlFltEvtID CHAR(16),
	EmlFltEvtStatus INTEGER,
	EmlFltEvtOp CHAR(16),
	EmlExcBlackList INTEGER,
	EmlExclWrongEmail INTEGER,
	EmlSndEnsID CHAR(16),
	EmlSndFldID CHAR(16),
	EmlSndTestGrp CHAR(16),
	EmlSndDate TIMESTAMP,
	EmlSndEosID CHAR(16),
	EmlFlwDoFollow INTEGER,
	EmlFlwEvtID CHAR(16),
	EmlFltEvtSent INTEGER,
	EmlFltEvtOpen INTEGER,
	EmlSttDate TIMESTAMP,
	EmlDstType INTEGER,
	EmlFltType TEXT,
	EmlSndType TEXT,
	EmlRegroupement VARCHAR(16),
	EmlDstPopTest CHAR(16),
	EmlFinalPerPopID CHAR(16),
	EmlFinalSilPopID CHAR(16),
	EmlResend INTEGER,
	EmlReSndDate TIMESTAMP,
	EmlCreID CHAR(16) NOT NULL,
	EmlModID CHAR(16) NOT NULL,
	EmlCrDt TIMESTAMP NOT NULL,
	EmlUpd TIMESTAMP NOT NULL,
	EmlMbm INTEGER,
	EmlMbs INTEGER,
	PRIMARY KEY (EmlID)
);

CREATE TABLE Origin (
	OriID CHAR(16) NOT NULL,
	OriName VARCHAR(30),
	OriUrl VARCHAR(100),
	OriCreID CHAR(16) NOT NULL,
	OriModID CHAR(16) NOT NULL,
	OriCrDt TIMESTAMP NOT NULL,
	OriUpd TIMESTAMP NOT NULL,
	OriMbm INTEGER,
	OriMbs INTEGER,
	PRIMARY KEY (OriID)
);

CREATE TABLE OutBoundLog (
	OblID CHAR(16) NOT NULL,
	OblCookie VARCHAR(8),
	OblOdrID CHAR(16),
	OblDate TIMESTAMP,
	OblOri VARCHAR(255),
	OblOriID CHAR(16),
	OblWopID CHAR(16),
	OblTyvID VARCHAR(16),
	OblVisitorID VARCHAR(16),
	OblRemoteIP VARCHAR(15),
	OblBrowser VARCHAR(100),
	OblHostName VARCHAR(255),
	OblTimeRange CHAR(16),
	OblCustom TEXT,
	OblCreID CHAR(16) NOT NULL,
	OblModID CHAR(16) NOT NULL,
	OblCrDt TIMESTAMP NOT NULL,
	OblUpd TIMESTAMP NOT NULL,
	OblMbm INTEGER,
	OblMbs INTEGER,
	PRIMARY KEY (OblID)
);

CREATE TABLE OutDoor (
	OdrID CHAR(16) NOT NULL,
	OdrCod VARCHAR(10),
	OdrNam VARCHAR(100),
	OdrUrl VARCHAR(255),
	OdrDsc TEXT,
	OdrCreID CHAR(16) NOT NULL,
	OdrModID CHAR(16) NOT NULL,
	OdrCrDt TIMESTAMP NOT NULL,
	OdrUpd TIMESTAMP NOT NULL,
	OdrMbm INTEGER,
	OdrMbs INTEGER,
	PRIMARY KEY (OdrID)
);

CREATE TABLE Publication (
	PubID CHAR(16) NOT NULL,
	PubCode VARCHAR(10),
	PubGroupCode VARCHAR(10),
	PubTitle VARCHAR(100),
	PubDescSmall VARCHAR(140),
	PubDescLarge VARCHAR(430),
	PubWebLink VARCHAR(150),
	PubPhotoID CHAR(16),
	PubFilmID CHAR(16),
	PubLastPublishDate TIMESTAMP,
	PubSendStatus CHAR(16),
	PubPhotoFileName VARCHAR(30),
	PubFilmFileName VARCHAR(30),
	PubPhotoUrl VARCHAR(120),
	PubFilmUrl VARCHAR(120),
	PubFilmToken VARCHAR(30),
	PubCreID CHAR(16) NOT NULL,
	PubModID CHAR(16) NOT NULL,
	PubCrDt TIMESTAMP NOT NULL,
	PubUpd TIMESTAMP NOT NULL,
	PubMbm INTEGER,
	PubMbs INTEGER,
	PRIMARY KEY (PubID)
);

CREATE TABLE PublicationOutlet (
	PboID CHAR(16) NOT NULL,
	PboTitle VARCHAR(50),
	PboOutletType CHAR(16),
	PboLogin VARCHAR(50),
	PboPassword VARCHAR(50),
	PboDescription VARCHAR(140),
	PboCode VARCHAR(10),
	PboToken VARCHAR(140),
	PboTokenSecret VARCHAR(140),
	PboAuthAllActors INTEGER,
	PboPublicUrl VARCHAR(120),
	PboPageID VARCHAR(32),
	PboPageAuthorized INTEGER,
	PboEnabled INTEGER,
	PboCreID CHAR(16) NOT NULL,
	PboModID CHAR(16) NOT NULL,
	PboCrDt TIMESTAMP NOT NULL,
	PboUpd TIMESTAMP NOT NULL,
	PboMbm INTEGER,
	PboMbs INTEGER,
	PRIMARY KEY (PboID)
);

CREATE TABLE PublicationStats (
	PbsID CHAR(16) NOT NULL,
	PbsPubID CHAR(16),
	PbsPboID CHAR(16),
	PbsLastPublishingDate TIMESTAMP,
	PbsNbClick INTEGER,
	PbsLastPublishingError VARCHAR(200),
	PbsStatus CHAR(16),
	PbsCreID CHAR(16) NOT NULL,
	PbsModID CHAR(16) NOT NULL,
	PbsCrDt TIMESTAMP NOT NULL,
	PbsUpd TIMESTAMP NOT NULL,
	PbsMbm INTEGER,
	PbsMbs INTEGER,
	PRIMARY KEY (PbsID)
);

CREATE TABLE Questions (
	QueID CHAR(16) NOT NULL,
	QueText TEXT,
	QueLvl INTEGER,
	QueAtyID CHAR(16),
	QuePerFldID CHAR(16),
	QueSilFldID CHAR(16),
	QueTheme CHAR(16),
	QueCreID CHAR(16) NOT NULL,
	QueModID CHAR(16) NOT NULL,
	QueCrDt TIMESTAMP NOT NULL,
	QueUpd TIMESTAMP NOT NULL,
	QueMbm INTEGER,
	QueMbs INTEGER,
	PRIMARY KEY (QueID)
);

CREATE TABLE ReturnedMailModel (
	RmmID CHAR(16) NOT NULL,
	RmmCode VARCHAR(100),
	RmmName VARCHAR(250),
	RmmPosition INTEGER,
	RmmStatus INTEGER,
	RmmActive INTEGER,
	RmmAddrLocation CHAR(16),
	RmmTextPos INTEGER,
	RmmTextLast INTEGER,
	RmmAddrHname VARCHAR(250),
	RmmAddrTextPos INTEGER,
	RmmAddrTextLast INTEGER,
	RmmCreID CHAR(16) NOT NULL,
	RmmModID CHAR(16) NOT NULL,
	RmmCrDt TIMESTAMP NOT NULL,
	RmmUpd TIMESTAMP NOT NULL,
	RmmMbm INTEGER,
	RmmMbs INTEGER,
	PRIMARY KEY (RmmID)
);

CREATE TABLE Silhouette (
	SilID CHAR(16) NOT NULL,
	SilCivID CHAR(16),
	SilName VARCHAR(30),
	SilFstName VARCHAR(30),
	SilEnterprise VARCHAR(100),
	SilPhone VARCHAR(20),
	SilMail VARCHAR(100),
	SilToken VARCHAR(8),
	SilCookie VARCHAR(8),
	SilCtyID CHAR(16),
	SilFonction VARCHAR(100),
	SilService VARCHAR(100),
	SilAd1 VARCHAR(50),
	SilAd2 VARCHAR(50),
	SilAd3 VARCHAR(50),
	SilZip VARCHAR(10),
	SilCity VARCHAR(32),
	SilFax VARCHAR(20),
	SilOrigin CHAR(16),
	SilCtrID CHAR(16),
	SilMailStatus INTEGER,
	SilBlackList INTEGER,
	SilFaxStatus INTEGER,
	SilField1 VARCHAR(200),
	SilField2 VARCHAR(200),
	SilField3 VARCHAR(200),
	SilField4 VARCHAR(200),
	SilField5 VARCHAR(200),
	SilField6 VARCHAR(200),
	SilField7 VARCHAR(200),
	SilField8 VARCHAR(200),
	SilField9 VARCHAR(200),
	SilField10 VARCHAR(200),
	SilCreID CHAR(16) NOT NULL,
	SilModID CHAR(16) NOT NULL,
	SilCrDt TIMESTAMP NOT NULL,
	SilUpd TIMESTAMP NOT NULL,
	SilMbm INTEGER,
	SilMbs INTEGER,
	PRIMARY KEY (SilID)
);

CREATE TABLE SilhouetteTranslator (
	StrID CHAR(16) NOT NULL,
	StrSilFldID CHAR(16),
	StrPerFldID CHAR(16),
	StrEntFldID CHAR(16),
	StrJouFldID CHAR(16),
	StrSupFldID CHAR(16),
	StrCreID CHAR(16) NOT NULL,
	StrModID CHAR(16) NOT NULL,
	StrCrDt TIMESTAMP NOT NULL,
	StrUpd TIMESTAMP NOT NULL,
	StrMbm INTEGER,
	StrMbs INTEGER,
	PRIMARY KEY (StrID)
);

CREATE TABLE WebOperation (
	WopID CHAR(16) NOT NULL,
	WopCod VARCHAR(10),
	WopNam VARCHAR(100),
	WopUrl VARCHAR(255),
	WopDsc TEXT,
	WopInDate TIMESTAMP,
	WopOutDate TIMESTAMP,
	WopCustom TEXT,
	WopPageName VARCHAR(100),
	WopRegroupement VARCHAR(20),
	WopTrackedUrl VARCHAR(120),
	WopUrlParams VARCHAR(255),
	WopCreID CHAR(16) NOT NULL,
	WopModID CHAR(16) NOT NULL,
	WopCrDt TIMESTAMP NOT NULL,
	WopUpd TIMESTAMP NOT NULL,
	WopMbm INTEGER,
	WopMbs INTEGER,
	PRIMARY KEY (WopID)
);

CREATE TABLE Alarm (
	AlmID CHAR(16) NOT NULL,
	AlmActID CHAR(16),
	AlmDate TIMESTAMP,
	AlmTime TIMESTAMP,
	AlmSubject VARCHAR(255),
	AlmMessage TEXT,
	AlmIntID CHAR(16),
	AlmOppID CHAR(16),
	AlmAutomation VARCHAR(16),
	AlmCreID CHAR(16) NOT NULL,
	AlmModID CHAR(16) NOT NULL,
	AlmCrDt TIMESTAMP NOT NULL,
	AlmUpd TIMESTAMP NOT NULL,
	AlmMbm INTEGER,
	AlmMbs INTEGER,
	PRIMARY KEY (AlmID)
);

CREATE TABLE Correspondent (
	CorID CHAR(16) NOT NULL,
	CorEntID CHAR(16),
	CorPerID CHAR(16),
	CorSupID CHAR(16),
	CorJouID CHAR(16),
	CorCreID CHAR(16) NOT NULL,
	CorModID CHAR(16) NOT NULL,
	CorCrDt TIMESTAMP NOT NULL,
	CorUpd TIMESTAMP NOT NULL,
	CorMbm INTEGER,
	CorMbs INTEGER,
	PRIMARY KEY (CorID)
);

CREATE TABLE Enterprise (
	EntID CHAR(16) NOT NULL,
	EntCorpName VARCHAR(100),
	EntAcronym VARCHAR(100),
	EntPhone VARCHAR(20),
	EntFax VARCHAR(20),
	EntWeb VARCHAR(100),
	EntAd1 VARCHAR(100),
	EntAd2 VARCHAR(50),
	EntAd3 VARCHAR(50),
	EntZip VARCHAR(10),
	EntCity VARCHAR(32),
	EntCtrID CHAR(16),
	EntSiret VARCHAR(15),
	EntSiren VARCHAR(10),
	EntNotes TEXT,
	EntPosID CHAR(16),
	EntFrequency NUMERIC,
	EntActID CHAR(16),
	EntOriID CHAR(16),
	EntAtvID CHAR(16),
	EntActivDet TEXT,
	EntTyeID CHAR(16),
	EntRecID CHAR(16),
	EntSector VARCHAR(250),
	EntTurnOver INTEGER,
	EntRelativeDelay NUMERIC,
	EntTzoID CHAR(16),
	EntMatchCode VARCHAR(255),
	EntDoubloon INTEGER,
	EntEmailPattern VARCHAR(250),
	EntCode VARCHAR(20),
	EntPrcID CHAR(16),
	EntAddressStatus CHAR(16),
	EntParentID CHAR(16),
	EntLa NUMERIC,
	EntLo NUMERIC,
	EntMktPressure NUMERIC,
	EntDeltaMktPress INTEGER,
	EntScMktPress CHAR(16),
	EntMtInvest NUMERIC,
	EntScoringInvest CHAR(16),
	EntDeltaInvest INTEGER,
	EntGeoCodeStatusID CHAR(16),
	EntFld1 VARCHAR(200),
	EntFld2 VARCHAR(200),
	EntFld3 VARCHAR(200),
	EntFld4 VARCHAR(200),
	EntFld5 VARCHAR(200),
	EntFld6 VARCHAR(200),
	EntFld7 VARCHAR(200),
	EntFld8 VARCHAR(200),
	EntFld9 VARCHAR(200),
	EntFld10 VARCHAR(200),
	EntIntraVAT VARCHAR(20),
	EntOrgType CHAR(16),
	EntAddressType CHAR(16),
	EntSiteType CHAR(16),
	EntStatus CHAR(16),
	EntSolv CHAR(16),
	EntFinanceInfo TEXT,
	EntMobileCreationStateID CHAR(16),
	EntCreID CHAR(16) NOT NULL,
	EntModID CHAR(16) NOT NULL,
	EntCrDt TIMESTAMP NOT NULL,
	EntUpd TIMESTAMP NOT NULL,
	EntMbm INTEGER,
	EntMbs INTEGER,
	PRIMARY KEY (EntID)
);

CREATE TABLE Expense (
	ExpID CHAR(16) NOT NULL,
	ExpExfID CHAR(16),
	ExpDate TIMESTAMP,
	ExpExtID CHAR(16),
	ExpProof INTEGER,
	ExpLocalITAmount NUMERIC,
	ExpCurID CHAR(16),
	ExpUCITAmount NUMERIC,
	ExpVATRate NUMERIC,
	ExpRecoverable INTEGER,
	ExpUCVATRecoverabled NUMERIC,
	ExpUCNTAmount NUMERIC,
	ExpPayID CHAR(16),
	ExpChaID CHAR(16),
	ExpNotes TEXT,
	ExpCreID CHAR(16) NOT NULL,
	ExpModID CHAR(16) NOT NULL,
	ExpCrDt TIMESTAMP NOT NULL,
	ExpUpd TIMESTAMP NOT NULL,
	ExpMbm INTEGER,
	ExpMbs INTEGER,
	PRIMARY KEY (ExpID)
);

CREATE TABLE ExpenseFile (
	ExfID CHAR(16) NOT NULL,
	ExfNumber INTEGER,
	ExfActID CHAR(16),
	ExfNumEmployee VARCHAR(10),
	ExfBegDate TIMESTAMP,
	ExfEndDate TIMESTAMP,
	ExfWeek INTEGER,
	ExfEfsID CHAR(16),
	ExfEmitDate TIMESTAMP,
	ExfMangerDate TIMESTAMP,
	ExfAccountDate TIMESTAMP,
	ExfPayementDate TIMESTAMP,
	ExfNotes TEXT,
	ExfProof INTEGER,
	ExfUCAmount NUMERIC,
	ExfUCAmountKM NUMERIC,
	ExfUCAmountTotal NUMERIC,
	ExfUCAdvanced NUMERIC,
	ExfUCAmountPayement NUMERIC,
	ExfKM INTEGER,
	ExfCreID CHAR(16) NOT NULL,
	ExfModID CHAR(16) NOT NULL,
	ExfCrDt TIMESTAMP NOT NULL,
	ExfUpd TIMESTAMP NOT NULL,
	ExfMbm INTEGER,
	ExfMbs INTEGER,
	PRIMARY KEY (ExfID)
);

CREATE TABLE ExpenseKM (
	ExkID CHAR(16) NOT NULL,
	ExkExfID CHAR(16),
	ExkDate TIMESTAMP,
	ExkRoute TEXT,
	ExkKM INTEGER,
	ExkUCAmount NUMERIC,
	ExkCreID CHAR(16) NOT NULL,
	ExkModID CHAR(16) NOT NULL,
	ExkCrDt TIMESTAMP NOT NULL,
	ExkUpd TIMESTAMP NOT NULL,
	ExkMbm INTEGER,
	ExkMbs INTEGER,
	PRIMARY KEY (ExkID)
);

CREATE TABLE ExternalLink (
	EliID CHAR(16) NOT NULL,
	EliUrl TEXT,
	EliExtId VARCHAR(30),
	EliIcon TEXT,
	EliName TEXT,
	EliEntID CHAR(16),
	EliPerID CHAR(16),
	EliMotRec CHAR(16),
	EliCreID CHAR(16) NOT NULL,
	EliModID CHAR(16) NOT NULL,
	EliCrDt TIMESTAMP NOT NULL,
	EliUpd TIMESTAMP NOT NULL,
	EliMbm INTEGER,
	EliMbs INTEGER,
	PRIMARY KEY (EliID)
);

CREATE TABLE Interaction (
	IntID CHAR(16) NOT NULL,
	IntOppID CHAR(16),
	IntStiID CHAR(16),
	IntTimeBeg TIMESTAMP,
	IntTimeEnd TIMESTAMP,
	IntMedID CHAR(16),
	IntPlace VARCHAR(350),
	IntDate TIMESTAMP,
	IntDetails TEXT,
	IntOrigID CHAR(16),
	IntType INTEGER,
	IntMsgID CHAR(16),
	IntInType INTEGER,
	IntOtlId VARCHAR(300),
	IntOtlSyncStatus INTEGER,
	IntAtvID CHAR(16),
	IntParLot CHAR(16),
	IntCatID CHAR(16),
	IntSpecif1 TEXT,
	IntSpecif2 TEXT,
	IntOpeID CHAR(16),
	IntCpgID CHAR(16),
	IntStgID CHAR(16),
	IntEmetteur CHAR(16),
	IntSubject VARCHAR(250),
	IntSimID CHAR(16),
	IntSimLot INTEGER,
	IntSyncOnlyFromExt INTEGER,
	IntExternalUID VARCHAR(200),
	IntCCS NUMERIC,
	IntCCE NUMERIC,
	IntICCE VARCHAR(100),
	IntCoutCom NUMERIC,
	IntModifExtOTF INTEGER,
	IntReport TEXT,
	IntReportTxt TEXT,
	IntLa NUMERIC,
	IntLo NUMERIC,
	IntGeoCodeStatusID CHAR(16),
	IntEveID CHAR(16),
	IntPvtID CHAR(16),
	IntRefMsgID CHAR(16),
	IntResult CHAR(16),
	IntDestEntID CHAR(16),
	IntDestPerID CHAR(16),
	IntProcessInstanceID CHAR(16),
	IntParentID CHAR(16),
	IntRefDocID CHAR(16),
	IntPtaID CHAR(16),
	IntBody TEXT,
	IntSentMailID CHAR(16),
	IntCreID CHAR(16) NOT NULL,
	IntModID CHAR(16) NOT NULL,
	IntCrDt TIMESTAMP NOT NULL,
	IntUpd TIMESTAMP NOT NULL,
	IntMbm INTEGER,
	IntMbs INTEGER,
	PRIMARY KEY (IntID)
);

CREATE TABLE Link (
	LinID CHAR(16) NOT NULL,
	LinFirst VARCHAR(16),
	LinSecond VARCHAR(16),
	LinTypeA CHAR(16),
	LinTypeB CHAR(16),
	LinCreID CHAR(16) NOT NULL,
	LinModID CHAR(16) NOT NULL,
	LinCrDt TIMESTAMP NOT NULL,
	LinUpd TIMESTAMP NOT NULL,
	LinMbm INTEGER,
	LinMbs INTEGER,
	PRIMARY KEY (LinID)
);

CREATE TABLE Location (
	LocID CHAR(16) NOT NULL,
	LocName VARCHAR(100),
	LocEntID CHAR(16),
	LocPhone VARCHAR(20),
	LocFax VARCHAR(20),
	LocAd1 VARCHAR(50),
	LocAd2 VARCHAR(50),
	LocAd3 VARCHAR(50),
	LocZip VARCHAR(10),
	LocCity VARCHAR(32),
	LocCtrID CHAR(16),
	LocSiren VARCHAR(5),
	LocDetails TEXT,
	LocAddressType CHAR(16),
	LocSiteType CHAR(16),
	LocLa NUMERIC,
	LocLo NUMERIC,
	LocGeoCodeStatusID CHAR(16),
	LocCreID CHAR(16) NOT NULL,
	LocModID CHAR(16) NOT NULL,
	LocCrDt TIMESTAMP NOT NULL,
	LocUpd TIMESTAMP NOT NULL,
	LocMbm INTEGER,
	LocMbs INTEGER,
	PRIMARY KEY (LocID)
);

CREATE TABLE Opportunity (
	OppID CHAR(16) NOT NULL,
	OppTitle VARCHAR(128),
	OppNumRef VARCHAR(15),
	OppActID CHAR(16),
	OppEntID CHAR(16),
	OppPerID CHAR(16),
	OppDate TIMESTAMP,
	OppStake NUMERIC,
	OppStoID CHAR(16),
	OppOpbID CHAR(16),
	OppDetail TEXT,
	OppCompetInf TEXT,
	OppMtInvest NUMERIC,
	OppStuID CHAR(16),
	OppBizProviderID CHAR(16),
	OppCreID CHAR(16) NOT NULL,
	OppModID CHAR(16) NOT NULL,
	OppCrDt TIMESTAMP NOT NULL,
	OppUpd TIMESTAMP NOT NULL,
	OppMbm INTEGER,
	OppMbs INTEGER,
	PRIMARY KEY (OppID)
);

CREATE TABLE Person (
	PerID CHAR(16) NOT NULL,
	PerCivID CHAR(16),
	PerFstName VARCHAR(30),
	PerName VARCHAR(30),
	PerEntID CHAR(16),
	PerTitle VARCHAR(200),
	PerDepID CHAR(16),
	PerFctID CHAR(16),
	PerPhone VARCHAR(20),
	PerFax VARCHAR(20),
	PerMobile VARCHAR(20),
	PerMail VARCHAR(100),
	PerRleID CHAR(16),
	PerLocID CHAR(16),
	PerRemarks TEXT,
	PerLogin VARCHAR(20),
	PerPwd VARCHAR(20),
	PerCookie VARCHAR(8),
	PerCtyID CHAR(16),
	PerToken VARCHAR(8),
	PerImpID CHAR(16),
	PerPoeID CHAR(16),
	PerService VARCHAR(100),
	PerExternalID VARCHAR(250),
	PerExtIdChecksum VARCHAR(2),
	PerCounselor CHAR(16),
	PerAd1 VARCHAR(50),
	PerAd2 VARCHAR(50),
	PerAd3 VARCHAR(50),
	PerZip VARCHAR(10),
	PerCity VARCHAR(32),
	PerCtrID CHAR(16),
	PerPersonalAddressDefault INTEGER,
	PerBlackList INTEGER,
	PerMatchCode VARCHAR(255),
	PerScoringY CHAR(16),
	PerPRP NUMERIC,
	PerDDC TIMESTAMP,
	PerLngPrinc CHAR(16),
	PerMktPressure NUMERIC,
	PerDeltaMktPress INTEGER,
	PerMailStatus INTEGER,
	PerMtInvest NUMERIC,
	PerDeltaInvest INTEGER,
	PerScoringX CHAR(16),
	PerTzoID CHAR(16),
	PerAddressStatus CHAR(16),
	PerDoubloon INTEGER,
	PerFld1 VARCHAR(200),
	PerFld2 VARCHAR(200),
	PerFld3 VARCHAR(200),
	PerFld4 VARCHAR(200),
	PerFld5 VARCHAR(200),
	PerFld6 VARCHAR(200),
	PerFld7 VARCHAR(200),
	PerFld8 VARCHAR(200),
	PerFld9 VARCHAR(200),
	PerFld10 VARCHAR(200),
	PerFctTyp CHAR(16),
	PerFctParentID CHAR(16),
	PerFctOrder INTEGER,
	PerFctEntryDt TIMESTAMP,
	PerFctExitDt TIMESTAMP,
	PerFctIsActive INTEGER,
	PerFctAddressType CHAR(16),
	PerFctSiteType CHAR(16),
	PerFaxStatus INTEGER,
	PerMobileStatus INTEGER,
	PerLa NUMERIC,
	PerLo NUMERIC,
	PerGeoCodeStatusID CHAR(16),
	PerMobileCreationStateID CHAR(16),
	PerCreID CHAR(16) NOT NULL,
	PerModID CHAR(16) NOT NULL,
	PerCrDt TIMESTAMP NOT NULL,
	PerUpd TIMESTAMP NOT NULL,
	PerMbm INTEGER,
	PerMbs INTEGER,
	PRIMARY KEY (PerID)
);

CREATE TABLE PersonHistory (
	PehID CHAR(16) NOT NULL,
	PehPerID CHAR(16),
	PehFunction VARCHAR(100),
	PehBegDate TIMESTAMP,
	PehEndDate TIMESTAMP,
	PehEntID CHAR(16),
	PehPhone VARCHAR(20),
	PehFax VARCHAR(20),
	PehMail VARCHAR(100),
	PehCreID CHAR(16) NOT NULL,
	PehModID CHAR(16) NOT NULL,
	PehCrDt TIMESTAMP NOT NULL,
	PehUpd TIMESTAMP NOT NULL,
	PehMbm INTEGER,
	PehMbs INTEGER,
	PRIMARY KEY (PehID)
);

CREATE TABLE ProductOpportunity (
	ProID CHAR(16) NOT NULL,
	ProOppID CHAR(16),
	ProPrdID CHAR(16),
	ProPrice NUMERIC,
	ProQuantity INTEGER,
	ProDiscountMny NUMERIC,
	ProDiscountP NUMERIC,
	ProUnitPrice NUMERIC,
	ProDesignation VARCHAR(250),
	ProCreID CHAR(16) NOT NULL,
	ProModID CHAR(16) NOT NULL,
	ProCrDt TIMESTAMP NOT NULL,
	ProUpd TIMESTAMP NOT NULL,
	ProMbm INTEGER,
	ProMbs INTEGER,
	PRIMARY KEY (ProID)
);

CREATE TABLE SalesInvest (
	SinID CHAR(16) NOT NULL,
	SinTitle VARCHAR(100),
	SinActID CHAR(16),
	SinMt NUMERIC,
	SinDt TIMESTAMP,
	SinIntID CHAR(16),
	SinPopID CHAR(16),
	SinEventID CHAR(16),
	SinOppID CHAR(16),
	SinPersID CHAR(16),
	SinEntID CHAR(16),
	SinJourID CHAR(16),
	SinSuppID CHAR(16),
	SinPersEventID CHAR(16),
	SinCreID CHAR(16) NOT NULL,
	SinModID CHAR(16) NOT NULL,
	SinCrDt TIMESTAMP NOT NULL,
	SinUpd TIMESTAMP NOT NULL,
	SinMbm INTEGER,
	SinMbs INTEGER,
	PRIMARY KEY (SinID)
);

CREATE TABLE Simulation (
	SimID CHAR(16) NOT NULL,
	SimCode VARCHAR(250),
	SimCreator CHAR(16),
	SimCalculated INTEGER,
	SimCalculationDate TIMESTAMP,
	SimPopulation CHAR(16),
	SimVolume INTEGER,
	SimBeginDate TIMESTAMP,
	SimEndDate TIMESTAMP,
	SimMaxPerDay INTEGER,
	SimDailyCoeffs VARCHAR(250),
	SimExclusion VARCHAR(250),
	SimIntAtvID CHAR(16),
	SimIntStiID CHAR(16),
	SimIntDetails TEXT,
	SimIntCpgID CHAR(16),
	SimIntStgID CHAR(16),
	SimActorType INTEGER,
	SimPersonalized VARCHAR(250),
	SimPredefined CHAR(16),
	SimNbActors INTEGER,
	SimEndParameter INTEGER,
	SimIntSubject VARCHAR(250),
	SimLot INTEGER,
	SimCreID CHAR(16) NOT NULL,
	SimModID CHAR(16) NOT NULL,
	SimCrDt TIMESTAMP NOT NULL,
	SimUpd TIMESTAMP NOT NULL,
	SimMbm INTEGER,
	SimMbs INTEGER,
	PRIMARY KEY (SimID)
);

CREATE TABLE CusSatisfaction (
	CsaID CHAR(16) NOT NULL,
	CsaNote TEXT,
	CsaPerID CHAR(16),
	CsaEntID CHAR(16),
	CsaSolID CHAR(16),
	CsaQuestion CHAR(16),
	CsaNumAnswer INTEGER,
	CsaCreID CHAR(16) NOT NULL,
	CsaModID CHAR(16) NOT NULL,
	CsaCrDt TIMESTAMP NOT NULL,
	CsaUpd TIMESTAMP NOT NULL,
	CsaMbm INTEGER,
	CsaMbs INTEGER,
	PRIMARY KEY (CsaID)
);

CREATE TABLE SAction (
	SacID CHAR(16) NOT NULL,
	SacSubject VARCHAR(100),
	SacSolID CHAR(16),
	SacFromDate TIMESTAMP,
	SacToDate TIMESTAMP,
	SacWorkload NUMERIC,
	SacTypID CHAR(16),
	SacDetail TEXT,
	SacDone INTEGER,
	SacAdvID CHAR(16),
	SacType INTEGER,
	SacPerID CHAR(16),
	SacAnswer TEXT,
	SacCreID CHAR(16) NOT NULL,
	SacModID CHAR(16) NOT NULL,
	SacCrDt TIMESTAMP NOT NULL,
	SacUpd TIMESTAMP NOT NULL,
	SacMbm INTEGER,
	SacMbs INTEGER,
	PRIMARY KEY (SacID)
);

CREATE TABLE Solicitation (
	SolID CHAR(16) NOT NULL,
	SolSubject VARCHAR(100),
	SolCatID CHAR(16),
	SolSubCatID CHAR(16),
	SolWorkload NUMERIC,
	SolPerID CHAR(16),
	SolSilID CHAR(16),
	SolActID CHAR(16),
	SolIntRmk TEXT,
	SolExtRmk TEXT,
	SolReport TEXT,
	SolClsDate TIMESTAMP,
	SolPtyID CHAR(16),
	SolClsID CHAR(16),
	SolStsID CHAR(16),
	SolNtfID CHAR(16),
	SolToken VARCHAR(20),
	SolPwd VARCHAR(100),
	SolChnID CHAR(16),
	SolDelay INTEGER,
	SolNextUpd TIMESTAMP,
	SolFstActID CHAR(16),
	SolNotifyActor INTEGER,
	SolMsgID CHAR(16),
	SolSlaID CHAR(16),
	SolSllID CHAR(16),
	SolEntID CHAR(16),
	SolCustomer CHAR(16),
	SolWikiUrl VARCHAR(300),
	SolTouchedDt TIMESTAMP,
	SolResolutionDt TIMESTAMP,
	SolResolutionType CHAR(16),
	SolLastQuestion CHAR(16),
	SolCreID CHAR(16) NOT NULL,
	SolModID CHAR(16) NOT NULL,
	SolCrDt TIMESTAMP NOT NULL,
	SolUpd TIMESTAMP NOT NULL,
	SolMbm INTEGER,
	SolMbs INTEGER,
	PRIMARY KEY (SolID)
);

CREATE TABLE WallPost (
	WptID CHAR(16) NOT NULL,
	WptDate TIMESTAMP,
	WptJsonData TEXT,
	WptActID CHAR(16),
	WptNbComment INTEGER,
	WptCreID CHAR(16) NOT NULL,
	WptModID CHAR(16) NOT NULL,
	WptCrDt TIMESTAMP NOT NULL,
	WptUpd TIMESTAMP NOT NULL,
	WptMbm INTEGER,
	WptMbs INTEGER,
	PRIMARY KEY (WptID)
);

CREATE TABLE WallPostObject (
	WpoID CHAR(16) NOT NULL,
	WpoObjID TEXT,
	WpoObjType TEXT,
	WpoPostID CHAR(16),
	WpoCreID CHAR(16) NOT NULL,
	WpoModID CHAR(16) NOT NULL,
	WpoCrDt TIMESTAMP NOT NULL,
	WpoUpd TIMESTAMP NOT NULL,
	WpoMbm INTEGER,
	WpoMbs INTEGER,
	PRIMARY KEY (WpoID)
);

CREATE TABLE WallTarget (
	WtaID CHAR(16) NOT NULL,
	WtaObjID VARCHAR(16),
	WtaTargeting INTEGER,
	WtaActID CHAR(16),
	WtaObjType TEXT,
	WtaObjActor INTEGER,
	WtaCreID CHAR(16) NOT NULL,
	WtaModID CHAR(16) NOT NULL,
	WtaCrDt TIMESTAMP NOT NULL,
	WtaUpd TIMESTAMP NOT NULL,
	WtaMbm INTEGER,
	WtaMbs INTEGER,
	PRIMARY KEY (WtaID)
);

CREATE TABLE MvaActSector (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActLngID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActCsoID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActCpoID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActNcoID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActRoles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActDshIDs (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActPermLics (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActFloatLics (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActSyncOptions (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaActPrevPwds (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaAdzPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaDshPages (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaOptValueList (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaTskDaysOfWeek (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaTskActions (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisOldMvaTextValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisOldMvaDateTimeValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaDateTime TIMESTAMP,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisOldMvaIntValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaInteger INTEGER,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisOldMvaFloatValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaFloat NUMERIC,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisNewMvaTextValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisNewMvaDateTimeValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaDateTime TIMESTAMP,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisNewMvaIntValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaInteger INTEGER,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaHisNewMvaFloatValue (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaFloat NUMERIC,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaInpReceiver (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaInpActWhoHaveRead (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMcoMcfID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMsgAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMsgMergedDocID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMsgDocID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMsgAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMsgPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaObjRolesEdit (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaInteger INTEGER,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaObjRoles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaObjRolesRead (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaInteger INTEGER,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaObjRolesCreate (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaInteger INTEGER,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaObjRolesDelete (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaInteger INTEGER,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaObjConnexObjs (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSlaFldID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSlaJouID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSlaHolidays (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaDateTime TIMESTAMP,
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSllActID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSlsFieldActor (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSlsRoles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSfwRoleHidden (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSplFamilles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrsPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPtaRefDocID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPtaIntRefMsgID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaDdaAuthRoles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCrtFaqID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFaqPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahKeyID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahPblChannel (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahCntctActID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahCntctCorID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaFahAudienceID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSnaParams (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSdiFilter1Values (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSdiFilter2Values (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSdiFilter3Values (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSdiFilter4Values (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSdiMergedTables (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSdiPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSpaDisplays (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCpgAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCpgAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCpgStgID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCptRopID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCptAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCptAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCriChx (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaCr2Chx (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaDocRolesID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaDocDocID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaDocPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEvtActors (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEvtPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaGliGuests (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaJouSupID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaJouHeaID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaJouIntID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaJouJevID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMarKeywordID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMarAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMarAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMatAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMatAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMemAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaMemAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaNepAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaNepAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaNotAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaNotAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPvtPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPopPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPpePartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrdAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrdAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrdCptID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrdQualification (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrdPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPrfQualification (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSelTargets (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSe2PartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSmdPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaStgAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaStgAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSupAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSupAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSupJevID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEmaHtmlCtlGrpID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEmaTextCtlGrpID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEmaNltID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEmlMsgID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEmlMailSendField (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPubAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPubAttNames (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPubLastPublishErrors (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPboAuthActors (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPboAuthRoles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaQueAnsID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaRmmMatchSubject (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaRmmMatchText (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaRmmMatchHeaders (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaRmmAddrHeaders (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSilNltID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSilQueID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEntEveID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEntCusID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEntAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEntAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaEntPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaExpActID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntActID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntCorID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntParentOwners (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntRefusedActID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaIntPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaLocParentOwners (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaLocAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaLocAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaOppCptID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaOppParentOwners (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaOppAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaOppAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaOppPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerLngID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerPevID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerNltID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerQueID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerParentOwners (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaPerPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaProPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSimActors (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSimRoles (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSacActID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSacAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSolDomID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSolAttID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSolAttFileName (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText VARCHAR(255),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE TABLE MvaSolPartitionID (
	MvaID CHAR(16) NOT NULL,
	MvaColID CHAR(16) NOT NULL,
	MvaText CHAR(16),
	MvaPosition INTEGER,
	PRIMARY KEY (MvaID)
);

CREATE Table Languages ( 
	 RefID CHAR(16), 
	 RefVal VARCHAR(100) 
);

CREATE Table Referential ( 
	 RefID CHAR(16), 
	 RefTabID CHAR(16), 
	 RefVal VARCHAR(100), 
	 RefTe1 VARCHAR(250), 
	 RefTe2 VARCHAR(250), 
	 RefTe3 VARCHAR(250), 
	 RefNu1 NUMERIC, 
	 RefNu2 NUMERIC, 
	 RefNu3 NUMERIC, 
	 RefDa1 TIMESTAMP, 
	 RefDa2 TIMESTAMP, 
	 RefDa3 TIMESTAMP, 
	 RefPos INTEGER, 
	 RefLngID CHAR(16), 
	 RefCreID CHAR(16), 
	 RefCrDt TIMESTAMP, 
	 RefModID CHAR(16), 
	 RefUpd TIMESTAMP 
);