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.