Collections functions
General functions
Render functions
Theme permission 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.
resource_typeint(11)Resource type specific field. Use Global if it's a general use metadata field (ie applies to all resource types).
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
tab_namevarchar(50)Tab name under which this field should be rendered when viewing a resource. DEPRECATED - use the tab column instead. From version >9.8 all tab names have been migrated to the system tabs.
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.
sync_fieldint(11)Ability to keep the settings of this field in sync with the ones of another one.
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_indexresource_typeresource_columndisplay_fielduse_for_similariptc_equivdisplay_templatetab_namerequiredsmart_theme_nameexiftool_fieldadvanced_searchsimple_searchhelp_textdisplay_as_dropdownexternal_user_accessautocomplete_macrohide_when_uploadinghide_when_restrictedvalue_filterexiftool_filteromit_when_copyingtooltip_textregexp_filtersync_fielddisplay_conditiononchange_macrolinked_data_fieldautomatic_nodes_orderingfits_fieldpersonal_datainclude_in_csv_exportbrowse_barread_onlyactivefull_widthtab
1keywordsKeywords - Other160100112#0250IPTC:Keywords,Subject,XMP:Keywords1001000011010
3countryCountry980100country112#1010IPTC:Country-PrimaryLocationName,XMP:Country100100011010
8titleTitle010100title012#0051IPTC:ObjectName,XMP:title100100111010
9extractDocument extract1700210

[title]

[value]

0100100011010
10creditCredit0120100112#0800IPTC:Credit,XMP:Credit100100111010
12dateDate490100creation_date112#0550DateTimeOriginal,IPTC:DateCreated,XMP:DateCreated000100if ($value!=''){$value=nicedate($value,false);}011010
18captionCaption120100102#120

[title]

[value]

0IPTC:Caption-Abstract,IPTC:ImageDescription,XMP:Description100100011010
25notesNotes1130000102#103

[title]

[value]

0JobID100100011010
29personNamed person(s)070100110XMP:PersonInImage,XMP:People100100111010
51originalfilenameOriginal filename0100100file_path010100110011010
52cameraCamera make / model01600001100Model100110011010
54sourceSource31601001110XMP:FileSource100100011010
72textExtracted text511000000

[title]

[value]

0100110011010
73subjectKeywords - Subject2301001101001000111010
74eventKeywords - Event2501001101001000011010
75emotionKeywords - Emotion2401001101001000011010
76framerateFrame Rate00103110framerate1001000011010
77videobitrateVideo Bitrate00103110videobitrate1001000011010
78aspectratioAspect Ratio00103110aspectratio1001000011010
79videosizeVideo Size00003110imagesize1001000011010
80durationDuration00004110duration1001000011010
81channelmodeChannel Mode00104110channelmode1001000011010
82samplerateSample Rate00004110samplerate1001000011010
83audiobitrateAudio Bitrate00104110audiobitrate1001000011010
84recognisedKeywords - Recognised09010011010010000011010
85landmarkKeywords - Landmark00010011010010000011010
86accessibilityalttextAccessibility - Alt Text000001110AltTextAccessibility10Enter 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^.{1,250}$0011010
87accessibilityextendAccessibility - Extended Description10001110ExtDescrAccessibility10Enter 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.010000011010

Please see the schema overview for context. This document was last updated on the 4th of October 2022 at 11:35 (Europe/London time).