Name Type MSSql Type Oracle Type DB2 Nullable Description
EV_AH_Idnr int NUMBER(38,0) int false Reference to AH
EV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Value Name
EV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 30000 COMPACT true Value
EV_Source smallint NUMBER(38,0) smallint true Value's source (0 own, 1 parent, 2 modified during runtime)
EV_SortOrder smallint NUMBER(38,0) smallint true Sort order
EV_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_EV EV_AH_Idnr, EV_VName true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File