@shutter-network/concorde/signals/schema

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

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

concorde_signals.runs

Column	Type	Nullable	Default
id	uuid	no	gen_random_uuid()
signal_id	uuid	no
session	text	yes
prompt	text	no
state	text	no	'pending'
error	text	yes
started_at	timestamp with time zone	yes
ended_at	timestamp with time zone	yes

Primary key: id

Indexes

Name	Columns	Method	Unique
runs_signal_idx	signal_id	btree	no

Check constraints

Name	Condition
runs_state_known	"concorde_signals"."runs"."state" in ('pending', 'running', 'done', 'failed')

Foreign keys

Columns	References	On delete	On update
signal_id	concorde_signals.signals (id)	no action	no action

concorde_signals.signals

Column	Type	Nullable	Default
id	uuid	no	gen_random_uuid()
kind	text	no
payload	jsonb	no
emitted_at	timestamp with time zone	no	clock_timestamp()
state	text	no	'pending'
error	text	yes

Primary key: id

Indexes

Name	Columns	Method	Unique
signals_pending_idx	state, emitted_at	btree	no

Check constraints

Name	Condition
signals_state_known	"concorde_signals"."signals"."state" in ('pending', 'processing', 'done', 'failed')