Contact Table
- Daniel Layne
Column | Type | Description |
|---|---|---|
Contact_Id | Integer | PK of the contact |
Relationship_Id | Integer | FK to the relationship that owns this contact |
Relationship_Name | String(255) | The name of the owning relationship |
Salesperson_Id | Integer | FK to the user that owns this contact |
Salesperson_Name | String(255) | The name of the owning salesperson |
Forename | String(255) | The contact’s forename (aka given name/first name) |
Middlename | String(255) | The contact’s middle name |
Surname | String(255) | The contact’s surname (aka family name) |
Position | String(255) | The contact’s position (job title) within the owning relationship |
Primary_Flag | Boolean | True = this is the primary/default contact within the owning relationship |
Director_Flag | Boolean | True = this contact is a director of the owning company |
Psc_Flag | Boolean | True = this contact is a Personal of Significant Control of the owning company |
Telephone_Number | String(30) | Telephone number of the contact |
Telephone_Number_2 | String(30) | Secondary telephone number of the contact |
Mobile_Number | String(30) | Mobile (cell) number of the contact |
Telephone_Number_Call_Flag | Boolean | True = the telephone number can be called for marketing purposes |
Telephone_Number_2_Call_Flag | Boolean | True = the secondary telephone number can be called for marketing purposes |
Mobile_Number_Call_Flag | Boolean | True = the mobile number can be called for marketing purposes |
Last_Callable_Check_Date | Timestamp | The date the TPS/CTPS databases were last checked to establish the Call_Flag values |
Email_Address | String(100) | The email address for the contact |
Creation_Date | Timestamp | The date this record was created |
Last_Update_Date | Timestamp | The date this record was updated |