ㄴㄴ
Tables (12)
dashboards
- dashboard_id — BIGINT
- report_id — BIGINT — NOT NULL
- source_type — ENUM('run','evaluation','aggregate') — NOT NULL
- source_id — BIGINT
- data — JSON — NOT NULL
- created_at — DATETIME — NOT NULL
engines
- engine_id — BIGINT
- name — VARCHAR(64) — NOT NULL
- country — VARCHAR(8)
- device — ENUM('desktop','mobile')
- data_source — VARCHAR(64)
- created_at — TIMESTAMP — NOT NULL
evaluation_checklist
- evaluation_id — BIGINT
- https — TINYINT(1) — NOT NULL
- hsts — TINYINT(1) — NOT NULL
- robots_txt_exists — TINYINT(1) — NOT NULL
- can_crawl — TINYINT(1) — NOT NULL
- sitemap_has_lastmod — TINYINT(1) — NOT NULL
- has_faq_schema — TINYINT(1) — NOT NULL
- has_author_schema — TINYINT(1) — NOT NULL
- has_profilepage_schema — TINYINT(1) — NOT NULL
- has_publication_date — TINYINT(1) — NOT NULL
- mobile_friendly — TINYINT(1) — NOT NULL
- has_canonical — TINYINT(1) — NOT NULL
- has_hreflang — TINYINT(1) — NOT NULL
- has_toc — TINYINT(1) — NOT NULL
- has_longtail_or_question — TINYINT(1) — NOT NULL
- page_fetched — TINYINT(1) — NOT NULL
evaluation_content_stats
- evaluation_id — BIGINT
- title_h1_alignment — DECIMAL(5,2)
- keyword_density — DECIMAL(6,4)
- longtail_ratio — DECIMAL(6,4)
- question_ratio — DECIMAL(6,4)
- top_terms — JSON
evaluation_web_vitals
- evaluation_id — BIGINT
- lcp_ms — INT
- cls — DECIMAL(6,4)
- inp_ms — INT
- mobile_friendly_detail — JSON
- lighthouse_json — JSON
evaluations
- evaluation_id — BIGINT
- report_id — BIGINT — NOT NULL
- page_id — BIGINT — NOT NULL
- evaluated_at — DATETIME — NOT NULL
- lang — VARCHAR(8)
- doc_length_tokens — INT
- score_overall — DECIMAL(5,2)
- score_authority — DECIMAL(5,2)
- score_relevance — DECIMAL(5,2)
- score_content — DECIMAL(5,2)
- stats — JSON
fact_gsc_query_page_daily
- id — BIGINT
- report_id — BIGINT — NOT NULL
- page_id — BIGINT
- date — DATE — NOT NULL
- clicks — INT
- impressions — INT
- ctr — DECIMAL(6,4)
- position — DECIMAL(6,2)
fact_keyword_rank_daily
- id — BIGINT
- report_id — BIGINT — NOT NULL
- engine_id — BIGINT — NOT NULL
- date — DATE — NOT NULL
- page_id — BIGINT
- rank — INT
- serp_features — JSON
pages
- page_id — BIGINT
- canonical_url — TEXT — NOT NULL
- domain — VARCHAR(255) — NOT NULL
- first_seen_at — DATETIME
- last_seen_at — DATETIME
reports
- report_id — BIGINT
- keyword — VARCHAR(255) — NOT NULL
- intent — ENUM('info','compare','transaction','nav') — NOT NULL
- status — ENUM('created','processing','done','failed') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
search_results
- result_id — BIGINT
- run_id — BIGINT — NOT NULL
- page_id — BIGINT — NOT NULL
- rank — INT — NOT NULL
- title — VARCHAR(512)
- snippet — TEXT
- serp_features — JSON
- fetched_at — DATETIME — NOT NULL
search_runs
- run_id — BIGINT
- report_id — BIGINT — NOT NULL
- engine_id — BIGINT — NOT NULL
- query_text — TEXT — NOT NULL
- executed_at — DATETIME — NOT NULL
- results_json — JSON