TFTRADENG

Reserved for HCL internal use.

Column Descriptions:

NameTypeDescription
TFTRADENG_IDBIGINT NOT NULLReserved for HCL internal use.
MEMBER_IDBIGINT NOT NULLReserved for HCL internal use.
STORE_IDINTEGER NOT NULLReserved for HCL internal use.
CREATETIMETIMESTAMPReserved for HCL internal use.
UPDATETIMETIMESTAMPReserved for HCL internal use.
CANCELTIMETIMESTAMPReserved for HCL internal use.
STATUSINTEGERReserved for HCL internal use.
STARTTIMETIMESTAMPReserved for HCL internal use.
STOPTIMETIMESTAMPReserved for HCL internal use.
MULTISTAGEINTEGERReserved for HCL internal use.
NAMEVARCHAR (254) NOT NULLReserved for HCL internal use.
OFFERLIMITINTEGERReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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