@shutter-network/concorde/scheduler/schema
The tables this component creates, and the PostgreSQL schema concorde_scheduler it creates them in. A configuration listing @shutter-network/concorde/scheduler/schema creates all of them.
Generated from the snapshot drizzle-kit takes of src/scheduler/schema/index.ts, which is the snapshot an Operator's own generation reads. Never edited by hand.
concorde_scheduler.schedules
| Column | Type | Nullable | Default |
|---|---|---|---|
name | text | no | |
kind | text | no | |
at | timestamp with time zone | yes | |
cron_expr | text | yes | |
tz | text | yes | |
until | timestamp with time zone | yes | |
data | jsonb | yes |
Primary key: name
Check constraints
| Name | Condition |
|---|---|
schedules_cron_has_fields | "concorde_scheduler"."schedules"."kind" <> 'cron' or ("concorde_scheduler"."schedules"."cron_expr" is not null and "concorde_scheduler"."schedules"."tz" is not null and "concorde_scheduler"."schedules"."at" is not null) |
schedules_kind_known | "concorde_scheduler"."schedules"."kind" in ('once', 'cron') |
schedules_once_has_at | "concorde_scheduler"."schedules"."kind" <> 'once' or "concorde_scheduler"."schedules"."at" is not null |