Table testsql_comments.authorised_values_branches
association table between authorised_values and branches

 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
av_id int 10  √  null
authorised_values.id authorised_values_branches_ibfk_1 C
branchcode varchar 10  √  null
branches.branchcode authorised_values_branches_ibfk_2 C

Table contained 0 rows at Tue Dec 27 17:46 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
av_id Performance Asc av_id
branchcode Performance Asc branchcode

Close relationships  within of separation: