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 |