StatusValue Table (199)
Values for statusesFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| StatusValue_id | Primary key | PK | No |
| StatusDef_id | Link to statusdefinition | FK StatusDef | No |
| contact_id | Link to contact, 0 if this status is not for contacts | FK contact | No |
| person_id | Link to person, 0 if this status is not for person (always 0 in 6.0) | FK person | No |
| project_id | Link to project, 0 if this status is not for project | FK project | No |
| extra1_id | Spare ID for future links | Id | No |
| extra2_id | Spare ID for future links | Id | No |
| isSignalled | 1 = this status is ‘true’, and the GUI should display it | Bool | No |
| needsUpdate | 1 = the value is dirty and needs updating; set when the target (contact, project) is changed (or its activities and sales are changed) | Bool | No |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
Indexes
| Fields | Types | Description |
|---|---|---|
| StatusDef_id | FK | Index |
| contact_id | FK | Index |
| person_id | FK | Index |
| project_id | FK | Index |
| extra1_id | Id | Index |
| extra2_id | Id | Index |
| isSignalled | Bool | Index |
| contact_id, isSignalled, StatusDef_id | FK, Bool, FK | Index |
| person_id, isSignalled, StatusDef_id | FK, Bool, FK | Index |
| project_id, isSignalled, StatusDef_id | FK, Bool, FK | Index |
| extra1_id, isSignalled, StatusDef_id | Id, Bool, FK | Index |
| extra2_id, isSignalled, StatusDef_id | Id, Bool, FK | Index |
Relationships
Replication Flags
- None
Security Flags
- No access control via user’s Role.