Agent Studion
Tables (6)
agent_specs
- id — BIGINT
- agent_id — UUID — NOT NULL
- version — INTEGER — NOT NULL
- workspace_id — INTEGER — Foreign key → workspaces.id — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- spec — JSONB — NOT NULL
- user_input_values — JSONB — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
agent_trigger_runs
- id — BIGINT
- trigger_id — BIGINT — Foreign key → agent_triggers.id — NOT NULL
- policy_kind — VARCHAR(30) — NOT NULL
- entity_key — TEXT
- status — VARCHAR(30) — NOT NULL
- run_after — TIMESTAMPTZ
- start_event_id — VARCHAR(255) — NOT NULL
- latest_event_id — VARCHAR(255) — NOT NULL
- dispatch_token — UUID — NOT NULL
- policy_metadata — JSONB — NOT NULL
- last_error — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
agent_triggers
- id — BIGINT
- agent_spec_id — BIGINT — Foreign key → agent_specs.id — NOT NULL
- workspace_id — INTEGER — Foreign key → workspaces.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- source — VARCHAR(50) — NOT NULL
- event_type — VARCHAR(100) — NOT NULL
- condition — JSONB — NOT NULL
- concurrency_key — VARCHAR(255)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
companies
- id — INTEGER
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- size — VARCHAR(20) — NOT NULL
- location — VARCHAR(255)
- logo_url — VARCHAR(500)
users
- id — INTEGER
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- given_name — VARCHAR(50)
- family_name — VARCHAR(50)
- picture — VARCHAR(500)
- role — VARCHAR(20)
- provider — VARCHAR(20) — NOT NULL
- refresh_token — VARCHAR(500)
- department — VARCHAR(50) — NOT NULL
- job_level — VARCHAR(20) — NOT NULL
- status — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
workspaces
- id — INTEGER
- name — VARCHAR(50) — NOT NULL
- company_id — INTEGER — Foreign key → companies.id — NOT NULL