Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| userid | text | 2147483647 | null |
|
|
The client the permission is assigned to. |
||||
| permission | "_oat"."permission" | 2147483647 | null |
|
|
The permission assigned. |
||||
| assigned_by | "_quest"."quest_userid" | 2147483647 | null |
|
|
Audit: who assigned it. |
||||
| assigned_when | timestamp | 29,6 | now() |
|
|
Audit: when it was assigned. |
Table contained 1003 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| clt_perm_grant_pkey | Primary key | Asc/Asc | userid + permission |
Relationships
Close relationships within degrees of separation
