SalesOrderBase

5734 rows


Description

Affiliate Order Entity

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SalesOrderId uuid 2147483647 √ null
Name varchar 300 √ null
Description text 2147483647 √ null
CreatedOn timestamp 26,3 √ null
StateCode int4 10 0
StatusCode int4 10 √ null
new_postnumber int4 10 √ null
new_totalorder_Base numeric 19,4 √ null
new_orderrevenue_Base numeric 19,4 √ null
new_PostStrategy int4 10 √ null
new_PaymentFrom text 2147483647 √ null
new_PaymentMethod uuid 2147483647 √ null
new_1InvoiceNOrdersId uuid 2147483647 √ null
new_DataStarted timestamp 26,3 √ null
new_DateEnded timestamp 26,3 √ null
new_Calculateposts bool 1 √ null
new_OrdeMode int4 10 √ null
new_TotalOrder numeric 19,4 √ null
new_OrderRevenue numeric 19,4 √ null
new_For int4 10 √ null
OrderFor.id SalesOrderBase_new_For_fkeyR
new_Renewal bool 1 √ null
new_PayTo int4 10 √ null
OrderPayTo.id SalesOrderBase_new_PayTo_fkeyR
new_RunningSince timestamp 26,3 √ null
new_Invoiced bool 1 √ null
new_OrderSubscriptionType int4 10 √ null
new_OrderType int4 10 √ null
OrderType.id SalesOrderBase_new_OrderType_fkeyR
new_AffiliateOrderType int4 10 √ null
new_AffiliateWebsite varchar 140 √ null
new_AffiliateaccountUsername varchar 100 √ null
new_AffiliateAccountPassword varchar 100 √ null
new_sendemailrenewal varchar 100 √ null
TraversedPath varchar 1250 √ null
new_skypegroup bool 1 √ null
new_nifty bool 1 √ null
new_affiliatebrands text 2147483647 √ null
new_hastrackers bool 1 √ null
new_affidnumber varchar 100 √ null
new_AffiliateDealType int4 10 √ null
AffDealType.id SalesOrderBase_new_AffiliateDealType_fkeyR
new_LastCheck timestamp 26,3 √ null
new_InvoicesNotPaid int4 10 √ null
new_InvoicesNotPaidAmount numeric 25,10 √ null
new_Clicks int4 10 √ null
new_OpenInIframe bool 1 √ null
new_AffOrderType uuid 2147483647 √ null
new_Country uuid 2147483647 √ null
new_RegistrationEmail uuid 2147483647 √ null
new_CreatedByUser varchar 1000 √ null
new_voonixadvertiser varchar 100 √ null
new_voonixaffsystem int4 10 √ null
new_voonixsaved bool 1 √ null
new_reportexclude bool 1 √ null
id serial 10 √ nextval('v1."SalesOrderBase_id_seq"'::regclass)
InvoiceBase.order_id InvoiceBase_order_id_fkeyR
new_trackerBase.order_id new_trackerBase_order_id_fkeyR
company_id int4 10 √ null
AccountBase.id SalesOrderBase_company_id_fkeyR
affiliate_project int4 10 √ null
new_affordertypeBase.id SalesOrderBase_affiliate_project_fkeyN
owner_id int4 10 √ null
SystemUserBase.id SalesOrderBase_owner_id_fkeyR
createdby_id int4 10 √ null
SystemUserBase.id SalesOrderBase_createdby_id_fkeyR
paymentmethod_id int4 10 √ null
new_paymentmethodBase.id SalesOrderBase_paymentmethod_id_fkeyR
registrationemail_id int4 10 √ null
new_regemailBase.id SalesOrderBase_registrationemail_id_fkeyR
currency_id int4 10 √ null
TransactionCurrencyBase.id SalesOrderBase_currency_id_fkeyR
PriorityCode int4 10 √ null
OrderPriority.id SalesOrderBase_PriorityCode_fkeyR
project_id int4 10 √ null
Project.id SalesOrderBase_project_id_fkeyN

Indexes

Constraint Name Type Sort Column(s)
SalesOrderBase_pkey Primary key Asc id
ndx_Core Performance Asc/Asc StateCode + StatusCode
order_aff_project_index Performance Asc affiliate_project
order_statecode_index Performance Asc StateCode
order_type_index Performance Asc new_OrderType
SalesOrderBase_id_key Must be unique Asc id

Relationships

Close relationships within degrees of separation