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
- ClassTypeIDs Stores in Table:
- xxxxx -
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
You could leave a comment if you were logged in.