Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

GenFileBlob

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table stores general file data.

Field Datatype Default Null Option Comment
GenFileSID INTEGER ?   MANDATORY General file unique identifier. The unique identifier is obtained from the GENERAL sequence.
ExtentCount INTEGER 0   MANDATORY System generated count for extents of data that makes up a file in raw data format.
RawData raw   OPTIONAL Data portion of file. This will store the data in a binary format.
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
GenFile GenFileBlob.GenFileSID = GenFile.GenFileSID CASCADE if GenFileBlob exists

Child Tables
Child TableJoin PhraseWhen deleting GenFileBlob record...