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 Tue Jan 16 21:06 NZDT 2018

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

Close relationships  within of separation: