| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| jobs_id |
Foreign key of the job this contact is linked to. |
globally unique identifier | |
| contact_id |
Foreign key of the linked contact. |
globally unique identifier | |
| firstname |
First name of the contact (denormalized copy of the contact record). |
string | |
| lastname |
Last name of the contact (denormalized copy of the contact record). |
string | |
| phone |
Phone number of the contact (denormalized copy of the contact record). |
string | |
| mobile |
Mobile phone number of the contact (denormalized copy of the contact record). |
string | |
|
Email address of the contact (denormalized copy of the contact record). |
string | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |