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