config.openathens_identity

↑ 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: config_openathens_identity_ou_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.openathens_identity_id_seq'::regclass)

active

boolean

No

true

org_unit FK

integer

No

→ actor.org_unit(id)

api_key

text

No

connection_id

text

No

connection_uri

text

No

auto_signon_enabled

boolean

No

true

auto_signout_enabled

boolean

No

false

unique_identifier FK

integer

No

1

→ config.openathens_uid_field(id)

display_name FK

integer

No

1

→ config.openathens_name_field(id)

release_prefix

boolean

No

false

release_first_given_name

boolean

No

false

release_second_given_name

boolean

No

false

release_family_name

boolean

No

false

release_suffix

boolean

No

false

release_email

boolean

No

false

release_home_ou

boolean

No

false

release_barcode

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

org_unit

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

config_openathens_identity_ou_fkey

display_name

config.openathens_name_field(id)

NO ACTION

NO ACTION

No

openathens_identity_display_name_fkey

unique_identifier

config.openathens_uid_field(id)

NO ACTION

NO ACTION

No

openathens_identity_unique_identifier_fkey

Indexes

Index Method Definition

openathens_identity_pkey PK

btree

CREATE UNIQUE INDEX openathens_identity_pkey ON config.openathens_identity USING btree (id)
Previous
Next