data-mart

Tables (4)

keyword_groups_dim

  • group_id — INT — Primary key
  • group_name — VARCHAR(255)
  • display_name — VARCHAR(255)
  • description — TEXT

post_keyword_groups

  • post_id — BIGINT — Foreign key → posts_dim.post_id
  • group_id — INT — Foreign key → keyword_groups_dim.group_id
  • has_keyword — BOOLEAN

posts_dim

  • post_id — BIGINT — Primary key
  • url — VARCHAR(255)
  • raw_date — VARCHAR(255)
  • post_date — DATE
  • post_month — INT
  • post_year — INT
  • author — VARCHAR(255)
  • question_text — TEXT

tokens_fact

  • token_id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → posts_dim.post_id
  • token — VARCHAR(255)
  • token_pos — VARCHAR(100)
  • token_count — INT
  • token_position — INT
  • is_stopword — BOOLEAN