CREATE TABLE UACI_OfferMapping(CREATE TABLE UACI_OfferMapping(OfferMappingRowID bigint NOT NULL,
OfferID bigint NOT NULL,
OfferName lvarchar(130) NULL,
OfferCode lvarchar(320) NULL,
CellID bigint NULL,
CellCode lvarchar(64) NULL,
ZoneID bigint NULL,
ZoneName lvarchar(64) NULL,
EligibilityPredicateEnabled INT NOT NULL DEFAULT 0,
EligibilityPredicate lvarchar(10000),
MarketerScore int NOT NULL DEFAULT 50,
ScorePredicateEnabled INT NOT NULL DEFAULT 0,
ScorePredicate lvarchar(10000),
LearningMode int,
LearningModelId bigint,
ParameterizedOfferAttribute lvarchar(10000),
EffectiveDate bigint,
ExpirationDate bigint,
EnableState INT NOT NULL DEFAULT 1,
CreateDate DATETIME YEAR TO FRACTION(3),
CreateBy INT,
UpdateDate DATETIME YEAR TO FRACTION(3),
UpdateBy INT,
PRIMARY KEY (OfferMappingRowID));
CREATE TABLE UACI_EligStat(
SeqNum BIGSERIAL,
ICID bigint NOT NULL,
ICName nvarchar(192) NOT NULL,
OfferID bigint NOT NULL,
OfferName lvarchar(390) NOT NULL,
TimeID bigint,
DateID bigint,
CellID bigint,
CellName nvarchar(192),
CellCode nvarchar(192),
IPID bigint,
IPName nvarchar(192),
EligibleOpps bigint NOT NULL,
CampaignID bigint NOT NULL,
PRIMARY KEY (SeqNum) );