Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
MELD_Idnr int NUMBER(38,0) int int false primary key
MELD_USR_Idnr int NUMBER(38,0) int int false user id
MELD_Seen smallint NUMBER(38,0) smallint smallint true has the user read the message?
MELD_TimeStamp datetime DATE timestamp timestamp true when has the user read the message?
MELD_MsgNr int NUMBER(38,0) int int true message number
MELD_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true message insert
MELD_DeleteFlag smallint NUMBER(38,0) smallint smallint true delete flag
MELD_Client smallint NUMBER(38,0) smallint smallint true client
MELD_Source int NUMBER(38,0) int int true information source
MELD_Category int NUMBER(38,0) int int true event category
MELD_Type int NUMBER(38,0) int int true event type
MELD_Host varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true host name
MELD_ArchiveFlag smallint NUMBER(38,0) smallint smallint true archive flag

Indexes:

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

Foreign Keys:

Name Local References Foreign References

Return to the Index File