config.remoteauth_profile

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: remoteauth_profile_context_org_fkey, remoteauth_profile_perm_fkey, remoteauth_profile_usr_activity_type_fkey.

Columns

Column Type Nullable Default Notes

name PK

text

No

description

text

Yes

context_org FK

integer

No

→ actor.org_unit(id)

enabled

boolean

No

false

perm FK

integer

No

→ permission.perm_list(id)

restrict_to_org

boolean

No

true

allow_inactive

boolean

No

false

allow_expired

boolean

No

false

block_list

text

Yes

usr_activity_type FK

integer

Yes

→ config.usr_activity_type(id)

Primary Key

(name)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

context_org

actor.org_unit(id)

CASCADE

CASCADE

DEFERRED

remoteauth_profile_context_org_fkey

perm

permission.perm_list(id)

RESTRICT

CASCADE

DEFERRED

remoteauth_profile_perm_fkey

usr_activity_type

config.usr_activity_type(id)

RESTRICT

CASCADE

DEFERRED

remoteauth_profile_usr_activity_type_fkey

Indexes

Index Method Definition

remoteauth_profile_pkey PK

btree

CREATE UNIQUE INDEX remoteauth_profile_pkey ON config.remoteauth_profile USING btree (name)
Previous
Next