Table : emails

Raw table description

Fields

id id

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

createdByUserId M  → userAccounts

{
  "name": "createdByUserId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin",
  "mandatory": "true"
}

communicationTokenId  → communicationTokens

{
  "name": "communicationTokenId",
  "type": "foreignKey",
  "table": "communicationTokens",
  "schema": "mspx_admin"
}

subject

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

body

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

sentDate

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

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

updatedDate

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

Referenced by

communications as emailId
emailContacts as emailId
emailFiles as emailId (connection table to files via fileId)