ORACLE转MYSQL各种函数说明（ROW_NUMBER() ，COUNT()，DENSE_RANK()）

ORACLE转MYSQL各种函数说明

涉及函数：

1. ROW_NUMBER() OVER(order by x desc)
2. ROW_NUMBER() OVER(PARTITION BY x ORDER BY y)
3. COUNT() OVER(PARTITION BY x order by y desc)
4. DENSE_RANK() OVER(ORDER BY x)

1、通用公式：（分组排序加序号）

ORACLE:

SELECT 
	tion.分组字段名称,
	ROW_NUMBER() OVER(PARTITION BY tion.分组字段名称 ORDER BY 排序字段名称) AS 
FROM 目标表名称 tion ;

MYSQL:

SELECT
  tion.分组字段名称,
  @last := IF(@first = tion.分组字段名称, @last + 1, 1),
  @first := tion.分组字段名称
FROM 目标表名称 tion,
     (SELECT
         @last := 0,
         @first := NULL) c
ORDER BY 分组字段名称, 排序字段名称

2、ROW_NUMBER() OVER(order by x desc)

根据X排序，不分组，取序号。

分析：若没有数据，可以造数据，根据需求，这里的需求是给t1a_workday表按照day_dt降序排列，然后加序号。这里就可以直接往t1a_workday的day_dt插入数据，比如’2016-12-31’,’2017-05-26’,2018-05-15’……随便加几个数据，然后执行sql，看排序之后的数据是不是从大到小排列，序号是不是从小到大往上走的，以此方法验证。

ORACLE:

select day_dt,row_number() over(order by day_dt desc) as row_number from t1a_workday;  

MYSQL:

SELECT day_dt,(@row_number:[email protected]_number+1) AS row_number FROM t1a_workday a,(SELECT (@row_number:=0))b ORDER BY day_dt desc;

3、ROW_NUMBER() OVER(PARTITION BY x ORDER BY y)

根据X分组Y排序，取第一条

分析：若没有数据，可以造数据，根据需求，这里的需求是取T3B_CASE_WF_LOG表某案例不同岗位最近的操作意见。按照CURR_POST_ID分组，OPR_TM降序排列，然后加序号，取第一条。这里就可以直接往T3B_CASE_WF_LOG的CURR_POST_ID，ADVICE，OPR_TM，CASE_ID插入数据，比如下图第一个……随便加几个数据，然后执行sql，看分组排序之后的数据是不是根据post_id分组，opr_tm从大到小排列，序号是不是按post_id从小到大往上走的，以此方法验证。

ORACLE:

SELECT CURR_POST_ID,ADVICE
  FROM (SELECT CURR_POST_ID,ADVICE,
               ROW_NUMBER() OVER(PARTITION BY CURR_POST_ID ORDER BY OPR_TM DESC) AS dt_num
          FROM T3B_CASE_WF_LOG
         WHERE CASE_ID = 'C201711281657171176') A
 WHERE A.dt_num = 1

MYSQL:

SELECT  SUBSTRING_INDEX( GROUP_CONCAT(advice ORDER BY opr_tm DESC SEPARATOR '_'),'_',1) advice,curr_post_id 
 FROM (
	SELECT curr_post_id,advice,opr_tm FROM T3B_CASE_WF_LOG WHERE CASE_ID = 'C201711281657171176'  ORDER BY curr_post_id ASC ,opr_tm DESC
 )b GROUP BY curr_post_id;

ROW_NUMBER() OVER(PARTITION BY x ORDER BY y)

多字段的分组取值，同上的操作，简洁版

分析：第一步、分组求和TR_AMT；第二步，根据ALERT_ID分组，TR_AMT降序排列；第三步，取每个ALERT_ID的第一条所有数据。

ORACLE:

