gdymtsceshi/WebContent/WEB-INF/complaint/doc/字典.sql.bak

-- **************************************************
--  table name:             dic_customertype
--  table description:      客户类型
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_customertype;
CREATE TABLE dic_customertype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_customertype primary key (KeyID)
);
delete from dic_customertype;
INSERT INTO dic_customertype VALUES ('30d163b8bd1f4d849e01c93db57ca9a6', '01', '自然人', '', '0', 'true', '1.00', 1, '/0/01/', 'admin','超级管理员','2017-12-01');
INSERT INTO dic_customertype VALUES ('eb77dd9a3512432bb50b5fef3efaa229', '02', '非自然人', '', '0', 'true', '2.00', 1, '/0/02/', 'admin','超级管理员','2017-12-01');






-- **************************************************
--  table name:             dic_status
--  table description:      客户身份
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_status;
CREATE TABLE dic_status (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_status primary key (KeyID)
);
delete from dic_status;
INSERT INTO dic_status VALUES ('e3ffb44240e744d6bf129b9f1d253a1c', '01', '投保人', '', '0', 'true', '1.00', 1,'/0/01/','admin','超级管理员','2017-01-31');
INSERT INTO dic_status VALUES ('5f8bce68a0e143b8a1fa381a88dbc607', '02', '被保人', '', '0', 'true', '2.00', 1,'/0/02/','admin','超级管理员','2017-01-31');
INSERT INTO dic_status VALUES ('34ed3678443a47f0a9041b3b4e8a6389', '03', '受益人', '', '0', 'true', '3.00', 1,'/0/03/','admin','超级管理员','2017-01-31');
INSERT INTO dic_status VALUES ('5761db5083734e3eb9ce74c0a00813a8', '04', '委托人', '', '0', 'true', '4.00', 1,'/0/04/','admin','超级管理员','2017-01-31');
INSERT INTO dic_status VALUES ('d9dba1ecd2184c5cba2b0a5fc8aaa9bc', '05', '其他', '', '0', 'true', '5.00', 1,'/0/05/','admin','超级管理员','2017-01-31');










-- **************************************************
--  table name:             dic_isemployee
--  table description:      是否员工
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_isemployee;
CREATE TABLE dic_isemployee (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_isemployee primary key (KeyID)
);
delete from dic_isemployee;
INSERT INTO dic_isemployee VALUES ('8cabcbd3295a46d9a2791c946a57a254', '01', '公司员工', '', '1.00', 'true', '1.00', 1, '/0/01/', 'admin', '超级管理员', '2017-12-01');
INSERT INTO dic_isemployee VALUES ('4a0b9a62d8244f8a99a8ba320776825f', '02', '非公司员工', '', '2.00', 'true', '2.00', 1, '/0/02/', 'admin', '超级管理员', '2017-12-01');










-- **************************************************
--  table name:             dic_respondenttype
--  table description:      被投诉类型
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_respondenttype;
CREATE TABLE dic_respondenttype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_respondenttype primary key (KeyID)
);
delete from dic_respondenttype;
INSERT INTO dic_respondenttype VALUES ('3296a12288a947df94e651c51d35ea24', '01', '产品规则', '', '0', 'true', '1.00', 1,'/0/01/','admin','超级管理员','2017-01-31');
INSERT INTO dic_respondenttype VALUES ('64143616013341ff85aa7c3a38d73117', '02', '销售服务', '', '0', 'true', '2.00', 1,'/0/02/','admin','超级管理员','2017-01-31');
INSERT INTO dic_respondenttype VALUES ('0608f8b005ce4f07bdb77b36bb9eea4b', '03', '业务处理', '', '0', 'true', '3.00', 1,'/0/03/','admin','超级管理员','2017-01-31');
INSERT INTO dic_respondenttype VALUES ('a8bf9735534547c4a63a5fa250f78f64', '04', '客服人员', '', '0', 'true', '4.00', 1,'/0/04/','admin','超级管理员','2017-01-31');
INSERT INTO dic_respondenttype VALUES ('c148c254e09545289c7094bc52a13c0c', '05', '其他', '', '0', 'true', '5.00', 1,'/0/05/','admin','超级管理员','2017-01-31');








-- **************************************************
--  table name:             dic_asktype
--  table description:      诉求类型
--  author:                 齐振宇
--  publish time:           2021-08-31
-- **************************************************
-- DROP TABLE dic_asktype;
CREATE TABLE dic_asktype
(
    keyID      varchar(60) NOT NULL, -- 数据编号
    TID        varchar(60),          -- 字典编号
    TName      varchar(200),         -- 字典名称
    TURL       varchar(200),         -- 链接地址
    ParentID   varchar(60),          -- 父编号
    IsLeaf     varchar(6),           -- 是否最末级节点 true,false
    SortID     decimal(15, 2),       -- 排序编号
    TreeLevel  integer,              -- 层级
    TreePath   varchar(500),         -- 层级路径
    UserID     varchar(32),          -- 创建人工号
    UserName   varchar(255),         -- 创建人名称
    RecordTime varchar(19),          -- 创建时间
    constraint PK_dic_asktype primary key (KeyID)
);
delete from dic_asktype;
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('001','001', '行政追责', '', '0', 'false', 1.00, 1, '/0/001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('001001','001001', '检查', '', '001', 'true', 1.00, 2, '/0/001/001001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('001002','001002', '处罚或其他监管措施', '', '001', 'true', 2.00, 2, '/0/001/001002','admin','超级管理员','2017-01-31');

insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002','002', '民事诉求', '', '0', 'false', 2.00, 1, '/0/002/','admin','超级管理员','2017-01-31');

insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002001','002001', '订立合同', '', '002', 'false', 1.00, 2, '/0/002/002001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002001001','002001001', '要求承保或按原有条件续保', '', '002001', 'true', 1.00, 3, '/0/002/002001/002001001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002001002','002001002', '要求单独承保', '', '002001', 'true', 2.00, 3, '/0/002/002001/002001002/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002001003','002001003', '其他', '', '002001', 'true', 3.00, 3, '/0/002/002001/002001003/','admin','超级管理员','2017-01-31');

insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002002','002002', '履行合同', '', '002', 'false', 2.00, 2, '/0/002/002002/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002002001','002002001', '提高理赔、给付、分红金额或降低保单贷款利率', '', '002002', 'true', 1.00, 3, '/0/002/002002/002002001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002002002','002002002', '尽快理赔、给付、分红或更改保单贷款还款规则', '', '002002', 'true', 2.00, 3, '/0/002/002002/002002002/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002002003','002002003', '履行订立合同时做出的其他承诺', '', '002002', 'true', 3.00, 3, '/0/002/002002/002002003/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002002004','002002004', '其他', '', '002', 'false', 4.00, 2, '/0/002/002002/002002004/','admin','超级管理员','2017-01-31');

insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002003','002003', '恢复合同', '', '002', 'false', 3.00, 2, '/0/002/002003/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002003001','002003001', '尽快批改/保全', '', '002003', 'true', 1.00, 3, '/0/002/002003/002003001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002003002','002003002', '要求批改/保全', '', '002003', 'true', 2.00, 3, '/0/002/002003/002003002/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002003003','002003003', '其他', '', '002002', 'true', 3.00, 3, '/0/002/002003/002003003/','admin','超级管理员','2017-01-31');

insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002004','002004', '解除合同/退保', '', '002', 'false', 4.00, 2, '/0/002/002004/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002004001','002004001', '全额退保', '', '002004', 'true', 1.00, 3, '/0/002/002004/002004001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002004002','002004002', '尽快退保', '', '002004', 'true', 2.00, 3, '/0/002/002004/002004002/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002004003','002004003', '其他', '', '002003', 'true', 3.00, 3, '/0/002/002004/002004003/','admin','超级管理员','2017-01-31');

insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002005','002005', '其他', '', '002', 'false', 5.00, 2, '/0/002/002005/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002005001','002005001', '提高服务质量或道歉', '', '002005', 'true', 1.00, 3, '/0/002/002005/002005001/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002005002','002005002', '要求不要再拨打电话', '', '002005', 'true', 2.00, 3, '/0/002/002005/002005002/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002005003','002005003', '要求解释信息来源', '', '002005', 'true', 3.00, 3, '/0/002/002005/002005003/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002005004','002005004', '赔偿额外损失', '', '002005', 'true', 4.00, 3, '/0/002/002005/002005004/','admin','超级管理员','2017-01-31');
insert into dic_asktype (keyID,TID,TName,TURL,ParentID,IsLeaf,SortID,TreeLevel,TreePath,UserID,UserName,RecordTime)
values ('002005005','002005005', '其他', '', '002005', 'true', 5.00, 3, '/0/002/002005/002005005/','admin','超级管理员','2017-01-31');

commit;











-- **************************************************
--  table name:             dic_productname
--  table description:      产品名称
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_productname;
CREATE TABLE dic_productname (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_productname primary key (KeyID)
);
delete from dic_productname;
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001', '001', '个养直销', '', '0', 1.0, 'false', 1, '/0/001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001001', '001001', '福寿丰年系列产品', '', '001', 1.0, 'true', 2, '/0/001/001001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001002', '001001', '福寿嘉年系列产品', '', '001', 2.0, 'true', 2, '/0/001/001002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001003', '001002', '国寿嘉年月月盈', '', '001', 3.0, 'true', 2, '/0/001/001003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001004', '001003', '国寿双月盈', '', '001', 4.0, 'true', 2, '/0/001/001004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001005', '001004', '国寿广源半年盈', '', '001', 5.0, 'true', 2, '/0/001/001005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001006', '001005', '国寿嘉年188', '', '001', 6.0, 'true', 2, '/0/001/001006/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001007', '001006', '国寿福盈今生年年盈', '', '001', 7.0, 'true', 2, '/0/001/001007/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001008', '001007', '国寿福盈今生年年利', '', '001', 8.0, 'true', 2, '/0/001/001008/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002', '002', '个养代销-支付宝', '', '0', 2.0, 'false', 1, '/0/002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002001', '002001', '国寿周周盈', '', '002', 1.0, 'true', 2, '/0/002/002001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002002', '002001', '国寿周周利', '', '002', 2.0, 'true', 2, '/0/002/002002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002003', '002002', '国寿超月宝', '', '002', 3.0, 'true', 2, '/0/002/002003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002004', '002003', '国寿嘉年188', '', '002', 4.0, 'true', 2, '/0/002/002004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002005', '002004', '国寿安鑫盈360天 ', '', '002', 5.0, 'true', 2, '/0/002/002005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002006', '002005', '国寿安鑫利365天', '', '002', 6.0, 'true', 2, '/0/002/002006/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003', '003', '个养代销-理财通', '', '0', 5.0, 'false', 1, '/0/003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003001', '003001', '国寿嘉年天天盈', '', '003', 1.0, 'true', 2, '/0/003/003001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003002', '003002', '国寿周添利', '', '003', 2.0, 'true', 2, '/0/003/003002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003003', '003003', '国寿嘉年月月盈 ', '', '003', 3.0, 'true', 2, '/0/003/003003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003004', '003004', '国寿广源180', '', '003', 4.0, 'true', 2, '/0/003/003004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003005', '003005', '国寿广源366', '', '003', 5.0, 'true', 2, '/0/003/003005/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004', '004', '个养代销-京东金融', '', '0', 4.0, 'false', 1, '/0/004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004001', '004001', '国寿周添利', '', '004', 1.0, 'true', 2, '/0/004/004001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004002', '004002', '国寿嘉年月月盈', '', '004', 2.0, 'true', 2, '/0/004/004002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004003', '004003', '国寿广园366', '', '004', 3.0, 'true', 2, '/0/004/004003/', 'admin', '超级管理员', '2017-01-31' );


INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '005', '005', '个养代销-广发银行', '', '0', 4.0, 'false', 1, '/0/005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '005001', '005001', '国寿嘉年188', '', '005', 1.0, 'true', 2, '/0/005/005001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '005002', '005002', '国寿广源366', '', '005', 2.0, 'true', 2, '/0/005/005002/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '008', '008', '个养代销-其他', '', '0', 5.0, 'false', 1, '/0/008/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007', '007', '团养', '', '0', 6.0, 'false', 1, '/0/007/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007001', '007001', '福寿延年', '', '007', 1.0, 'true', 2, '/0/007/007001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007002', '007002', '福寿鑫瑞', '', '007', 2.0, 'true', 2, '/0/007/007002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007003', '007003', '丰盈久久 ', '', '007', 3.0, 'true', 2, '/0/007/007003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007004', '007004', '福建农信社', '', '007', 4.0, 'true', 2, '/0/007/007004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007005', '007005', '福寿鑫享 ', '', '007', 5.0, 'true', 2, '/0/007/007005/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '010', '010', '企业年金单一计划', '', '0', 7.0, 'false', 1, '/0/010/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006', '006', '企业年金集合计划', '', '0', 8.0, 'false', 1, '/0/006/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006001', '006001', '国寿永丰', '', '006', 1.0, 'true', 2, '/0/006/006001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006002', '006002', '国寿永福', '', '006', 2.0, 'true', 2, '/0/006/006002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006003', '006003', '国寿永睿 ', '', '006', 3.0, 'true', 2, '/0/006/006003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006004', '006003', '国寿永富', '', '006', 4.0, 'true', 2, '/0/006/006004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006005', '006005', '国寿永诚 ', '', '006', 5.0, 'true', 2, '/0/006/006005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006006', '006006', '国寿永乐', '', '006', 6.0, 'true', 2, '/0/006/006006/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006007', '006007', '国寿永颐', '', '006', 7.0, 'true', 2, '/0/006/006007/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006008', '006008', '国寿永祥', '', '006', 8.0, 'true', 2, '/0/006/006008/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006009', '006009', '国寿永通', '', '006', 9.0, 'true', 2, '/0/006/006009/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006010', '006010', '国寿永信', '', '006', 10.0, 'true', 2, '/0/006/006010/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '013', '013', '养老金产品', '', '0', 8.1, 'false', 1, '/0/012/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '009', '009', '职业年金', '', '0', 11.0, 'false', 1, '/0/009/', 'admin', '超级管理员', '2017-01-31' );


INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '012', '012', '第三方资产管理业务', '', '0', 12.0, 'false', 1, '/0/012/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_productname ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '099', '099', '其他', '', '0', 99.0, 'false', 1, '/0/099/', 'admin', '超级管理员', '2017-01-31' );

-- **************************************************
--  table name:             dic_saleschannel 
--  table description:      销售渠道
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_saleschannel;
CREATE TABLE dic_saleschannel (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_saleschannel primary key (KeyID)
);
delete from dic_saleschannel;
INSERT INTO dic_saleschannel VALUES ('f0d2e13ba00c4d79a0e2bd5a80b6e681', '01', '个人渠道', NULL, '0', 'true', 1, 1, '/0/01/', 'admin', '超级管理员', '2017-12-01');
INSERT INTO dic_saleschannel VALUES ('0ab4caedf9fb40279460f092bf969a29', '02', '团体渠道', NULL, '0', 'true', 3, 1, '/0/02/', 'admin', '超级管理员', '2017-12-01');
INSERT INTO dic_saleschannel VALUES ('38d89179587d40a89cac6aaee15033be', '03', '银保渠道', NULL, '0', 'true', 2, 1, '/0/03/', 'admin', '超级管理员', '2017-12-01');
INSERT INTO dic_saleschannel VALUES ('66e47ce9949a445baeff7b7540c4164e', '06', '网销渠道', NULL, '0', 'true', 4, 1, '/0/06/', 'admin', '超级管理员', '2017-12-01');
INSERT INTO dic_saleschannel VALUES ('66d93845723048e5851de67f2ba4c59d', '08', '创新协同渠道', NULL, '0', 'true', 5, 1, '/0/08/', 'admin', '超级管理员', '2017-12-01');
commit;

 
-- **************************************************
--  table name:             dic_salestype
--  table description:      销售方式
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_salestype;
CREATE TABLE dic_salestype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_salestype primary key (KeyID)
);
delete from dic_salestype;

INSERT INTO dic_salestype VALUES ('27cc126eae28433c806c80d19124dd26', '001', '业务员', '', '01', 'true', '1.00', 1, '/0/001/', 'admin', '超级管理员', '2017-12-01');
INSERT INTO dic_salestype VALUES ('a5fd769ab010481e8d056cc144acc6ec', '002', '柜面', '', '03', 'true', '2.00', 1, '/0/002/', 'admin', '超级管理员', '2017-12-01');
 
commit;











-- **************************************************
--  table name:             dic_inscetype
--  table description:      险种类别
--  author:                 韩林平
--  publish time:           2021-08-31
-- **************************************************
-- DROP TABLE dic_inscetype;
CREATE TABLE dic_inscetype
(
    keyID      varchar(60) NOT NULL, -- 数据编号
    TID        varchar(60),          -- 字典编号
    TName      varchar(200),         -- 字典名称
    TURL       varchar(200),         -- 链接地址
    ParentID   varchar(60),          -- 父编号
    IsLeaf     varchar(6),           -- 是否最末级节点 true,false
    SortID     decimal(15, 2),       -- 排序编号
    TreeLevel  integer,              -- 层级
    TreePath   varchar(500),         -- 层级路径
    UserID     varchar(32),          -- 创建人工号
    UserName   varchar(255),         -- 创建人名称
    RecordTime varchar(19),          -- 创建时间
    constraint PK_dic_inscetype primary key (KeyID)
);
delete from dic_inscetype;

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001', '001001001', '机动车辆消费贷款保证保险', null, '001001', 'true', 1.00, 3, '/0/001/001001/001001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001002', '001001002', '个人贷款抵押房屋保证保险', null, '001001', 'true', 2.00, 3, '/0/001/001001/001001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001003', '001001003', '保证保险其他', null, '001001', 'true', 3.00, 3, '/0/001/001001/001001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002', '001002', '机动车辆保险', null, '001', 'true', 2.00, 2, '/0/001/001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001', '001002001', '交强险', null, '001002', 'true', 1.00, 3, '/0/001/001002/001002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002', '001002002', '商业车险', null, '001002', 'true', 2.00, 3, '/0/001/001002/001002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003', '001002003', '机动车辆保险其他', null, '001002', 'true', 3.00, 3, '/0/001/001002/001002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003', '001003', '货物运输保险', null, '001', 'true', 3.00, 2, '/0/001/001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003001', '001003001', '货物运输保险', null, '001003', 'true', 1.00, 3, '/0/001/001003/001003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001004', '001004', '企业财产保险', null, '001', 'true', 4.00, 2, '/0/001/001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001004001', '001004001', '企业财产保险', null, '001004', 'true', 1.00, 3, '/0/001/001004/001004001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001099', '001099', '财产险其他', null, '001', 'true', 99.00, 2, '/0/001/001099/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001006001', '001006001', '家庭财产保险', null, '001006', 'true', 2.00, 3, '/0/001/001006/001006001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001007', '001007', '农业保险', null, '001', 'true', 91.00, 2, '/0/001/001007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001007001', '001007001', '农业保险', null, '001007', 'true', 2.00, 3, '/0/001/001007/001007001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001008', '001008', '船舶保险', null, '001', 'true', 91.00, 2, '/0/001/001008/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001008001', '001008001', '船舶保险', null, '001008', 'true', 2.00, 3, '/0/001/001008/001008001/', 'admin', '超级管理员', '2017-01-31');



insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001010', '001010', '特殊风险', null, '001', 'true', 92.00, 2, '/0/001/001010/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001010001', '001010001', '特殊风险', null, '001010', 'true', 2.00, 3, '/0/001/001010/001010001/', 'admin', '超级管理员', '2017-01-31');


insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001011', '001011', '综合险', null, '001', 'true', 93.00, 2, '/0/001/001011/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001011001', '001011001', '综合险', null, '001011', 'true', 2.00, 3, '/0/001/001011/001011001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001012', '001012', '协议险', null, '001', 'true', 94.00, 2, '/0/001/001012/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001012001', '001012001', '协议险', null, '001012', 'true', 2.00, 3, '/0/001/001012/001012001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001013', '001013', '种植业', null, '001', 'true', 95.00, 2, '/0/001/001013/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001013001', '001013001', '种植业', null, '001013', 'true', 2.00, 3, '/0/001/001013/001013001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001014', '001014', '养殖业', null, '001', 'true', 96.00, 2, '/0/001/001014/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001014001', '001014001', '养殖业', null, '001014', 'true', 2.00, 3, '/0/001/001014/001014001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001015', '001015', '林业', null, '001', 'true', 97.00, 2, '/0/001/001015/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001015001', '001015001', '林业', null, '001015', 'true', 2.00, 3, '/0/001/001015/001015001/', 'admin', '超级管理员', '2017-01-31');




insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001099099', '001099099', '财产险其他', null, '001099', 'true', 99.00, 3, '/0/001/001099/001099099/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002', '002', '人身险', null, '0', 'false', 1.00, 1, '/0/002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001', '002001', '健康保险', null, '002', 'true', 1.00, 2, '/0/002/002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001001', '002001001', '医疗保险', null, '002001', 'true', 1.00, 3, '/0/002/002001/002001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001002', '002001002', '疾病保险', null, '002001', 'true', 2.00, 3, '/0/002/002001/002001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001099', '002001099', '健康保险其他', null, '002001', 'true', 99.00, 3, '/0/002/002001/002001099/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002', '002002', '人寿保险', null, '002', 'true', 2.00, 2, '/0/002/002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002001', '002002001', '普通人寿保险', null, '002002', 'true', 1.00, 3, '/0/002/002002/002002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002002', '002002002', '分红保险', null, '002002', 'true', 2.00, 3, '/0/002/002002/002002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002003', '002002003', '万能保险', null, '002002', 'true', 3.00, 3, '/0/002/002002/002002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002004', '002002004', '投连保险', null, '002002', 'true', 4.00, 3, '/0/002/002002/002002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003', '002003', '意外伤害保险', null, '002', 'true', 3.00, 2, '/0/002/002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003001', '002003001', '意外伤害保险', null, '002003', 'true', 1.00, 3, '/0/002/002003/002003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002099', '002099', '人身险其他', null, '002', 'true', 99.00, 2, '/0/002/002099/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002099001', '002099001', '人身险其他', null, '002099', 'true', 1.00, 3, '/0/002/002099/002099001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001005', '001005', '责任保险', null, '001', 'true', 90.00, 2, '/0/001/001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001005001', '001005001', '责任保险', null, '001005', 'true', 2.00, 3, '/0/001/001005/001005001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001', '001', '财产险', null, '0', 'false', 1.00, 1, '/0/001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001', '001001', '保证保险', null, '001', 'true', 1.00, 2, '/0/001/001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001006', '001006', '家庭财产保险', null, '001', 'true', 90.00, 2, '/0/001/001006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001009', '001009', '工程保险', null, '001', 'true', 91.00, 2, '/0/001/001009/', 'admin', '超级管理员', '2017-01-31');

insert into dic_inscetype (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001009001', '001009001', '工程保险', null, '001009', 'true', 2.00, 3, '/0/001/001009/001009001/', 'admin', '超级管理员', '2017-01-31');
commit;






-- **************************************************
--  table name:             dic_complainttype
--  table description:      投诉类别
--  author:                 韩林平
--  publish time:           2021-08-31
-- **************************************************
-- DROP TABLE dic_complainttype;
CREATE TABLE dic_complainttype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_complainttype primary key (KeyID)
);
 
 
delete from dic_complainttype;
insert into  dic_complainttype values ('01','01','常规投诉','','0','false',1.0,1,'/0/01/','admin','超级管理员','2017-01-31');
insert into  dic_complainttype values ('02','02','疑难投诉','','0','true',2.0,1,'/0/02/','admin','超级管理员','2017-01-31');
insert into  dic_complainttype values ('03','03','重大投诉','','0','true',3.0,1,'/0/03/','admin','超级管理员','2017-01-31');





