4
Tables (11)
credentials
- id — BIGSERIAL — Primary key — NOT NULL
- mcp_id — BIGINT — NOT NULL
- key_value — VARCHAR(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
imports
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → profiles.id — NOT NULL
- target_type — import_target_type — NOT NULL
- target_id — BIGINT — NOT NULL
- imported_at — TIMESTAMP — NOT NULL
mcp_catalog
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- key_required — BOOLEAN — NOT NULL
- key_issue_url — VARCHAR(255)
- metadata_json — JSON
- created_at — TIMESTAMP — NOT NULL
processed
- id — BIGSERIAL — Primary key — NOT NULL
- workflow_id — BIGINT — NOT NULL
- item_key — VARCHAR(255) — NOT NULL
- processed_at — TIMESTAMP — NOT NULL
profiles
- id — BIGSERIAL — Primary key — NOT NULL
- clerk_user_id — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
run_state
- id — BIGSERIAL — Primary key — NOT NULL
- workflow_id — BIGINT — NOT NULL
- run_id — VARCHAR(100) — NOT NULL
- status — run_status — NOT NULL
- paused_at — TIMESTAMP
- resumed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
skill_tags
- skill_id — BIGINT — Foreign key → skills.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
skills
- id — BIGSERIAL — Primary key — NOT NULL
- author_id — BIGINT — Foreign key → profiles.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- content_md — TEXT — NOT NULL
- import_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
tags
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
workflow_tags
- workflow_id — BIGINT — Foreign key → workflows.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
workflows
- id — BIGSERIAL — Primary key — NOT NULL
- author_id — BIGINT — Foreign key → profiles.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- graph_json — JSON — NOT NULL
- import_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL