Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EJPVA_AH_Idnr int NUMBER(38,0) int int false RunID
EJPVA_EJPP_Lnr smallint NUMBER(38,0) smallint smallint false Task Lnr
EJPVA_OPU_Lnr smallint NUMBER(38,0) smallint smallint false OPU_Lnr
EJPVA_EJPPV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Value Name or Prompt Set Element Variablen Name
EJPVA_Lnr int NUMBER(38,0) int int false Ascending number (index of array)
EJPVA_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true Value = Caption on MULTI+Array (Checkbox, Checklist)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EJPVA EJPVA_AH_Idnr, EJPVA_EJPP_Lnr, EJPVA_OPU_Lnr, EJPVA_EJPPV_VName, EJPVA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File