|
id
|
bigint(20)
|
|
|
|
|
indateDelivered
|
bigint(20)
|
|
|
|
|
type
|
enum
|
-- |
|
Notification
|
|
idUserAccessFrom
|
bigint(20)
|
|
|
|
|
sentFrom
|
varchar(255)
|
|
|
|
|
idUserAccessTo
|
bigint(20)
|
|
|
|
|
sentTo
|
varchar(255)
|
|
|
|
|
priority
|
enum
|
-- |
|
Normal
|
|
status
|
enum
|
-- |
|
New
|
|
countSeen
|
smallint(6)
|
|
|
0
|
|
subject
|
varchar(255)
|
|
|
|
|
message
|
mediumtext
|
|
|
|
|
indateCreated
|
bigint(20)
|
|
|
|
|
indateModified
|
bigint(20)
|
|
|
|
|
idUserAccessCreated
|
bigint(20)
|
|
|
|
|
idUserAccessModified
|
bigint(20)
|
|
|
|
|
idLogAccess
|
bigint(20)
|
|
|
|