config.remote_account

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_remote_account_owner_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.remote_account_id_seq'::regclass)

label

text

No

host

text

No

username

text

Yes

password

text

Yes

account

text

Yes

path

text

Yes

owner FK

integer

No

actor.org_unit(id)

last_activity

timestamp with time zone

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

config_remote_account_owner_fkey

Indexes

Index Method Definition

remote_account_pkey PK

btree

CREATE UNIQUE INDEX remote_account_pkey ON config.remote_account USING btree (id)