select a.FETR_ID, a.ALERT_ID, a.CUST_ID, a.PK, a.TR_DT, a.SUB_FETR_ID
from (select c.FETR_ID,
c.ALERT_ID,
c.CUST_ID,
ROW_NUMBER() OVER(PARTITION BY c.ALERT_ID ORDER BY c.TR_AMT DESC) PK,
c.TR_DT,
c.SUB_FETR_ID
from (SELECT b.FETR_ID,
b.ALERT_ID,
b.CUST_ID,
b.TR_DT,
sum(b.TR_AMT) as TR_AMT,
b.SUB_FETR_ID
FROM T3H_ALERT_TRAN_MID b
where b.SUB_FETR_ID = ‘CPDE-100008’
group by b.FETR_ID,
b.ALERT_ID,
b.CUST_ID,
b.TR_DT,
b.SUB_FETR_ID) c) a where a.PK = 1;

MYSQL:

SELECT 
	SUBSTRING_INDEX( GROUP_CONCAT(c.FETR_ID ORDER BY c.TR_AMT DESC SEPARATOR '_'),'_',1) AS fetr_id,
	c.ALERT_ID,
	SUBSTRING_INDEX( GROUP_CONCAT(c.CUST_ID ORDER BY c.TR_AMT DESC SEPARATOR '_'),'_',1) AS CUST_ID,
	'1' AS pk,
	SUBSTRING_INDEX( GROUP_CONCAT(c.TR_DT ORDER BY c.TR_AMT DESC SEPARATOR '_'),'_',1) AS TR_DT,
	SUBSTRING_INDEX( GROUP_CONCAT(c.SUB_FETR_ID ORDER BY c.TR_AMT DESC SEPARATOR '_'),'_',1) AS SUB_FETR_ID
FROM
       (SELECT b.FETR_ID,
                         b.ALERT_ID,
                         b.CUST_ID,
                         b.TR_DT,
                         SUM(b.TR_AMT) AS TR_AMT,
                         b.SUB_FETR_ID
                    FROM T3H_ALERT_TRAN_MID b
                   WHERE b.SUB_FETR_ID = 'CPDE-100008'
                   GROUP BY b.FETR_ID,
                            b.ALERT_ID,
                            b.CUST_ID,
                            b.TR_DT,
                            b.SUB_FETR_ID) c GROUP BY c.ALERT_ID 

5、ROW_NUMBER() OVER(PARTITION BY x ORDER BY y)

分组排序加序号

分析：根据CASE_ID分组，然后根据CASE_SCORE排序，加序号

ORACLE:

SELECT ROW_NUMBER() OVER(PARTITION BY T.CASE_ID ORDER BY T.CASE_SCORE DESC) AS ORD_SEQ,
       T.CASE_ID,
       T.MODEL_ID,
       T1.MODEL_NAME
  FROM T3B_CASE_MODEL_MID T, T1F_SUSP_MODEL T1
 WHERE T.MODEL_ID = T1.MODEL_ID;

MYSQL:

SELECT  
    @group_row:=CASE WHEN @case_id=a.case_id THEN  @group_row+1 ELSE 1 END AS groupRow,
    @case_id:=a.case_id AS case_id,
    a.model_id,a.model_name
  FROM  
    (
      SELECT 
        T.CASE_ID,T.MODEL_ID,T1.MODEL_NAME,t.CASE_SCORE
      FROM T3B_CASE_MODEL_MID t,T1F_SUSP_MODEL T1 
      WHERE T.MODEL_ID=T1.MODEL_ID
    )a ,(SELECT @group_row:=1, @case_id:='') AS b
    ORDER BY   a.case_id ASC, a.CASE_SCORE DESC;

6、COUNT() OVER(PARTITION BY x order by y desc)：

求分组后的总数

分析：以case_id分组，统计分组后每个case_id的记录总数及对应的别的数据

ORACLE:

select T.CASE_ID,COUNT(*) OVER(PARTITION BY T.CASE_ID) as ORD_SEQ,
       t.CASE_SCORE,
       T.MODEL_ID,
       T1.MODEL_NAME
  FROM T3B_CASE_MODEL_MID T, T1F_SUSP_MODEL T1
 WHERE T.MODEL_ID = T1.MODEL_ID;

