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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000151 | NAME | Unique Index |
SQL030416034956230 | MBRATTR_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_438 | ATTRTYPE_ID | ATTRTYPE | ATTRTYPE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_442 | MBRATTR_ID | MBRATTRVAL | MBRATTR_ID | Cascade |