Table | cm_history |
|---|---|
Description | Transaction history (human readable) |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
co_person_id | integer, foreign key | CO Person Record ID change applied to | cm_co_people:id |
|
co_person_role_id | integer, foreign key | CO Person Role Record ID change applied to |
| |
org_identity_id | integer, foreign key | Organizational Identity Record ID change applied to |
| |
| co_group_id | integer, foreign key | CO Group Record ID change applied to | cm_co_group_members:id | |
actor_co_person_id | integer, foreign key | CO Person who executed or requested this change | cm_co_people:id |
|
action | varchar(4) | Machine readable transaction code | As defined in ActionEnum | Local history should be identified with an action code beginning with the letter 'X'. |
comment | varchar(160) | Human readable transaction description |
|
|