Table : versions

Raw table description

Fields

id id

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

logoFileId  → files

{
  "name": "logoFileId",
  "type": "foreignKey",
  "table": "files"
}

associationDocumentId  → associationDocuments

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

documentId  → documents

{
  "name": "documentId",
  "type": "foreignKey",
  "table": "documents"
}

publishedDate

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

dealId  → deals

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

identifier M

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

associationParentVersionId  → associationVersions

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

parentVersionId  → versions

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

displayOrderId  → displayOrders

{
  "name": "displayOrderId",
  "type": "foreignKey",
  "table": "displayOrders"
}

notes

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

createdDate

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

areRowsCopied bit

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

isBundleItem bit

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

printTitle

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

settingsJSON

{
  "name": "settingsJSON",
  "type": "jsonObject"
}

issuingInformation

{
  "name": "issuingInformation",
  "type": "text",
  "maxLength": 80
}

updatedDate

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

Collections

[
  "rows"
]

Referenced by

dealDocumentBundleDocuments as versionId
documents as currentVersionId
rowContainers as versionId
rowGroups as versionId
rows as versionId
versionDigitalSignatures as versionId
versionFiles as versionId
versionSignatures as versionId
versions as parentVersionId