Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
---|---|---|---|---|---|
ODOC_Name | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | false | name of the documentation or name of a subcomponent (CIT) |
ODOC_OH_Idnr | int | NUMBER(38,0) | int | false | reference to the object header (OH) |
ODOC_Lnr | int | NUMBER(38,0) | int | false | block number |
ODOC_Type | smallint | NUMBER(38,0) | smallint | true | Type of Content: 1=directory.xml, 2=subcomponent.xml, 3=connection.xml |
ODOC_Content | varbinary(4096) | BLOB | varchar(4096) for bit data | true | 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