Table: resource_type_field

Coding standards

Security in ResourceSpace

Developer reference

Database

Action functions

Admin functions

Ajax functions

Annotation functions

API functions

Collections functions

Comment functions

Config functions

CSV export functions

Dash functions

Debug functions

Encryption functions

Facial recognition functions

File functions

General functions

Language functions

Log functions

Message functions

Migration functions

Node functions

PDF functions

Plugin functions

Render functions

Reporting functions

Request functions

Research functions

Slideshow functions

Theme permission functions

getThemePathPerms()

User functions

Video functions

Database functions

Metadata functions

Resource functions

Search functions

Map functions

Job functions

get_job_type_priority()

Tab functions

Test functions

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.
browse_bar	tinyint(1)	Set to 1 to show field in the browse bar
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.

Default contents are as follows.

ref	name	title	field_constraint	type	order_by	keywords_index	global	resource_column	display_field	iptc_equiv	display_template	required	exiftool_field	advanced_search	help_text	external_user_access	hide_when_uploading	value_filter	omit_when_copying	regexp_filter	fits_field	include_in_csv_export	browse_bar	read_only	active
1	keywords	Keywords - Other		9	60	1	1		1	2#025		0	IPTC:Keywords,Subject,XMP:Keywords	1		1	0		0			0	1	1	1
3	country	Country		9	80	1	1	country	1	2#101		0	IPTC:Country-PrimaryLocationName,XMP:Country	1		1	0					0	1	1	1
8	title	Title		0	10	1	1	title	0	2#005		1	IPTC:ObjectName,XMP:title	1		1	0					1	1	1	1
9	extract	Document extract		1	7	0	0		1		[title] [value]	0		1		1	0					0	1	1	1
10	credit	Credit		0	120	1	1		1	2#080		0	IPTC:Credit,XMP:Credit	1		1	0					1	1	1	1
12	date	Date		4	90	1	1	creation_date	1	2#055		0	DateTimeOriginal,IPTC:DateCreated,XMP:DateCreated	0		1	0	if ($value!=''){$value=nicedate($value,false);}				0	1	1	1
18	caption	Caption		1	20	1	1		1	2#120	[title] [value]	0	IPTC:Caption-Abstract,XMP:Description	1		1	0					0	1	1	1
25	notes	Notes		1	130	0	1		1	2#103	[title] [value]	0	JobID	1		1	0					0	1	1	1
29	person	Named person(s)		9	70	1	1		1			0	XMP:PersonInImage,XMP:People	1		1	0					1	1	1	1
51	originalfilename	Original filename		0	100	1	1	file_path	1			0		1		1	1					0	1	1	1
52	camera	Camera make / model		0	1600	0	0		1			0	Model	1		1	1					0	1	1	1
54	source	Source		3	1601	0	0		1			0	XMP:FileSource	1		1	0					0	1	1	1
72	text	Extracted text		5	110	0	1		0		[title] [value]	0		1		1	1					0	1	1	1
73	subject	Keywords - Subject		2	30	1	1		1			0		1		1	0		0			1	1	1	1
74	event	Keywords - Event		2	50	1	1		1			0		1		1	0		0			0	1	1	1
75	emotion	Keywords - Emotion		2	40	1	1		1			0		1		1	0		0			0	1	1	1
76	framerate	Frame Rate		0	0	1	0		1			0	framerate	1		1	0		0			0	1	1	1
77	videobitrate	Video Bitrate		0	0	1	0		1			0	videobitrate	1		1	0		0			0	1	1	1
78	aspectratio	Aspect Ratio		0	0	1	0		1			0	aspectratio	1		1	0		0			0	1	1	1
79	videosize	Video Size		0	0	0	0		1			0	imagesize	1		1	0		0			0	1	1	1
80	duration	Duration		0	0	0	0		1			0	duration	1		1	0		0			0	1	1	1
81	channelmode	Channel Mode		0	0	1	0		1			0	channelmode	1		1	0		0			0	1	1	1
82	samplerate	Sample Rate		0	0	0	0		1			0	samplerate	1		1	0		0			0	1	1	1
83	audiobitrate	Audio Bitrate		0	0	1	0		1			0	audiobitrate	1		1	0		0			0	1	1	1
84	recognised	Keywords - Recognised	0	9	0	1	0		1			0		1		1	0		0		0	0	1	1	1
85	landmark	Keywords - Landmark	0	9	0	1	0		1			0		1		1	0		0		0	0	1	1	1
86	accessibilityalttext	Accessibility - Alt Text	0	0	0	0	0		1			0	AltTextAccessibility	1	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.	1	0		0	^.{0,250}$	0	0	1	1	1
87	accessibilityextend	Accessibility - Extended Description		1	0	0	0		1			0	ExtDescrAccessibility	1	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.	1	0		0		0	0	1	1	1

Please see the schema overview for context. This document was last updated on the 17th of November 2024 at 15:35 (Europe/London time).

Knowledge Base

Table: resource_type_field

[title]

[title]

[title]

[title]