@shutter-network/concorde/password-auth/schema

The tables this component creates, and the PostgreSQL schema concorde_password_auth it creates them in. A configuration listing @shutter-network/concorde/password-auth/schema creates all of them.

Generated from the snapshot drizzle-kit takes of src/password-auth/schema/index.ts, which is the snapshot an Operator's own generation reads. Never edited by hand.

Foreign keys leave this schema. passwords.user_id and tokens.user_id point into concorde_users, which @shutter-network/concorde/users/schema creates. A configuration that lists @shutter-network/concorde/password-auth/schema without it generates a constraint onto a table nobody creates.

concorde_password_auth.passwords

Column	Type	Nullable	Default
user_id	uuid	no
password_hash	text	no
updated_at	timestamp with time zone	no	clock_timestamp()

Primary key: user_id

Foreign keys

Columns	References	On delete	On update
user_id	concorde_users.users (id)	no action	no action

concorde_password_auth.tokens

Column	Type	Nullable	Default
id	uuid	no	gen_random_uuid()
user_id	uuid	no
token_hash	text	no
created_at	timestamp with time zone	no	clock_timestamp()
expires_at	timestamp with time zone	no

Primary key: id

Unique constraints

Name	Columns	Nulls not distinct
password_auth_tokens_token_hash_unique	token_hash	no

Indexes

Name	Columns	Method	Unique
password_auth_tokens_user_idx	user_id	btree	no

Foreign keys

Columns	References	On delete	On update
user_id	concorde_users.users (id)	cascade	no action