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