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: preview_size
Defines preview sizes used for resource preview and thumbnail generation.
| Column | Type | Note |
|---|---|---|
| ref | int(11) | Auto incrementing index |
| id | char(3) | Short code e.g. 'scr', 'lpr' |
| width | int(11) | Width in pixels |
| height | int(11) | Height in pixels |
| padtosize | int(11) | (boolean) Add padding to make image required size. If set to 0 the image will be scaled to fit within the defined dimensions |
| name | varchar(50) | Friendly name |
| internal | int(11) | (boolean) For system use. Prevents deletion. |
| allow_preview | int(11) | (boolean) Show a link to preview this size on the resource view page? |
| allow_restricted | int(11) | (boolean) Allow users with restricted access to see this preview size |
| quality | int(3) | JPEG quality |
Default contents are as follows.
| ref | id | width | height | padtosize | name | internal | allow_preview | allow_restricted | quality |
|---|---|---|---|---|---|---|---|---|---|
| 1 | thm | 200 | 200 | 0 | Thumbnail | 1 | 0 | 0 | 0 |
| 2 | pre | 900 | 540 | 0 | Preview | 1 | 0 | 1 | 0 |
| 3 | scr | 1400 | 800 | 0 | Screen | 0 | 1 | 0 | 0 |
| 4 | lpr | 2000 | 2000 | 0 | Low resolution print | 0 | 0 | 0 | 0 |
| 5 | hpr | 999999 | 999999 | 0 | High resolution print | 0 | 0 | 0 | 0 |
| 6 | col | 140 | 140 | 0 | Collection | 1 | 0 | 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).