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 | |
| co_email_list_id | integer, foreign key | CO Email List ID change applied to | cm_co_email_lists:id | |
| co_service_id | integer, foreign key | CO Service ID change applied to | cm_co_services:id | Added Registry v3.3.0 |
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 |