Table : documents

Raw table description

Fields

id id

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

organizationUnitId  → organizationUnits

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

title M

{
  "name": "title",
  "type": "text",
  "maxLength": 60,
  "mandatory": "true"
}

identifier

{
  "name": "identifier",
  "type": "text",
  "maxLength": 60
}

currentVersionId  → versions

{
  "name": "currentVersionId",
  "type": "foreignKey",
  "table": "versions"
}

isHidden bit

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

preValidationUrl

{
  "name": "preValidationUrl",
  "type": "text",
  "maxLength": 400
}

postValidationUrl

{
  "name": "postValidationUrl",
  "type": "text",
  "maxLength": 400
}

clonedAssociationDocumentId  → associationDocuments

{
  "name": "clonedAssociationDocumentId",
  "type": "foreignKey",
  "table": "associationDocuments",
  "schema": "mspx_admin"
}

clonedAssociationVersionId  → associationVersions

{
  "name": "clonedAssociationVersionId",
  "type": "foreignKey",
  "table": "associationVersions",
  "schema": "mspx_admin"
}

createdByUserId  → userAccounts

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

updatedDate

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

Collections

[
  "versions"
]

Referenced by

versions as documentId