Name Type MSSql Type Oracle Type DB2 Nullable Description
OOI_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OOI_Lnr smallint NUMBER(38,0) smallint false ascending number of the content
OOI_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar
OOI_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar keyword
OOI_USR_Idnr int NUMBER(38,0) int false IDNR of the user (operator) or usergroup
OOI_EmailAddress varchar (255) VARCHAR2 (255 CHAR) varchar(255) 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