Table : files

Read how to upload files in /doc

Raw table description

Fields

id id

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

viewURI   (Max 1920x1920)

{
  "name": "viewURI",
  "type": "text",
  "maxLength": 500,
  "readOnly": true,
  "note": "Max 1920x1920"
}

viewResolution

{
  "name": "viewResolution",
  "type": "text",
  "maxLength": 11,
  "readOnly": true
}

thumbnailURI   (Max 300x300)

{
  "name": "thumbnailURI",
  "type": "text",
  "maxLength": 500,
  "readOnly": true,
  "note": "Max 300x300"
}

thumbnailResolution

{
  "name": "thumbnailResolution",
  "type": "text",
  "maxLength": 11,
  "readOnly": true
}

originalURI M

{
  "name": "originalURI",
  "type": "text",
  "maxLength": 500,
  "readOnly": true,
  "mandatory": "true"
}

originalResolution

{
  "name": "originalResolution",
  "type": "text",
  "maxLength": 11,
  "readOnly": true
}

fileSize   (File size is saved in bytes)

{
  "name": "fileSize",
  "type": "int unsigned",
  "readOnly": true,
  "note": "File size is saved in bytes"
}

displayOrder

{
  "name": "displayOrder",
  "type": "int unsigned"
}

title

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

fileCategoryId  → fileCategories

{
  "name": "fileCategoryId",
  "type": "foreignKey",
  "table": "fileCategories"
}

description

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

isImage bit

{
  "name": "isImage",
  "type": "bit",
  "readOnly": true
}

isPublished bit

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

isMarketing bit

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

createdByUserId  → userAccounts

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

createdDate

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

extension

{
  "name": "extension",
  "type": "text",
  "maxLength": 15,
  "readOnly": true
}

mimeType

{
  "name": "mimeType",
  "type": "text",
  "maxLength": 100,
  "readOnly": true
}

updatedDate

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

Referenced by

contacts as profilePictureId
dealDocumentBundleDocuments as fileId
deals as mainImageFileId
documentBundleDocuments as fileId
emailFiles as fileId (connection table to emails via emailId)
emailOutboxFiles as fileId (connection table to emailOutboxes via emailOutboxId)
estates as mainImageFileId
filesInBrokerJournalEntry as fileId (connection table to brokerJournalEntries via brokerJournalEntryId)
filesInContacts as fileId (connection table to contacts via contactId)
filesInDeals as fileId (connection table to deals via dealId)
filesInHousingAssociationBuildings as fileId (connection table to housingAssociationBuildings via housingAssociationBuildingId)
filesInHousingAssociations as fileId
filesServiceDeliveries as fileId (connection table to serviceDeliveries via serviceDeliveryId)
imagesInDeals as fileId
imagesInEstates as fileId
imagesInHousingAssociations as fileId (connection table to housingAssociations via housingAssociationId)
imagesInRooms as fileId (connection table to rooms via roomId)
imagesServiceDeliveries as fileId (connection table to serviceDeliveries via serviceDeliveryId)
locationDescriptions as fileId
marketValuationFiles as fileId (connection table to marketValuations via marketValuationId)
marketValuations as imageFileId
newspaperAds as fileId
organizationFiles as fileId
organizationUnits as printDocumentHeaderLogoFileId
versionFiles as fileId
webhome as fileId