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: resource_type_field

Metadata fields.

ColumnTypeNote
refint(11)Auto incrementing index
namevarchar(50)Metadata field short name identifier
titlevarchar(400)Metadata field name
field_constraintint(11)Apply constraints to field (e.g number)
typeint(11)Field type. See include/definitions.php
order_byint(11)Metadata field order defined by administrators.
keywords_indexint(11)Set if values of this field should be indexed.
partial_indexint(11)Allows searching and matching algorithms to check only parts of this field values.
globalint(1)Set to 1 if field is applicable to all resource types. If set to 0 then mappings are stored in resource_type_field_resource_type. Replaces the old resource_type column.
resource_columnvarchar(50)Points to a resource table column to keep it up to date. Deprecated?
display_fieldint(11)Determines if a field is visible on the resource view page
iptc_equivvarchar(20)IPTC codes for extracting embedded metadata. See https://www.resourcespace.com/knowledge-base/resourceadmin/metadata-read-write-mapping
display_templatetextCustom HTML display template
requiredint(11)Mark field as mandatory.
smart_theme_namevarchar(200)Generate featured collections based on the values of this field
exiftool_fieldvarchar(200)Exif values for extracting from embedded metadata.
advanced_searchint(11)Display on advanced search.
simple_searchint(11)Display on simple search.
help_texttextHelp text shown when having focus of field in edit/upload.
display_as_dropdownint(11)Display field as a dropdown selector.
external_user_accessint(11)
autocomplete_macrotextMacro used to autocomplete field if when saving it's empty (ie no value)
hide_when_uploadingint(11)Do not show when uploading
hide_when_restrictedint(11)Do not show when restricted access.
value_filtertextPHP code snippet which allows the transformation of $value to modify the display of a field value in search display fields or resource view.
exiftool_filtertextPHP code to modify extracted exiftool $value upon import into the database.
omit_when_copyingint(11)Specifies that the field should not be copied when using the resource copy function.
tooltip_texttextText that will appear in simple/advanced search when the cursor hovers over the field.
regexp_filtervarchar(400)Regular expression used to add constraints on the values input to the field.
display_conditionvarchar(400)Adding dependencies on other field values for displaying the current field.
onchange_macrotextPHP code to be executed when updating the field value.
linked_data_fieldtextUsed for date range fields
automatic_nodes_orderingtinyint(1)If 1, nodes get ordered by translated names, otherwise uses the order_by column.
fits_fieldvarchar(255)FITS values for extracting from embedded metadata.
personal_datatinyint(1)If 1, field may contain personal data.
include_in_csv_exporttinyint(1)If 1, field can be included in CSV exports.
browse_bartinyint(1)Set to 1 to show field in the browse bar
read_onlytinyint(1)Set to 1 to make field read-only and not write back to the file on download.
activetinyint(1)Set to 1 to have field active, 0 to be disabled.
full_widthtinyint(1)Set to 1 to have the field be displayed full width on the view page.
tabint(11)Reference to a system tab. See the "tab" table.

Default contents are as follows.

refnametitlefield_constrainttypeorder_bykeywords_indexpartial_indexglobalresource_columndisplay_fieldiptc_equivdisplay_templaterequiredsmart_theme_nameexiftool_fieldadvanced_searchsimple_searchhelp_textdisplay_as_dropdownexternal_user_accessautocomplete_macrohide_when_uploadinghide_when_restrictedvalue_filterexiftool_filteromit_when_copyingtooltip_textregexp_filterdisplay_conditiononchange_macrolinked_data_fieldautomatic_nodes_orderingfits_fieldpersonal_datainclude_in_csv_exportbrowse_barread_onlyactivefull_widthtab
1keywordsKeywords - Other96010112#0250IPTC:Keywords,Subject,XMP:Keywords100100001110
3countryCountry980101country12#1010IPTC:Country-PrimaryLocationName,XMP:Country10010001110
8titleTitle010101title02#0051IPTC:ObjectName,XMP:title10010011110
9extractDocument extract170001

[title]

[value]

010010001110
10creditCredit012010112#0800IPTC:Credit,XMP:Credit10010011110
12dateDate490101creation_date12#0550DateTimeOriginal,IPTC:DateCreated,XMP:DateCreated000100if ($value!=''){$value=nicedate($value,false);}01110
18captionCaption12010112#120

[title]

[value]

0IPTC:Caption-Abstract,XMP:Description10010001110
25notesNotes113000112#103

[title]

[value]

0JobID10010001110
29personNamed person(s)97010110XMP:PersonInImage,XMP:People10010011110
51originalfilenameOriginal filename0100101file_path1010011001110
52cameraCamera make / model0160000010Model10011001110
54sourceSource3160100010XMP:FileSource10010001110
72textExtracted text51100010

[title]

[value]

010011001110
73subjectKeywords - Subject23010110100100011110
74eventKeywords - Event25010110100100001110
75emotionKeywords - Emotion24010110100100001110
76framerateFrame Rate0010010framerate100100001110
77videobitrateVideo Bitrate0010010videobitrate100100001110
78aspectratioAspect Ratio0010010aspectratio100100001110
79videosizeVideo Size0000010imagesize100100001110
80durationDuration0000010duration100100001110
81channelmodeChannel Mode0010010channelmode100100001110
82samplerateSample Rate0000010samplerate100100001110
83audiobitrateAudio Bitrate0010010audiobitrate100100001110
84recognisedKeywords - Recognised090100101001000001110
85landmarkKeywords - Landmark090100101001000001110
86accessibilityalttextAccessibility - Alt Text00000010AltTextAccessibility10Enter text describing the appearance of the image from a visual perspective, focusing on details that are relevant to the purpose and meaning of the image. A maximum of 250 characters can be entered.01000^.{0,250}$001110
87accessibilityextendAccessibility - Extended Description1000010ExtDescrAccessibility10Enter the text describing the appearance of an image from a visual perspective, focusing on relevant details that further describe the meaning and purpose of the image.01000001110

Please see the schema overview for context. This document was last updated on the 5th of December 2024 at 07:05 (Europe/London time).