Table testsql_comments.authorised_values_branches
association table between authorised_values and branches

Generated by
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 authorised_values_branches_ibfk_1 C
branchcode varchar 10
branches.branchcode authorised_values_branches_ibfk_2 C

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

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

Close relationships  within of separation: