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
- Automated Testing
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: research_request
Research requests - requests for appropriate resources for a project (for example)
| Column | Type | Note |
|---|---|---|
| ref | int(11) | Auto incrementing index |
| name | text | Research (project) name. |
| description | text | Research description. |
| deadline | datetime | Deadline for requested resources. |
| varchar(200) | E-mail of the person making the request (when $anonymous_login is set). | |
| contact | varchar(100) | Telephone contact. |
| finaluse | text | Description of the final use of the resources. |
| resource_types | varchar(50) | List (CSV) of resource types |
| noresources | int(11) | Number of required resources |
| shape | varchar(50) | Orientation of the resources. Available options: Portrait, Landscape, Either. |
| created | datetime | Date request was created. |
| user | int(11) | The user making the request. For $anonymous_login, the user is the ID of the anonymous user. |
| assigned_to | int(11) | User assigned to work on the research request. |
| status | int(11) | Request processing status. Available options: 0 - Unassigned; 1 - In progress; 2 - Complete. |
| collection | int(11) | See table collection |
| custom_fields_json | longtext | JSON encoded data of custom research fields. See $custom_researchrequest_fields configuration option. |
This table is empty by default.
Please see the schema overview for context. This document was last updated on the 1st of September 2026 at 21:35 (Europe/London time).