creator_batches

338 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
label_id INT 10 √ null
batch_id INT 10 1
description MEDIUMTEXT 16777215 √ NULL
item_number INT 10 √ NULL
items.itemnumber creator_batches_ibfk_3 C
borrower_number INT 10 √ NULL
borrowers.borrowernumber creator_batches_ibfk_1 C
timestamp TIMESTAMP 19 current_timestamp()
branch_code VARCHAR 10 'NB'
branches.branchcode creator_batches_ibfk_2 C
creator CHAR 15 'Labels'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc label_id
borrower_fk_constraint Performance Asc borrower_number
branch_fk_constraint Performance Asc branch_code
item_fk_constraint Performance Asc item_number

Relationships

Close relationships within degrees of separation