Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
FJPPC_FE_Idnr int NUMBER(38,0) int int false reference to the forecast (FE)
FJPPC_FJPP_Lnr smallint NUMBER(38,0) smallint smallint false reference to the jobplan process (FJPP)
FJPPC_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the condition
FJPPC_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true object name (calendar)
FJPPC_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true name of the calendar keyword

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_FJPPC FJPPC_FE_Idnr, FJPPC_FJPP_Lnr, FJPPC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_FJPPC_FJPP FJPPC_FE_Idnr, FJPPC_FJPP_Lnr FJPP_FE_Idnr, FJPP_Lnr

Return to the Index File