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.
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.

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_width
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

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