Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AV_AH_Idnr int NUMBER(38,0) int int false Reference to AH
AV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Value Name
AV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 30000 COMPACT text true Value
AV_Source smallint NUMBER(38,0) smallint smallint true Value's source (0 own, 1 parent, 2 modified during runtime)
AV_SortOrder smallint NUMBER(38,0) smallint smallint true Sort order
AV_ERTUsage smallint NUMBER(38,0) smallint 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_AV AV_AH_Idnr, AV_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_AV_AH AV_AH_Idnr AH_Idnr

Return to the Index File