| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| OKG_OH_Idnr | int | NUMBER(38,0) | int | false | reference to the object header (OH) |
| OKG_OKB_Lnr | smallint | NUMBER(38,0) | smallint | false | reference to the keyword |
| OKG_Lnr | smallint | NUMBER(38,0) | smallint | false | line number for sort order |
| OKG_Operator | char (1) | CHAR (1 CHAR) | char(1) | true | O=or, A=and, N=not |
| OKG_CaleName | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | true | name of the calendar |
| OKG_CaleKeyName | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | true | name of the calendar keyword |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| NK_OKG_CaleName | OKG_CaleName, OKG_CaleKeyName | false | false | false | false |
| PK_OKG | OKG_OH_Idnr, OKG_OKB_Lnr, OKG_Lnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_OKG_OKB | OKG_OH_Idnr, OKG_OKB_Lnr | OKB_OH_Idnr, OKB_Lnr |
Return to the Index File