@shutter-network/concorde/messenger/schema

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

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

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

concorde_messenger.messages

Column	Type	Nullable	Default
id	uuid	no	gen_random_uuid()
user_id	uuid	no
direction	text	no
seq	integer	no
text	text	no
created_at	timestamp with time zone	no	clock_timestamp()

Primary key: id

Unique constraints

Name	Columns	Nulls not distinct
messages_user_id_seq_unique	user_id, seq	no

Check constraints

Name	Condition
messages_direction_known	"concorde_messenger"."messages"."direction" in ('inbound', 'outbound')

Foreign keys

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