Collections functions
Encryption functions
General functions
Render functions
Theme permission functions
Video functions
Resource functions

Table: resource_type_field

Metadata fields.

ColumnTypeNote
refint(11)Auto incrementing index
namevarchar(50)
titlevarchar(400)
field_constraintint(11)
typeint(11)
order_byint(11)
keywords_indexint(11)
partial_indexint(11)
resource_typeint(11)See table resource_type
resource_columnvarchar(50)
display_fieldint(11)
use_for_similarint(11)
iptc_equivvarchar(20)
display_templatetext
tab_namevarchar(50)
requiredint(11)
smart_theme_namevarchar(200)
exiftool_fieldvarchar(200)
advanced_searchint(11)
simple_searchint(11)
help_texttext
display_as_dropdownint(11)
external_user_accessint(11)
autocomplete_macrotext
hide_when_uploadingint(11)
hide_when_restrictedint(11)
value_filtertext
exiftool_filtertext
omit_when_copyingint(11)
tooltip_texttext
regexp_filtervarchar(400)
sync_fieldint(11)
display_conditionvarchar(400)
onchange_macrotext
linked_data_fieldtext
automatic_nodes_orderingtinyint(1)
fits_fieldvarchar(255)
personal_datatinyint(1)
include_in_csv_exporttinyint(1)
browse_bartinyint(1)
read_onlytinyint(1)
activetinyint(1)
full_widthtinyint(1)

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#0250Keywords,Subject1001000011010
3countryCountry980100country112#1010category,country100100011010
8titleTitle010100title012#0051Title100100111010
9extractDocument extract1700210

[title]

[value]

0100100011010
10creditCredit0120100112#0800Source,Creator,Credit,By-line100100111010
12dateDate490100creation_date112#0550DateTimeOriginal000100if ($value!=''){$value=nicedate($value,false);}011010
18captionCaption120100102#120

[title]

[value]

0Caption-Abstract,Description,ImageDescription100100011010
25notesNotes1130000102#103

[title]

[value]

0JobID100100011010
29personNamed person(s)070100110People100100111010
51originalfilenameOriginal filename0100100file_path010100110011010
52cameraCamera make / model01600001100Model100110011010
54sourceSource31601001110100100011010
72textExtracted text511010000

[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 27th of February 2021 at 22:05 (Europe/London time).