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

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
userid quest_userid 2147483647
usr_user
The user the permission is assigned to.
permission permission 2147483647
oat_permission
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
userid + permission Primary key Asc/Asc

Close relationships  within of separation: