Table : letters

Raw table description

Fields

id id

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

name 

{
  "name": "name",
  "type": "text",
  "maxLength": 100
}

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

senderContactId  → contacts

{
  "name": "senderContactId",
  "type": "foreignKey",
  "table": "contacts"
}

recipientContactId  → contacts  (If both recipient and recipientContactId is set then contactId will be used)

{
  "name": "recipientContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "If both recipient and recipientContactId is set then contactId will be used"
}

recipient   (If both recipient and recipientContactId is set then contactId will be used)

{
  "name": "recipient",
  "type": "text",
  "note": "If both recipient and recipientContactId is set then contactId will be used"
}

cityAndDate 

{
  "name": "cityAndDate",
  "type": "text",
  "maxLength": 100
}

subject 

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

body 

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

signature 

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

createdDate 

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

updatedDate 

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