| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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_en_US | VARCHAR | 64 | √ | null |
|
|
||||||
| label_b_a_en_US | VARCHAR | 64 | √ | null |
|
|
||||||
| description_en_US | VARCHAR | 255 | √ | null |
|
|
||||||
| label_a_b_fr_CA | VARCHAR | 64 | √ | null |
|
|
||||||
| label_b_a_fr_CA | VARCHAR | 64 | √ | null |
|
|
||||||
| description_fr_CA | VARCHAR | 255 | √ | null |
|
|
Showing 1 to 15 of 15 entries
