MEMBRAUCT

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
AUCT_IDBIGINT NOT NULLReserved for HCL internal use.
MEMBER_IDBIGINT NOT NULLReserved for HCL internal use.
RELATIONTYPECHAR (10) NOT NULLReserved for HCL internal use.
STATUSCHAR (4)Reserved for HCL internal use.
COMMENTSVARCHAR (254)Reserved for HCL internal use.
FIELD1BIGINTReserved for HCL internal use.
FIELD2BIGINTReserved for HCL internal use.
FIELD3BIGINTReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>AUCT_ID+MEMBER_ID+RELATIONTYPEPrimary Key
I0000154RELATIONTYPENon-Unique Index
I0000155STATUSNon-Unique Index
I0000618MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_457AUCT_IDAUCTIONAUCT_IDCascade
F_458MEMBER_IDMEMBERMEMBER_IDCascade