Table: resource_type_field
Metadata fields.
| Column | Type | Note |
|---|---|---|
| ref | int(11) | Auto incrementing index |
| name | varchar(50) | Metadata field short name identifier |
| title | varchar(400) | Metadata field name |
| field_constraint | int(11) | Apply constraints to field (e.g number) |
| type | int(11) | Field type. See include/definitions.php |
| order_by | int(11) | Metadata field order defined by administrators. |
| keywords_index | int(11) | Set if values of this field should be indexed. |
| partial_index | int(11) | Allows searching and matching algorithms to check only parts of this field values. |
| global | int(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_column | varchar(50) | Points to a resource table column to keep it up to date. Deprecated? |
| display_field | int(11) | Determines if a field is visible on the resource view page |
| iptc_equiv | varchar(20) | IPTC codes for extracting embedded metadata. See https://www.resourcespace.com/knowledge-base/resourceadmin/metadata-read-write-mapping |
| display_template | text | Custom HTML display template |
| required | int(11) | Mark field as mandatory. |
| smart_theme_name | varchar(200) | Generate featured collections based on the values of this field |
| exiftool_field | varchar(200) | Exif values for extracting from embedded metadata. |
| advanced_search | int(11) | Display on advanced search. |
| simple_search | int(11) | Display on simple search. |
| help_text | text | Help text shown when having focus of field in edit/upload. |
| display_as_dropdown | int(11) | Display field as a dropdown selector. |
| external_user_access | int(11) | |
| autocomplete_macro | text | Macro used to autocomplete field if when saving it's empty (ie no value) |
| hide_when_uploading | int(11) | Do not show when uploading |
| hide_when_restricted | int(11) | Do not show when restricted access. |
| value_filter | text | PHP code snippet which allows the transformation of $value to modify the display of a field value in search display fields or resource view. |
| exiftool_filter | text | PHP code to modify extracted exiftool $value upon import into the database. |
| omit_when_copying | int(11) | Specifies that the field should not be copied when using the resource copy function. |
| tooltip_text | text | Text that will appear in simple/advanced search when the cursor hovers over the field. |
| regexp_filter | varchar(400) | Regular expression used to add constraints on the values input to the field. |
| display_condition | varchar(400) | Adding dependencies on other field values for displaying the current field. |
| onchange_macro | text | PHP code to be executed when updating the field value. |
| linked_data_field | text | Used for date range fields |
| automatic_nodes_ordering | tinyint(1) | If 1, nodes get ordered by translated names, otherwise uses the order_by column. |
| fits_field | varchar(255) | FITS values for extracting from embedded metadata. |
| personal_data | tinyint(1) | If 1, field may contain personal data. |
| include_in_csv_export | tinyint(1) | If 1, field can be included in CSV exports. |
| read_only | tinyint(1) | Set to 1 to make field read-only and not write back to the file on download. |
| active | tinyint(1) | Set to 1 to have field active, 0 to be disabled. |
| full_width | tinyint(1) | Set to 1 to have the field be displayed full width on the view page. |
| tab | int(11) | Reference to a system tab. See the "tab" table. |
| complete_index | int(11) | Index field values as one unbroken keyword. Incompatible with partial indexing. |
| sort_method | int(11) | Sort method used when ordering by this field in search results. Alphanumeric by default. |
| geomapping | int(11) | Geomapping behaviour for this field. Set to 0 = none, 1 = latitude, 2 = longitude, or 3 = combined latitude/longitude. |
Default contents are as follows.
| ref | name | title | field_constraint | type | order_by | keywords_index | partial_index | global | resource_column | display_field | iptc_equiv | display_template | required | smart_theme_name | exiftool_field | advanced_search | simple_search | help_text | display_as_dropdown | external_user_access | autocomplete_macro | hide_when_uploading | hide_when_restricted | value_filter | exiftool_filter | omit_when_copying | tooltip_text | regexp_filter | display_condition | onchange_macro | linked_data_field | automatic_nodes_ordering | fits_field | personal_data | include_in_csv_export | read_only | active | full_width | tab | complete_index | sort_method | geomapping |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | keywords | Keywords - Other | 9 | 60 | 1 | 0 | 1 | 1 | 2#025 | 0 | IPTC:Keywords,Subject,XMP:Keywords | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 3 | country | Country | 9 | 80 | 1 | 0 | 1 | country | 1 | 2#101 | 0 | IPTC:Country-PrimaryLocationName,XMP:Country | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 8 | title | Title | 0 | 10 | 1 | 0 | 1 | title | 0 | 2#005 | 1 | IPTC:ObjectName,XMP:title | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 9 | extract | Document extract | 1 | 7 | 0 | 0 | 0 | 1 | [title][value] | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 10 | credit | Credit | 0 | 120 | 1 | 0 | 1 | 1 | 2#080 | 0 | IPTC:Credit,XMP:Credit | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 12 | date | Date | 4 | 90 | 1 | 0 | 1 | creation_date | 1 | 2#055 | 0 | DateTimeOriginal,IPTC:DateCreated,XMP:DateCreated | 0 | 0 | 0 | 1 | 0 | 0 | if ($value!=''){$value=nicedate($value,false);} | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||
| 18 | caption | Caption | 1 | 20 | 1 | 0 | 1 | 1 | 2#120 | [title][value] | 0 | IPTC:Caption-Abstract,XMP:Description | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 25 | notes | Notes | 1 | 130 | 0 | 0 | 1 | 1 | 2#103 | [title][value] | 0 | JobID | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 29 | person | Named person(s) | 9 | 70 | 1 | 0 | 1 | 1 | 0 | XMP:PersonInImage,XMP:People | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 51 | originalfilename | Original filename | 0 | 100 | 1 | 0 | 1 | file_path | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 52 | camera | Camera make / model | 0 | 1600 | 0 | 0 | 0 | 1 | 0 | Model | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 54 | source | Source | 3 | 1601 | 0 | 0 | 0 | 1 | 0 | XMP:FileSource | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 72 | text | Extracted text | 5 | 110 | 0 | 0 | 1 | 0 | [title][value] | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 73 | subject | Keywords - Subject | 2 | 30 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 74 | event | Keywords - Event | 2 | 50 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 75 | emotion | Keywords - Emotion | 2 | 40 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 76 | framerate | Frame Rate | 0 | 0 | 1 | 0 | 0 | 1 | 0 | framerate | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 77 | videobitrate | Video Bitrate | 0 | 0 | 1 | 0 | 0 | 1 | 0 | videobitrate | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 78 | aspectratio | Aspect Ratio | 0 | 0 | 1 | 0 | 0 | 1 | 0 | aspectratio | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 79 | videosize | Video Size | 0 | 0 | 0 | 0 | 0 | 1 | 0 | imagesize | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 80 | duration | Duration | 0 | 0 | 0 | 0 | 0 | 1 | 0 | duration | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 81 | channelmode | Channel Mode | 0 | 0 | 1 | 0 | 0 | 1 | 0 | channelmode | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 82 | samplerate | Sample Rate | 0 | 0 | 0 | 0 | 0 | 1 | 0 | samplerate | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 83 | audiobitrate | Audio Bitrate | 0 | 0 | 1 | 0 | 0 | 1 | 0 | audiobitrate | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 84 | recognised | Keywords - Recognised | 0 | 9 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 85 | landmark | Keywords - Landmark | 0 | 9 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 86 | accessibilityalttext | Accessibility - Alt Text | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | AltTextAccessibility | 1 | 0 | Enter 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. | 0 | 1 | 0 | 0 | 0 | ^.{0,250}$ | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||
| 87 | accessibilityextend | Accessibility - Extended Description | 1 | 0 | 0 | 0 | 0 | 1 | 0 | ExtDescrAccessibility | 1 | 0 | Enter 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. | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |
Please see the schema overview for context. This document was last updated on the 1st of September 2026 at 12:35 (Europe/London time).