0 rows


Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
import_batches.profile_id import_batches_ibfk_1N

unique identifier and primary key

name VARCHAR 100 null

name of this profile

matcher_id INT 10 null

the id of the match rule used (matchpoints.matcher_id)

template_id INT 10 null

the id of the marc modification template

overlay_action VARCHAR 50 null

how to handle duplicate records

nomatch_action VARCHAR 50 null

how to handle records where no match is found

item_action VARCHAR 50 null

what to do with item records

parse_items BIT 0 null

should items be parsed

record_type VARCHAR 50 null

type of record in the batch

encoding VARCHAR 50 null

file encoding

format VARCHAR 50 null

marc format

comments LONGTEXT 2147483647 null

any comments added when the file was uploaded


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
u_import_batch_profiles__name Must be unique Asc name