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

Please see the schema overview for context. This document was last updated on the 2nd of December 2020 at 00:05 (Europe/London time).