MYSQL:（通用版）

 SELECT a.CASE_ID, b.count_model, a.CASE_SCORE, a.MODEL_ID, a.MODEL_NAme
   FROM (SELECT T.CASE_ID, T.MODEL_ID, T1.MODEL_NAME, t.CASE_SCORE
           FROM T3B_CASE_MODEL_MID t, T1F_SUSP_MODEL T1
          WHERE T.MODEL_ID = T1.MODEL_ID) a,
        (SELECT t.case_id, COUNT(*) AS count_model
           FROM T3B_CASE_MODEL_MID t, T1F_SUSP_MODEL T1
          WHERE T.MODEL_ID = T1.MODEL_ID
          GROUP BY t.case_id) b
  WHERE a.case_id = b.case_id

7、DENSE_RANK() OVER(ORDER BY x)

连续排序，有两个第二名时仍然跟着第三名

分析：根据cust_id排序，一样的cust_id序号一样，紧接着的是序号+1

ORACLE:

SELECT T1.CUST_ID,
       T1.OPP_CUST_ID,
       DENSE_RANK() OVER(ORDER BY T1.CUST_ID) AS NET_ID
  FROM T3X_TRANS_OPP_D T1;

MYSQL:

 SELECT main.cust_id,
       main.OPP_CUST_ID,
       (SELECT 
            COUNT(DISTINCT cust_id)
          FROM T3X_TRANS_OPP_D sub
         WHERE main.cust_id > sub.cust_id) + 1 rank
  FROM T3X_TRANS_OPP_D main
 ORDER BY rank IS NULL, rank;

