Definition of table: MELD - messages

generated: 09.12.2016 10:27:55
by UC2010.accdb

AE Database 12.0 (Step 013)



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