Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkTrackingFieldID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each tracking field definition |
|
| fkCategory | int | 4 | √ | null |
|
|
Category reference - Links to tracking field category for organization |
|
| TrackingFieldName | nvarchar | 510 | √ | null |
|
|
Field name - Descriptive name of the tracking field |
|
| TrackingFieldDesc | nvarchar | 510 | √ | null |
|
|
Field description - Detailed description of the tracking field purpose |
|
| TableNameLink | nvarchar | 100 | √ | null |
|
|
Linked table - Database table that this tracking field is associated with |
|
| FieldNameLink | nvarchar | 100 | √ | null |
|
|
Linked field - Specific field in the linked table that triggers tracking |
|
| AutoCreateTrigger | int | 4 | √ | null |
|
|
Auto-create trigger - Flag indicating if tracking records are automatically created |
|
| AutoDueExpireDateTrigger | int | 4 | √ | null |
|
|
Auto due date trigger - Flag for automatic due date calculation |
|
| AutoTargetTrigger | int | 4 | √ | null |
|
|
Auto target trigger - Flag for automatic target date calculation |
|
| DueExpireTableLink | int | 4 | √ | null |
|
|
Due date table link - Table reference for due date calculations |
|
| DueExpireFieldLink | int | 4 | √ | null |
|
|
Due date field link - Field reference for due date calculations |
|
| DueExpireDateIncType | int | 4 | √ | null |
|
|
Due date increment type - Type of increment for due date calculation (days, months, etc.) |
|
| DueExpireDateIncValue | int | 4 | √ | null |
|
|
Due date increment value - Number of units to add for due date calculation |
|
| VAL_EditDueExpireDate | int | 4 | √ | null |
|
|
Edit due date permission - Flag indicating if due dates can be manually edited |
|
| TargetIncType | varchar | 50 | √ | null |
|
|
Target increment type - Type of increment for target date calculation |
|
| TargetIncValue | int | 4 | √ | null |
|
|
Target increment value - Number of units to add for target date calculation |
|
| VAL_EditTargetDate | int | 4 | √ | null |
|
|
Edit target date permission - Flag indicating if target dates can be manually edited |
|
| AutoRepeatFieldWhenClosed | nvarchar | 510 | √ | null |
|
|
Auto-repeat configuration - Configuration for automatically creating new tracking records when closed |
|
| TrackingFieldOrder | int | 4 | √ | null |
|
|
Display order - Order for displaying tracking fields in user interface |
|
| VAL_DeleteTrackingValueRecord | int | 4 | √ | null |
|
|
Delete permission - Flag indicating if tracking records can be deleted |
|
| TrackingFieldIMPORTID | nvarchar | 510 | √ | null |
|
|
Import identifier - Reference ID for data migration and import tracking |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this tracking field |
|
| CreatedDate | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when the tracking field was created |
|
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by user - UserID of the person who last modified this tracking field |
|
| ModifiedDate | smalldatetime | 16 | √ | null |
|
|
Modification date - Timestamp of the most recent modification |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_TrackingFields | Primary key | Asc | pkTrackingFieldID |
Relationships
Close relationships within degrees of separation
