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.