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)))