Table odyssey_test._oat.usr_permission
Permissions assigned to a user.

 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
userid quest_userid 2147483647
usr_user.userid oat_user_permission_userid_fkey C
The user the permission is assigned to.
permission permission 2147483647
oat_permission.permission oat_user_permission_permission_fkey R
The permission assigned.
assigned_by quest_userid 2147483647 Audit: who assigned it.
assigned_when timestamp 29,6 now() Audit: when it was assigned.

Table contained 133 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
userid + permission Primary key Asc/Asc oat_user_permission_pkey

Close relationships  within of separation: