actor.passwd

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

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: passwd_passwd_type_fkey, passwd_usr_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.passwd_id_seq'::regclass)
usr FK	`integer`	No		→ actor.usr(id)
salt	`text`	Yes
passwd	`text`	No
passwd_type FK	`text`	No		→ actor.passwd_type(code)
create_date	`timestamp with time zone`	No	now()
edit_date	`timestamp with time zone`	No	now()

id PK

integer

nextval('actor.passwd_id_seq'::regclass)

usr FK

integer

→ actor.usr(id)

salt

text

Yes

passwd

text

passwd_type FK

text

→ actor.passwd_type(code)

create_date

timestamp with time zone

now()

edit_date

timestamp with time zone

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`passwd_type`	actor.passwd_type(code)	NO ACTION	NO ACTION	DEFERRED	`passwd_passwd_type_fkey`
`usr`	actor.usr(id)	CASCADE	NO ACTION	DEFERRED	`passwd_usr_fkey`

passwd_type

actor.passwd_type(code)

NO ACTION

DEFERRED

passwd_passwd_type_fkey

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

passwd_usr_fkey

Unique Constraints

passwd_type_once_per_user: (usr, passwd_type)

Indexes

Index Method Definition

Index	Method	Definition
`passwd_pkey` PK	btree	`CREATE UNIQUE INDEX passwd_pkey ON actor.passwd USING btree (id)`
`passwd_type_once_per_user` UNIQUE	btree	`CREATE UNIQUE INDEX passwd_type_once_per_user ON actor.passwd USING btree (usr, passwd_type)`

passwd_pkey PK

btree

CREATE UNIQUE INDEX passwd_pkey ON actor.passwd USING btree (id)

passwd_type_once_per_user UNIQUE

btree

CREATE UNIQUE INDEX passwd_type_once_per_user ON actor.passwd USING btree (usr, passwd_type)