infra/sql/0010_worker_runtime.sql

Metadata

• Purpose: SQL migration or seed data script for persistent storage.
• Domain: infrastructure
• Language: sql
• Bytes: 312
• Lines: 10
• Content hash (short): b4324e09
• Source (start): infra/sql/0010_worker_runtime.sql:1
• Source (end): infra/sql/0010_worker_runtime.sql:10

Indexed Symbols

No indexed functions/methods detected in this file.

Markdown Headings (if applicable)

No markdown headings detected.

Source Preview

create table if not exists worker_runtime_status (
  worker_name text primary key,
  status text not null,
  last_seen_at timestamptz not null default now(),
  details jsonb not null default '{}'::jsonb
);

create index if not exists idx_worker_runtime_status_seen
  on worker_runtime_status(last_seen_at desc);