additional_fields


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 16

is an authorised value category

marcfield VARCHAR 16

contains the marc field to copied into the record

searchable BIT 0 0

is the field searchable?

Table contained 0 rows

Indexes

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

Relationships