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)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OV OV_OH_Idnr, OV_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_OV_OH OV_OH_Idnr OH_Idnr

Return to the Index File