ERMail
/ ERCMailMessage
parent of
ERCMailMessageArchive
referenced by
ERCMessageAttachment
External Name
ERCMAIL_MESSAG
Class Name
er.corebusinesslogic.ERCMailMessage
Attributes
show details
hide non-class
bccAddresses
BCC_ADDR
External Type
varchar1000 (VARCHAR)
Allows Null?
Yes
Used For Locking?
Yes
Width
1000
ccAddresses
CC_ADDR
External Type
varchar1000 (VARCHAR)
Allows Null?
Yes
Used For Locking?
No
Width
1000
contentGzipped
CONTENT_GZIPPED
External Type
intBoolean (INTEGER)
Allows Null?
No
Used For Locking?
Yes
created
CREATED
External Type
dateTime (TIMESTAMP)
Allows Null?
No
Used For Locking?
No
dateSent
DATE_SENT
External Type
dateTime (TIMESTAMP)
Allows Null?
Yes
Used For Locking?
No
exceptionReason
EXCEPTION_REASON
External Type
varchar1000 (VARCHAR)
Allows Null?
Yes
Used For Locking?
No
Width
1000
fromAddress
FROM_ADDR
External Type
varchar255 (VARCHAR)
Allows Null?
No
Used For Locking?
Yes
Width
255
id [primary key]
ID
External Type
id (INTEGER)
Allows Null?
No
Used For Locking?
Yes
isRead
IS_READ
External Type
intBoolean (INTEGER)
Allows Null?
No
Used For Locking?
Yes
lastModified
LAST_MODIFIED
External Type
dateTime (TIMESTAMP)
Allows Null?
No
Used For Locking?
No
plainText
PLAIN_TEXT_
External Type
varcharLarge (VARCHAR)
Allows Null?
Yes
Used For Locking?
No
Width
10000000
plainTextCompressed
plain_text_compressed
External Type
blob (BLOB)
Allows Null?
Yes
Used For Locking?
No
replyToAddress
REPLY_TO_ADDR
External Type
varchar1000 (VARCHAR)
Allows Null?
Yes
Used For Locking?
No
Width
1000
shouldArchiveSentMail
SHOULD_ARCHIVE_SENT_MAIL
External Type
intBoolean (INTEGER)
Allows Null?
No
Used For Locking?
Yes
state
MAIL_STATE_ID
External Type
osType (VARCHAR)
Allows Null?
No
Used For Locking?
Yes
Width
4
text
TEXT_
External Type
varcharLarge (VARCHAR)
Allows Null?
Yes
Used For Locking?
No
Width
10000000
textCompressed
TEXT_COMPRESSED
External Type
blob (BLOB)
Allows Null?
Yes
Used For Locking?
No
title
TITLE
External Type
varchar255 (VARCHAR)
Allows Null?
No
Used For Locking?
Yes
Width
255
toAddresses
TO_ADDR
External Type
varchar1000 (VARCHAR)
Allows Null?
No
Used For Locking?
Yes
Width
1000
xMailer
X_MAILER
External Type
varchar255 (VARCHAR)
Allows Null?
Yes
Used For Locking?
Yes
Width
255
Relationships
show details
attachments
ERCMessageAttachment
Type
To-Many
Joins
id
>
mailMessageId
Fetch Specifications
show details
messagesToBeSent
Qualifier
state = 'rtbs'
Fetch Limit
0
Deep Fetch?
true
Refreshes Refetched?
true
ripeMessages
Qualifier
state = 'rtbs' and lastModified < $date
Fetch Limit
0
Deep Fetch?
true
Refreshes Refetched?
true
Entity Indexes
no entity indexes