History Table (53)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
History lists for lists and searchable controls. Maintains history for Navigator or other search (find dialogs). A single table may have more than one record here, as indicated by the extra_id field. The HistorySize (preference may be set in maintenance client) defines how many records you can have in a history list.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| history_id | Primary key | PK | |
| associate_id | Owner of history list | FK associate | |
| table_id | Table this is a history of | TableNumber | |
| record_id | Record within the table | RecordId | |
| extra_id | Extra ID, used to manage multiple histories per table | Id | |
| rank | Sort order, indexed so it can used for sorting in the query | UShort | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| history_id | PK | Clustered, Unique |
| rank | UShort | Index |
| associate_id, table_id, extra_id | FK, TableNumber, Id | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
Replication Flags
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.