stat.io.hub

Tables (7)

agents

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • content_hash — varchar(100)
  • content_md — text — NOT NULL
  • file_path — varchar(500) — NOT NULL
  • repository_id — int8 — Foreign key → repositories.id — NOT NULL

category_stats

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • avg_value — numeric(15, 6) — NOT NULL
  • category — varchar(100)
  • last_updated — timestamp(6) — NOT NULL
  • max_value — numeric(15, 6) — NOT NULL
  • min_value — numeric(15, 6) — NOT NULL
  • sample_count — int4 — NOT NULL

community_posts

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • author_admin_id — int8
  • body — text
  • category — varchar(20) — NOT NULL
  • published_at — timestamp(6)
  • source_links_json — text
  • source_type — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL
  • summary — text
  • tags_json — text
  • title — varchar(255) — NOT NULL
  • source_data_updated_at — timestamp(6)
  • COMPARISON::character — varying
  • GUIDE::character — varying)::text)))
  • EXTERNAL_WEB::character — varying
  • MANUAL::character — varying)::text)))
  • PUBLISHED::character — varying
  • REJECTED::character — varying
  • HIDDEN::character — varying)::text)))
  • id (id2) — int8 — Foreign key → users.id — NOT NULL

refresh_tokens

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • member_id — int8 — NOT NULL
  • token — varchar(1000) — NOT NULL
  • id (id2) — int8 — Foreign key → users.id — NOT NULL

repositories

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • active — bool — NOT NULL
  • default_branch — varchar(100)
  • etag — varchar(255)
  • fork_count — int4
  • github_id — int8 — NOT NULL
  • homepage — varchar(500)
  • is_official — bool
  • language_stats — jsonb
  • license — varchar(50)
  • name — varchar(150) — NOT NULL
  • owner_avatar_url — varchar(500)
  • owner_type — varchar(255)
  • raw_metadata — jsonb
  • size — int4
  • source_repo — varchar(255) — NOT NULL
  • source_updated_at — timestamp(6)
  • source_uri — varchar(500) — NOT NULL
  • star_count — int4
  • summary — text
  • ORGANIZATION::character — varying)::text)))

skills

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • category — varchar(20) — NOT NULL
  • content_hash — varchar(100)
  • content_md — text — NOT NULL
  • file_path — varchar(500) — NOT NULL
  • name — varchar(150) — NOT NULL
  • tags_json — jsonb
  • repository_id — int8 — Foreign key → repositories.id — NOT NULL
  • BACKEND::character — varying
  • FRONTEND::character — varying
  • FULLSTACK::character — varying
  • DATABASE::character — varying
  • DEVOPS::character — varying
  • SECURITY::character — varying
  • INFRA::character — varying
  • DATA_AI::character — varying
  • TESTING_QA::character — varying
  • DOCUMENTATION::character — varying
  • AUTOMATION::character — varying
  • OTHER::character — varying)::text)))

users

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • email — varchar(255) — NOT NULL
  • google_sub — varchar(100) — NOT NULL
  • name — varchar(100) — NOT NULL
  • role — varchar(20) — NOT NULL
  • ADMIN::character — varying)::text)))