StatusValue Table (199)

•
Environment: onsite, online
• 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

StatusValue table relationship diagram

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.
person Persons
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.