Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
---|---|---|---|---|---|
JPVA_OH_Idnr | int | NUMBER(38,0) | int | false | OH_Idnr of Process Flow |
JPVA_JPP_Lnr | smallint | NUMBER(38,0) | smallint | false | Task Lnr |
JPVA_OPU_Lnr | smallint | NUMBER(38,0) | smallint | false | OPU_Lnr |
JPVA_JPPV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Value Name or Prompt Set Element Variablen Name |
JPVA_Lnr | int | NUMBER(38,0) | int | false | Ascending number (index of array) |
JPVA_Value | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 1024 COMPACT | true | Value = Caption on MULTI+Array (Checkbox, Checklist) |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_JPVA | JPVA_OH_Idnr, JPVA_JPP_Lnr, JPVA_OPU_Lnr, JPVA_JPPV_VName, JPVA_Lnr | true | true | true | false |
Name | Local References | Foreign References |
---|---|---|
FK_JPVA_JPPV | JPVA_OH_Idnr, JPVA_JPP_Lnr, JPVA_OPU_Lnr, JPVA_JPPV_VName | JPPV_OH_Idnr, JPPV_JPP_Lnr, JPPV_OPU_Lnr, JPPV_VName |
Return to the Index File