| 1.1 | 新闻公司事件表新表 | (news_co_event_v2) | ||||||||
| FULL_NAME_EN | News Company Event Tag | |||||||||
| 描述 : | 记录公司类新闻的事件分类标签，包含资产冻结、财务造假、安全事故、高管变更、债务风险等。 | |||||||||
| DESCRIPTION_EN : | Record event classification labels for company news, including asset freezes, financial fraud, security incidents, executive changes, debt risks, etc. | |||||||||
| 唯一键 : | NEWS_ID,COMPANY_ID,EVENT_ID | |||||||||
| 数据起始时间 : | 2018-07-01 | |||||||||
| 更新频率 : | 实时 | |||||||||
| 数据更新时间 : | 不定时 | |||||||||
| 数据调用方式 : | API,HERMES | |||||||||
| API文档 : | getNewsCoEventV2--新闻公司事件表新表 | |||||||||
| 数据来源 : | 通联数据 | |||||||||
| DATA_SOURCE_EN : | Datayes | |||||||||
| 字段信息 : | ||||||||||
| 序号 | 字段名 | 中文名称 | FULL_NAME_EN | 数据类型 | 可空 | 字段描述 | DESCRIPTION_EN | 参数值 | 备注 | |
| 1 | ID | 自增ID | ID | bigint | 否 | |||||
| 2 | NEWS_ID | 新闻ID | News ID | bigint | 否 | |||||
| 3 | COMPANY_ID | 公司内部ID | Company ID | bigint | 否 | 关联md_institution的PARTY_ID字段 | Associate COMPANY_ID of the institution_ID field | |||
| 4 | EVENT_ID | 事件ID | Event ID | varchar(20) | 否 | 关联news_classify_std的TYPE_ID字段 | Associate the TYPE-ID field of news_classify_std | |||
| 5 | EVENT_NAME | 事件名称 | Event Name | varchar(200) | 是 | |||||
| 6 | EFFECTIVE_TIME | 新闻有效发布时间 | Effective Time | datetime | 是 | |||||
| 7 | UPDATE_TIME | 更新时间 | Update Time | datetime | 是 | |||||
| 1.2 | 新闻公司事件分类表 | (news_company_event) | ||||||||
| FULL_NAME_EN | News Company Event Classification | |||||||||
| 描述 : | 记录公司类新闻的事件分类标签，包含财务状况、行业景气度、价格变动、评级调整、融资类型、违法违规、风险警示等。 | |||||||||
| DESCRIPTION_EN : | Event classification labels for recording company news, including financial status, industry prosperity, price change, rating adjustment, financing type, violation of laws and regulations, risk warning, etc | |||||||||
| 唯一键 : | NEWS_ID,COMPANY_ID,EVENT_2ND | |||||||||
| 数据起始时间 : | 2016-01-01 | |||||||||
| 更新频率 : | 实时 | |||||||||
| 数据更新时间 : | 不定时 | |||||||||
| 数据调用方式 : | API,HERMES | |||||||||
| API文档 : | getNewsCompanyEvent--新闻公司事件分类表 | |||||||||
| 数据来源 : | 通联数据 | |||||||||
| DATA_SOURCE_EN : | Datayes | |||||||||
| 字段信息 : | ||||||||||
| 序号 | 字段名 | 中文名称 | FULL_NAME_EN | 数据类型 | 可空 | 字段描述 | DESCRIPTION_EN | 参数值 | 备注 | |
| 1 | ID | 自增ID | ID | bigint | 否 | |||||
| 2 | NEWS_ID | 新闻ID | News ID | bigint | 否 | |||||
| 3 | COMPANY_ID | 公司内部ID | Company ID | bigint | 否 | 关联md_institution的PARTY_ID字段 | ||||
| 4 | EVENT_1ST | 一级事件类别 | First-level Event Category | varchar(30) | 是 | 共12个类型，分别为：个人言行、股权变动、资产变动、分红送转、日常经营、风险警示与消除、融资、财务状况、违法违规、行业、交易价格变动、评级调整 | There are a total of 12 types, namely: personal words and deeds, equity changes, asset changes, dividends and transfers, daily operations, risk warning and elimination, financing, financial status, violations of laws and regulations, industry, transaction price changes, rating adjustment | |||
| 5 | EVENT_2ND | 二级事件类别 | Second-level Event Category | varchar(30) | 是 | 与一级对应共34个分类，分别为个人言行、增减持、股份回购、股权冻结、股权质押、股权激励、员工持股、资产重组、资产买卖、分红送转、生产、合作、研发、销售、人事、风险警示、风险消除、资本融资、IPO、再融资、贷款、业绩、财务质量、资金、负债、机构监管、法律纠纷、立案调查和处罚、行业政策、行业景气度、股价上涨、股价下跌、评级上调、评级下调 | There are 34 categories corresponding to the first level, which are personal words and deeds, increase or decrease of holdings, share repurchase, equity freeze, equity pledge, equity incentive, employee shareholding, asset restructuring, asset trading, dividend transfer, production, cooperation, research and development , Sales, Personnel, Risk Warning, Risk Elimination, Capital Financing, IPO, Refinancing, Loans, Performance, Financial Quality, Funds, Liabilities, Institutional Supervision, Legal Disputes, Investigation and Punishment, Industry Policies, Industry Prosperity, Stock Price Increases , stock price decline, rating upgrade, rating downgrade | |||
| 6 | EFFECTIVE_TIME | 新闻有效发布时间 | Effective Time | datetime | 是 | |||||
| 7 | CREATE_TIME | 创建时间 | Create Time | datetime | 否 | |||||
| 8 | UPDATE_TIME | 更新时间 | Update Time | datetime | 否 | |||||
| 1.3 | 新闻事件参数表 | (news_classify_std) | ||||||||
| FULL_NAME_EN | News Event Parameter Table | |||||||||
| 描述 : | 记录新闻事件新表的事件分类体系。 | |||||||||
| DESCRIPTION_EN : | Event classification system for recording new tables of news events. | |||||||||
| 唯一键 : | CLASSIFY_NAME,TYPE_ID | |||||||||
| 数据起始时间 : | 不适用 | |||||||||
| 更新频率 : | 不定期 | |||||||||
| 数据更新时间 : | 不定时 | |||||||||
| 数据调用方式 : | Hermes,API | |||||||||
| API文档 : | getNewsClassifyStd--新闻事件参数表 | |||||||||
| 数据来源 : | 通联数据 | |||||||||
| DATA_SOURCE_EN : | Datayes | |||||||||
| 字段信息 : | ||||||||||
| 序号 | 字段名 | 中文名称 | FULL_NAME_EN | 数据类型 | 可空 | 字段描述 | DESCRIPTION_EN | 参数值 | 备注 | |
| 1 | ID | 信息编码 | ID | bigint | 否 | |||||
| 2 | CLASSIFY_NAME | 分类参数名称 | Classify Name | varchar(50) | 否 | |||||
| 3 | TYPE_ID | 分类ID | Type ID | varchar(20) | 否 | |||||
| 4 | TYPE_NAME | 分类名称 | Type Name | varchar(200) | 是 | |||||
| 5 | TYPE_LEVEL | 所属层级 | Type Level | int | 是 | |||||
| 6 | PARENT_ID | 父级节点 | Parent ID | varchar(20) | 是 | |||||
| 7 | CLASSIF_STD | 分类标准 | Classify Standards | varchar(200) | 是 | |||||
| 8 | UPDATE_TIME | 更新时间 | Update Time | datetime | 是 | |||||