ORDERTMPL

Each row of this table indicates that an Order is used as a template by a customer. And it also indicates whether the template is current for that customer.

Column Descriptions:

Name	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 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>	MEMBER_ID+ORDERS_ID	Primary Key
I0000655	ORDERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_518	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_519	ORDERS_ID	ORDERS	ORDERS_ID	Cascade

Related reference
Order data model