Updated: 2016-04-14

Version: Control 5.7

Table Purpose, Usage, and Notes

This table stores the proof files for each Artwork Group.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • xxxxx -

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
ArtworkProofFile.ArtworkItemID Int The ArtworkItem this proof file is associated with. ArtworkItem.ID
ArtworkProofFile.ClassTypeID SmallInt
ArtworkProofFile.FileAddedDT Smalldatetime The datetime the proof file was added to the artwork item either manually or by discovery of the file monitoring system. (e: This is the created date of the file.)
ArtworkProofFile.FileDeletedDT Smalldatetime The datetime the file was deleted or discovered missing on the drive.
ArtworkProofFile.FileFoundOnDrive Bit A Boolean flag to indicate if the file exists on the drive.
ArtworkProofFile.FileModifiedDT Smalldatetime The datetime the file was last modified on the drive. This date is pulled from the file itself.
ArtworkProofFile.FileSizeInKB Int The size of the file, rounded up to the next highest KB.
ArtworkProofFile.HasLowRes Computed bit A computed Boolean field indicating if the file has a Low Res image on the file system.
ArtworkProofFile.HasPDF Computed bit A computed Boolean field indicating if the file has a PDF image on the file system.
ArtworkProofFile.HasThumbnail Computed bit A computed Boolean field indicating if the file has a thumbnail image on the file system.
ArtworkProofFile.ID Int PRIMARY KEY
ArtworkProofFile.ImageHeight Smallint The height of the image in pixels.
ArtworkProofFile.ImageWidth Smallint The width of the image in pixels.
ArtworkProofFile.IsLatestVersion Bit A Boolean flag to indicate if this version is the latest version for that artwork item
ArtworkProofFile.IsManuallyAdded Bit A Boolean flag to indicate if the file was manually added by the user (1) or was automatically added by the file monitoring system (0)
ArtworkProofFile.LowResFileName Varchar(265) The name and extension of the Low Resolution file image if it exists.
ArtworkProofFile.PDFFileName Varchar(265) The name and extension of the PDF file image if it exists.
ArtworkProofFile.SeqID Smallint
ArtworkProofFile.ThumbnailFileName Varchar(265) The name and extension of the thumbnail file image if it exists.
ArtworkProofFile.Version Tinyint The version of the ArtworkItem this proof file represents.
ArtworkProofFile.VersionFileName Varchar(256) The file name of this current version of the ArtworkItem.

Related Tables

You could leave a comment if you were logged in.