Table : files

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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