Table | vecifications |
|---|---|
Description | Verifications |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| code | varchar(32) | Verification Code | |||
| verification_time | datetime | The time of verification | |||
| request_expiration_time | datetime | The expiration time of a verification request | |||
| method | varchar(2) | Verification Method |
| ||
| trusted_source | varchar(128) | For Trusted Source verifications, a description of the Trusted Source | |||
| email_address_id | integer, foreign key | Email Address verified by this Verification | email_addresses:id | ||
| petition_id | integer, foreign key | Petition associated with this Verification | petitions:id |