Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Primary key |
||
| name_a_b | VARCHAR | 64 | √ | null |
|
|
name for relationship of contact_a to contact_b. |
|
| name_b_a | VARCHAR | 64 | √ | null |
|
|
Optional name for relationship of contact_b to contact_a. |
|
| contact_type_a | VARCHAR | 12 | √ | null |
|
|
If defined, contact_a in a relationship of this type must be a specific contact_type. |
|
| contact_type_b | VARCHAR | 12 | √ | null |
|
|
If defined, contact_b in a relationship of this type must be a specific contact_type. |
|
| contact_sub_type_a | VARCHAR | 64 | √ | null |
|
|
If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type. |
|
| contact_sub_type_b | VARCHAR | 64 | √ | null |
|
|
If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type. |
|
| is_reserved | TINYINT | 3 | √ | null |
|
|
Is this relationship type a predefined system type (can not be changed or de-activated)? |
|
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is this relationship type currently active (i.e. can be used when creating or editing relationships)? |
|
| label_a_b | VARCHAR | 64 | √ | null |
|
|
||
| label_b_a | VARCHAR | 64 | √ | null |
|
|
||
| description | VARCHAR | 255 | √ | null |
|
|