Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
ODOC_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Name of the documentation tab or the sub-component (RA only).
ODOC_OH_Idnr int NUMBER(38,0) int int false ID of the object.
ODOC_Lnr int NUMBER(38,0) int int false Block number.
ODOC_Type smallint NUMBER(38,0) smallint smallint true Type of content. 1 = directory, 2 = sub-component, 3 = connection
ODOC_Content varbinary(4096) BLOB varchar(4096) for bit data bytea true The content (text or XML).
ODOC_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if ODOC_Content is stored in UTF-8 (1) or legacy encoding (0)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_ODOC ODOC_OH_Idnr, ODOC_Name, ODOC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_ODOC_OH ODOC_OH_Idnr OH_Idnr

Return to the Index File