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

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

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

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

concorde_nostr_channel.outbox

Column	Type	Nullable	Default
event_id	text	no
user_id	uuid	no
message_id	uuid	no
wrap	text	no
reason	text	yes
queued_at	timestamp with time zone	no	clock_timestamp()
failed_at	timestamp with time zone	yes

Primary key: event_id

Foreign keys

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

concorde_nostr_channel.pubkeys

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

Primary key: user_id

Unique constraints

Name	Columns	Nulls not distinct
pubkeys_pubkey_unique	pubkey	no

Foreign keys

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

concorde_nostr_channel.received

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

Primary key: event_id