MEMBRAUCT

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

Column Descriptions:

NameTypeDescription
AUCT_IDBIGINT NOT NULLReserved for IBM internal use.
MEMBER_IDBIGINT NOT NULLReserved for IBM internal use.
RELATIONTYPECHAR (10) NOT NULLReserved for IBM internal use.
STATUSCHAR (4)Reserved for IBM internal use.
COMMENTSVARCHAR (254)Reserved for IBM internal use.
FIELD1BIGINTReserved for IBM internal use.
FIELD2BIGINTReserved for IBM internal use.
FIELD3BIGINTReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM 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