-- **************************************************
--  table name:             dic_reason
--  table description:      投诉原因
--  author:                 韩林平
--  publish time:           2017-07-18
-- **************************************************
-- DROP TABLE dic_reason;
CREATE TABLE dic_reason (
                            keyID varchar(60) NOT NULL, -- 数据编号
                            TID varchar(60) ,           -- 字典编号
                            TName varchar(200) ,        -- 字典名称
                            TURL varchar(200) ,         -- 链接地址
                            ParentID varchar(60) ,      -- 父编号
                            IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
                            SortID decimal(15,2) ,      -- 排序编号
                            TreeLevel integer     ,     -- 层级
                            TreePath varchar(500) ,     -- 层级路径
                            UserID   varchar(32)   ,    -- 创建人工号
                            UserName  varchar(255) ,    -- 创建人名称
                            RecordTime varchar(19) ,    -- 创建时间
                            constraint PK_dic_reason primary key (KeyID)
);
delete from dic_reason;

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001', '001', '销售', null, '0', 'false', 1.00, 1, '/0/001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001', '001001', '关系建立', null, '001', 'false', 1.00, 2, '/0/001/001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001', '001001001', '沟通方式', null, '001001', 'false', 1.00, 3, '/0/001/001001/001001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001001', '001001001001', '电话沟通', null, '001001001', 'true', 1.00, 4, '/0/001/001001/001001001/001001001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001002', '001001001002', '电子邮件沟通', null, '001001001', 'true', 2.00, 4, '/0/001/001001/001001001/001001001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001003', '001001001003', '短信沟通', null, '001001001', 'true', 3.00, 4, '/0/001/001001/001001001/001001001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001004', '001001001004', '移动平台沟通', null, '001001001', 'true', 4.00, 4, '/0/001/001001/001001001/001001001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001001005', '001001001005', '其他沟通方式', null, '001001001', 'true', 5.00, 4, '/0/001/001001/001001001/001001001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001002', '001001002', '沟通频率', null, '001001', 'true', 2.00, 3, '/0/001/001001/001001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001003', '001001003', '沟通态度', null, '001001', 'true', 3.00, 3, '/0/001/001001/001001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001004', '001001004', '沟通内容', null, '001001', 'true', 4.00, 3, '/0/001/001001/001001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001005', '001001005', '营销扰民', null, '001001', 'false', 5.00, 3, '/0/001/001001/001001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001005001', '001001005001', '影响正常作息', null, '001001005', 'true', 1.00, 4, '/0/001/001001/001001005/001001005001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001005002', '001001005002', '质疑信息来源', null, '001001005', 'true', 2.00, 4, '/0/001/001001/001001005/001001005002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001005003', '001001005003', '违反禁播管理制度（违规）', null, '001001005', 'true', 3.00, 4, '/0/001/001001/001001005/001001005003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001005004', '001001005004', '其他销售骚扰', null, '001001005', 'true', 4.00, 4, '/0/001/001001/001001005/001001005004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001001006', '001001006', '其他关系建立', null, '001001', 'true', 6.00, 3, '/0/001/001001/001001006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002', '001002', '产品销售', null, '001', 'false', 2.00, 2, '/0/001/001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001', '001002001', '承保规则', null, '001002', 'false', 1.00, 3, '/0/001/001002/001002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001001', '001002001001', '主险及附加险', null, '001002001', 'true', 1.00, 4, '/0/001/001002/001002001/001002001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001002', '001002001002', '定价', null, '001002001', 'true', 2.00, 4, '/0/001/001002/001002001/001002001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001003', '001002001003', '费率折扣', null, '001002001', 'true', 3.00, 4, '/0/001/001002/001002001/001002001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001004', '001002001004', '理赔对续保的影响', null, '001002001', 'true', 4.00, 4, '/0/001/001002/001002001/001002001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002001005', '001002001005', '其他承保规则', null, '001002001', 'true', 5.00, 4, '/0/001/001002/001002001/001002001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002', '001002002', '误导保险责任或收益', null, '001002', 'false', 2.00, 3, '/0/001/001002/001002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002001', '001002002001', '夸大保险责任或收益', null, '001002002', 'true', 1.00, 4, '/0/001/001002/001002002/001002002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002002', '001002002002', '承诺不确定利益的收益保证', null, '001002002', 'true', 2.00, 4, '/0/001/001002/001002002/001002002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002003', '001002002003', '隐瞒保险公司的免除责任', null, '001002002', 'true', 3.00, 4, '/0/001/001002/001002002/001002002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002004', '001002002004', '隐瞒解约损失', null, '001002002', 'true', 4.00, 4, '/0/001/001002/001002002/001002002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002005', '001002002005', '隐瞒万能、投连的费用扣除', null, '001002002', 'true', 5.00, 4, '/0/001/001002/001002002/001002002005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002006', '001002002006', '隐瞒新型产品利益的不确定性', null, '001002002', 'true', 6.00, 4, '/0/001/001002/001002002/001002002006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002007', '001002002007', '隐瞒保险期间、交费期限、不按期交费的后果', null, '/0/001/001002/001002002/001002002007/', 'true', 7.00, 4, '/0/001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002008', '001002002008', '隐瞒观察期相关情况', null, '001002002', 'true', 8.00, 4, '/0/001/001002/001002002/001002002008/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002002009', '001002002009', '隐瞒犹豫期相关情况', null, '001002002', 'true', 9.00, 4, '/0/001/001002/001002002/001002002009/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('0010020020010', '001002002010', '隐瞒满期给付年限', null, '001002002', 'true', 10.00, 4, '/0/001/001002/001002002/0010020020010/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003', '001002003', '宣传说明', null, '001002', 'false', 3.00, 3, '/0/001/001002/001002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003001', '001002003001', '虚假宣传保险法律、法规、政策', null, '001002003', 'true', 1.00, 4, '/0/001/001002/001002003/001002003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003002', '001002003002', '虚假宣传保险公司情况', null, '001002003', 'true', 2.00, 4, '/0/001/001002/001002003/001002003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003003', '001002003003', '以其他金融产品名义宣传', null, '001002003', 'true', 3.00, 4, '/0/001/001002/001002003/001002003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003004', '001002003004', '与其他金融产品收益率不实对比', null, '001002003', 'true', 4.00, 4, '/0/001/001002/001002003/001002003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003005', '001002003005', '虚假宣传产品或销售人员', null, '001002003', 'true', 5.00, 4, '/0/001/001002/001002003/001002003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003006', '001002003006', '虚假赠送', null, '001002003', 'true', 6.00, 4, '/0/001/001002/001002003/001002003006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002003007', '001002003007', '虚假停售', null, '001002003', 'true', 7.00, 4, '/0/001/001002/001002003/001002003007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004', '001002004', '其他产品销售', null, '001002', 'false', 4.00, 3, '/0/001/001002/001002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004001', '001002004001', '撤旧投新', null, '001002004', 'true', 1.00, 4, '/0/001/001002/001002004/001002004001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004002', '001002004002', '阻碍回访或诱导不如实回访', null, '001002004', 'true', 2.00, 4, '/0/001/001002/001002004/001002004002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004003', '001002004003', '阻碍消费者如实告知、利诱或唆使消费者不如实告知', null, '001002004', 'true', 3.00, 4, '/0/001/001002/001002004/001002004003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004004', '001002004004', '抢单占单', null, '001002004', 'true', 4.00, 4, '/0/001/001002/001002004/001002004004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004005', '001002004005', '强制销售（含搭售）', null, '001002004', 'true', 5.00, 4, '/0/001/001002/001002004/001002004005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001002004006', '001002004006', '其他', null, '001002004', 'true', 6.00, 4, '/0/001/001002/001002004/001002004006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003', '001003', '其他销售', null, '001', 'false', 3.00, 2, '/0/001/001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003001', '001003001', '服务内容告知', null, '001003', 'true', 1.00, 3, '/0/001/001003/001003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003002', '001003002', '礼品促销内容告知', null, '001003', 'true', 2.00, 3, '/0/001/001003/001003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003003', '001003003', '服务态度', null, '001003', 'true', 3.00, 3, '/0/001/001003/001003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003004', '001003004', '服务时效', null, '001003', 'true', 4.00, 3, '/0/001/001003/001003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001003005', '001003005', '其他', null, '001003', 'true', 5.00, 3, '/0/001/001003/001003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002', '002', '承保', null, '0', 'false', 1.00, 1, '/0/002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001', '002001', '投保', null, '002', 'false', 1.00, 2, '/0/002/002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001001', '002001001', '重要单证未签字', null, '002001', 'true', 1.00, 3, '/0/002/002001/002001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001002', '002001002', '重要单证代签', null, '002001', 'true', 2.00, 3, '/0/002/002001/002001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001003', '002001003', '风险提示语未抄录', null, '002001', 'true', 3.00, 3, '/0/002/002001/002001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001004', '002001004', '风险提示语代抄录', null, '002001', 'true', 4.00, 3, '/0/002/002001/002001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001005', '002001005', '未出示条款', null, '002001', 'true', 5.00, 3, '/0/002/002001/002001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001006', '002001006', '产品停办或切换', null, '002001', 'true', 6.00, 3, '/0/002/002001/002001006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002001007', '002001007', '其他投保', null, '002001', 'true', 7.00, 3, '/0/002/002001/002001007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002', '002002', '核保', null, '002', 'false', 2.00, 2, '/0/002/002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002001', '002002001', '拒绝承保', null, '002002', 'true', 1.00, 3, '/0/002/002002/002002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002002', '002002002', '延迟核保', null, '002002', 'true', 2.00, 3, '/0/002/002002/002002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002003', '002002003', '保额争议', null, '002002', 'true', 3.00, 3, '/0/002/002002/002002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002004', '002002004', '保费争议', null, '002002', 'true', 4.00, 3, '/0/002/002002/002002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002005', '002002005', '除外责任', null, '002002', 'true', 5.00, 3, '/0/002/002002/002002005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002002006', '002002006', '其他核保', null, '002002', 'true', 6.00, 3, '/0/002/002002/002002006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003', '002003', '出单', null, '002', 'false', 3.00, 2, '/0/002/002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003001', '002003001', '服务时效', null, '002003', 'true', 1.00, 3, '/0/002/002003/002003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003002', '002003002', '指引告知', null, '002003', 'true', 2.00, 3, '/0/002/002003/002003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003003', '002003003', '重要凭证', null, '002003', 'true', 3.00, 3, '/0/002/002003/002003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003004', '002003004', '服务态度', null, '002003', 'true', 4.00, 3, '/0/002/002003/002003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002003005', '002003005', '其他出单', null, '002003', 'true', 5.00, 3, '/0/002/002003/002003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002004', '002004', '收费', null, '002', 'false', 4.00, 2, '/0/002/002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002004001', '002004001', '收费时效', null, '002004', 'true', 1.00, 3, '/0/002/002004/002004001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002004002', '002004002', '收费金额', null, '002004', 'true', 2.00, 3, '/0/002/002004/002004002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002004003', '002004003', '收费方式', null, '002004', 'true', 3.00, 3, '/0/002/002004/002004003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002004004', '002004004', '侵占、挪用保费', null, '002004', 'true', 4.00, 3, '/0/002/002004/002004004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002004005', '002004005', '其他费用', null, '002004', 'true', 5.00, 3, '/0/002/002004/002004005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002005', '002005', '配送', null, '002', 'false', 5.00, 2, '/0/002/002005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002005001', '002005001', '配送错漏', null, '002005', 'true', 1.00, 3, '/0/002/002005/002005001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002005002', '002005002', '配送时效', null, '002005', 'true', 2.00, 3, '/0/002/002005/002005002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002005003', '002005003', '服务态度', null, '002005', 'true', 3.00, 3, '/0/002/002005/002005003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002005004', '002005004', '其他配送', null, '002005', 'true', 4.00, 3, '/0/002/002005/002005004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002006', '002006', '其他承保环节', null, '002', 'true', 6.00, 2, '/0/002/002006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003', '003', '保险合同变更（保全）', null, '0', 'false', 3.00, 1, '/0/003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001', '003001', '批改', null, '003', 'false', 1.00, 2, '/0/003/003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001001', '003001001', '擅自批改保单', null, '003001', 'true', 1.00, 3, '/0/003/003001/003001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001002', '003001002', '批改材料争议', null, '003001', 'true', 2.00, 3, '/0/003/003001/003001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001003', '003001003', '批改错漏', null, '003001', 'true', 3.00, 3, '/0/003/003001/003001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001004', '003001004', '批改费用或保费', null, '003001', 'true', 4.00, 3, '/0/003/003001/003001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001005', '003001005', '批改时效', null, '003001', 'true', 5.00, 3, '/0/003/003001/003001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001006', '003001006', '其他批改', null, '003001', 'true', 5.00, 3, '/0/003/003001/003001006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003002', '003002', '质押', null, '003', 'false', 2.00, 2, '/0/003/003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003002001', '003002001', '金额争议', null, '003002', 'true', 1.00, 3, '/0/003/003002/003002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003002002', '003002002', '质押材料争议', null, '003002', 'true', 2.00, 3, '/0/003/003002/003002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003002003', '003002003', '质押时效', null, '003002', 'true', 3.00, 3, '/0/003/003002/003002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003002004', '003002004', '其他质押', null, '003002', 'true', 4.00, 3, '/0/003/003002/003002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003003', '003003', '分红', null, '003', 'false', 3.00, 2, '/0/003/003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003003001', '003003001', '信息披露', null, '003003', 'true', 1.00, 3, '/0/003/003003/003003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003003002', '003003002', '分红金额', null, '003003', 'true', 2.00, 3, '/0/003/003003/003003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003003003', '003003003', '分红通知', null, '003003', 'true', 3.00, 3, '/0/003/003003/003003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003003004', '003003004', '其他分红', null, '003003', 'true', 4.00, 3, '/0/003/003003/003003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004', '003004', '给付', null, '003', 'false', 4.00, 2, '/0/003/003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004001', '003004001', '金额争议', null, '003004', 'true', 1.00, 3, '/0/003/003004/003004001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004002', '003004002', '给付材料争议', null, '003004', 'true', 2.00, 3, '/0/003/003004/003004002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004003', '003004003', '给付方式', null, '003004', 'true', 3.00, 3, '/0/003/003004/003004003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004004', '003004004', '给付时效', null, '003004', 'true', 4.00, 3, '/0/003/003004/003004004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004005', '003004005', '给付通知', null, '003004', 'true', 5.00, 3, '/0/003/003004/003004005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003004006', '003004006', '其他给付', null, '003004', 'true', 6.00, 3, '/0/003/003004/003004006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003005', '003005', '退保', null, '003', 'false', 5.00, 2, '/0/003/003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003005001', '003005001', '金额争议', null, '003005', 'true', 1.00, 3, '/0/003/003005/003005001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003005002', '003005002', '退保材料争议', null, '003005', 'true', 2.00, 3, '/0/003/003005/003005002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003005003', '003005003', '退保方式', null, '003005', 'true', 3.00, 3, '/0/003/003005/003005003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003005004', '003005004', '退保时效', null, '003005', 'true', 4.00, 3, '/0/003/003005/003005004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003005005', '003005005', '其他退保', null, '003005', 'true', 5.00, 3, '/0/003/003005/003005005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003006', '003006', '其他保险合同变更', null, '003', 'true', 6.00, 2, '/0/003/003006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('005', '005', '续保服务', null, '0', 'false', 5.00, 1, '/0/005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('005001', '005001', '续保服务', null, '005', 'false', 1.00, 2, '/005/005001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('005001001', '005001001', '拒绝续保或有条件续保', null, '005001', 'true', 1.00, 3, '/005/005001/005001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('005001002', '005001002', '未收到续保通知', null, '005001', 'true', 2.00, 3, '/005/005001/005001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('005001003', '005001003', '其他续保服务', null, '005001', 'true', 3.00, 3, '/005/005001/005001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006', '006', '理赔', null, '0', 'false', 6.00, 1, '/0/006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006001', '006001', '报案', null, '006', 'false', 1.00, 2, '/0/006/006001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006001001', '006001001', '电话未接通', null, '006001', 'true', 1.00, 3, '/0/006/006001/006001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006001002', '006001002', '电话无人接听', null, '006001', 'true', 2.00, 3, '/0/006/006001/006001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006001003', '006001003', '服务态度', null, '006001', 'true', 3.00, 3, '/0/006/006001/006001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006001004', '006001004', '受理错漏', null, '006001', 'true', 4.00, 3, '/0/006/006001/006001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006001005', '006001005', '其他报案服务', null, '006001', 'true', 5.00, 3, '/0/006/006001/006001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006002', '006002', '查勘（现场、非现场）', null, '006', 'false', 2.00, 2, '/0/006/006002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006002001', '006002001', '查勘时效', null, '006002', 'true', 1.00, 3, '/0/006/006002/006002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006002002', '006002002', '服务态度', null, '006002', 'true', 2.00, 3, '/0/006/006002/006002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006002003', '006002003', '查勘服务能力', null, '006002', 'true', 3.00, 3, '/0/006/006002/006002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006002004', '006002004', '其他查勘服务', null, '006002', 'true', 4.00, 3, '/0/006/006002/006002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003', '006003', '定核损', null, '006', 'false', 3.00, 2, '/0/006/006003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003001', '006003001', '责任认定', null, '006003', 'true', 1.00, 3, '/0/006/006003/006003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003002', '006003002', '金额争议', null, '006003', 'true', 2.00, 3, '/0/006/006003/006003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003003', '006003003', '定核损时效', null, '006003', 'true', 3.00, 3, '/0/006/006003/006003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003004', '006003004', '定核损错漏', null, '006003', 'true', 4.00, 3, '/0/006/006003/006003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003005', '006003005', '服务态度', null, '006003', 'true', 5.00, 3, '/0/006/006003/006003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006003006', '006003006', '其他定损服务', null, '006003', 'true', 6.00, 3, '/0/006/006003/006003006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004', '006004', '资料收集', null, '006', 'false', 4.00, 2, '/0/006/006004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004001', '006004001', '索赔申请', null, '006004', 'true', 1.00, 3, '/0/006/006004/006004001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004002', '006004002', '未一次性告知', null, '006004', 'true', 2.00, 3, '/0/006/006004/006004002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004003', '006004003', '理赔材料争议', null, '006004', 'true', 3.00, 3, '/0/006/006004/006004003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004004', '006004004', '资料遗失', null, '006004', 'true', 4.00, 3, '/0/006/006004/006004004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004005', '006004005', '资料收集错漏', null, '006004', 'true', 5.00, 3, '/0/006/006004/006004005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004006', '006004006', '服务态度', null, '006004', 'true', 6.00, 3, '/0/006/006004/006004006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006004007', '006004007', '其他资料收集服务', null, '006004', 'true', 7.00, 3, '/0/006/006004/006004007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006005', '006005', '核赔', null, '006', 'false', 5.00, 2, '/0/006/006005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006005001', '006005001', '责任认定', null, '006005', 'true', 1.00, 3, '/0/006/006005/006005001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006005002', '006005002', '金额争议', null, '006005', 'true', 2.00, 3, '/0/006/006005/006005002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006005003', '006005003', '核赔错漏', null, '006005', 'true', 3.00, 3, '/0/006/006005/006005003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006005004', '006005004', '核赔时效', null, '006005', 'true', 4.00, 3, '/0/006/006005/006005004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006005005', '006005005', '其他核赔服务', null, '006005', 'true', 5.00, 3, '/0/006/006005/006005005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006', '006006', '赔款', null, '006', 'false', 6.00, 2, '/0/006/006006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006001', '006006001', '赔付对象', null, '006006', 'true', 1.00, 3, '/0/006/006006/006006001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006002', '006006002', '赔付方式', null, '006006', 'true', 2.00, 3, '/0/006/006006/006006002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006003', '006006003', '赔付时效', null, '006006', 'true', 3.00, 3, '/0/006/006006/006006003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006004', '006006004', '强制赔付', null, '006006', 'true', 4.00, 3, '/0/006/006006/006006004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006005', '006006005', '代位求偿', null, '006006', 'true', 5.00, 3, '/0/006/006006/006006005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006006006', '006006006', '其他赔付服务', null, '006006', 'true', 6.00, 3, '/0/006/006006/006006006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007', '006007', '其他理赔', null, '006', 'false', 7.00, 2, '/0/006/006007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007001', '006007001', '未按消费者要求注销案件', null, '006007', 'true', 1.00, 3, '/0/006/006007/006007001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007002', '006007002', '抢救费用垫付', null, '006007', 'true', 2.00, 3, '/0/006/006007/006007002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007003', '006007003', '强行指定修理厂/医院', null, '006007', 'true', 3.00, 3, '/0/006/006007/006007003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007004', '006007004', '推荐维修/治疗质量', null, '006007', 'true', 4.00, 3, '/0/006/006007/006007004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007006', '006007006', '推荐医疗质量', null, '006007', 'true', 5.00, 3, '/0/006/006007/006007006/', 'admin', '超级管理员', '2020-08-21');


insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006007005', '006007005', '其他', null, '006007', 'true', 6.00, 3, '/0/006/006007/006007005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007', '007', '回访调查', null, '0', 'false', 7.00, 1, '/0/007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007001', '007001', '新契约回访', null, '007', 'false', 1.00, 2, '/0/007/007001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007001001', '007001001', '沟通方式', null, '007001', 'true', 1.00, 3, '/0/007/007001/007001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007001002', '007001002', '沟通频率', null, '007001', 'true', 2.00, 3, '/0/007/007001/007001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007001003', '007001003', '沟通态度', null, '007001', 'true', 3.00, 3, '/0/007/007001/007001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007001004', '007001004', '沟通内容', null, '007001', 'true', 4.00, 3, '/0/007/007001/007001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007001005', '007001006', '其他新契约回访', null, '007001', 'true', 5.00, 3, '/0/007/007001/007001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007002', '007002', '投诉满意度回访', null, '007', 'false', 2.00, 2, '/0/007/007002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007002001', '007002001', '沟通方式', null, '007002', 'true', 1.00, 3, '/0/007/007002/007002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007002002', '007002002', '沟通频率', null, '007002', 'true', 2.00, 3, '/0/007/007002/007002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007002003', '007002003', '沟通态度', null, '007002', 'true', 3.00, 3, '/0/007/007002/007002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007002004', '007002004', '沟通内容', null, '007002', 'true', 4.00, 3, '/0/007/007002/007002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007002005', '007002006', '其他投诉满意度回访', null, '007002', 'true', 5.00, 3, '/0/007/007002/007002005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007003', '007003', '理赔结案回访', null, '007', 'false', 3.00, 2, '/0/007/007003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007003001', '007003001', '沟通方式', null, '007003', 'true', 1.00, 3, '/0/007/007003/007003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007003002', '007003002', '沟通频率', null, '007003', 'true', 2.00, 3, '/0/007/007003/007003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007003003', '007003003', '沟通态度', null, '007003', 'true', 3.00, 3, '/0/007/007003/007003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007003004', '007003004', '沟通内容', null, '007003', 'true', 4.00, 3, '/0/007/007003/007003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007003005', '007003006', '其他理赔结案回访', null, '007003', 'true', 5.00, 3, '/0/007/007003/007003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007004', '007004', '其他回访', null, '007', 'true', 4.00, 2, '/0/007/007004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008', '008', '合同条款', null, '0', 'false', 8.00, 1, '/0/008/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001', '008001', '合同条款', null, '008', 'false', 1.00, 2, '/0/008/008001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001001', '008001001', '保险责任', null, '008001', 'true', 1.00, 3, '/0/008/008001/008001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001002', '008001002', '责任免除', null, '008001', 'true', 2.00, 3, '/0/008/008001/008001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001003', '008001003', '保险收益', null, '008001', 'true', 3.00, 3, '/0/008/008001/008001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001004', '008001004', '现金价值', null, '008001', 'true', 4.00, 3, '/0/008/008001/008001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001005', '008001005', '保险费率（含精算）', null, '008001', 'true', 5.00, 3, '/0/008/008001/008001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001006', '008001006', '投保人（被保险人、受益人）权利义务', '/0/008/008001/008001006/', '008001', 'true', 6.00, 3, null, 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008001007', '008001007', '其他合同条款', null, '008001', 'true', 7.00, 3, '/0/008/008001/008001007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009', '009', '其他', null, '0', 'false', 9.00, 1, '/0/009/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001', '009001', '增值服务', null, '009', 'false', 1.00, 2, '/0/009/009001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001001', '009001001', '赠品质量', null, '009001', 'true', 1.00, 3, '/0/009/009001/009001001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001002', '009001002', '救援服务', null, '009001', 'true', 2.00, 3, '/0/009/009001/009001002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001003', '009001003', 'VIP服务', null, '009001', 'true', 3.00, 3, '/0/009/009001/009001003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001004', '009001004', '消费者关怀', null, '009001', 'true', 4.00, 3, '/0/009/009001/009001004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001005', '009001005', '承诺未履行', null, '009001', 'true', 5.00, 3, '/0/009/009001/009001005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009001006', '009001006', '其他增值服务', null, '009001', 'true', 6.00, 3, '/0/009/009001/009001006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002', '009002', '客服热线', null, '009', 'false', 2.00, 2, '/0/009/009002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002001', '009002001', '未接通', null, '009002', 'true', 1.00, 3, '/0/009/009002/009002001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002002', '009002002', '无人接听', null, '009002', 'true', 2.00, 3, '/0/009/009002/009002002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002003', '009002003', '语音菜单', null, '009002', 'true', 3.00, 3, '/0/009/009002/009002003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002004', '009002004', '服务态度', null, '009002', 'true', 4.00, 3, '/0/009/009002/009002004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002005', '009002005', '服务时效', null, '009002', 'true', 5.00, 3, '/0/009/009002/009002005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002006', '009002006', '受理错漏', null, '009002', 'true', 6.00, 3, '/0/009/009002/009002006/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009002007', '009002007', '其他客服热线', null, '009002', 'true', 7.00, 3, '/0/009/009002/009002007/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009003', '009003', '投诉处理', null, '009', 'false', 3.00, 2, '/0/009/009003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009003001', '009003001', '投诉渠道', null, '009003', 'true', 1.00, 3, '/0/009/009003/009003001/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009003002', '009003002', '服务态度', null, '009003', 'true', 2.00, 3, '/0/009/009003/009003002/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009003003', '009003003', '服务时效', null, '009003', 'true', 3.00, 3, '/0/009/009003/009003003/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009003004', '009003004', '受理错漏', null, '009003', 'true', 4.00, 3, '/0/009/009003/009003004/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('00900300', '009003005', '其他投诉处理', null, '009003', 'true', 5.00, 3, '/0/009/009003/009003005/', 'admin', '超级管理员', '2017-01-31');

insert into dic_reason (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('009004', '009004', '其他未列明', null, '009', 'true', 3.00, 2, '/0/009/009004/', 'admin', '超级管理员', '2017-01-31');
commit;







 



 
-- **************************************************
--  table name:             dic_endresult
--  table description:      案件办结――处理结果
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_endresult;
CREATE TABLE dic_endresult (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_endresult primary key (KeyID)
);
delete from dic_endresult;
INSERT INTO dic_endresult VALUES ('61ccc42a15a746d5beea93ba1f89b0ee', '01', '满足诉求', '', '0', 'false', '1.00', 1, '/0/01/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('371fe429fd854b3c82e4552127d45046', '0101', '双方协商', '', '01', 'true', '1.00', 2, '/0/01/0101/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('0c7588646adc4d159ae860eeceb133bf', '0102', '根据保险合同条款', '', '01', 'true', '2.00', 2, '/0/01/0102/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('33d00b01ae18498490eab985eb6cd969', '0103', '根据业务规则', '', '01', 'true', '3.00', 2, '/0/01/0103/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('9ed67f84fb1943d387abaec71a2d19af', '0104', '第三方机构处理', '', '01', 'true', '4.00', 2, '/0/01/0104/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('3f86cbee4ebd4af1a518b7a7d59a033a', '0105', '其他', '', '01', 'true', '5.00', 2, '/0/01/0105/', 'admin', '超级管理员', '2017-01-31');
INSERT INTO dic_endresult VALUES ('15e0e0e09e8f439f879f1de43a29394d', '02', '未满足诉求', '', '0', 'false', '2.00', 1, '/0/02/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('3427cc5ba39e4f1b9db390790b839000', '0201', '双方协商', '', '02', 'true', '1.00', 2, '/0/02/0101/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('efcc36b68dc6430ea2a69f5ff0a73bbb', '0202', '根据保险合同条款', '', '02', 'true', '2.00', 2, '/0/02/0102/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('4563230f69a64eb5bfc6e15567ba5332', '0203', '根据业务规则', '', '02', 'true', '3.00', 2, '/0/02/0103/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_endresult VALUES ('2647c22be2a446eca5e45e8cacf460c0', '0204', '第三方机构处理', '', '02', 'true', '4.00', 2, '/0/02/0104/', 'admin', '超级管理员', '2017-01-31');






-- **************************************************
--  table name:             dic_casetype
--  table description:      案件办结――案件类型
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_casetype;
CREATE TABLE dic_casetype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_casetype primary key (KeyID)
);
delete from dic_casetype;
INSERT INTO dic_casetype VALUES ('25373b6b24d1483e82410ef3781d2e1c', '01', '有效件', '', '0', 'true', '1.00', 1,'/0/01/','admin','超级管理员','2017-12-01');
INSERT INTO dic_casetype VALUES ('552b12c4db9f484a928a71121698af07', '02', '无效件', '', '0', 'true', '2.00', 1,'/0/02/','admin','超级管理员','2017-12-01');






-- **************************************************
--  table name:             dic_inscetype
--  table description:      险种类别
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_inscetype;
CREATE TABLE dic_inscetype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_inscetype primary key (KeyID)
);
delete from dic_inscetype;
delete from dic_inscetype;
insert into  dic_inscetype values ('001','001','人身险','','0','false',1,1,'/0/001/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('001001','001001','健康保险','','001','true',1,2,'/0/001/001001/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('001002','001002','医疗保险','','001','true',2,2,'/0/001/001002/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('001003','001003','疾病保险','','001','true',3,2,'/0/001/001003/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('001004','001004','健康保险其他','','001','true',4,2,'/0/001/001004/','admin','超级管理员','2017-01-31');

insert into  dic_inscetype values ('002','002','人寿保险','','0','false',2,1,'/0/002/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('002001','002001','普通人寿保险','','002','true',1,2,'/0/002/002001/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('002002','002002','分红保险','','002','true',2,2,'/0/002/002002/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('002003','002003','万能保险','','002','true',3,2,'/0/002/002003/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('002004','002004','投连保险','','002','true',4,2,'/0/002/002004/','admin','超级管理员','2017-01-31');

insert into  dic_inscetype values ('003','003','意外伤害保险','','0','false',3,1,'/0/003/','admin','超级管理员','2017-01-31');
insert into  dic_inscetype values ('003003','003003','意外伤害保险','','003','true',1,2,'/0/003/003003/','admin','超级管理员','2017-01-31');

insert into  dic_inscetype values ('004','004','人身险其他','','0','false',4,1,'/0/004/','admin','超级管理员','2017-01-31');
commit;




 

-- **************************************************
--  table name:             dic_reasonanalyse
--  table description:      原因分析（办结）
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_reasonanalyse;
CREATE TABLE dic_reasonanalyse (
  keyID varchar(60)  not NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  SortID decimal(15,2) ,      -- 排序编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_reasonanalyse primary key (KeyID)
);
delete from dic_reasonanalyse;
INSERT INTO dic_reasonanalyse VALUES ('5977287a57dc4ddab8d9e8246a7b77f8', '01', '投诉对象原因', '', '0', 1, 'false', 1, '/0/01/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('1673ba536c324b839b67997c1c8a326d', '0101', '产品设计', '', '01', 1, 'true', 2, '/0/01/0101/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('77519b2e85a5458aa6e1e2a144971323', '0102', '制度建设', '', '01', 2, 'true', 2, '/0/01/0102/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('c1dab092f2f64ce9a39862a387f85ac0', '0103', '实务流程', '', '01', 3, 'true', 2, '/0/01/0103/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('d3f4116e9d6e431ab280a16c83bc398a', '0104', '系统问题', '', '01', 4, 'true', 2, '/0/01/0104/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('4715dfd5e8cb4adc95688ce0c0cf611d', '0105', '人员操作', '', '01', 5, 'true', 2, '/0/01/0105/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('7e8fc9bc73b449fcb47d1cf58da5688f', '0106', '其他', '', '01', 6, 'true', 2, '/0/01/0106/', 'admin', '超级管理员', '2017-01-31');

INSERT INTO dic_reasonanalyse VALUES ('557a11194d2e429a8c38eee2f9db137f', '02', '投诉人原因', '', '0', 2, 'false', 1, '/0/02/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('98ba9f3e9b624d77bc126a03fde91ebd', '0201', '投诉合理，诉求过高', '', '02', 1, 'true', 2, '/0/02/0201/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('40d62f58ad994fa2b95ddab9deb6d43a', '0202', '无理、恶意投诉', '', '02', 2, 'true', 2, '/0/02/0202/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('03aa926b74944ff5bc972f491c5da381', '0203', '欺诈行为', '', '02', 3, 'true', 2, '/0/02/0203/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('bcad73e56b0549779f746000fd5bbb4f', '0204', '其他', '', '02', 4, 'true', 2, '/0/02/0204/', 'admin', '超级管理员', '2017-01-31');

INSERT INTO dic_reasonanalyse VALUES ('4737c82d69f847738ea62d378da20879', '03', '保险中介原因', '', '0', 3, 'false', 1, '/0/03/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('a33a4599e2e74c26950d02905306b166', '0301', '保险中介原因', '', '03', 1, 'true', 2, '/0/03/0301/', 'admin', '超级管理员', '2017-01-31');

INSERT INTO dic_reasonanalyse VALUES ('906a08a37562440f82a608217863f977', '04', '行业原因', '', '0', 4, 'false', 1, '/0/04/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('ec68d0d4bbb04980b6d7ab8104391a37', '0401', '条款设计解释', '', '04', 1, 'true', 2, '/0/04/0401/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('c87371fd0888422e8cb168b73fae9f89', '0402', '协会平台建设', '', '04', 2, 'true', 2, '/0/04/0402/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('ae320439f5d9443d920b1bd492e0d8af', '0403', '行业标准', '', '04', 3, 'true', 2, '/0/04/0403/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('37acc53ad14f44ceaa0a1d6ff7f71205', '0404', '其他', '', '04', 4, 'true', 2, '/0/04/0404/', 'admin', '超级管理员', '2017-01-31');

INSERT INTO dic_reasonanalyse VALUES ('7fcea85341ba4bfc919e6745161ba645', '05', '监管原因', '', '0', 5, 'false', 1, '/0/05/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('be6e618da5da4330822bd1233dc45513', '0501', '规章政策原因', '', '05', 1, 'true', 2, '/0/05/0501/', 'admin', '超级管理员', '2017-01-31');
   INSERT INTO dic_reasonanalyse VALUES ('bc99cdecf4194dceb8f5f46ae8ae385c', '0502', '其他', '', '05', 2, 'true', 2, '/0/05/0502/', 'admin', '超级管理员', '2017-01-31');
INSERT INTO dic_reasonanalyse VALUES ('2648b5142fbf4bffa4c93e862f100a90', '06', '保险相关行业原因', '', '0', 6, 'false', 1, '/0/06/', 'admin', '超级管理员', '2017-01-31');
  INSERT INTO dic_reasonanalyse VALUES ('2ba6b5615b604e75ac2f237167ce0ddb', '0601', '修理行业', '', '06', 1, 'true', 2, '/0/06/0601/', 'admin', '超级管理员', '2017-01-31');
	INSERT INTO dic_reasonanalyse VALUES ('9a723d85017144eb83a1a8bad92fa1a6', '0602', '医疗机构', '', '06', 2, 'true', 2, '/0/06/0602/', 'admin', '超级管理员', '2017-01-31');
  INSERT INTO dic_reasonanalyse VALUES ('14549781720a4adbb73d942d9bb1f938', '0603', '救援公司', '', '06', 3, 'true', 2, '/0/06/0603/', 'admin', '超级管理员', '2017-01-31');
  INSERT INTO dic_reasonanalyse VALUES ('4a9cfdc4304f48668863bffc82d93a79', '0604', '物流', '', '06', 4, 'true', 2, '/0/06/0604/', 'admin', '超级管理员', '2017-01-31');
  INSERT INTO dic_reasonanalyse VALUES ('d05c16fc4c4e4c72afa58dde887d73f8', '0605', '其他', '', '06', 5, 'true', 2, '/0/06/0605/', 'admin', '超级管理员', '2017-01-31');

INSERT INTO dic_reasonanalyse VALUES ('b488b054083e4f9aa492be726f15d199', '07', '外部原因', '', '0', 7, 'false', 1, '/0/07/', 'admin', '超级管理员', '2017-01-31');
  INSERT INTO dic_reasonanalyse VALUES ('b830822a5d3049a2b8248330e26108d9', '0701', '行政执法部门', '', '07', 1, 'true', 2, '/0/07/0701/', 'admin', '超级管理员', '2017-01-31');
INSERT INTO dic_reasonanalyse VALUES ('ec09cf961f444c1ebca4b0bd39717c05', '08', '司法仲裁部门', '', '0', 8, 'false', 1, '/0/08/', 'admin', '超级管理员', '2017-01-31');
	INSERT INTO dic_reasonanalyse VALUES ('6d308099e9ba4485882a04d4ab5d437d', '0801', '价格或伤残鉴定机构', '', '08', 1, 'true', 2, '/0/08/0801/', 'admin', '超级管理员', '2017-01-31');
	INSERT INTO dic_reasonanalyse VALUES ('f08dec4da15349b5b6b9a31c5721ae5d', '0802', '其他', '', '08', 2, 'true', 2, '/0/08/0802/', 'admin', '超级管理员', '2017-01-31');
commit;
 


-- **************************************************
--  table name:             dic_nationality
--  table description:      国籍
--  author:                 韩林平
--  publish time:           2017-12-01
-- **************************************************
-- DROP TABLE dic_nationality;
CREATE TABLE dic_nationality (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_nationality primary key (KeyID)
);
delete from dic_nationality;
INSERT INTO dic_nationality VALUES ('086', '086', '中国', '', '0', 'true', '1.00', 1,'/0/086/','admin','超级管理员','2017-12-01');
INSERT INTO dic_nationality VALUES ('999', '999', '外国', '', '0', 'true', '2.00', 1,'/0/999/','admin','超级管理员','2017-12-01');




-- DROP TABLE t_org;
CREATE TABLE t_org (
  KeyID varchar(32) NOT NULL , --  主键编号,
  ORGID varchar(255)  , --  机构编码,
  ORGNAME varchar(255)  , --  机构名称,
  PARENTID varchar(255)  , --  上级编号,
  UPDATEUSERID varchar(255)  , --  更新人编号,
  UPDATETIME varchar(19)  , --  更新时间,
  INSERTUSERID varchar(255)  , --  创建人编号,
  InsertUserName varchar(255)  , --  创建人名称,
  INSERTTIME varchar(19)  , --  创建时间,
  SORTID   decimal(15,2)   , --  排序值,
  TREELEVEL int   , --  树层级,
  TREEPATH varchar(500)  , --  树路径,
  ORGDESC varchar(255)  , --  机构描述,
  OrgType VARCHAR(20)   ,--机构类型
  constraint PK_t_org primary key (KeyID)
);
 delete from t_org;
   
insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
				values ('86', '86', '总公司', '00', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '1', 1, '/0/86/8612/', '总公司', '总公司');
						
						insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
							values ('861200', '861200', '经营管理团队', '86', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '1', 2, '/0/86/8612/861200/', '内部', '内部');
					   insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						   values ('861201', '861201', '创新发展部', '86', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '2', 2, '/0/86/8612/861201/', '内部', '内部');
						insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						   values ('861202', '861202', '银行保险部', '86', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '3', 2, '/0/86/8612/861202/', '内部', '内部');
					   insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						   values ('861203', '861203', '运营管理部', '86', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '4',2, '/0/86/8612/861203/', '内部', '内部');
					   
   
			insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
				values ('8613', '8613', '天津分公司', '86', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '2', 2, '/0/86/8613/', '分公司', '分公司');
					insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						values ('861300', '861300', '天津分公司领导', '8613', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '1', 3, '/0/86/8613/861300/', '内部', '内部');
					insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						values ('861302', '861302', '客户服务部', '8613', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '3', 3, '/0/86/8613/861302/', '内部', '内部');
				   insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						values ('861303', '861303', '营销部', '8613', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '4', 3, '/0/86/8613/861303/', '内部', '内部');
				   insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						values ('861304', '861304', '多元渠道部', '8613', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '5', 3, '/0/86/8613/861304/', '内部', '内部');
				   insert into t_org (KEYID, ORGID, ORGNAME, PARENTID, UPDATEUSERID, UPDATETIME, INSERTUSERID, INSERTUSERNAME, INSERTTIME, SORTID, TREELEVEL, TREEPATH, ORGDESC, ORGTYPE)
						values ('861307', '861307', '银行保险部', '8613', 'admin', '2017-09-12 15:30:51', 'admin', '超级管理员', '2017-09-12 15:30:51', '8',3, '/0/86/8613/861307/', '内部', '内部');
				  
				commit;

/*-- **************************************************
--  table name:             dic_cplQualification
--  table description:      投诉人资格
--  author:                 马玉洁
--  publish time:           2021-03-18
-- **************************************************
-- DROP TABLE dic_cplQualification;
CREATE TABLE dic_cplQualification (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_cplQualification primary key (KeyID)
);
delete from dic_cplQualification;
insert into  dic_cplQualification values ('001','001','保险公司员工','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
insert into  dic_cplQualification values ('001001','001001','非销售人员','','001','true',1,2,'/0/001/001001/','admin','超级管理员','2021-03-18');
insert into  dic_cplQualification values ('001002','001002','销售从业人员','','001','true',2,2,'/0/001/001002/','admin','超级管理员','2021-03-18');
insert into  dic_cplQualification values ('002','002','非保险公司员工','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18');
insert into  dic_cplQualification values ('002001','002001','销售从业人员','','002','true',1,2,'/0/002/002001/','admin','超级管理员','2021-03-18');
insert into  dic_cplQualification values ('002002','002002','非销售人员','','002','true',2,2,'/0/002/002002/','admin','超级管理员','2021-03-18');
insert into  dic_cplQualification values ('003','003','无法判断','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18');

commit;*/
-- **************************************************
--  table name:             dic_cplIdentity
--  table description:      特殊投诉人标识
--  author:                 马玉洁
--  publish time:           2021-03-18
-- **************************************************
-- DROP TABLE dic_cplIdentity;
CREATE TABLE dic_cplIdentity (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_cplIdentity primary key (KeyID)
);
delete from dic_cplIdentity;
insert into  dic_cplIdentity values ('001','001','高风险用户','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('002','002','黑名单用户','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('003','003','3次以上投诉用户','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('004','004','政府官员','','0','false',4,1,'/0/004/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('005','005','媒体人','','0','false',5,1,'/0/005/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('006','006','集团人员','','0','false',6,1,'/0/006/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('007','007','无法判断','','0','false',7,1,'/0/007/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('008','008','保险从业者','','0','false',8,1,'/0/008/','admin','超级管理员','2021-03-18');
insert into  dic_cplIdentity values ('009','009','其他','','0','false',9,1,'/0/009/','admin','超级管理员','2021-03-18');

commit;

-- **************************************************
--  table name:             dic_cplQualification
--  table description:      被诉人业务类型
--  author:                 马玉洁
--  publish time:           2021-03-18
-- **************************************************
-- DROP TABLE dic_respondentbusinesstype;
CREATE TABLE dic_respondentbusinesstype (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_respondentbusinesstype primary key (KeyID)
);
delete from dic_respondentbusinesstype;
insert into  dic_respondentbusinesstype values ('001','001','前端业务','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('001001','001001','互联网业务','','001','true',1,2,'/0/001/001001/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('001002','001002','银保业务','','001','true',2,2,'/0/001/001002/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('001003','001003','代理人业务员','','001','true',3,2,'/0/001/001003/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('001004','001004','经代业务','','001','true',4,2,'/0/001/001004/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('001005','001005','团险业务','','001','true',5,2,'/0/001/001005/','admin','超级管理员','2021-03-18');

insert into  dic_respondentbusinesstype values ('002','002','中后台业务','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('002001','002001','运营客服类','','002','true',1,2,'/0/002/002001/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('002002','002002','系统类','','002','true',2,2,'/0/002/002002/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('002003','002003','财务收付费类','','002','true',3,2,'/0/002/002003/','admin','超级管理员','2021-03-18');
insert into  dic_respondentbusinesstype values ('002004','002004','分红结算类','','002','true',4,2,'/0/002/002004/','admin','超级管理员','2021-03-18');

insert into  dic_respondentbusinesstype values ('099','099','其他','','0','false',99,1,'/0/099/','admin','超级管理员','2021-03-18');

commit;

/*-- **************************************************
--  table name:             dic_limitdays
--  table description:      办理时限
--  author:                 马玉洁
--  publish time:           2021-03-18
-- **************************************************
-- DROP TABLE dic_limitdays;
CREATE TABLE dic_limitdays (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_limitdays primary key (KeyID)
);
delete from dic_limitdays;
insert into  dic_limitdays values ('001','001','5日内','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
insert into  dic_limitdays values ('002','002','15日内','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18');
insert into  dic_limitdays values ('003','003','30日内','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18');
insert into  dic_limitdays values ('099','099','其他','','0','false',99,1,'/0/099/','admin','超级管理员','2021-03-18');

commit;*/
-- **************************************************
--  table name:             dic_handlingmethod
--  table description:      办理方式
--  author:                 马玉洁
--  publish time:           2021-03-18
-- **************************************************
-- DROP TABLE dic_handlingmethod;
CREATE TABLE dic_handlingmethod (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_handlingmethod primary key (KeyID)
);
delete from dic_handlingmethod;
insert into  dic_handlingmethod values ('001','001','确认登记','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
insert into  dic_handlingmethod values ('001001','001001','转办处理','','001','true',1,2,'/0/001/001001/','admin','超级管理员','2021-03-18');
insert into  dic_handlingmethod values ('001002','001002','办结处理','','001','true',2,2,'/0/001/001002/','admin','超级管理员','2021-03-18');
insert into  dic_handlingmethod values ('002','002','取消登记','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18');
insert into  dic_handlingmethod values ('002001','002001','重复登记','','002','true',1,2,'/0/002/002001/','admin','超级管理员','2021-03-18');
insert into  dic_handlingmethod values ('002002','002002','转办前撤件','','002','true',2,2,'/0/002/002002/','admin','超级管理员','2021-03-18');
insert into  dic_handlingmethod values ('003','003','暂存','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18');
commit;

-- **************************************************
--  table name:             dic_businesshall
--  table description:      被诉部门
--  author:                 韩林平
--  publish time:           2021-03-18
-- **************************************************
-- DROP TABLE dic_businesshall;
CREATE TABLE dic_businesshall (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_businesshall primary key (KeyID)
);
delete from dic_businesshall;
insert into  dic_businesshall values ('001','001','银行保险部','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('002','002','营销管理部','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('003','003','创新协同部--网销','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('004','004','多元渠道部','','0','false',4,1,'/0/004/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('005','005','养老健康事业部','','0','false',5,1,'/0/005/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('006','006','运营管理部','','0','false',6,1,'/0/006/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('007','007','客户服务部','','0','false',7,1,'/0/007/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('008','008','计划财务部','','0','false',8,1,'/0/008/','admin','超级管理员','2021-03-18');
insert into  dic_businesshall values ('009','009','信息技术部','','0','false',9,1,'/0/009/','admin','超级管理员','2021-03-18');
commit;


	

CREATE TABLE dic_filiale (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_filiale primary key (KeyID)
);
delete from dic_filiale;
insert into dic_filiale (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001', '001', '总公司', null, '0', 'false', 1.00, 1, '/0/001/', 'admin', '超级管理员', '2021-03-19');

insert into dic_filiale (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002', '002', '天津分公司', null, '0', 'false', 2.00, 1, '/0/002/', 'admin', '超级管理员', '2021-03-19');

insert into dic_filiale (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003', '003', '北京分公司', null, '0', 'false', 3.00, 1, '/0/003/', 'admin', '超级管理员', '2021-03-19');

insert into dic_filiale (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003001', '003001', '北京朝阳支公司', null, '003', 'true', 1.00, 1, '/0/003/003001/', 'admin', '超级管理员', '2021-03-19');


insert into dic_filiale (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('004', '004', '河北分公司', null, '0', 'false', 4.00, 1, '/0/004/', 'admin', '超级管理员', '2021-03-19');
insert into dic_filiale (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('004001', '004001', '石家庄中支公司', null, '004', 'true', 1.00, 1, '/0/004/004001/', 'admin', '超级管理员', '2021-03-19');


-- **************************************************
--  table name:             dic_QuestionType
--  table description:      投诉事由类别
--  author:                 qizhenyu
--  publish time:           2021-07-18
-- **************************************************
-- DROP TABLE dic_QuestionType;
CREATE TABLE dic_QuestionType
(
    keyID      varchar(60) NOT NULL, -- 数据编号
    TID        varchar(60),          -- 字典编号
    TName      varchar(200),         -- 字典名称
    TURL       varchar(200),         -- 链接地址
    ParentID   varchar(60),          -- 父编号
    IsLeaf     varchar(6),           -- 是否最末级节点 true,false
    SortID     decimal(15, 2),       -- 排序编号
    TreeLevel  integer,              -- 层级
    TreePath   varchar(500),         -- 层级路径
    UserID     varchar(32),          -- 创建人工号
    UserName   varchar(255),         -- 创建人名称
    RecordTime varchar(19),          -- 创建时间
    constraint PK_dic_QuestionType primary key (KeyID)
);

DELETE FROM dic_QuestionType;
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001', '001', '个养代销', '', '0', 1.0, 'false', 1, '/0/001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001001', '001001', '中途取出', '', '001', 1.0, 'true', 2, '/0/001/001001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001002', '001002', '到账时效', '', '001', 2.0, 'true', 2, '/0/001/001002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001003', '001003', '收益', '', '001', 3.0, 'true', 2, '/0/001/001003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001004', '001004', '通知服务', '', '001', 4.0, 'true', 2, '/0/001/001004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001005', '001005', '撤单', '', '001', 5.0, 'true', 2, '/0/001/001005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001006', '001006', '页面提示', '', '001', 6.0, 'true', 2, '/0/001/001006/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001007', '001007', '产品规则', '', '001', 7.0, 'true', 2, '/0/001/001007/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '001008', '001008', '其他', '', '001', 8.0, 'true', 2, '/0/001/001008/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002', '002', '个养直销', '', '0', 2.0, 'false', 1, '/0/002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002001', '002001', '中途取出', '', '002', 1.0, 'true', 2, '/0/002/002001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002002', '002002', '业务时效', '', '002', 2.0, 'true', 2, '/0/002/002002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002003', '002003', '超募退回', '', '002', 3.0, 'true', 2, '/0/002/002003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002004', '002004', '收益', '', '002', 4.0, 'true', 2, '/0/002/002004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002005', '002005', '通知服务', '', '002', 5.0, 'true', 2, '/0/002/002005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002006', '002006', '换卡规则', '', '002', 6.0, 'true', 2, '/0/002/002006/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002007', '002007', '撤单', '', '002', 7.0, 'true', 2, '/0/002/002007/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002008', '002008', '页面提示', '', '002', 8.0, 'true', 2, '/0/002/002008/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002009', '002009', '产品规则', '', '002', 9.0, 'true', 2, '/0/002/002009/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002011', '002011', '一账通及电商公司平台类问题', '', '002', 9.1, 'true', 2, '/0/002/002011/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '002099', '002099', '其他', '', '002', 10.0, 'true', 2, '/0/002/002010/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003', '003', '企业年金单一', '', '0', 3.0, 'false', 1, '/0/003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003001', '003001', '业务时效', '', '003', 1.0, 'true', 2, '/0/003/003001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003002', '003002', '公司系统', '', '003', 2.0, 'true', 2, '/0/003/003002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003003', '003003', '公司管理', '', '003', 3.0, 'true', 2, '/0/003/003003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003004', '003004', '客户经理', '', '003', 4.0, 'true', 2, '/0/003/003004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '003005', '003005', '其他', '', '003', 5.0, 'true', 2, '/0/003/003005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004', '004', '企业年金集合', '', '0', 4.0, 'false', 1, '/0/004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004001', '004001', '业务时效', '', '004', 1.0, 'true', 2, '/0/004/004001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004002', '004002', '公司系统', '', '004', 2.0, 'true', 2, '/0/004/004002/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004003', '004003', '公司管理', '', '004', 3.0, 'true', 2, '/0/004/004003/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004004', '004004', '客户经理', '', '004', 4.0, 'true', 2, '/0/004/004004/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '004005', '004005', '其他', '', '004', 5.0, 'true', 2, '/0/004/004005/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '005', '005', '职业年金', '', '0', 5.0, 'true', 1, '/0/005/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '005001', '005001', '职业年金', '', '005', 1.0, 'true', 2, '/0/005/005001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '005002', '005002', '其他', '', '005', 2.0, 'true', 2, '/0/005/005002/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006', '006', '团养', '', '0', 6.0, 'true', 1, '/0/006/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006001', '006001', '团养', '', '006', 1.0, 'true', 2, '/0/006/006001/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '006002', '006002', '其他', '', '006', 2.0, 'true', 2, '/0/006/006002/', 'admin', '超级管理员', '2017-01-31' );

INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007', '007', '其他', '', '0', 7.0, 'true', 1, '/0/007/', 'admin', '超级管理员', '2017-01-31' );
INSERT INTO dic_QuestionType ( keyID, TID, TName, TURL, ParentID, SortID, IsLeaf, TreeLevel, TreePath, UserID, UserName, RecordTime )
VALUES( '007001', '007001', '其他', '', '007', 1.0, 'true', 2, '/0/007/007001/', 'admin', '超级管理员', '2017-01-31' );

commit;
		
 -- **************************************************
--  table name:             dic_appealnature1
--  table description:      投诉件性质
--  author:                 韩林平
--  publish time:           2021-03-19
-- **************************************************
-- DROP TABLE dic_appealnature1;
CREATE TABLE dic_appealnature1 (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_appealnature1 primary key (KeyID)
);
delete from dic_appealnature1;
insert into  dic_appealnature1 values ('001','001','有效件','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
    insert into  dic_appealnature1 values ('001001','001001','首次有效件','','001','true',1,2,'/0/001/001001/','admin','超级管理员','2021-03-18');
    insert into  dic_appealnature1 values ('001002','001002','关联新件','','001','true',2,2,'/0/001/001002/','admin','超级管理员','2021-03-18');
    insert into  dic_appealnature1 values ('001003','001003','异议件','','001','true',3,2,'/0/001/001003/','admin','超级管理员','2021-03-18');
insert into  dic_appealnature1 values ('002','002','无效件','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18'); 
    insert into  dic_appealnature1 values ('002001','002001','要素不全无效件','','002','true',1,2,'/0/002/002001/','admin','超级管理员','2021-03-18');
		insert into  dic_appealnature1 values ('002002','002002','催办件','','002','true',2,2,'/0/002/002002/','admin','超级管理员','2021-03-18');
		insert into  dic_appealnature1 values ('002003','002003','主体错误件','','002','true',3,2,'/0/002/002003/','admin','超级管理员','2021-03-18');
		insert into  dic_appealnature1 values ('002004','002004','转办前撤诉件','','002','true',4,2,'/0/002/002004/','admin','超级管理员','2021-03-18');
insert into  dic_appealnature1 values ('003','003','其他','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18'); 
    insert into  dic_appealnature1 values ('003001','003001','撤诉件','','003','true',1,2,'/0/003/003001/','admin','超级管理员','2021-03-18');
		insert into  dic_appealnature1 values ('003002','003002','核查件','','003','true',2,2,'/0/003/003002/','admin','超级管理员','2021-03-18');
		insert into  dic_appealnature1 values ('003003','003003','其他件','','003','true',3,2,'/0/003/003003/','admin','超级管理员','2021-03-18'); 
commit;	

-- **************************************************
--  table name:             dic_doopinion
--  table description:      处理意见
--  author:                 韩林平
--  publish time:           2021-03-22
-- **************************************************
-- DROP TABLE dic_doopinion;
CREATE TABLE dic_doopinion (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_doopinion primary key (KeyID)
);
delete from dic_doopinion;
insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('001', '001', '协议退保', null, '0', 'false', 1.00, 1, '/0/001/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('002', '002', '公司解约', null, '0', 'false', 2.00, 1, '/0/002/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('003', '003', '续期退费', null, '0', 'false', 3.00, 1, '/0/003/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('004', '004', '特殊复效', null, '0', 'false', 4.00, 1, '/0/004/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('005', '005', '差额补偿', null, '0', 'false', 5.00, 1, '/0/005/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('006', '006', '简化流程', null, '0', 'false', 6.00, 1, '/0/006/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('007', '007', '解释说明', null, '0', 'false', 7.00, 1, '/0/007/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('008', '008', '按照条款规则处理', null, '0', 'false', 8.00, 1, '/0/008/', 'admin', '超级管理员', '2021-03-19');

insert into dic_doopinion (KEYID, TID, TNAME, TURL, PARENTID, ISLEAF, SORTID, TREELEVEL, TREEPATH, USERID, USERNAME, RECORDTIME)
values ('099', '099', '其他', null, '0', 'false', 99.00, 1, '/0/099/', 'admin', '超级管理员', '2021-03-19');
 
commit;
	
 

 
                 

 

 

-- **************************************************
--  table name:             dic_appealaffiliation
--  table description:      投诉件归属
--  author:                 韩林平
--  publish time:           2021-03-23
-- **************************************************
-- DROP TABLE dic_appealaffiliation;
CREATE TABLE dic_appealaffiliation (
  keyID varchar(60) NOT NULL, -- 数据编号
  TID varchar(60) ,           -- 字典编号
  TName varchar(200) ,        -- 字典名称
  TURL varchar(200) ,         -- 链接地址
  ParentID varchar(60) ,      -- 父编号
  IsLeaf varchar(6) ,         -- 是否最末级节点 true,false
  SortID decimal(15,2) ,      -- 排序编号
  TreeLevel integer     ,     -- 层级
  TreePath varchar(500) ,     -- 层级路径
  UserID   varchar(32)   ,    -- 创建人工号  
  UserName  varchar(255) ,    -- 创建人名称 
  RecordTime varchar(19) ,    -- 创建时间
  constraint PK_dic_appealaffiliation primary key (KeyID)
);
delete from dic_appealaffiliation;
insert into  dic_appealaffiliation values ('001','001','业务渠道','','0','false',1,1,'/0/001/','admin','超级管理员','2021-03-18');
    insert into  dic_appealaffiliation values ('001001','001001','银行保险部','','001','true',1,2,'/0/001/001001/','admin','超级管理员','2021-03-18');
    insert into  dic_appealaffiliation values ('001002','001002','营销管理部','','001','true',2,2,'/0/001/001002/','admin','超级管理员','2021-03-18');
    insert into  dic_appealaffiliation values ('001003','001003','多元渠道部','','001','true',3,2,'/0/001/001003/','admin','超级管理员','2021-03-18');
    insert into  dic_appealaffiliation values ('001004','001004','养老健康险事业部','','001','true',4,2,'/0/001/001004/','admin','超级管理员','2021-03-18');
    insert into  dic_appealaffiliation values ('001005','001005','互联网业务','','001','true',5,2,'/0/001/001005/','admin','超级管理员','2021-03-18');
insert into  dic_appealaffiliation values ('002','002','中后台','','0','false',2,1,'/0/002/','admin','超级管理员','2021-03-18'); 
    insert into  dic_appealaffiliation values ('002001','002001','运营客服部','','002','true',1,2,'/0/002/002001/','admin','超级管理员','2021-03-18');
		insert into  dic_appealaffiliation values ('002002','002002','计划财务部','','002','true',2,2,'/0/002/002002/','admin','超级管理员','2021-03-18');
		insert into  dic_appealaffiliation values ('002003','002003','产品精算部','','002','true',3,2,'/0/002/002003/','admin','超级管理员','2021-03-18');
		insert into  dic_appealaffiliation values ('002004','002004','信息技术部','','002','true',4,2,'/0/002/002004/','admin','超级管理员','2021-03-18');
insert into  dic_appealaffiliation values ('003','003','其他','','0','false',3,1,'/0/003/','admin','超级管理员','2021-03-18'); 
    
commit;