Coding standards
Security in ResourceSpace
Developer reference
Database
Action functions
Admin functions
Ajax functions
Annotation functions
API functions
Collections functions
Comment functions
Config functions
CSV export functions
Dash functions
Debug functions
Encryption functions
Facial recognition functions
File functions
General functions
Language functions
Log functions
Login functions
Message functions
Migration functions
Node functions
PDF functions
Plugin functions
Render functions
Reporting functions
Request functions
Research functions
Slideshow functions
Theme permission functions
User functions
Video functions
Database functions
Metadata functions
Resource functions
Search functions
Map functions
Job functions
Tab functions
Test functions

Table: research_request

Research requests - requests for appropriate resources for a project (for example)

ColumnTypeNote
refint(11)Auto incrementing index
nametextResearch (project) name.
descriptiontextResearch description.
deadlinedatetimeDeadline for requested resources.
emailvarchar(200)E-mail of the person making the request (when $anonymous_login is set).
contactvarchar(100)Telephone contact.
finalusetextDescription of the final use of the resources.
resource_typesvarchar(50)List (CSV) of resource types
noresourcesint(11)Number of required resources
shapevarchar(50)Orientation of the resources. Available options: Portrait, Landscape, Either.
createddatetimeDate request was created.
userint(11)The user making the request. For $anonymous_login, the user is the ID of the anonymous user.
assigned_toint(11)User assigned to work on the research request.
statusint(11)Request processing status. Available options: 0 - Unassigned; 1 - In progress; 2 - Complete.
collectionint(11)See table collection
custom_fields_jsonlongtextJSON 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 4th of December 2024 at 08:35 (Europe/London time).