Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: 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 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030401870 MEMBER_ID+ORDERS_ID Primary Key I0000655 ORDERS_ID Non-Unique Index
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
Related reference
_vcc_freeselect_bottom_