Name Type MSSql Type Oracle Type DB2 Nullable Description
OVP_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OVP_Lnr smallint NUMBER(38,0) smallint false ascending number
OVP_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar
OVP_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar keyword
OVP_From char (4) CHAR (4 CHAR) char(4) true HHMM from
OVP_To char (4) CHAR (4 CHAR) char(4) true HHMM to
OVP_Max int NUMBER(38,0) int true Queue: Maximum number of Slots
OVP_UC4Priority smallint NUMBER(38,0) smallint true Priority
OVP_Description varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Description

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OVP OVP_OH_Idnr, OVP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OVP_OH OVP_OH_Idnr OH_Idnr

Return to the Index File