MBRATTR

This table contains the custom member attributes available to be assigned to users and organizations.

Column Descriptions:

NameTypeDescription
MBRATTR_IDBIGINT NOT NULLPrimary key of this MBRATTR table.
ATTRTYPE_IDCHAR (16) NOT NULLType of the member attribute. Foreign key to the ATTRTYPE table.
NAMEVARCHAR (254) NOT NULLName of the member attribute.
DESCRIPTIONVARCHAR (254)Description of the member attribute.
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>MBRATTR_IDPrimary Key
I0000151NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_438ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_442MBRATTR_IDMBRATTRVALMBRATTR_IDCascade