BE
Tables (4)
analysis_artifacts
- id — UUID
- run_id — UUID — Foreign key → analysis_runs.id — NOT NULL
- artifact_type — TEXT — NOT NULL
- bucket — TEXT — NOT NULL
- object_key — TEXT — NOT NULL
- content_type — TEXT
- content_hash — TEXT
- size_bytes — BIGINT
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
analysis_runs
- id — UUID
- user_id — UUID — Foreign key → app_users.id — NOT NULL
- orchestrator_type — TEXT — NOT NULL
- status — TEXT — NOT NULL
- repository_url — TEXT
- repository_name — TEXT
- input_json — JSONB — NOT NULL
- output_json — JSONB — NOT NULL
- error_message — TEXT
- started_at — TIMESTAMPTZ
- finished_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
analysis_sources
- id — UUID
- run_id — UUID — Foreign key → analysis_runs.id — NOT NULL
- source_type — TEXT — NOT NULL
- source_url — TEXT — NOT NULL
- title — TEXT
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
app_users
- id — UUID
- github_user_id — BIGINT
- github_login — TEXT
- email — TEXT
- name — TEXT
- avatar_url — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL