Name Type MSSql Type Oracle Type DB2 Nullable Description
OVW_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OVW_VValue varchar (200) VARCHAR2 (200 CHAR) varchar(200) false validity value
OVW_OH_Client smallint NUMBER(38,0) smallint true client
OVW_VRName varchar (4) VARCHAR2 (4 CHAR) varchar(4) true name of the validity range
OVW_Value1 varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true String representation of value column 1
OVW_Value2 varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true String representation of value column 2
OVW_Value3 varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true String representation of value column 3
OVW_Value4 varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true String representation of value column 4
OVW_Value5 varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true String representation of value column 5
OVW_ValueX xml XMLTYPE xml true XML data value

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OVW_VValue OVW_OH_Client, OVW_VRName, OVW_VValue false false false false
PK_OVW OVW_OH_Idnr, OVW_VValue true true true false
NK_OVW_VRNAME OVW_VRNAME false false false false

Foreign Keys:

Name Local References Foreign References
FK_OVW_OH OVW_OH_Idnr OH_Idnr

Return to the Index File