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