Coding standards
Security in ResourceSpace
Developer reference
- Project structure
- Database schema
- Fixed list fields
- Debugging ResourceSpace
- Writing your own plugins
- Context help links
- Custom fields ("user" defined)
- Query caching
- All user permissions
- Client side API calls
- Modals
- Sending user notifications
- Progressive Web App
- Managing (PHP) code dependencies
- Managing (JS) code dependencies
- OpenAPI documentation
Database
- Table: activity_log
- Table: annotation
- Table: annotation_node
- Table: collection
- Table: collection_keyword
- Table: collection_log
- Table: collection_resource
- Table: collection_savedsearch
- Table: comment
- Table: daily_stat
- Table: dash_tile
- Table: dynamic_tree_node
- Table: external_access_keys
- Table: filter
- Table: filter_rule
- Table: filter_rule_node
- Table: ip_lockout
- Table: job_queue
- Table: keyword
- Table: keyword_related
- Table: mail_log
- Table: message
- Table: node
- Table: node_keyword
- Table: plugins
- Table: preview_size
- Table: report
- Table: report_periodic_emails
- Table: report_periodic_emails_unsubscribe
- Table: request
- Table: research_request
- Table: resource
- Table: resource_alt_files
- Table: resource_custom_access
- Table: resource_dimensions
- Table: resource_keyword
- Table: resource_log
- Table: resource_node
- Table: resource_related
- Table: resource_type
- Table: resource_type_field
- Table: resource_type_field_resource_type
- Table: search_log
- Table: site_text
- Table: slideshow
- Table: sysvars
- Table: tab
- Table: user
- Table: user_collection
- Table: user_dash_tile
- Table: user_message
- Table: user_preferences
- Table: user_rating
- Table: user_report
- Table: user_userlist
- Table: usergroup
- Table: usergroup_collection
- Table: usergroup_dash_tile
Table: collection
Collections are groups of resources.
| Column | Type | Note |
|---|---|---|
| ref | int(11) | Auto incrementing index |
| name | varchar(100) | The collection display name. |
| user | int(11) | User ID |
| created | datetime | |
| public | int(11) | Set to '1' for public collections and featured collections (deprecated - use type instead). |
| theme | varchar(100) | The first level theme category. Defined for multi-level featured collections. |
| theme2 | varchar(100) | The second level theme category. Defined for multi-level featured collections. |
| theme3 | varchar(100) | The third level theme category. Defined for multi-level featured collections. |
| allow_changes | int(11) | |
| cant_delete | int(11) | Prevent collection from being deleted (used for e.g. user 'New uploads' collections) |
| keywords | text | Optional keywords entered by the user and indexed for collection searching. |
| savedsearch | int(11) | |
| home_page_publish | int(11) | (legacy) used if $home_dash=false |
| home_page_text | text | (legacy) used if $home_dash=false |
| home_page_image | int(11) | (legacy) used if $home_dash=false |
| session_id | int(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. |
| description | text | Textual description. |
| type | int(11) | Collection type such as Public / Featured / Upload / Select (see include/definition.php) |
| parent | int(11) | The parent collection for collections existing within a tree structure such as Featured Collections. |
| thumbnail_selection_method | int(11) | How do we select the thumbnails to show on the tile for this collection? |
| bg_img_resource_ref | int(11) | The resource ID of the preview image. |
| order_by | int(11) | YES,,0,The order by of the collection. Used only by Featured Collections at the moment. |
Default contents are as follows.
| ref | name | user | created | public | theme | theme2 | theme3 | allow_changes | cant_delete | keywords | savedsearch | home_page_publish | home_page_text | home_page_image | session_id | description | type | parent | thumbnail_selection_method | bg_img_resource_ref | order_by |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Default Collection | 1 | 2008-01-01 10:00:00 | 0 | 0 | 1 | 0 | 0 |
Please see the schema overview for context. This document was last updated on the 19th of August 2026 at 16:05 (Europe/London time).