Table | history_records |
|---|---|
Description | Transaction history (human readable) |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID change applied to | people:id | At least one entity foreign key is required | |
| person_role_id | integer, foreign key | Person Role ID change applied to | person_roles:id | At least one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID change applied to | external_identities:id | At least one entity foreign key is required | |
| external_identity_role_id | integer, foreign key | External Identity Role ID change applied to | external_identity_roles:id | At least one entity foreign key is required | |
| group_id | integer, foreign key | Group ID change applied to | groups:id | At least one entity foreign key is required | |
| actor_person_id | integer, foreign key | Person ID who executed or requested this change | people:id | ||
| actor_api_user_id | integer, foreign key | API User ID that executed or requested this change | api_users:id | ||
action | varchar(4) | Machine readable transaction code | ActionEnum | Local action codes should begin with X, plugin action codes should begin with p | |
comment | varchar(256) | Human readable transaction description |