思诺指标数据库设计

achi_level_indicators 初始化查的这张表 根据"年度绩效目标1" indicator_init(“indicator_table”, “年度绩效目标1”,"");
achi_indicator 根据一级二级查询这张表
achi_cases
achi_cases_indicators
指标表与案例表根据中间表 achi_cases_indicators相互关联

//第一张表  根据指标名称获取一级二级指标数据
SELECT a.`indicator_name` AS indOne,b.`indicator_name` AS indTwo,a.`order_num` as indOne_order, b.`order_num`as indTwo_order
FROM `achi_level_indicators` a, achi_level_indicators b
WHERE a.`indicator_id` = b.`parent_id`
<if test="indicatorName != null  and indicatorName != '' ">AND a.parent_id=(SELECT indicator_id FROM achi_level_indicators WHERE indicator_name=#{indicatorName})</if>
ORDER BY a.`order_num` , b.`order_num`