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