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