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
}
{
"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"
}
{
"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"
}