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 |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_OOI | OOI_OH_Idnr, OOI_Lnr | true | true | true | false |
Name | Local References | Foreign References |
---|---|---|
FK_OOI_OOA | OOI_OH_Idnr | OOA_OH_Idnr |
Return to the Index File