Collections functions
Encryption functions
General functions
Theme permission functions
Resource functions

Table: resource

A resource is the central record within ResourceSpace mapping to a single asset / file.

ColumnTypeNote
refint(11)Auto incrementing index
titlevarchar(200)The resource title, synchronised with the configured title metadata field
resource_typeint(11)See table resource_type
has_imageint(11)Does the resource have a preview image?
is_transcodingint(11)Is there a transcoding process underway for this resource?
hit_countint(11)How many times this resource has been viewed.
new_hit_countint(11)Copied from hit_count by cron so that resource hit counts don't change throughout the day affecting search ordering.
creation_datedatetimeWhen the resource record was created.
ratingint(11)
user_ratingint(11)See table user_rating
user_rating_countint(11)
user_rating_totalint(11)
countryvarchar(200)
file_extensionvarchar(10)The extension of the uploaded main file e.g. 'jpg'.
preview_extensionvarchar(10)The extension of the chosen preview format, e.g. 'mp4'
image_redint(11)The average red component of the image excluding desaturated areas. Used for image placeholders during loading.
image_greenint(11)The average red component of the image excluding desaturated areas. Used for image placeholders during loading.
image_blueint(11)The average red component of the image excluding desaturated areas. Used for image placeholders during loading.
thumb_widthint(11)The display width of the thumbnail ('thm' preview size)
thumb_heightint(11)The display height of the thumbnail ('thm' preview size)
archiveint(11)The delete/archive/custom workflow state of the resource: default states -2 = pending submission, -1 = pending review, 0 = active, 1 = pending archive, 2 = archived, 3 = deleted
accessint(11)The default access level: 0 = open (all users), 1 = restricted (must be requested by non admin), 2 = confidential (admin only), 3 = custom (defined by resource_custom_access)
colour_keyvarchar(5)A descriptive string listing the main colours in order. Not used.
created_byint(11)The user that created the resource record.
file_pathvarchar(500)The path to the file on disk, only used in the case of a staticsync file.
file_modifieddatetime
file_checksumvarchar(32)
request_countint(11)
expiry_notification_sentint(11)
preview_tweaksvarchar(50)
geo_latdoubleGeographical latitude in degrees, extracted from the resource file if configured
geo_longdoubleGeographical longitutude in degrees, extracted from the resource file if configured
mapzoomint(11)The map zoom level to use by default, set when manually setting a map coordinate
disk_usagebigint(20)Disk usage of all resource files including previews and alternatives in bytes
disk_usage_last_updateddatetimeThe last time disk_usage was updated
file_sizebigint(20)The file size of the core file in bytes
preview_attemptsint(11)
modifiedtimestamp
last_verifieddatetime
integrity_failtinyint(1)
lock_userint(11)The ID of the user that has checked out (locked) this resource record

This table is empty by default.

Please see the schema overview for context. This document was last updated on the 7th of July 2020 at 09:05 (Europe/London time).