additional_fields

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
additional_field_values.field_id afv_fk C

primary key identifier
tablename VARCHAR 255 ''

tablename of the new field
name VARCHAR 255 ''
items_search_fields.name Implied Constraint R

name of the field
authorised_value_category VARCHAR 32 √ NULL

is an authorised value category
marcfield VARCHAR 16 ''

contains the marc field to copied into the record
marcfield_mode enum('get', 'set') 3 'get'

mode of operation (get or set) for marcfield
searchable BOOLEAN 3 0

is the field searchable?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fields_uniq Must be unique Asc/Asc tablename + name

Relationships

Close relationships within degrees of separation