WebAppUsage Table (249)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Usage statistics for web applications
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| WebAppUsage_id | Primary key | PK | |
| version | Version number of usage stats | UInt | |
| assocId | ID of associate | FK associate | |
| timestamp | Time stamp of operation | DateTime | |
| viewState | Current view state, excluding data | String(254) | |
| aggregateBin | Bin no. If this is aggregated data | UInt | ● |
| aggregateCount | Bin count, if this is aggregated data | UInt | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| WebAppUsage_id | PK | Clustered, Unique |
| viewState, timestamp, assocId | String(254), DateTime, FK | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
Replication Flags
- None
Security Flags
- No access control via user's Role.