-- 服务预约评价表（专家模块）
CREATE TABLE IF NOT EXISTS `biz_service_appointment_review` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `appointment_id` bigint(20) NOT NULL COMMENT '预约ID',
  `reviewer_name` varchar(64) NOT NULL COMMENT '评价人姓名',
  `review_time` datetime NOT NULL COMMENT '评价时间',
  `punctuality_score` tinyint(4) NOT NULL COMMENT '到场准时1-5',
  `attitude_score` tinyint(4) NOT NULL COMMENT '服务态度1-5',
  `guidance_score` tinyint(4) NOT NULL COMMENT '指导效果1-5',
  `summary` varchar(200) DEFAULT NULL COMMENT '综合评价',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_appointment_id` (`appointment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务预约评价(专家)';