Database Table: ORDERTMPL

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 Column Description
MEMBER_ID BIGINT
NOT NULL
The customer.
ORDERS_ID BIGINT
NOT NULL
The Order.
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035018430 MEMBER_ID, ORDERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_518 MEMBER_ID MEMBER MEMBER_ID Cascade
F_519 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable