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). |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_ODOC | ODOC_OH_Idnr, ODOC_Name, ODOC_Lnr | true | true | true | false |
Name | Local References | Foreign References |
---|---|---|
FK_ODOC_OH | ODOC_OH_Idnr | OH_Idnr |
Return to the Index File