Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OOI_OH_Idnr int NUMBER(38,0) int int false ID of the notification object.
OOI_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for the recipients of a notification object.
OOI_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of a calendar object.
OOI_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of a calendar event.
OOI_USR_Idnr int NUMBER(38,0) int int false ID of a user or a user group.
OOI_EmailAddress varchar (320) VARCHAR2 (320 CHAR) varchar(320) varchar (320) true Email address.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OOI OOI_OH_Idnr, OOI_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OOI_OOA OOI_OH_Idnr OOA_OH_Idnr

Return to the Index File