TFTRADENG

Reserved for IBM internal use.

Column Descriptions:

NameTypeDescription
TFTRADENG_IDBIGINT NOT NULLReserved for IBM internal use.
MEMBER_IDBIGINT NOT NULLReserved for IBM internal use.
STORE_IDINTEGER NOT NULLReserved for IBM internal use.
CREATETIMETIMESTAMPReserved for IBM internal use.
UPDATETIMETIMESTAMPReserved for IBM internal use.
CANCELTIMETIMESTAMPReserved for IBM internal use.
STATUSINTEGERReserved for IBM internal use.
STARTTIMETIMESTAMPReserved for IBM internal use.
STOPTIMETIMESTAMPReserved for IBM internal use.
MULTISTAGEINTEGERReserved for IBM internal use.
NAMEVARCHAR (254) NOT NULLReserved for IBM internal use.
OFFERLIMITINTEGERReserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TFTRADENG_IDPrimary Key
I0000249NAMEUnique Index
I0000812STORE_IDNon-Unique Index
I0000813MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_858MEMBER_IDMEMBERMEMBER_IDCascade
F_859STORE_IDSTORESTORE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_676TFTRADENG_IDRFQTFTRADENG_IDCascade
F_684TFTRADENG_IDRFQRSPTFTRADENG_IDCascade
F_854TFTRADENG_IDTFEXTENGTFTRADENG_IDCascade
F_860TFTRADENG_IDTFTRENGDSCTFTRADENG_IDCascade