marc_subfield_structure - testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

tagfield

VARCHAR

3

tagsubfield

VARCHAR

1

liblibrarian

VARCHAR

255

libopac

VARCHAR

255

repeatable

TINYINT

3

0

mandatory

TINYINT

3

0

important

TINYINT

3

0

kohafield

VARCHAR

40

√

null

tab

BIT

0

√

null

authorised_value

VARCHAR

32

√

null

authorised_value_categories.category_name

marc_subfield_structure_ibfk_1N

Showing 1 to 10 of 20 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc/Asc/Asc	frameworkcode + tagfield + tagsubfield
kohafield	Performance	Asc/Asc	frameworkcode + kohafield
kohafield_2	Performance	Asc	kohafield
marc_subfield_structure_ibfk_1	Performance	Asc	authorised_value
tab	Performance	Asc/Asc	frameworkcode + tab

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation

One
Two degrees