WebSphere Commerce database table: TFTRADENG

Reserved for IBM internal use.

Column Descriptions

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.

Indexes

Index Name	Indexed Column Names	Index Type
I0000249	NAME	Unique Index
SQL060903235301590	TFTRADENG_ID	Primary Key
I0000812	STORE_ID	Non-Unique Index
I0000813	MEMBER_ID	Non-Unique Index

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

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