ORDERREL

Each row in this table represent relationship between one child order and one parent order.

Column Descriptions:

NameTypeDescription
ORDERREL_IDBIGINT NOT NULLThe internal reference number of the order relationship.
PARENTORDER_IDBIGINTThe parent order id.
PARENTORDERITEM_IDBIGINTThe parent order item id.
CHILDORDER_IDBIGINT NOT NULLThe child order id.
TYPECHAR (3)The type of the order. 'REC' represent for recurring order. 'SUB' represent for subscription order.
LASTUPDATETIMESTAMPThe time this order relationship was most recently updated.
MARKFORDELETESMALLINT NOT NULL DEFAULT 0For future usage. Indicates if this order relationship has been marked for deletion: 0 = No. 1 = Yes.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERREL_IDPrimary Key
I0001354PARENTORDER_ID+CHILDORDER_IDUnique Index
I0001355PARENTORDERITEM_ID+CHILDORDER_IDUnique Index
I0001356CHILDORDER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3639PARENTORDER_IDORDERSORDERS_IDCascade
F_3640CHILDORDER_IDORDERSORDERS_IDCascade
F_3641PARENTORDERITEM_IDORDERITEMSORDERITEMS_IDCascade