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
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