{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["目录","新闻概念字典表_v1.1","概念成分股表_v1.2","新闻事件字典表_v1.1","地区字典表_v1.2","新闻基本信息表_v1.1","新闻人物标签表_v1.1","新闻产品标签表_v1.1","新闻地区标签表_v1.1","新闻概念标签表_v1.2","新闻事件标签表_v1.1","新闻行业标签表_v1.1"],"read":"whole","date_system":"1900"}

{"sheet":"目录","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[0,1,0,7]]}
["\n                    说明\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                ","\n每张表都设有一个系统字段为操作状态，该字段枚举值为 A\\U\\D， A 代表新增， U 代表更新(个别情况U会是插入操作，建议U使用upsert语义进行处理)， D 代表删除，\n我们可以根据该字段值对数据进行增删改的操作。\n默认推送数据文件格式为 csv，文件编码默认为UTF-8\n                "]
["模块名称","模块版本","表显示名","表名","表版本","说明","数据维护状态","表结构维护状态"]
["公共字典表","v1.1","新闻概念字典表","concept_dictionary","v1.1","该表记录了A股市场各概念板块的基本信息，包含概念名称、概念定义等。","正常维护","数据验证通过"]
["公共字典表","v1.1","概念成分股表","concept_stock","v1.2","标准版本","正常维护","数据验证通过"]
["公共字典表","v1.1","新闻事件字典表","event_dictionary","v1.1","该表为新闻事件标签的基本信息及层级关系表。","正常维护","数据验证通过"]
["公共字典表","v1.1","地区字典表","region_dictionary","v1.2","标准版本","正常维护","数据验证通过"]
["Smartag","v4.2","新闻基本信息表","news_info","v1.1","该表记录了新闻基本信息，包含发布时间、新闻标题、摘要、新闻来源、新闻舆情等","正常维护","数据验证通过"]
["Smartag","v4.2","新闻人物标签表","news_people_label","v1.1","该表记录了新闻的人物标签及人物舆情，由Smartag算法计算得来。","正常维护","数据验证通过"]
["Smartag","v4.2","新闻产品标签表","news_product_label","v1.1","该表记录了新闻的产品标签，由Smartag算法计算得来。","正常维护","数据验证通过"]
["Smartag","v4.2","新闻地区标签表","news_region_label","v1.1","该表记录了新闻的地区标签，由Smartag算法计算得来。","正常维护","数据验证通过"]
["Smartag","v4.2","新闻概念标签表","news_concept_label","v1.2","该表记录了新闻的概念标签，由Smartag算法计算得来。","正常维护","数据验证通过"]
["Smartag","v4.2","新闻事件标签表","news_event_label","v1.1","该表记录了新闻的事件标签，由Smartag算法计算得来。","正常维护","数据验证通过"]
["Smartag","v4.2","新闻行业标签表","news_industry_label","v1.1","该表记录了新闻的行业标签，由Smartag算法计算得来。","正常维护","数据验证通过"]

{"sheet":"新闻概念字典表_v1.1","index":1,"n_rows":12,"n_cols":5,"rows_kept":12}
["返回目录","表名","concept_dictionary","新闻概念字典表","主键：concept_name + inclusion_date"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、U:更新：D删除）"]
["","concept_code","概念编码","varchar(40)",""]
["","concept_name","概念名称","varchar(200)",""]
["","concept_name_en","概念名称_英文","varchar(200)",""]
["","concept_id","概念记录id","varchar(200)",""]
["","inclusion_date","纳入日期","date",""]
["","def","概念定义","varchar(256)",""]
["","create_time","创建时间","timestamp",""]
["","update_time","更新时间","timestamp",""]

{"sheet":"概念成分股表_v1.2","index":2,"n_rows":12,"n_cols":5,"rows_kept":12}
["返回目录","表名","concept_stock","概念成分股表","主键：secu + concept_code + inclusion_date"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、U:更新：D删除）"]
["","secu","证券代码","varchar(40)",""]
["","abbr","证券简称","varchar(200)",""]
["","name_en","证券简称_英文","varchar(200)",""]
["","concept_code","概念编码","varchar(40)","关联 concept_dictionary 表的concept_code"]
["","inclusion_date","纳入日期","date",""]
["","delete_date","剔除日期","date",""]
["","create_time","创建时间","timestamp",""]
["","update_time","更新时间","timestamp",""]

{"sheet":"新闻事件字典表_v1.1","index":3,"n_rows":15,"n_cols":5,"rows_kept":15}
["返回目录","表名","event_dictionary","新闻事件字典表","主键：event_name + inclusion_date"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、U:更新：D删除）"]
["","event_code","事件编码","varchar(40)",""]
["","event_name","事件名称","varchar(200)",""]
["","event_name_en","事件名称_英文","varchar(200)",""]
["","parent_code","事件父级","varchar(40)",""]
["","event_level","事件层级","int",""]
["","event_pos","事件舆情","int","0：中性/1：正面/2：负面"]
["","event_importance","事件重要性","int","0：一般重要/1：较重要/2：重要/3：非常重要/4：最重要"]
["","inclusion_date","纳入时间","date",""]
["","delete_date","剔除时间","date",""]
["","create_time","创建时间","timestamp",""]
["","update_time","更新时间","timestamp",""]

{"sheet":"地区字典表_v1.2","index":4,"n_rows":13,"n_cols":5,"rows_kept":13}
["返回目录","表名","region_dictionary","地区字典表","主键：region_code"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、U:更新：D删除）"]
["","region_code","地区编码","varchar(40)",""]
["","region_name","地区名称","varchar(200)",""]
["","region_name_en","地区名称_英文","varchar(200)",""]
["","region_level","层级","int",""]
["","parent_code","父级","varchar(40)",""]
["","ancestors","全部父级","varchar(200)",""]
["","external_code","官方行政区划代码","varchar(16)",""]
["","create_time","创建时间","timestamp",""]
["","update_time","更新时间","timestamp",""]

{"sheet":"新闻基本信息表_v1.1","index":5,"n_rows":17,"n_cols":5,"rows_kept":17}
["返回目录","表名","news_info","新闻基本信息表","主键：newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","newsid","新闻Id","bigint",""]
["","newstitle","新闻标题","varchar(2000)",""]
["","newstitle_cn","新闻标题_中文","varchar(2000)",""]
["","newsts","新闻时间戳","datetime",""]
["","newsoriginalts","新闻发布时间","datetime",""]
["","newsurl","新闻Url","varchar(2000)",""]
["","newssource","新闻源","varchar(200)",""]
["","newssummary","新闻摘要","text",""]
["","whitelistflag","是否加入白名单","int","0：否/1：是"]
["","newsextid","新闻内部Id","varchar(256)",""]
["","emotionindicator","新闻舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","新闻舆情指标权重","double(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]

{"sheet":"新闻人物标签表_v1.1","index":6,"n_rows":12,"n_cols":5,"rows_kept":12}
["返回目录","表名","news_people_label","新闻人物标签表","主键：personcode + newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","personcode","人物代码","varchar(40)",""]
["","chinesename","人物名称","varchar(200)",""]
["","englishname","人物名称_英文","varchar(200)",""]
["","newsid","新闻Id","bigint",""]
["","newsts","新闻时间戳","datetime",""]
["","emotionindicator","人物舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","人物舆情指标权重","float(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]

{"sheet":"新闻产品标签表_v1.1","index":7,"n_rows":13,"n_cols":5,"rows_kept":13}
["返回目录","表名","news_product_label","新闻产品标签表","主键：productcode + newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","productcode","产品代码","varchar(40)",""]
["","chinesename","产品名称","varchar(200)",""]
["","englishname","产品名称_英文","varchar(200)",""]
["","newsid","新闻Id","bigint",""]
["","newsts","新闻时间戳","datetime",""]
["","relevance","标签的相关度","float(8,4)",""]
["","emotionindicator","新闻舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","新闻舆情指标权重","float(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]

{"sheet":"新闻地区标签表_v1.1","index":8,"n_rows":12,"n_cols":5,"rows_kept":12}
["返回目录","表名","news_region_label","新闻地区标签表","主键：regioncode + newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","regioncode","地区代码","varchar(40)",""]
["","chinesename","地区名称","varchar(200)",""]
["","englishname","地区名称_英文","varchar(200)",""]
["","newsid","新闻Id","bigint",""]
["","newsts","新闻时间戳","datetime",""]
["","emotionindicator","新闻舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","新闻舆情指标权重","float(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]

{"sheet":"新闻概念标签表_v1.2","index":9,"n_rows":13,"n_cols":5,"rows_kept":13}
["返回目录","表名","news_concept_label","新闻概念标签表","主键：conceptcode + newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","conceptcode","概念代码","varchar(40)","关联[concept_dictionary]\"concept_id\""]
["","chinesename","概念名称","varchar(200)",""]
["","englishname","概念名称_英文","varchar(200)",""]
["","newsid","新闻Id","bigint",""]
["","newsts","新闻时间戳","datetime",""]
["","relevance","标签的相关度","float(8,4)",""]
["","emotionindicator","新闻舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","新闻舆情指标权重","float(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]

{"sheet":"新闻事件标签表_v1.1","index":10,"n_rows":12,"n_cols":5,"rows_kept":12}
["返回目录","表名","news_event_label","新闻事件标签表","主键：eventcode + newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","eventcode","事件代码","varchar(40)",""]
["","chinesename","事件名称","varchar(200)",""]
["","englishname","事件名称_英文","varchar(200)",""]
["","newsid","新闻Id","bigint",""]
["","newsts","新闻时间戳","datetime",""]
["","emotionindicator","新闻舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","新闻舆情指标权重","float(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]

{"sheet":"新闻行业标签表_v1.1","index":11,"n_rows":13,"n_cols":5,"rows_kept":13}
["返回目录","表名","news_industry_label","新闻行业标签表","主键：industrycode + newsid"]
["","","","",""]
["","字段","注释","格式","说明"]
["","operation","记录标识","varchar(2)","（A:新增、 U:更新： D 删除）"]
["","industrycode","行业代码","varchar(40)",""]
["","chinesename","行业名称","varchar(200)",""]
["","englishname","行业名称_英文","varchar(200)",""]
["","newsid","新闻Id","bigint",""]
["","newsts","新闻时间戳","datetime",""]
["","relevance","标签的相关度","float(8,4)",""]
["","emotionindicator","新闻舆情指标","int","0：中性/1：正面/2：负面"]
["","emotionweight","新闻舆情指标权重","float(4,2)",""]
["","emotiondetail","三类舆情指标对应的权重","varchar(100)",""]