Collections functions
Encryption functions
General functions
Render functions
Theme permission functions
Video functions
Resource functions

Table: collection

Collections are groups of resources.

refint(11)Auto incrementing index
namevarchar(100)The collection display name.
userint(11)See table user
publicint(11)Set to '1' for public collections and featured collections.
themevarchar(100)The first level theme category. Defined for multi-level featured collections.
theme2varchar(100)The second level theme category. Defined for multi-level featured collections.
theme3varchar(100)The third level theme category. Defined for multi-level featured collections.
keywordstextOptional keywords entered by the user and indexed for collection searching.
session_idint(11)Used for anonymous access with collections enabled - the session ID cookie used by the anonymous user, as a single user is used for all accesses.
descriptiontextTextual description.
typeint(11)Collection type such as Featured / Upload / Select
parentint(11)The parent collection for collections existing within a tree structure such as Featured Collections.
thumbnail_selection_methodint(11)How do we select the thumbnails to show on the tile for this collection?
bg_img_resource_refint(11)The resource ID of the preview image.

Default contents are as follows.

1Default Collection12008-01-01 10:00:00001

Please see the schema overview for context. This document was last updated on the 11th of May 2021 at 10:35 (Europe/London time).