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

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

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

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

concorde_nostr_auth.admitted

Column	Type	Nullable	Default
event_id	text	no
admitted_at	timestamp with time zone	no	clock_timestamp()

Primary key: event_id

Indexes

Name	Columns	Method	Unique
nostr_auth_admitted_at_idx	admitted_at	btree	no

concorde_nostr_auth.grants

Column	Type	Nullable	Default
pubkey	text	no
user_id	uuid	no
granted_at	timestamp with time zone	no	clock_timestamp()

Primary key: pubkey

Indexes

Name	Columns	Method	Unique
nostr_auth_grants_user_idx	user_id	btree	no

Foreign keys

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