new_trackerBase

5318 rows


Description

Trackers

Columns

Column Type Size Nulls Auto Default Children Parents Comments
new_trackerId uuid 2147483647 √ null
CreatedOn timestamp 29,6 √ null
statecode int4 10 0
statuscode int4 10 √ null
new_Brand uuid 2147483647 √ null
new_TrackerOrder uuid 2147483647 √ null
new_IsDefaultTracker bool 1 √ null
new_Clicks int4 10 √ null
new_name varchar 400 √ null
new_MediaType int4 10 √ null
new_BannerSize int4 10 √ null
new_AffiliateTracker text 2147483647 √ null
new_LastClicked timestamp 26,3 √ null
new_AdzzTracker text 2147483647 √ null
new_Website uuid 2147483647 √ null
new_AffiliateTrackerExternal varchar 256 √ null
new_Description text 2147483647 √ null
new_Deal int4 10 √ null
TrackerDeal.id new_trackerBase_new_Deal_fkeyR
new_CPA numeric 25,10 √ null
new_Revshare int4 10 √ null
new_eCPA numeric 25,10 √ null
new_OnlineStatus int4 10 √ null
new_OnlineCheckedOn timestamp 26,3 √ null
new_DirectLink bool 1 √ null
new_ClickCount int4 10 √ null
new_ClickCountStatistics uuid 2147483647 √ null
new_Promoted bool 1 √ null
new_Currency uuid 2147483647 √ null
new_createdby uuid 2147483647 √ null
new_createdbyuser varchar 200 √ null
id serial 10 √ nextval('v1."new_trackerBase_id_seq"'::regclass)
TrackerToTags.tracker_id TrackerToTags_tracker_id_fkeyR
order_id int4 10 √ null
SalesOrderBase.id new_trackerBase_order_id_fkeyR
brand_id int4 10 √ null
new_brandBase.id new_trackerBase_brand_id_fkeyR
currency_id int4 10 √ null
TransactionCurrencyBase.id new_trackerBase_currency_id_fkeyR
createdby_id int4 10 √ null
SystemUserBase.id new_trackerBase_createdby_id_fkeyR
project_id int4 10 √ null
Project.id new_trackerBase_project_id_fkeyN

Indexes

Constraint Name Type Sort Column(s)
new_trackerBase_pkey Primary key Asc id
new_trackerBase_id_key Must be unique Asc id
new_trackerBase_new_name_key Must be unique Asc new_name

Relationships

Close relationships within degrees of separation