Task Table
- Daniel Layne
- Matt Sullivan (Unlicensed)
Column | Type | Description |
|---|---|---|
Task_Id | Integer | The PK of this task |
Relationship_Id | Integer | The FK to the relationship related to this task |
Opportunity_Id | Integer | The FK to the opportunity related to this task |
Contract_Id | Integer | The FK to the contract related to this task |
Proposal_Id | Integer | The FK to the proposal related to this task |
Order_Id | Integer | The FK to the order related to this task |
Salesperson_Id | Integer | The FK to the salesperson related to this task |
Responsible_User_Id | Integer | The FK to the responsible user related to this task |
User_Group_Id | Integer | The FK to the user group related to this task |
Working_User_Id | Integer | The FK to the working user related to this task |
Salesperson_Name | String(255) | The name of the salesperson that owns the opportunity or relationship that this is is related to |
Deferral_Count | Integer | The number of times this task has been deferred |
Completed | Boolean | True = task completed |
Completion_Date | Timestamp | When this task was completed |
Creation_Date | Timestamp | When this record was created |
Last_Update_Date | Timestamp | When this record was last updated |
Comments | String(255) | Comments for this task |