| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| OV_OH_Idnr | int | NUMBER(38,0) | int | false | Reference to OH |
| OV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Value Name |
| OV_Value | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 30000 COMPACT | true | Value |
| OV_ERTUsage | smallint | NUMBER(38,0) | smallint | true | Defines how this value is used in ERT calculation (0=No ERT usage, 1=Nominal, 2=Numeric, 3=Timestamp, 4=Date, 5=Time) |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_OV | OV_OH_Idnr, OV_VName | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_OV_OH | OV_OH_Idnr | OH_Idnr |
Return to the Index File