Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
ABLOB_AH_Idnr int NUMBER(38,0) int int false Reference to AH
ABLOB_Key varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Individual Key
ABLOB_Content varbinary(max) BLOB blob(128 M) INLINE LENGTH 20000 COMPACT bytea true Content
ABLOB_OH_Idnr int NUMBER(38,0) int int false Reference to STORE Object
ABLOB_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Name of component/resource, Reference to OBLOB_Name
ABLOB_OH_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of STORE Object
ABLOB_ModCnt smallint NUMBER(38,0) smallint smallint true Modification count of object (OH_ModCnt).
ABLOB_Type smallint NUMBER(38,0) smallint smallint true Type of Content (1=component.jar, 3=storage.xml)
ABLOB_ModDate datetime DATE timestamp timestamp true Modification time of resource within STORE object
ABLOB_Filename varchar(512) VARCHAR2 (512 CHAR) varchar(512) varchar(512) true Filename the resource will have in target filesystem
ABLOB_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Restrict resource to particular operating systems (WINDOWS, UNIX)
ABLOB_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Restrict resource to particular software (i.e. operating system)
ABLOB_Usage char (1) CHAR (1 CHAR) char(1) char (1) true Defines whether this resource has to be stored in client or task cache (T=task, C=client)
ABLOB_ReplaceVar smallint NUMBER(38,0) smallint smallint true Replace Variables in this resource (Text only?)
ABLOB_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)
ABLOB_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Restrict resource to particular hardware
ABLOB_Version smallint NUMBER(38,0) smallint smallint true AE system version

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_ABLOB ABLOB_AH_Idnr, ABLOB_Key, ABLOB_OH_Idnr, ABLOB_Name true true true false

Foreign Keys:

Name Local References Foreign References
FK_ABLOB_AH ABLOB_AH_Idnr AH_Idnr

Return to the Index File