CREATE TABLE IF NOT EXISTS facebook_post_observations (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, facebook_group_id BIGINT UNSIGNED NOT NULL,
 post_url TEXT NULL, post_label TEXT NOT NULL, published_at DATETIME NULL,
 reach_count INT UNSIGNED NULL, reaction_count INT UNSIGNED NOT NULL DEFAULT 0, comment_count INT UNSIGNED NOT NULL DEFAULT 0,
 best_comment TEXT NULL, diagnosis TEXT NOT NULL, suggestion TEXT NOT NULL, observed_at DATETIME NOT NULL,
 UNIQUE KEY group_latest_observation (facebook_group_id), INDEX(observed_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
