StatusValue Table (199)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
Values for statuses
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| StatusValue_id | Primary key | PK | |
| StatusDef_id | Link to statusdefinition | FK StatusDef | |
| contact_id | Link to contact, 0 if this status is not for contacts | FK contact | |
| person_id | Link to person, 0 if this status is not for person (always 0 in 6.0) | FK person | |
| project_id | Link to project, 0 if this status is not for project | FK project | |
| extra1_id | Spare ID for future links | Id | |
| extra2_id | Spare ID for future links | Id | |
| isSignalled | 1 = this status is 'true', and the GUI should display it | Bool | |
| 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 | |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| StatusValue_id | PK | Clustered, Unique |
| 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
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
| project | Projects |
| StatusDef | Status definitions. Name and description are in LocaleText for internationalization |
Replication Flags
- None
Security Flags
- No access control via user's Role.