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_1 C

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

to_regex_search

MEDIUMTEXT

16777215

√

null

to_regex_replace

MEDIUMTEXT

16777215

√

null

to_regex_modifiers

VARCHAR

8

√

conditional

enum('if', 'unless')

6

√

null

conditional_field

VARCHAR

3

√

null

conditional_subfield

VARCHAR

1

√

null

conditional_comparison

enum('exists', 'not_exists', 'equals', 'not_equals')

10

√

null

conditional_value

MEDIUMTEXT

16777215

√

null

conditional_regex

BIT

0

description

MEDIUMTEXT

16777215

√

null

Showing 1 to 20 of 20 entries

Table contained 0 rows

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