user_permissions

0 rows


Columns

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc borrowernumber + module_bit + code
user_permissions_ibfk_1 Performance Asc borrowernumber
user_permissions_ibfk_2 Performance Asc/Asc module_bit + code

Relationships

Close relationships within degrees of separation