ㄴㄴ

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