new_affiliateincomereportBase

136 rows


Description

Affiliate Income Report

Columns

Column Type Size Nulls Auto Default Children Parents Comments
new_affiliateincomereportId uuid 2147483647 null
CreatedOn timestamp 26,3 null
CreatedBy uuid 2147483647 null
ModifiedOn timestamp 26,3 null
ModifiedBy uuid 2147483647 null
CreatedOnBehalfBy uuid 2147483647 null
ModifiedOnBehalfBy uuid 2147483647 null
OwnerId uuid 2147483647 null
OwnerIdType int4 10 8
OwningBusinessUnit uuid 2147483647 null
statecode int4 10 null
statuscode int4 10 null
VersionNumber bytea 2147483647 null
ImportSequenceNumber int4 10 null
OverriddenCreatedOn timestamp 26,3 null
TimeZoneRuleVersionNumber int4 10 null
UTCConversionTimeZoneCode int4 10 null
TransactionCurrencyId uuid 2147483647 null
ExchangeRate numeric 25,10 null
new_name varchar 100 null
new_StartDate timestamp 26,3 null
new_EndDate timestamp 26,3 null
new_Income numeric 19,4 null
new_Players int4 10 null
new_SignUps int4 10 null
new_Year int4 10 null
new_Traffic int4 10 null
new_month int4 10 null
new_income_Base numeric 19,4 null
new_AffiliateProgram uuid 2147483647 null
new_LpmCampaign uuid 2147483647 null
new_Brand uuid 2147483647 null
new_TrafficGa int4 10 null
new_FTDValue int4 10 null
new_CPC numeric 25,10 null
new_ConversionRateClickFtd numeric 25,10 null
new_AffiliateOrder uuid 2147483647 null
id serial 10 nextval('v1."new_affiliateincomereportBase_id_seq"'::regclass)

Indexes

Constraint Name Type Sort Column(s)
PK_new_affiliateincomereportBase Primary key Asc id
new_affiliateincomereportBase_id_key Must be unique Asc id

Diagram producer might be missing

No diagrams were produced please see application output for any errors