Table | ad_hoc_attributes |
|---|---|
Description | Ad Hoc Attributes for an Entity |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:id | Exactly one entity foreign key is required | |
| person_role_id | integer, foreign key | Person Role ID | person_roles:id | Exactly one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:id | Exactly one entity foreign key is required | |
| external_identity_role_id | integer, foreign key | External Identity Role ID | external_identity_roles:id | Exactly one entity foreign key is required | |
| tag | varchar(128) | Attribute Tag | Key is a reserved word for MySQL, so this column is called Tag. | ||
| value | varchar(256) | Attribute Value | |||
| source_ad_hoc_attributes_id | integer, foreign key | External Identity Ad Hoc Attribute that was the source for this Ad Hoc Attribute | ad_hoc_attributes:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|