marc_modification_template_actions - testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

mmta_id

INT

10

√

null

template_id

INT

10

null

marc_modification_templates.template_id

mmta_ibfk_1C

ordering

INT

10

null

action

enum('delete_field', 'add_field', 'update_field', 'move_field', 'copy_field', 'copy_and_replace_field')

22

null

field_number

SMALLINT

5

0

from_field

VARCHAR

3

null

from_subfield

VARCHAR

1

√

null

field_value

VARCHAR

100

√

null

to_field

VARCHAR

3

√

null

to_subfield

VARCHAR

1

√

null

Showing 1 to 10 of 20 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	mmta_id
mmta_ibfk_1	Performance	Asc	template_id

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One