Each row in this table represent relationship
between one child order and one parent order.
Column Descriptions:
| Name | Type | Description |
| ORDERREL_ID | BIGINT NOT NULL | The internal reference number of the order
relationship. |
| PARENTORDER_ID | BIGINT | The parent order id. |
| PARENTORDERITEM_ID | BIGINT | The parent order item id. |
| CHILDORDER_ID | BIGINT NOT NULL | The child order id. |
| TYPE | CHAR (3) | The type of the order.
'REC' represent for recurring order.
'SUB' represent for subscription order. |
| LASTUPDATE | TIMESTAMP | The time this order relationship was most
recently updated. |
| MARKFORDELETE | SMALLINT NOT NULL DEFAULT 0 | For future usage.
Indicates if this order relationship has been marked for
deletion:
0 = No.
1 = Yes. |
| FIELD1 | INTEGER | Customizable. |
| FIELD2 | DECIMAL (20,5) | Customizable. |
| FIELD3 | VARCHAR (254) | Customizable. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ORDERREL_ID | Primary Key |
| I0001354 | PARENTORDER_ID+CHILDORDER_ID | Unique Index |
| I0001355 | PARENTORDERITEM_ID+CHILDORDER_ID | Unique Index |
| I0001356 | CHILDORDER_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3639 | PARENTORDER_ID | ORDERS | ORDERS_ID | Cascade |
| F_3640 | CHILDORDER_ID | ORDERS | ORDERS_ID | Cascade |
| F_3641 | PARENTORDERITEM_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |