{$page}
Updated: 2016-04-15
Version: Control 5.7
Table Purpose, Usage, and Notes
This table stores the history of all artwork status changes for an Artwork group. Each change of the artwork group status results in a record in the ArtworkGroupStatusHistory table. No history record is created for the initial creation of the Artwork Group.
Information on Table Data
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| ArtworkGroupStatusHistory.ArtworkGroupID | Int | The artwork group the status change was for. | ArtworkGroup.ID | ||||
| ArtworkGroupStatusHistory.ClassTypeID | SmallInt | ||||||
| ArtworkGroupStatusHistory.FromStatusID | Tinyint | The pre-change status ID of the artwork group. | _ArtworkStatus.ID | ||||
| ArtworkGroupStatusHistory.ID | Int PRIMARY KEY | ||||||
| ArtworkGroupStatusHistory.PlayerID | Int | The ID of the player who initiated the change. If the user making the change is not already a player, an adhoc player record is created. | ArtworkPlayer.ID | ||||
| ArtworkGroupStatusHistory.SeqID Small | int | ||||||
| ArtworkGroupStatusHistory.StatusDT | Smalldatetime | The datetime of the status change. | |||||
| ArtworkGroupStatusHistory.ToStatusID | Tinyint | The post-change status ID of the artwork group. | _ArtworkStatus.ID |
Related Tables
See Also