kyj-yanglao-end-new/sql/mysql/food_satisfaction_survey.sql

DROP TABLE IF EXISTS `food_satisfaction_survey`;
CREATE TABLE `food_satisfaction_survey` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色',
  `record_date` date DEFAULT NULL COMMENT '记录日期',
  `fresh` decimal(5, 2) DEFAULT NULL COMMENT '菜品新鲜度',
  `taste` decimal(5, 2) DEFAULT NULL COMMENT '菜品口味（咸淡、口感等）',
  `variety` decimal(5, 2) DEFAULT NULL COMMENT '菜品种类丰富度',
  `staple` decimal(5, 2) DEFAULT NULL COMMENT '主食多样性（米饭、面食等）',
  `soup` decimal(5, 2) DEFAULT NULL COMMENT '汤品 / 饮品口感与温度',
  `nutrtion` decimal(5, 2) DEFAULT NULL COMMENT '菜品营养搭配合理性',
  `tableware` decimal(5, 2) DEFAULT NULL COMMENT '餐具清洁程度',
  `environment` decimal(5, 2) DEFAULT NULL COMMENT '用餐环境卫生（桌椅、地面等）',
  `attitude` decimal(5, 2) DEFAULT NULL COMMENT '工作人员服务态度',
  `timely` decimal(5, 2) DEFAULT NULL COMMENT '菜品供应及时性（未出现长时间断供）',
  `portion` decimal(5, 2) DEFAULT NULL COMMENT '菜品分量充足度',
  `soft_food` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否满足软食需求',
  `vegetarian` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否满足素食需求',
  `allergy_label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '对有过敏食材的人群，是否能提供明确的食材标注',
  `improve` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最需要改进的方面',
  `new_dishes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '希望新增哪些菜品或服务',
  `other` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '其他想反馈的内容',
  `quality_total` decimal(5, 2) DEFAULT NULL COMMENT '膳食质量评价总分',
  `service_total` decimal(5, 2) DEFAULT NULL COMMENT '膳食服务评价总分',
  `submitter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提交人',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '机构id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='膳食满意度调查' ROW_FORMAT=Dynamic;