Table : memoPad

organizationUnitId set=memoPadRow belongs to orgUnit and all under | userAccountId set=personal writing, belongs to userAccount | none set=belongs to organization

Raw table description

Fields

id id

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

subject

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

body

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

organizationUnitId  → organizationUnits

{
  "name": "organizationUnitId",
  "type": "foreignKey",
  "table": "organizationUnits"
}

userAccountId  → userAccounts

{
  "name": "userAccountId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin"
}

isLetterTemplate bit

{
  "name": "isLetterTemplate",
  "type": "bit"
}

updatedDate

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