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

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: