Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each activity record, auto-incrementing integer |
|
| Company | nvarchar | 200 | √ | null |
|
|
Company name - Display name of the company associated with this user activity |
|
| Type | nvarchar | 200 | √ | null |
|
|
Activity type - Classification of the type of activity performed |
|
| Feature | nvarchar | 200 | √ | null |
|
|
Feature name - Specific feature or functionality that was accessed or used |
|
| FeatureType | nvarchar | 200 | √ | null |
|
|
Feature category - Category or type classification of the feature used |
|
| UserId | int | 4 | √ | null |
|
|
User identifier - Reference to the user who performed this activity |
|
| Name | nvarchar | 200 | √ | null |
|
|
User name - Display name of the user for activity reporting |
|
| nvarchar | 200 | √ | null |
|
|
User email - Email address of the user for identification and communication |
||
| Date | datetime | 16,3 | √ | null |
|
|
Activity timestamp - When this activity occurred for chronological tracking |
|
| CompanyId | nvarchar | 60 | √ | null |
|
|
Company identifier - Numeric reference to the company for multi-tenant activity tracking |
|
| IPAddress | nvarchar | 60 | √ | null |
|
|
IP address - Network IP address from which the activity originated for security tracking |
|
| InternalAgencyID | int | 4 | √ | null |
|
|
Internal agency ID - Reference to internal agency for organizational activity tracking |
|
| App | nvarchar | 200 | √ | null |
|
|
Application name - Name of the application or module where the activity occurred |
|
| SystemId | int | 4 | √ | null |
|
|
System identifier - Reference to system or environment where activity took place |
|
| CaseName | varchar | 100 | √ | null |
|
|
Case name - Name of case or project associated with this activity |
|
| CaseId | int | 4 | √ | null |
|
|
Case identifier - Reference to case or project for activity context |
|
| Url | varchar | 200 | √ | null |
|
|
Activity URL - URL or page where the activity occurred for navigation tracking |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__UserActi__3214EC276F7F8B4B | Primary key | Asc | ID |