feedback_id varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci not_null comment(Primary key - string identifier generated by FeedbackManager (e.g. feedback_xxx_yyy))
target_actor_id varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci not_null comment(FK to the actor agent receiving the feedback)
output_id varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci not_null comment(Identifier of the actor output being evaluated by the critic(s))
consensus_score decimal(3,2) not_null default 0.00 comment(Aggregated critic consensus score - range 0.00 to 1.00)
categorized_feedback longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin not_null comment(JSON map of feedback grouped by category - correctness, completeness, efficiency, best_practice) CHECK (json_valid(categorized_feedback))
strengths longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin not_null comment(JSON array of strengths identified by the critics) CHECK (json_valid(strengths))
improvements longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin not_null comment(JSON array of improvement suggestions emitted by the critics) CHECK (json_valid(improvements))
acknowledged tinyint(1) default 0 comment(1 once the actor has acknowledged the feedback, 0 otherwise)
created_at timestamp NULL default(current_timestamp) comment(Timestamp of feedback creation)
delivered_at timestamp NULL default null comment(Timestamp when the feedback was delivered to the target actor)
acknowledged_at timestamp NULL default null comment(Timestamp of the actor acknowledgment, NULL until acknowledged)

--
primary feedback_id
idx_target_actor target_actor_id
idx_output_id output_id
idx_acknowledged acknowledged
idx_created_at created_at
idx_consensus_score consensus_score

##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
