Table : outgoingEmails

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

emailOutboxId M  → emailOutboxes

{
  "name": "emailOutboxId",
  "type": "foreignKey",
  "table": "emailOutboxes",
  "mandatory": "true"
}

emailAddress M

{
  "name": "emailAddress",
  "type": "text",
  "maxLength": 80,
  "mandatory": "true"
}

contactId M  → contacts

{
  "name": "contactId",
  "type": "foreignKey",
  "table": "contacts",
  "mandatory": "true"
}

status E

{
  "name": "status",
  "type": "enum",
  "enums": [
    "ENUMS_EMAILSTATUS_DELIVERED",
    "ENUMS_EMAILSTATUS_UNDELIVERED",
    "ENUMS_EMAILSTATUS_WAITING"
  ]
}

statusReason

{
  "name": "statusReason",
  "type": "text"
}

recipientData

{
  "name": "recipientData",
  "type": "jsonObject"
}

sentDate

{
  "name": "sentDate",
  "type": "datetime"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}