WebSphere Commerce database table: TFTRADENG

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
TFTRADENG_ID BIGINT NOT NULL Reserved for IBM internal use.
MEMBER_ID BIGINT NOT NULL Reserved for IBM internal use.
STORE_ID INTEGER NOT NULL Reserved for IBM internal use.
CREATETIME TIMESTAMP Reserved for IBM internal use.
UPDATETIME TIMESTAMP Reserved for IBM internal use.
CANCELTIME TIMESTAMP Reserved for IBM internal use.
STATUS INTEGER Reserved for IBM internal use.
STARTTIME TIMESTAMP Reserved for IBM internal use.
STOPTIME TIMESTAMP Reserved for IBM internal use.
MULTISTAGE INTEGER Reserved for IBM internal use.
NAME VARCHAR(254) NOT NULL Reserved for IBM internal use.
OFFERLIMIT INTEGER Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000249 NAME Unique Index
SQL050212031321370 TFTRADENG_ID Primary Key
I0000812 STORE_ID Non-Unique Index
I0000813 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_858 MEMBER_ID MEMBER MEMBER_ID Cascade
F_859 STORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_676 TFTRADENG_ID RFQ TFTRADENG_ID Cascade
F_684 TFTRADENG_ID RFQRSP TFTRADENG_ID Cascade
F_854 TFTRADENG_ID TFEXTENG TFTRADENG_ID Cascade
F_860 TFTRADENG_ID TFTRENGDSC TFTRADENG_ID Cascade

Feedback