Reserved for IBM internal use.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_858 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_859 |
STORE_ID |
STORE |
STORE_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.