Table testsql_comments.marc_modification_template_actions Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
mmta_id int 10  √ 
template_id int 10
marc_modification_templates.template_id mmta_ibfk_1 C
ordering int 10
action enum 22
field_number smallint 5 0
from_field varchar 3
from_subfield varchar 1  √  null
field_value varchar 100  √  null
to_field varchar 3  √  null
to_subfield varchar 1  √  null
to_regex_search text 65535  √  null
to_regex_replace text 65535  √  null
to_regex_modifiers varchar 8  √ 
conditional enum 6  √  null
conditional_field varchar 3  √  null
conditional_subfield varchar 1  √  null
conditional_comparison enum 10  √  null
conditional_value text 65535  √  null
conditional_regex bit 0 0
description text 65535  √  null

Table contained 0 rows at Mon Jun 26 09:07 NZST 2017

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

Close relationships: