expertise_id int(11) not_null auto_increment comment(Auto-incrementing expertise ID)
agent_id varchar(100) not_null comment(Agent identifier)
output_type varchar(50) not_null comment(Type of output)
expertise_level enum('novice','competent','expert') not_null comment(Expertise level)
expertise_weight decimal(3,2) not_null default 1.00 comment(Weight multiplier for consensus (0.50-1.50))
evaluation_count int(11) not_null default 0 comment(Number of evaluations performed)
average_agreement decimal(3,2) default null comment(Average agreement with consensus)
registered_at timestamp NULL default(current_timestamp) comment(When expertise was registered)
updated_at timestamp NULL default(current_timestamp) ON UPDATE current_timestamp() comment(Last update timestamp)

--
primary expertise_id
unique unique_agent_output_expertise agent_id output_type
idx_agent_id agent_id
idx_output_type output_type
idx_expertise_level expertise_level

##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
