Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EVP_AH_Idnr int NUMBER(38,0) int int false reference to the executive header (EH)
EVP_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the element
EVP_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true name of the calendar
EVP_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true name of the calendar keyword
EVP_From char (4) CHAR (4 CHAR) char(4) char (4) true HHMM from
EVP_To char (4) CHAR (4 CHAR) char(4) char (4) true HHMM to
EVP_Status int NUMBER(38,0) int int true state (aktive yes/no)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EVP EVP_AH_Idnr, EVP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File