Name Type MSSql Type Oracle Type DB2 Nullable Description
OBLOB_OH_Idnr int NUMBER(38,0) int false Reference to OH
OBLOB_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) false Name of Component
OBLOB_Type smallint NUMBER(38,0) smallint false Type of Content (1=component.jar, 3=storage.xml)
OBLOB_ContentLen int NUMBER(38,0) int true Length of content
OBLOB_Content varbinary(max) BLOB blob(128 M) INLINE LENGTH 20000 COMPACT true Content (jar)
OBLOB_ModDate datetime DATE timestamp true Modification time of resource within STORE object
OBLOB_Filename varchar(512) VARCHAR2 (512 CHAR) varchar(512) true Filename the resource will have in target filesystem
OBLOB_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) false Restrict resource to particular operating systems (WINDOWS, UNIX)
OBLOB_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Restrict resource to particular software (i.e. operating system)
OBLOB_Usage char (1) CHAR (1 CHAR) char(1) true Defines whether this resource has to be stored in client or task cache (T=task, C=client)
OBLOB_ReplaceVar smallint NUMBER(38,0) smallint true Replace Variables in this resource (Text only?)
OBLOB_FileType char (1) CHAR (1 CHAR) 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) true Here are the Checksum
OBLOB_Version varchar (512) VARCHAR2 (512 CHAR) varchar(512) true Here are the Version
OBLOB_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Restrict resource to particular hardware

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