Table | cm_co_invites |
|---|---|
Description | Per-CO invitations to join |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
co_person_id | integer, foreign key | CO Person Record ID | cm_co_people:id | |
varchar(256) | Email address invited | cm_email_addresses:mail | Copied rather than linked since the linked reference could change | |
| skip_invite | boolean | Whether to skip the invitation step due to an already verified email address being present | Added in Registry v4.0.0 as a workaround for SkipIfVerified mode | |
email_address_id | integer, foreign key | Email Address ID to confirm | If set, the invite is intended to verify the linked email address | |
invitation | varchar(16) | Randomly generated activation key | ||
expires | datetime | Time at which invitation is no longer valid |