generated: 12.12.2016 18:33:56
by UC2010.accdb
AE Database 11.2 (Step 018)
| Name | Type | Len | Attributes | Description |
|---|---|---|---|---|
| MELD_Idnr | Long Integer | 4 | UC: Typ=Zähler Null=False | primary key |
| MELD_USR_Idnr | Long Integer | 4 | UC: Null=False | user id |
| MELD_Seen | Byte | 1 | UC: Typ=Boolean Null=True | has the user read the message? |
| MELD_TimeStamp | Date/Time | 8 | UC: Null=True | when has the user read the message? |
| MELD_MsgNr | Long Integer | 4 | UC: Null=True | message number |
| MELD_MsgInsert | Text | 50 | UC: Null=True L=1024 | message insert |
| MELD_DeleteFlag | Byte | 1 | UC: Null=True | delete flag |
| MELD_Client | Integer | 2 | UC: Null=True | client |
| MELD_Source | Long Integer | 4 | UC: Null=True | information source |
| MELD_Category | Long Integer | 4 | UC: Null=True | event category |
| MELD_Type | Long Integer | 4 | UC: Null=True | event type |
| MELD_Host | Text | 200 | UC: Null=True | host name |
| MELD_ArchiveFlag | Byte | 1 | UC: Null=True | archive flag |
Indexes:
| Name | Fields |
|---|---|
| NK_MELD_Loekz | MELD_DeleteFlag, MELD_Idnr |
| NK_MELD_Reorg | MELD_Seen, MELD_TimeStamp, MELD_Client, MELD_ArchiveFlag, MELD_Idnr |
| NK_MELD_Source | MELD_Client, MELD_Source, MELD_Seen, MELD_Idnr |
| NK_MELD_TimeStamp | MELD_TimeStamp, MELD_USR_Idnr, MELD_Idnr |
| NK_MELD_USR | MELD_Seen, MELD_USR_Idnr, MELD_Client, MELD_Idnr |
| PK_MELD | MELD_Idnr |
Return to the Index File