Generic Email UML


Added On:  02/13/12 
SQL Table:  GENERIC_EMAIL 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  GenericEmail 
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
SQL Column:  TO_EMAIL
Java Field:  toEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The addresser of the email.
Added On:  02/13/12
SQL Column:  SUBJECT
Java Field:  subject
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Subject (main title) of the email.
Added On:  02/13/12
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(8192)
Java Type:  String
Attributes:
Content message of the email.
Added On:  02/13/12
SQL Column:  ATTACHMENT_CODE
Java Field:  attachmentCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the attachment to the email (if there is any).
Added On:  02/13/12
SQL Column:  FILE_EXTENTION
Java Field:  fileExtention
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Extention of the email attachment.
Added On:  02/13/12
SQL Column:  SEND_DATE
Java Field:  sendDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the email was sent.
Added On:  02/13/12
SQL Column:  MESSAGE_ID
Java Field:  messageId
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Identification number of the message in the system.
Added On:  02/13/12
SQL Column:  RESPONSE
Java Field:  response
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  SUBMISSION_CODE
Java Field:  submissionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/13/12
SQL Column:  EXTERNAL_REFERENCE_CODE
Java Field:  externalReferenceCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  02/13/12
SQL Column:  EMAIL_TRANSACTION_FK
Java Field:  emailTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Email Transaction
Attributes:
Reference to the entity that represents email information.
Added On:  02/13/12
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  03/06/12
SQL Column:  ATTACHMENT_CONTENT_SOURCE_CL
Java Field:  attachmentContentSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of source from where the attachment content can be downloaded.
Added On:  09/26/13
SQL Column:  FROM_EMAIL
Java Field:  fromEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Addresser of the email.
Added On:  09/26/13
SQL Column:  CC_EMAIL
Java Field:  ccEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  10/10/13
SQL Column:  IS_PLAIN_MESSAGE
Java Field:  isPlainMessage
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the email is a plain message.
Added On:  12/21/15
SQL Column:  BCC_EMAIL
Java Field:  bccEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(12288)
Java Type:  String
Attributes:
Content message of the email.