Database Table: MBRATTR

This table contains an attribute definition dictionary for members.

Column Name Column Type Column Description
ATTRTYPE_ID CHARACTER (16)
NOT NULL
Type of the member attribute. Foreign key to the ATTRTYPE table.
DESCRIPTION VARCHAR (254)
NULL
Description of the member attribute.
MBRATTR_ID BIGINT
NOT NULL
Primary key of this MBRATTR table.
NAME VARCHAR (254)
NOT NULL
Name of the member attribute.
Indexes:
Index Name Indexed Column Names Index Type
I0000151 NAME Unique Index
SQL030416034956230 MBRATTR_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_438 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_442 MBRATTR_ID MBRATTRVAL MBRATTR_ID Cascade