Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AJPVA_AH_Idnr int NUMBER(38,0) int int false RunID
AJPVA_AJPP_Lnr smallint NUMBER(38,0) smallint smallint false Task Lnr
AJPVA_OPU_Lnr smallint NUMBER(38,0) smallint smallint false OPU_Lnr
AJPVA_AJPPV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Value Name or Prompt Set Element Variablen Name
AJPVA_Lnr int NUMBER(38,0) int int false Ascending number (index of array)
AJPVA_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_AJPVA AJPVA_AH_Idnr, AJPVA_AJPP_Lnr, AJPVA_OPU_Lnr, AJPVA_AJPPV_VName, AJPVA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPVA_AJPPV AJPVA_AH_Idnr, AJPVA_AJPP_Lnr, AJPVA_OPU_Lnr, AJPVA_AJPPV_VName AJPPV_AH_Idnr, AJPPV_AJPP_Lnr, AJPPV_OPU_Lnr, AJPPV_VName

Return to the Index File