Table | petition_history_records |
|---|---|
Description | Petition Transaction History |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| petition_id | integer, foreign key | Petition ID | petitions:id | | |
| enrollment_flow_step_id | integer, foreign key | Enrollment Flow Step ID | enrollment_flow_steps:id | | |
| action | varchar(4) | Machine readable transaction code | PetitionActionEnum | | Local action codes should begin with X, plugin action codes should begin with p |
| comment | varchar(256) | Human readable transaction comment | | ||
| actor_person_id | integer, foreign key | Actor Person ID | people:id |