Table : outgoingSms

Raw table description

Fields

id id

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

smsOutboxId  → smsOutboxes

{
  "name": "smsOutboxId",
  "type": "foreignKey",
  "table": "smsOutboxes"
}

phoneNumber 

{
  "name": "phoneNumber",
  "type": "text",
  "maxLength": 25
}

individualText 

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

status E

{
  "name": "status",
  "type": "enum",
  "enums": [
    "ENUMS_SMSSTATUS_DELIVERED (Levererat)",
    "ENUMS_SMSSTATUS_UNDELIVERED (Olevererbart)",
    "ENUMS_SMSSTATUS_WAITING (Väntar på leverans)"
  ]
}

contactId  → contacts

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

sentDate 

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

updatedDate 

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