illbatches

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ill_batch_id INT 10 √ null
illrequests.batch_id illrequests_ibfk N

Batch ID
name VARCHAR 100 null

Unique name of batch
backend VARCHAR 20 null

Name of batch backend
patron_id INT 10 √ null
borrowers.borrowernumber illbatches_bnfk N

Patron associated with batch
library_id VARCHAR 50 √ null
branches.branchcode illbatches_bcfk N

Branch associated with batch
status_code VARCHAR 20 √ null
illbatch_statuses.code illbatches_sfk N

Status of batch

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ill_batch_id
illbatches_bcfk Performance Asc library_id
illbatches_bnfk Performance Asc patron_id
illbatches_sfk Performance Asc status_code
u_illbatches__name Must be unique Asc name

Relationships

Close relationships within degrees of separation