Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AJPOV_AH_Idnr int NUMBER(38,0) int int false reference to the archive header (AH) (RunID)
AJPOV_AJPP_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the jobplan process (Task Lnr)
AJPOV_Location smallint NUMBER(38,0) smallint smallint false 1=Pre, 2=Post
AJPOV_AJPPO_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of conditions in a workflow-task
AJPOV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name (S=Parameterset)
AJPOV_Value varchar(max) CLOB clob(128 M) INLINE LENGTH 1024 COMPACT text true Variable value
AJPOV_Type char (1) CHAR (1 CHAR) char(1) char (1) true V=Value, S=Parameterset
AJPOV_AltView smallint NUMBER(38,0) smallint smallint true Flag for alternative view

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AJPOV AJPOV_AH_Idnr, AJPOV_AJPP_Lnr, AJPOV_Location, AJPOV_AJPPO_Lnr, AJPOV_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPOV_AJPPO AJPOV_AH_Idnr, AJPOV_AJPP_Lnr, AJPOV_Location, AJPOV_AJPPO_Lnr AJPPO_AH_Idnr, AJPPO_AJPP_Lnr, AJPPO_Location, AJPPO_Lnr

Return to the Index File