DENSE_RANK() OVER(ORDER BY ，COUNT() OVER(PARTITION BY，ROW_NUMBER() OVER(PARTITION BY组合使用

组合使用

分析：这是个比较复杂的函数组合应用，用到了count() over(partition by ),dense_rank() over(partition by ),row_number() over (partition by order by),第一个括号里面的内容比较容易实现，但由于实现后的sql内容较多，要实现外面的那些函数的话，就会看起来比较复杂，这里用中间表的话，看起来会简洁明了许多。

ORACLE:

SELECT T1.NEW_NET_ID,T1.NET_ID,T1.OBJ_ID,T1.NET_CNT,
       COUNT(T1.OBJ_ID) OVER(PARTITION BY T1.NET_ID) AS OBJ_CNT,
       ROW_NUMBER() OVER(PARTITION BY T1.NET_ID ORDER BY T1.NET_CNT DESC, T1.NEW_NET_ID) AS ROW_NUM
  FROM (SELECT  '1201'||'N'||'0'||'-'||DENSE_RANK() OVER(ORDER BY T.OBJ_ID) AS NEW_NET_ID,
               COUNT(T.NET_ID) OVER(PARTITION BY T.OBJ_ID) AS NET_CNT,
               T.NET_ID,
               T.OBJ_ID AS OBJ_ID
          FROM T3X_NET_MID1 T,
               (SELECT T.OBJ_ID
                  FROM T3X_NET_MID1 T
                 GROUP BY T.OBJ_ID
                HAVING COUNT(T.NET_ID) > 1) S
         WHERE T.OBJ_ID = S.OBJ_ID
         ) T1;

MYSQL:
分解第一步（实现图14选中的sql的结果）：

INSERT INTO T3X_NET_MID4                      
  (new_net_id, net_cnt, net_id, obj_id)                         
SELECT CONCAT_WS('','1201', 'N', '0', '-', a.rank) AS NEW_NET_ID, 
       s.NET_CNT,                                                 
       a.NET_ID,                                                  
       a.OBJ_ID                                                   
  FROM (SELECT main.OBJ_ID,                                       
               main.NET_ID,                                       
               (SELECT COUNT(DISTINCT OBJ_ID)                     
                  FROM (SELECT t.NET_ID, T.OBJ_ID                 
                          FROM T3X_NET_MID1 T,                    
                               (SELECT T.OBJ_ID                   
                                  FROM T3X_NET_MID1 T             
                                 GROUP BY T.OBJ_ID                
                                HAVING COUNT(T.NET_ID) > 1) S     
                         WHERE T.OBJ_ID = S.OBJ_ID) sub           
                 WHERE main.OBJ_ID > sub.OBJ_ID) + 1 rank         
          FROM (SELECT t.NET_ID, T.OBJ_ID                         
                  FROM T3X_NET_MID1 T,                            
                       (SELECT T.OBJ_ID                           
                          FROM T3X_NET_MID1 T                     
                         GROUP BY T.OBJ_ID                        
                        HAVING COUNT(T.NET_ID) > 1) S             
                 WHERE T.OBJ_ID = S.OBJ_ID) main                  
         ORDER BY rank IS NULL, rank) a,                          
       (SELECT obj_id, COUNT(NET_ID) AS NET_CNT                   
          FROM T3X_NET_MID1                                       
         GROUP BY obj_id) s                                       
 WHERE a.OBJ_ID = S.OBJ_ID ;

分解第二步（实现最终结果，借用中间表完成）：

SELECT a.NEW_NET_ID,a.OBJ_ID,a.NET_CNT,a.OBJ_CNT,                     
       @group_row := CASE                                             
         WHEN @net_id = a.net_id THEN                                 
          @group_row + 1                                              
         ELSE                                                         
          1                                                           
       END AS ROW_NUM,                                                
       @net_id := a.net_id AS net_id                                  
  FROM (SELECT k.NEW_NET_ID, k.NET_ID, k.OBJ_ID, k.NET_CNT, t.OBJ_CNT 
          FROM T3X_NET_MID4 k,                                        
               (SELECT net_id, COUNT(OBJ_ID) AS OBJ_CNT               
                  FROM T3X_NET_MID4                                   
                 GROUP BY net_id) t                                   
         WHERE k.net_id = t.net_id) a,                                
       (SELECT @group_row := 1, @net_id := '') AS b                   
 ORDER BY a.NET_ID, a.NET_CNT DESC     

ps:测试数据奉上：

造数据原则，PARTITION BY后面的字段造多个一样的，ORDER BY后面的字段造多个不一样的，如果要测试dense_rank的话，order by 后面的字段也应该造几个一样，几个不一样的。自己心里要有期待的数据结果，最后通过sql执行结果验证正确性。

--2、row_number() over(order by 测试数据
insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('06-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('07-11-2015', 'dd-mm-yyyy'), '1', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('08-11-2015', 'dd-mm-yyyy'), '1', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('09-11-2015', 'dd-mm-yyyy'), '0', '1', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('10-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('11-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('12-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('13-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('14-11-2015', 'dd-mm-yyyy'), '1', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('15-11-2015', 'dd-mm-yyyy'), '1', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('16-11-2015', 'dd-mm-yyyy'), '0', '1', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('17-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('18-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('19-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('20-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('21-11-2015', 'dd-mm-yyyy'), '1', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('22-11-2015', 'dd-mm-yyyy'), '1', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('23-11-2015', 'dd-mm-yyyy'), '0', '1', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('24-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('25-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

insert into t1a_workday (DAY_DT, IS_HOLIDAY, IS_WEEK_FIRST, DAY_DESC, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER)
values (to_date('26-11-2015', 'dd-mm-yyyy'), '0', '0', null, '2018-04-16 13:55:54', 'admin', '2018-04-16 13:55:54', 'admin');

--3、ROW_NUMBER() OVER(PARTITION BY测试数据
insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129093121', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 09:31:21', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129093525', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-11-29 09:35:25', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129093555', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 09:35:55', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129142704', null, null, 'WFBS0101', 'P1101', '1', null, 'P1103', 'WFBS0103', '3', '排除至审批岗', '1', '低风险，排除可疑', '2017-11-29 14:27:04', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129142843', null, null, 'WFBS0103', 'P1103', '3', null, 'P1102', 'WFBS0102', '5', '退回', '1', '情况不明朗，持续跟踪', '2017-11-29 14:28:43', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143110', null, null, 'WFBS0102', 'P1102', '5', null, 'P1101', 'WFBS0101', '5', '退回', '0', '情况不明朗，持续跟踪', '2017-11-29 14:31:10', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143526', null, null, 'WFBS0103', 'P1103', '3', null, 'P9999', 'WFBS9999', '4', '同意', '1', '中风险，正常走流程', '2017-11-29 14:35:26', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143625', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 14:36:25', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143723', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '情况不明朗，持续跟踪', '2017-11-29 14:37:23', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143754', null, null, 'WFBS0102', 'P1102', '2', null, 'P1101', 'WFBS0101', '5', '退回', '0', '中风险，正常走流程', '2017-11-29 14:37:54', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143851', null, null, 'WFBS0101', 'P1101', '5', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '情况不明朗，持续跟踪', '2017-11-29 14:38:51', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143939', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 14:39:39', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129093449', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-29 09:34:49', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129104140', null, null, 'WFBS0103', 'P1103', '3', null, 'P9999', 'WFBS9999', '4', '同意', '1', '中风险，正常走流程', '2017-11-29 10:41:40', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129104232', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 10:42:32', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129104815', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 10:48:15', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143453', null, null, 'WFBS0101', 'P1101', '5', null, 'P1103', 'WFBS0103', '3', '排除至审批岗', '1', '情况不明朗，持续跟踪', '2017-11-29 14:34:53', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129104059', null, null, 'WFBS0101', 'P1101', '1', null, 'P1103', 'WFBS0103', '3', '排除至审批岗', '1', '中风险，正常走流程', '2017-11-29 10:40:59', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129104555', null, null, 'WFBS0101', 'P1101', '1', null, 'P1103', 'WFBS0103', '3', '排除至审批岗', '1', '中风险，正常走流程', '2017-11-29 10:45:55', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129104803', null, null, 'WFBS0103', 'P1103', '3', null, 'P9999', 'WFBS9999', '4', '同意', '1', '中风险，正常走流程', '2017-11-29 10:48:03', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129143910', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-11-29 14:39:10', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144419', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '情况不明朗，持续跟踪', '2017-11-29 14:44:19', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144450', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '中风险，正常走流程', '2017-11-29 14:44:50', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144618', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 14:46:18', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144741', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-29 14:47:41', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144826', null, null, 'WFBS0102', 'P1102', '2', null, 'P1101', 'WFBS0101', '5', '退回', '0', '中风险，正常走流程', '2017-11-29 14:48:26', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144851', null, null, 'WFBS0101', 'P1101', '5', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-29 14:48:51', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144923', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-11-29 14:49:23', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129144948', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 14:49:48', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145246', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '中风险，正常走流程', '2017-11-29 14:52:46', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145319', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-11-29 14:53:19', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145342', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 14:53:42', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145510', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-29 14:55:10', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145550', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-11-29 14:55:50', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145647', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-29 14:56:47', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129145837', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-29 14:58:37', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171128173102', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-28 17:31:02', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171128173227', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-11-28 17:32:27', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171128173312', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-11-28 17:33:12', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129092934', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '高风险，继续核实', '2017-11-29 09:29:34', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171129093012', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '中风险，正常走流程', '2017-11-29 09:30:12', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206110206', null, null, 'WFBS0102', 'P1102', '2', null, 'P1101', 'WFBS0101', '5', '退回', '0', '啊啊啊啊啊啊啊', '2017-12-06 11:02:06', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206110506', null, null, 'WFBS0101', 'P1101', '5', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '中风险，正常走流程', '2017-12-06 11:05:06', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206111245', null, null, 'WFBS0101', 'P1101', '1', null, 'P1102', 'WFBS0102', '2', '排除至审核岗', '1', '啊啊啊啊啊啊啊', '2017-12-06 11:12:45', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206110714', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '高风险，继续核实', '2017-12-06 11:07:14', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206110832', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-12-06 11:08:32', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206111402', null, null, 'WFBS0102', 'P1102', '2', null, 'P9999', 'WFBS9999', '4', '同意', '1', '中风险，正常走流程', '2017-12-06 11:14:02', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', null, '20171206111452', null, null, 'WFBS9999', 'P9999', '4', null, 'P1101', 'WFBS0101', '1', '恢复', '0', '恢复到甄别岗', '2017-12-06 11:14:52', 'admin');

insert into T3B_CASE_WF_LOG (CASE_ID, STAT_DT, WF_SEQ, FLOW_ID, CURR_ORG_ID, CURR_NODE_ID, CURR_POST_ID, CURR_STS, NEXT_ORG_ID, NEXT_POST_ID, NEXT_NODE_ID, NEXT_STS, OPER_ID, IS_DEL, ADVICE, OPR_TM, OPR_USER)
values ('C201711281657171176', to_date('28-11-2017', 'dd-mm-yyyy'), '20180702045457', 'WFBS01', null, 'WFBS0101', 'P1101', null, null, 'P1101', 'WFBS0101', '1', '跟踪', '0', '中风险，正常走流程', '2018-07-02 04:54:57', 'admin');

--4、测试数据
--oracle测试数据
insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '15', '123', '0021566', null, 'MT1021', null, 6000.0000, null, to_date('19-03-2019', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '14', '124', '0021567', null, 'MT1022', null, 45.0000, null, to_date('01-03-2019', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '13', '124', '0021567', null, 'MT1025', null, 180.0000, null, to_date('03-03-2019', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '12', '123', '0021566', null, 'MT1026', null, 200.0000, null, to_date('07-03-2018', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('2', '21', '223', '2021562', null, 'MT1027', null, 99.0000, null, to_date('07-03-2018', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('2', '22', '224', '2021561', null, 'MT1029', null, 12.0000, null, to_date('03-03-2019', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('3', '35', '323', '0021533', null, 'MT1030', null, 526.0000, null, to_date('23-03-2015', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('3', '34', '324', '0021543', null, 'MT1031', null, 458.0000, null, to_date('30-03-2016', 'dd-mm-yyyy'), 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('3', '33', '324', '0021563', null, 'MT1032', null, 426.0000, null, to_date('24-03-2019', 'dd-mm-yyyy'), 'CPDE-100008', null);
--mysql测试数据
insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '15', '123', '0021566', null, 'MT1021', null, 6000.0000, null, '2019-03-19', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '14', '124', '0021567', null, 'MT1022', null, 45.0000, null, '2019-03-01', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '13', '124', '0021567', null, 'MT1025', null, 180.0000, null, '2019-03-19', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('1', '12', '123', '0021566', null, 'MT1026', null, 200.0000, null, '2018-03-07', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('2', '21', '223', '2021562', null, 'MT1027', null, 99.0000, null, '2018-03-07', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('2', '22', '224', '2021561', null, 'MT1029', null, 12.0000, null, '2019-03-03', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('3', '35', '323', '0021533', null, 'MT1030', null, 526.0000, null, '2015-03-23', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('3', '34', '324', '0021543', null, 'MT1031', null, 458.0000, null, '2016-03-30', 'CPDE-100008', null);

insert into T3H_ALERT_TRAN_MID (ALERT_ID, FETR_ID, OBJ_ID, CUST_ID, ACCT_ID, TR_ID, ORG_ID, TR_AMT, ALERT_DT, TR_DT, SUB_FETR_ID, TMP_KEY)
values ('3', '33', '324', '0021563', null, 'MT1032', null, 426.0000, null, '2019-03-24', 'CPDE-100008', null);

--5、ROW_NUMBER() OVER(   6、COUNT() OVER(PARTITION BY测试数据
insert into T1F_SUSP_MODEL (MODEL_ID, MODEL_NAME, MODEL_DESC, MODEL_TYPE, OBJ_TYPE, CRIME_TYPE, MODEL_STS, MIN_SCORE, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER, MODEL_SQL, MODEL_SQL_DES, MODEL_LEVEL)
values ('1301', '涉恐可疑模型', '交易特征1、身份证号前两位为“65”；2、姓名4个汉字以上（含4个）', '09', '1', '0301', '3', 0.00, '2017-03-31', 'admin', '2017-11-16 05:23:23', 'admin', null, null, '2');

insert into T1F_SUSP_MODEL (MODEL_ID, MODEL_NAME, MODEL_DESC, MODEL_TYPE, OBJ_TYPE, CRIME_TYPE, MODEL_STS, MIN_SCORE, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER, MODEL_SQL, MODEL_SQL_DES, MODEL_LEVEL)
values ('1302', '骗取出口退税', '可疑主体身份信息多为生产厂家虚开发票和骗税款分成的回流资金。', '12', '2', '1001', '3', 20.00, '2017-03-30', 'admin', null, null, null, null, '2');

insert into T1F_SUSP_MODEL (MODEL_ID, MODEL_NAME, MODEL_DESC, MODEL_TYPE, OBJ_TYPE, CRIME_TYPE, MODEL_STS, MIN_SCORE, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER, MODEL_SQL, MODEL_SQL_DES, MODEL_LEVEL)
values ('1303', '虚开增值税专用发票', '1、可疑主体身份基本信息：企业代理注册特征明显，多为农产品企业等享受税收优惠企业或者黄金珠宝经销商、商贸公司、黄金珠宝公司，注册时间、注册地址相近或类似，同类型企业股东交叉， 有相同控制人，且存在被同一团伙控制情形。', '12', '2', '1001', '3', 0.00, '2017-03-31', 'admin', null, null, null, null, '2');

insert into T1F_SUSP_MODEL (MODEL_ID, MODEL_NAME, MODEL_DESC, MODEL_TYPE, OBJ_TYPE, CRIME_TYPE, MODEL_STS, MIN_SCORE, CREATE_TM, CREATOR, MODIFY_TM, MODIFIER, MODEL_SQL, MODEL_SQL_DES, MODEL_LEVEL)
values ('1304', '非法集资（201号） ', '以个人名义集资，以公司名义集资', '04', '2', '0701', '3', 0.00, '2017-03-27', 'admin', '2017-03-28 10:00:41', 'admin', null, null, '2');

--oracle测试数据
insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C20160624181302-1-3-20160624KY', to_date('24-06-2016', 'dd-mm-yyyy'), '1302', 1, '1', '1302-1-3-20160624', 10.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C201606241813022016062423', to_date('24-06-2016', 'dd-mm-yyyy'), '1302', 3, '1', '1302-1-5-20160624', 4.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C2017111512415101000000121061', to_date('15-11-2017', 'dd-mm-yyyy'), '1302', 1, '2', '1302-1-38-20160707', 3.00, 4.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C20160624181302-1-3-20160624KY', to_date('24-06-2016', 'dd-mm-yyyy'), '1303', 1, '1', '1302-1-3-20160624', 8.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C201606241813022016062423', to_date('24-06-2016', 'dd-mm-yyyy'), '1301', 2, '1', '1302-1-5-20160624', 8.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C201606241813022016062423', to_date('24-06-2016', 'dd-mm-yyyy'), '1304', 1, '1', '1302-1-5-20160624', 5.00, 0.00, null, null, null);

--mysql测试数据
insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C20160624181302-1-3-20160624KY', '2016-06-24', '1302', 1, '1', '1302-1-3-20160624', 10.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C201606241813022016062423', '2016-06-24', '1302', 3, '1', '1302-1-5-20160624', 4.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C2017111512415101000000121061', '2017-11-15', '1302', 1, '2', '1302-1-38-20160707', 3.00, 4.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C20160624181302-1-3-20160624KY', '2016-06-24', '1303', 1, '1', '1302-1-3-20160624', 8.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C201606241813022016062423', '2016-06-24', '1301', 2, '1', '1302-1-5-20160624', 8.00, 0.00, null, null, null);

insert into T3B_CASE_MODEL_MID (CASE_ID, STAT_DT, MODEL_ID, TRIG_SEQ, TRIG_TYPE, NET_ID, CASE_SCORE, MODEL_SCORE, FOMULA_EXP, FOMULA_DESC, CUST_ID)
values ('C201606241813022016062423', '2016-06-24', '1304', 1, '1', '1302-1-5-20160624', 5.00, 0.00, null, null, null);


--7、DENSE_RANK() OVER(ORDER BY x)的测试数据
insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000044783,01000000264813', null, '01000000264813', null, null, '01000000044783', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000201744,01000000353208', null, '01000000201744', null, null, '01000000353208', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000457476,OP6228481002298870911', null, '01000000457476', null, null, 'OP6228481002298870911', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000457476,OP6222080410001380672', null, '01000000457476', null, null, 'OP6222080410001380672', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000201744,OP6217900200001950014', null, '01000000201744', null, null, 'OP6217900200001950014', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000325177,OP6217855000026580290', null, '01000000325177', null, null, 'OP6217855000026580290', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000325177,OP6228481000586065517', null, '01000000325177', null, null, 'OP6228481000586065517', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000100035011,OP31001547840050012398', null, '01000100035011', null, null, 'OP31001547840050012398', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000192006,01000000332001', null, '01000000192006', null, null, '01000000332001', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000264813,02000000012844', null, '01000000264813', null, null, '02000000012844', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000264813,02000000018277', null, '01000000264813', null, null, '02000000018277', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000264813,OP6227000210490124896', null, '01000000264813', null, null, 'OP6227000210490124896', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000272753,OP6217000210009897611', null, '01000000272753', null, null, 'OP6217000210009897611', null);

insert into T3X_TRANS_OPP_D (RECORD_ID, ACCT_ID, CUST_ID, CUST_TYPE, IS_CASH, OPP_CUST_ID, OPP_ACCT_ID)
values ('01000000647439,OP6228481008692770672', null, '01000000647439', null, null, 'OP6228481008692770672', null);

--8、组合的测试数据
insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075252');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075259');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075260');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075266');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075272');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075273');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '02000000012844');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '02000000015181');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-3', 'OP6217855000026580290');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-3', 'OP6228481000586065517');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-4', 'OP6222080410001380672');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6217000210008698168');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6228491006004404764');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-7', '01000000555903');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-7', '01000100109733');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-7', '01000100112676');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-7', '01000100118732');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-2', 'OP6217000210009897611');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-1', '01000000353208');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000000044783');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000000264813');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075243');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075246');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075274');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075275');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075288');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075289');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075293');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075331');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075333');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-5', '01000000496049');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-5', 'OP6210210070601371469');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-5', 'OP6227070710236701');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6228481000977176816');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6228481001051887716');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-1', '01000000192006');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-2', '01000000272753');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-1', '01000000201744');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-1', 'OP6217900200001950014');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000000686980');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000000755757');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075263');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075267');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075276');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075328');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-3', '01000000325177');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-4', '01000000457476');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-5', '01000000469051');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', '01000000632250');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6212260410000505207');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6227000210770360327');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-7', '01000100111287');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-3', '01000000647439');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-3', 'OP6228481008692770672');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-4', '01000100035011');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000000433197');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075244');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075245');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075254');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075261');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075264');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075268');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075271');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075291');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075295');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075330');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075332');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '01000100075334');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', '02000000018277');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-2', 'OP6227000210490124896');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-4', 'OP6228481002298870911');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-5', 'OP6222080410001382892');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-5', 'OP6228451006019544164');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', '01000000506713');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-6', 'OP6222080410000722569');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-7', '01000100112677');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-1', '01000000332001');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-3-4', 'OP31001547840050012398');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-1', '01000100075259');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-3', '01000100075252');

insert into T3X_NET_MID1 (NET_ID, OBJ_ID)
values ('1312-1-1', '01000100075252');