Collections functions
General functions
Node functions
Render functions
Theme permission functions
User functions
Resource 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
use_for_similarint(11)Means the field is available to help users find similar resources
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_fielduse_for_similariptc_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 - Other960101112#0250IPTC:Keywords,Subject,XMP:Keywords100100001110
3countryCountry980101country112#1010IPTC:Country-PrimaryLocationName,XMP:Country10010001110
8titleTitle010101title012#0051IPTC:ObjectName,XMP:title10010011110
9extractDocument extract1700010

[title]

[value]

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

[title]

[value]

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

[title]

[value]

0JobID10010001110
29personNamed person(s)970101110XMP:PersonInImage,XMP:People10010011110
51originalfilenameOriginal filename0100101file_path01010011001110
52cameraCamera make / model01600000100Model10011001110
54sourceSource31601000110XMP:FileSource10010001110
72textExtracted text511000100

[title]

[value]

010011001110
73subjectKeywords - Subject230101110100100011110
74eventKeywords - Event250101110100100001110
75emotionKeywords - Emotion240101110100100001110
76framerateFrame Rate00100110framerate100100001110
77videobitrateVideo Bitrate00100110videobitrate100100001110
78aspectratioAspect Ratio00100110aspectratio100100001110
79videosizeVideo Size00000110imagesize100100001110
80durationDuration00000110duration100100001110
81channelmodeChannel Mode00100110channelmode100100001110
82samplerateSample Rate00000110samplerate100100001110
83audiobitrateAudio Bitrate00100110audiobitrate100100001110
84recognisedKeywords - Recognised0901001101001000001110
85landmarkKeywords - Landmark0901001101001000001110
86accessibilityalttextAccessibility - Alt Text000000110AltTextAccessibility10Enter 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 Description10000110ExtDescrAccessibility10Enter 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 19th of March 2024 at 06:05 (Europe/London time).