Table | petitions |
|---|---|
Description | Petitions |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
enrollment_flow_id | integer, foreign key | Enrollment Flow ID | | ||
| status | varchar(2) | Enrollment Flow Step status |
| | |
| cou_id | integer, foreign key | COU ID | cous:id | ||
| enrollee_email | varchar(256) | Email address to be used for handoff to the Enrollee | RFC 5321 Mailbox format | This address does not automatically get added to email_addresses | |
| enrollee_identifier | varchar(256) | Authenticated identifier for Enrollee received as part of user authentication | |||
| enrollee_person_id | integer, foreign key | Enrollee Person ID | people:id | ||
| petitioner_identifier | varchar(256) | Authenticated identifier for Petitioner received as part of user authentication | |||
| petitioner_person_id | integer, foreign key | Petitioner Person ID | people:id | ||
| token | varchar(256) | For unauthenticated enrollments, token used to verify Enrollee requests | Will also be used for Petitioner when the Enrollee is also the Petitioner |