Table testsql_comments.creator_batches 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
label_id int 10  √ 
batch_id int 10 1
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

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

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

Close relationships  within of separation: