Updated: 2016-04-15

Version: Control 5.7

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • xxxxx -

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
ClassTypeID SmallInt
CurrentVersion Tinyint The version number for this artwork item. This number is incremented for each new version of the software.
Description Varchar(255) The user-entered description for this artwork item.
GroupID Int The ID for the parent Artwork Group. ArtworkGroup.ID
ID Int ID of the Artwork Item
IsActive Bit Indicates if this record is active. Users may set artwork items inactive manually. Non-chosen artwork in an Artwork Choice Group is automatically set to inactive upon approval.
ItemIndex Tinyint The index of this Artwork Item amongst its peers when an Artwork Group has multiple artwork items.
ModifiedByComputer varchar(25) The windows computer name of the last user who modified this record
ModifedByUser Varchar(25) The user name of the last user who modified this record
ModifiedDate Smalldatetime The datetime this record was last modified.
OriginalFileName Varchar(255) This original file name of the artwork item, before the file name was changed for versioning. This does not include the file path, but does include the extention.
SeqID Smallint

Related Tables

You could leave a comment if you were logged in.