Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OBLOB_OH_Idnr int NUMBER(38,0) int int false ID of the object.
OBLOB_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Name of the content.
OBLOB_Type smallint NUMBER(38,0) smallint smallint false Type of the content. 1 = Component, 3 = Storage, 4 = public certificate of the AE
OBLOB_ContentLen int NUMBER(38,0) int int true Length of the content.
OBLOB_Content varbinary(max) BLOB blob(128 M) INLINE LENGTH 20000 COMPACT bytea true Content.
OBLOB_ModDate datetime DATE timestamp timestamp true Modification timestamp of the resource within the object.
OBLOB_Filename varchar(1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar(1024) true Defines the file name the resource will have on the target file system.
OBLOB_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) false Restrict the resource to a particular operating systems.
OBLOB_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Restrict the resource to a particular software.
OBLOB_Usage char (1) CHAR (1 CHAR) char(1) char (1) true Defines whether or not this resource has to be stored in the client or task cache. T = Task, C = Client
OBLOB_ReplaceVar smallint NUMBER(38,0) smallint smallint true Replace variables in this resource. Textual content only.
OBLOB_FileType char (1) CHAR (1 CHAR) char(1) char (1) true The data representation type used for data transfer and storage. T = Text, B = Binary
OBLOB_Checksum varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true Checksum of the content.
OBLOB_Version varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true Version of the content.
OBLOB_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Restrict the resource to a particular hardware.
OBLOB_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if OBLOB_Content is stored in UTF-8 (1) or legacy encoding (0)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OBLOB OBLOB_OH_Idnr, OBLOB_Name, OBLOB_HostAttrType, OBLOB_SW, OBLOB_HW true true true false

Foreign Keys:

Name Local References Foreign References
FK_OBLOB_OH OBLOB_OH_Idnr OH_Idnr

Return to the Index File