TFTRADENG

Reserved for IBM internal use.

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	TFTRADENG_ID	Primary Key
I0000249	NAME	Unique Index
I0000812	STORE_ID	Non-Unique Index
I0000813	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_858	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_859	STORE_ID	STORE	STORE_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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