Database Table: TFTRADENG

Reserved for IBM internal use.

Column Name Column Type Column Description
CANCELTIME TIMESTAMP
NULL
Reserved for IBM internal use.
CREATETIME TIMESTAMP
NULL
Reserved for IBM internal use.
MEMBER_ID BIGINT
NOT NULL
Reserved for IBM internal use.
MULTISTAGE INTEGER
NULL
Reserved for IBM internal use.
NAME VARCHAR (254)
NOT NULL
Reserved for IBM internal use.
OFFERLIMIT INTEGER
NULL
Reserved for IBM internal use.
STARTTIME TIMESTAMP
NULL
Reserved for IBM internal use.
STATUS INTEGER
NULL
Reserved for IBM internal use.
STOPTIME TIMESTAMP
NULL
Reserved for IBM internal use.
STORE_ID INTEGER
NOT NULL
Reserved for IBM internal use.
TFTRADENG_ID BIGINT
NOT NULL
Reserved for IBM internal use.
UPDATETIME TIMESTAMP
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000249 NAME Unique Index
SQL030416035134930 TFTRADENG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names 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