Name Type MSSql Type Oracle Type DB2 Nullable Description
EVP_AH_Idnr int NUMBER(38,0) int false reference to the executive header (EH)
EVP_Lnr smallint NUMBER(38,0) smallint false ascending number of the element
EVP_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar
EVP_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar keyword
EVP_From char (4) CHAR (4 CHAR) char(4) true HHMM from
EVP_To char (4) CHAR (4 CHAR) char(4) true HHMM to
EVP_Status int NUMBER(38,0) 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