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 | |
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 |
|
|