| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| MELD_Idnr | int | NUMBER(38,0) | int | false | primary key |
| MELD_USR_Idnr | int | NUMBER(38,0) | int | false | user id |
| MELD_Seen | smallint | NUMBER(38,0) | smallint | true | has the user read the message? |
| MELD_TimeStamp | datetime | DATE | timestamp | true | when has the user read the message? |
| MELD_MsgNr | int | NUMBER(38,0) | int | true | message number |
| MELD_MsgInsert | varchar (1024) | VARCHAR2 (1024 CHAR) | varchar(1024) | true | message insert |
| MELD_DeleteFlag | smallint | NUMBER(38,0) | smallint | true | delete flag |
| MELD_Client | smallint | NUMBER(38,0) | smallint | true | client |
| MELD_Source | int | NUMBER(38,0) | int | true | information source |
| MELD_Category | int | NUMBER(38,0) | int | true | event category |
| MELD_Type | int | NUMBER(38,0) | int | true | event type |
| MELD_Host | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | true | host name |
| MELD_ArchiveFlag | smallint | NUMBER(38,0) | smallint | true | archive flag |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| NK_MELD_Loekz | MELD_DeleteFlag, MELD_Idnr | false | false | false | false |
| NK_MELD_Reorg | MELD_Seen, MELD_TimeStamp, MELD_Client, MELD_ArchiveFlag, MELD_Idnr | false | false | false | false |
| NK_MELD_Source | MELD_Client, MELD_Source, MELD_Seen, MELD_Idnr | false | false | false | false |
| NK_MELD_TimeStamp | MELD_TimeStamp, MELD_USR_Idnr, MELD_Idnr | false | false | false | false |
| NK_MELD_USR | MELD_Seen, MELD_USR_Idnr, MELD_Client, MELD_Idnr | false | false | false | false |
| PK_MELD | MELD_Idnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|
Return to the Index File