Table testsql_comments.user_permissions 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
borrowernumber int 10 0
borrowers.borrowernumber user_permissions_ibfk_1 C
module_bit int 10 0
permissions.module_bit user_permissions_ibfk_2 C
code varchar 64  √  null
permissions.code user_permissions_ibfk_2 C

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

Indexes:
Column(s) Type Sort Constraint Name
borrowernumber Performance Asc user_permissions_ibfk_1
module_bit + code Performance Asc/Asc user_permissions_ibfk_2

Close relationships  within of separation: