Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| username | varchar | 2147483647 | √ | null |
|
|
||||
| orgName | varchar | 2147483647 | √ | null |
|
|
||||
| templateCode | varchar | 2147483647 | √ | null |
|
|
||||
| permissionName | varchar | 2147483647 | √ | null |
|
|
||||
| stageNumber | int4 | 10 | √ | null |
|
|
||||
| reviewLevel | int4 | 10 | √ | null |
|
|
||||
| allowedSections | _varchar | 2147483647 | √ | null |
|
|
||||
| canSelfAssign | bool | 1 | √ | null |
|
|
||||
| canMakeFinalDecision | bool | 1 | √ | null |
|
|
||||
| restrictions | jsonb | 2147483647 | √ | null |
|
|
||||
| policyName | varchar | 2147483647 | √ | null |
|
|
||||
| permissionType | permission_policy_type | 2147483647 | √ | null |
|
|
||||
| permissionPolicyId | int4 | 10 | √ | null |
|
|
||||
| permissionPolicyRules | jsonb | 2147483647 | √ | null |
|
|
||||
| permissionNameId | int4 | 10 | √ | null |
|
|
||||
| templatePermissionId | int4 | 10 | √ | null |
|
|
||||
| templateId | int4 | 10 | √ | null |
|
|
||||
| userId | int4 | 10 | √ | null |
|
|
||||
| orgId | int4 | 10 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
