additional_fields

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

INT

10

√

null

additional_field_values.field_id

afv_fkC

primary key identifier

tablename

VARCHAR

255

tablename of the new field

name

VARCHAR

255

items_search_fields.name

Implied ConstraintR

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

is the field searchable?

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation