Each row of this table indicates that an Order is used as a template by a customer, and also indicates whether the template is current for that customer.
Column Name | Column Type | Description |
---|---|---|
ORDERS_ID | BIGINT NOT NULL | The Order. |
MEMBER_ID | BIGINT NOT NULL | The customer. |
USAGE | INTEGER NOT NULL DEFAULT 0 | The intended usage for this template. 0 = no usage information. 1 = template is a current template. Values less than 1000 are reserved for IBM internal use. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031244440 | MEMBER_ID+ORDERS_ID | Primary Key |
I0000655 | ORDERS_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_518 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_519 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |