class JYDB_DeleteRec(SQLTableEntity): name: str = 'JYDB_DeleteRec' chn_name: str = 'JYDB_删除表' business_unique: str = '无' refresh_freq: str = """不定时更新""" comment: str = """本表记录各表删除记录的ID值""" TABLENAME: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='JYDB_DeleteRec', column_name='TABLENAME', column_type='varchar(100)', nullable=True, chn_name='表名') """表名:""" RECID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='JYDB_DeleteRec', column_name='RECID', column_type='bigint', nullable=True, chn_name='被删除表ID') """被删除表ID:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='JYDB_DeleteRec', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='修改日期') """修改日期:""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='JYDB_DeleteRec', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='JYDB_DeleteRec', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class C_ED_IndicatorDimension(SQLTableEntity): name: str = 'C_ED_IndicatorDimension' chn_name: str = '宏观指标维度表' business_unique: str = 'IndicatorCode,CategoryCode' refresh_freq: str = """""" comment: str = """收录宏观指标的维度信息""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" IndicatorCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='IndicatorCode', column_type='int', nullable=True, chn_name='指标代码') """指标代码:指标代码(IndicatorCode):与“宏观指标主表(C_ED_IndicatorMain)”中的“指标代码(IndicatorCode)” 关联,得到宏观指标的基础信息。""" CategoryCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='CategoryCode', column_type='int', nullable=True, chn_name='维度类别') """维度类别:""" CategoryName: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='CategoryName', column_type='varchar(50)', nullable=False, chn_name='维度类别名称') """维度类别名称:""" DimensionCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='DimensionCode', column_type='int', nullable=True, chn_name='维度代码') """维度代码:""" DimensionName: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='DimensionName', column_type='varchar(300)', nullable=False, chn_name='维度名称') """维度名称:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_IndicatorDimension', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class C_ED_MacroIndicatorData(SQLTableEntity): name: str = 'C_ED_MacroIndicatorData' chn_name: str = '宏观基础指标数据' business_unique: str = 'IndicatorCode,EndDate' refresh_freq: str = """""" comment: str = """收录宏观基础指标时间序列数据""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" IndicatorCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='IndicatorCode', column_type='int', nullable=True, chn_name='指标代码') """指标代码:指标代码(IndicatorCode):与“宏观指标主表(C_ED_IndicatorMain)”中的“指标代码(IndicatorCode)” 关联,得到宏观指标的基础信息。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='EndDate', column_type='datetime', nullable=False, chn_name='截止日期') """截止日期:""" DataValue: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='DataValue', column_type='decimal(28,6)', nullable=False, chn_name='指标数据') """指标数据:""" PowerNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='PowerNumber', column_type='smallint', nullable=False, chn_name='量纲系数') """量纲系数:量纲系数(PowerNumber):聚源宏观数据都存放最小单位数据,此字段对应展示单位。例如:如果数据按百万公布,即10的6次方,则此处存的是6。""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='C_ED_MacroIndicatorData', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class Sample_Table(SQLTableEntity): name: str = 'CT_Function' chn_name: str = '标准函数表' business_unique: str = '内部专用' refresh_freq: str = """""" comment: str = """收录常用函数数值表数据,包括:标准正态分布函数数值表""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Function', column_name='ID', column_type='bigint',nullable=True, chn_name='ID') """""" FuncCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Function', column_name='FuncCode', column_type='int',nullable=True, chn_name='函数代码') """""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Function', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='修改日期') """"""
class HK_SHSellingList(SQLTableEntity): name: str = 'HK_SHSellingList' chn_name: str = '港股卖空名单表' business_unique: str = 'InnerCode,InDate,IfEffected' refresh_freq: str = """不定时更新""" comment: str = """1.记录港股指定卖空名单变化,包含字段有:信息发布日期、豁免卖空价规例、入选日期 、剔除日期 等。 2.数据范围:2016-05至今。 3.数据来源:港交所。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='InnerCode', column_type='int', nullable=True, chn_name='内部代码') """内部代码:内部代码(InnerCode):与“港股证券主表(HK_SecuMain)”中的“证券内部编码(InnerCode)”关联,得到港股的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" ExempSPRule: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='ExempSPRule', column_type='int', nullable=False, chn_name='豁免卖空价规例') """豁免卖空价规例:豁免卖空价规例(ExempSPRule),该字段固定以下常量:1-是,2-否。""" InDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='InDate', column_type='datetime', nullable=True, chn_name='入选日期') """入选日期:""" OutDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='OutDate', column_type='datetime', nullable=False, chn_name='剔除日期') """剔除日期:""" IfEffected: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='IfEffected', column_type='int', nullable=True, chn_name='是否有效') """是否有效:是否有效(IfEffected),该字段固定以下常量:1-是,2-否。""" Remarks: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='Remarks', column_type='varchar(200)', nullable=False, chn_name='备注') """备注:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_SHSellingList', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:"""
class MF_FundTradeInfo(SQLTableEntity): name: str = 'MF_FundTradeInfo' chn_name: str = '公募基金股票交易信息' business_unique: str = 'InnerCode,ReportDate' refresh_freq: str = """半年更新""" comment: str = """1.本表记录了中报、年报中公布报告期内股票买卖金额信息,包括买入股票成本、卖出股票收入等数据。 2.历史数据:2004年6月起-至今。 3.数据来源:基金公司披露的定期报告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" ReportDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='ReportDate', column_type='datetime', nullable=True, chn_name='报告期') """报告期:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='InfoSource', column_type='varchar(50)', nullable=False, chn_name='信息来源') """信息来源:信息来源(InfoSource)与(CT_SystemConst)表中的DM字段关联,令LB = 1032,得到信息来源的具体描述:1-招股说明书,2-招股意向书,3-配股说明书,4-上市公告书,5-年度报告,6-中期报告,7-公司章程,8-增发新股招股说明书,9-增发新股招股意向书,10-增发新股上市公告书,11-可转换债券募集说明书,12-可转换债券上市...""" BuyingCost: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='BuyingCost', column_type='decimal(19,4)', nullable=False, chn_name='买入股票成本') """买入股票成本:""" SellingIncome: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='SellingIncome', column_type='decimal(19,4)', nullable=False, chn_name='卖出股票收入') """卖出股票收入:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_FundTradeInfo', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class HK_ExgIndustry(SQLTableEntity): name: str = 'HK_ExgIndustry' chn_name: str = '港股公司行业划分表' business_unique: str = 'CompanyCode,Standard,IndustryNum,ExcuteDate' refresh_freq: str = """不定时更新""" comment: str = """1.描述香港联交所上市的公司的行业分类,主要有恒生行业分类、恒生聚源行业分类、中国证监会行业分类、申万行业分类等,该表记录港股上市公司的行业分类。 2.信息来源:港交所、恒生聚源等。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='CompanyCode', column_type='int', nullable=True, chn_name='公司内码') """公司内码:公司内码(CompanyCode):与“港股证券主表(HK_SecuMain)”中的“公司代码(CompanyCode)”关联,得到港股的交易代码、简称等。""" Standard: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='Standard', column_type='int', nullable=True, chn_name='行业划分标准') """行业划分标准:行业划分标准(Standard)与(CT_SystemConst)表中的DM字段关联,令LB=1081,得到行业划分标准的具体描述:1-CSRC行业分类,2-非CSRC行业分类,3-中信行业分类,5-SSE行业分类,6-GICS行业分类,7-SSE-GICS行业分类,8-聚源行业分类,9-申万行业分类,10-聚源板块分类,11-中银(BOCI)行业分类,12...""" IndustryNum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='IndustryNum', column_type='int', nullable=True, chn_name='行业编码') """行业编码:行业编码(IndustryNum):与“港股行业分类表(HK_IndustryCategory)”中的“行业编码(行业编码)”关联,得到行业的名称及相关信息。""" ExcuteDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='ExcuteDate', column_type='datetime', nullable=True, chn_name='生效日期') """生效日期:""" CancelDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='CancelDate', column_type='datetime', nullable=False, chn_name='取消日期') """取消日期:""" IfExecuted: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='IfExecuted', column_type='tinyint', nullable=False, chn_name='是否执行') """是否执行:是否执行(IfExecuted):该字段固定以下常量1-是,2-否""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='修改时间') """修改时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='HK_ExgIndustry', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class CT_Keywords(SQLTableEntity): name: str = 'CT_Keywords' chn_name: str = '系统关键词表' business_unique: str = '无' refresh_freq: str = """不定时更新""" comment: str = """本表收录证券新闻等中用到的关键词""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" Type: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='Type', column_type='int', nullable=False, chn_name='类别') """类别:类别(Type)与(CT_SystemConst)表中的DM字段关联,令LB = 2,得到类别的具体描述:10-内部编码,11-公司代码,205-证券信托公司,206-省市表,301-行业表,311-临时公告关键词,312-非公告关键词,313-法律法规关键词,314-研究报告关键词,315-数据解读关键词,316-专题关键词,320-常规产品分类,321-...""" Content: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='Content', column_type='varchar(50)', nullable=False, chn_name='内容词组') """内容词组:""" Keyword: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='Keyword', column_type='varchar(50)', nullable=False, chn_name='关键词组') """关键词组:""" Code: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='Code', column_type='int', nullable=False, chn_name='代码') """代码:""" ChiSpelling: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='ChiSpelling', column_type='varchar(50)', nullable=False, chn_name='关键词拼音简称') """关键词拼音简称:""" InfoLevel: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='InfoLevel', column_type='tinyint', nullable=False, chn_name='级别') """级别:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='修改日期') """修改日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='CT_Keywords', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class LC_CorrIndexIndustry(SQLTableEntity): name: str = 'LC_CorrIndexIndustry' chn_name: str = '指数与行业对应' business_unique: str = '此表与指数基本情况 LC_IndexBasicInfo关联,开通需要一起开' refresh_freq: str = """不定时更新""" comment: str = """1.收录了行业指数与所属行业的对应关系,包括行业分类标准,行业分类信息;通过与系统常量表等相关联,能获取具体的行业分类标准和所属行业信息。 2.数据源:申银万国研究所、中证指数有限公司、中信证券股份有限公司等""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" IndexCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='IndexCode', column_type='int', nullable=True, chn_name='指数内码') """指数内码:指数内码(IndexCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到指数的代码、简称等。""" IndustryStandard: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='IndustryStandard', column_type='int', nullable=True, chn_name='行业分类标准') """行业分类标准:行业分类标准(IndustryStandard)与(CT_SystemConst)表中的DM字段关联,令LB = 1081,得到行业分类标准的具体描述:1-CSRC行业分类,2-非CSRC行业分类,3-中信行业分类,5-SSE行业分类,6-GICS行业分类,7-SSE-GICS行业分类,8-聚源行业分类,9-申万行业分类,10-聚源板块分类,11-中银(BO...""" IndustryCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='IndustryCode', column_type='int', nullable=False, chn_name='所属行业') """所属行业:所属行业(IndustryCode): 当IndustryStandard=1、8或18时,与“行业表(CT_Industry)”中的“行业编码(IndustryNum)”关联; 当IndustryStandard=3或5时,与“系统常量表(CT_SystemConst)”的“代码(DM)”关联,“LB=1082”; 当IndustryStandard=6或...""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='EndDate', column_type='datetime', nullable=False, chn_name='截止日期') """截止日期:""" IndexState: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='IndexState', column_type='int', nullable=False, chn_name='指数状态') """指数状态:指数状态(IndexState),该字段定为固定常量:1-新增;2-延用;3-停用""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_CorrIndexIndustry', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class MF_FundArchives(SQLTableEntity): name: str = 'MF_FundArchives' chn_name: str = '公募基金概况' business_unique: str = 'InnerCode' refresh_freq: str = """日更新""" comment: str = """1.本表记录了基金基本情况,包括基金规模、成立日期、投资类型、管理人、托管人、存续期、历史简介等。 2.历史数据:1998年3月起-至今。 3.信息来源:基金公司官网披露的产品说明书。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" Type: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='Type', column_type='int', nullable=False, chn_name='基金运作方式') """基金运作方式:基金运作方式(Type)与(CT_SystemConst)表中的DM字段关联,令LB = 1210,得到基金运作方式的具体描述:1-契约型封闭式,2-开放式,3-LOF,4-ETF,6-创新型封闭式,7-开放式(带固定封闭期),8-ETF联接基金,9-半开放式。""" FundNature: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='FundNature', column_type='int', nullable=False, chn_name='基金性质') """基金性质:基金性质(FundNature)与(CT_SystemConst)表中的DM字段关联,令LB = 1485,得到基金性质的具体描述:1-常规基金,2-QDII基金,3-互认基金。""" InvestmentType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InvestmentType', column_type='int', nullable=False, chn_name='基金投资类型') """基金投资类型:基金投资类型(InvestmentType)与(CT_SystemConst)表中的DM字段关联,令LB = 1094,得到基金投资类型的具体描述:1-成长型—积极成长型,2-成长型—稳健成长型,3-成长型—中小企业成长型,4-平衡型,5-资产重组型,6-科技型,7-指数型,8-优化指数型,9-价值型,10-债券型,11-收益型,15-现金型,20-内需增长...""" InvestStyle: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InvestStyle', column_type='int', nullable=False, chn_name='基金投资风格') """基金投资风格:基金投资风格(InvestStyle)与(CT_SystemConst)表中的DM字段关联,令LB = 1093,得到基金投资风格的具体描述:1-股票型,2-指数型,3-配置型,4-现金型,5-激进债券型,6-债券型,7-普通债券型,8-短期债券型,9-保本型,10-激进配置型,11-保守混合型,12-偏股型,13-偏债型,14-中短债型,15-特殊策略型,...""" FundType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='FundType', column_type='varchar(100)', nullable=False, chn_name='基金类别') """基金类别:""" FundTypeCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='FundTypeCode', column_type='int', nullable=True, chn_name='基金类别代码') """基金类别代码:基金类别代码(FundTypeCode)与(CT_SystemConst)表中的DM字段关联,令LB=1249,得到基金类别代码的具体描述:1101-股票型,1103-混合型,1105-债券型,1107-保本型,1109-货币型,1199-其他型。""" RegInstCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='RegInstCode', column_type='int', nullable=False, chn_name='注册登记机构') """注册登记机构:注册登记机构(RegInstCode):与“机构基本资料(LC_InstiArchive)”中“企业编号(CompanyCode)”关联,得到注册登记机构基本信息。""" InvestOrientation: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InvestOrientation', column_type='varchar(1000)', nullable=False, chn_name='基金投资方向') """基金投资方向:""" InvestTarget: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InvestTarget', column_type='varchar(1000)', nullable=False, chn_name='基金投资目标') """基金投资目标:""" InvestField: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InvestField', column_type='varchar(2000)', nullable=False, chn_name='基金投资范围') """基金投资范围:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" PerformanceBenchMark: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='PerformanceBenchMark', column_type='varchar(500)', nullable=False, chn_name='业绩比较基准') """业绩比较基准:""" RiskReturncharacter: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='RiskReturncharacter', column_type='varchar(500)', nullable=False, chn_name='风险收益特征') """风险收益特征:""" ProfitDistributionRule: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ProfitDistributionRule', column_type='varchar(1000)', nullable=False, chn_name='收益分配原则') """收益分配原则:""" ExProfitDistri: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ExProfitDistri', column_type='int', nullable=False, chn_name='场内收益分配方式') """场内收益分配方式:场内收益分配方式(ExProfitDistri)与(CT_SystemConst)表中的DM字段关联,令LB=1989,得到场内收益分配方式的具体描述:1-现金分红,2-红利再投资,3-现金分红或红利再投资,4-不分配。""" OTCProfitDistri: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='OTCProfitDistri', column_type='int', nullable=False, chn_name='场外收益分配方式') """场外收益分配方式:场外收益分配方式(OTCProfitDistri)与(CT_SystemConst)表中的DM字段关联,令LB=1989,得到场外收益分配方式的具体描述:1-现金分红,2-红利再投资,3-现金分红或红利再投资,4-不分配。""" BriefIntro: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='BriefIntro', column_type='text', nullable=False, chn_name='基金简介') """基金简介:""" FloatType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='FloatType', column_type='int', nullable=False, chn_name='发售方式') """发售方式:发售方式(FloatType)与(CT_SystemConst)表中的DM字段关联,令LB=1652,得到发售方式的具体描述:1-场内,2-场外,3-场内和场外。""" FoundedSize: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='FoundedSize', column_type='decimal(18,2)', nullable=False, chn_name='基金设立规模(份)') """基金设立规模(份):""" EstablishmentDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='EstablishmentDate', column_type='datetime', nullable=False, chn_name='设立日期') """设立日期:""" ListedDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ListedDate', column_type='datetime', nullable=False, chn_name='上市日期') """上市日期:""" ApplyingCodeFront: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ApplyingCodeFront', column_type='varchar(10)', nullable=False, chn_name='前端申购代码') """前端申购代码:""" Duration: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='Duration', column_type='decimal(18,2)', nullable=False, chn_name='存续年限(年)') """存续年限(年):""" StartDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='StartDate', column_type='datetime', nullable=False, chn_name='存续期起始日') """存续期起始日:""" ExpireDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ExpireDate', column_type='datetime', nullable=False, chn_name='存续期截止日') """存续期截止日:""" StClearingDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='StClearingDate', column_type='datetime', nullable=False, chn_name='清算起始日') """清算起始日:""" EnClearingDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='EnClearingDate', column_type='datetime', nullable=False, chn_name='清算截止日') """清算截止日:""" GuaranteedPeriod: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='GuaranteedPeriod', column_type='decimal(18,2)', nullable=False, chn_name='保本型基金保本期(月)') """保本型基金保本期(月):""" CarryOverDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='CarryOverDate', column_type='int', nullable=False, chn_name='货币基金结转日') """货币基金结转日:货币基金结转日(CarryOverDate)与(CT_SystemConst)表中的DM字段关联,令LB=1250,得到货币基金结转日的具体描述:1-每月1日,2-每月2日,3-每月3日,4-每月4日,5-每月5日,6-每月6日,7-每月7日,8-每月8日,9-每月9日,10-每月10日,11-每月11日,12-每月12日,13-每月13日,14-每月14日...""" CarryOverDateRemark: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='CarryOverDateRemark', column_type='varchar(100)', nullable=False, chn_name='货币基金结转日说明') """货币基金结转日说明:""" CarryOverType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='CarryOverType', column_type='int', nullable=False, chn_name='货币基金收益分配方式(份额结转方式)') """货币基金收益分配方式(份额结转方式):货币基金收益分配方式(份额结转方式)(CarryOverType)与(CT_SystemConst)表中的DM字段关联,令LB=1273,得到货币基金收益分配方式(份额结转方式)的具体描述:1-按日结转,30-按月结转,99-按期结转。""" ClassificationFundType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ClassificationFundType', column_type='int', nullable=False, chn_name='分级基金类别') """分级基金类别:""" ApplyingCodeBack: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ApplyingCodeBack', column_type='varchar(10)', nullable=False, chn_name='后端申购代码') """后端申购代码:""" AgrBenchmkRateOfShareA: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='AgrBenchmkRateOfShareA', column_type='varchar(200)', nullable=False, chn_name='A份额约定年基准收益率表达式') """A份额约定年基准收益率表达式:A份额约定年基准收益率表达式(AgrBenchmkRateOfShareA):本表该字段已停止维护,此信息在分级基金主表(MF_GradedFund)中“A份额约定年基准收益表达式(AnnualEarningExp)”字段维护。""" AgrBenchmkRateOfShareANotes: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='AgrBenchmkRateOfShareANotes', column_type='varchar(1000)', nullable=False, chn_name='A份额约定年基准收益率表达式备注') """A份额约定年基准收益率表达式备注:A份额约定年基准收益率表达式备注(AgrBenchmkRateOfShareANotes):本表该字段已停止维护,此信息在分级基金主表(MF_GradedFund)中“A份额约定年基准收益表达式备注(AnnualEarningRemark)”字段维护。""" ShareProperties: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ShareProperties', column_type='int', nullable=False, chn_name='份额属性') """份额属性:份额属性(ShareProperties)与(CT_SystemConst)表中的DM字段关联,令LB=1651,得到份额属性的具体描述:1-稳健型,2-进取型。""" RegularShareConversionNotes: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='RegularShareConversionNotes', column_type='varchar(1000)', nullable=False, chn_name='定期份额折算说明') """定期份额折算说明:定期份额折算说明(RegularShareConversionNotes):本表该字段已停止维护,此信息在分级基金主表(MF_GradedFund)中“定期份额折算说明(RegularShareCon)”字段维护。""" NonRegularShareConversionNotes: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='NonRegularShareConversionNotes', column_type='varchar(1000)', nullable=False, chn_name='不定期份额折算说明') """不定期份额折算说明:不定期份额折算说明(NonRegularShareConversionNotes):本表该字段已停止维护,此信息在分级基金主表(MF_GradedFund)中“不定份额折算说明(TrampShareCon)”字段维护。""" Manager: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='Manager', column_type='varchar(50)', nullable=False, chn_name='基金经理') """基金经理:""" InvestAdvisorCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='InvestAdvisorCode', column_type='int', nullable=False, chn_name='基金管理人') """基金管理人:基金管理人代码(InvestAdvisorCode):与“基金管理人概况表(MF_InvestAdvisorOutline)”中的“基金管理人名称编号(InvestAdvisorCode)”关联,得到基金管理人的具体名称。""" TrusteeCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='TrusteeCode', column_type='int', nullable=False, chn_name='基金托管人') """基金托管人:基金托管人代码(TrusteeCode):与“基金托管人概况表(MF_TrusteeOutline)”中的“基金托管人名称编号(TrusteeCode)”关联,得到基金托管人的具体名称。""" Warrantor: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='Warrantor', column_type='varchar(250)', nullable=False, chn_name='保本担保机构') """保本担保机构:""" LowestSumSubscribing: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LowestSumSubscribing', column_type='varchar(500)', nullable=False, chn_name='最低认购申购金额描述') """最低认购申购金额描述:""" SecurityCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='SecurityCode', column_type='varchar(10)', nullable=False, chn_name='基金交易代码(交易所交易代码)') """基金交易代码(交易所交易代码):""" LowestSumSubLL: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LowestSumSubLL', column_type='decimal(19,4)', nullable=False, chn_name='最低认购金额下限(元)') """最低认购金额下限(元):最低认购金额下限(元)(LowestSumSubLL):取值为不同认购平台最低认购金额的最小值。""" LowestSumPurLL: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LowestSumPurLL', column_type='decimal(19,4)', nullable=False, chn_name='最低申购金额下限(元)') """最低申购金额下限(元):最低申购金额下限(元)(LowestSumPurLL):取值为不同申购平台最低申购金额的最小值。""" LowestSumRedemption: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LowestSumRedemption', column_type='decimal(16,6)', nullable=False, chn_name='最低赎回份额(份)') """最低赎回份额(份):""" LSFRDescription: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LSFRDescription', column_type='varchar(200)', nullable=False, chn_name='最低赎回份额描述') """最低赎回份额描述:""" LowestSumForHolding: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LowestSumForHolding', column_type='decimal(16,6)', nullable=False, chn_name='最低持有份额(份)') """最低持有份额(份):""" LSFHDescription: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='LSFHDescription', column_type='varchar(200)', nullable=False, chn_name='最低持有份额描述') """最低持有份额描述:""" DeliveryDays: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='DeliveryDays', column_type='int', nullable=False, chn_name='赎回款到账天数') """赎回款到账天数:""" RiskReturnCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='RiskReturnCode', column_type='int', nullable=False, chn_name='风险收益特征代码') """风险收益特征代码:风险收益特征代码(RiskReturnCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1651,得到风险收益特征代码的具体描述:1-稳健型,2-进取型。""" CustodyMarket: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='CustodyMarket', column_type='int', nullable=False, chn_name='转托管市场') """转托管市场:转托管市场(CustodyMarket)与(CT_SystemConst)表中的DM字段关联,令LB=201 AND DM IN (83,90),得到转托管市场的具体描述:""" OperationPeriod: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='OperationPeriod', column_type='decimal(9,2)', nullable=False, chn_name='运作期') """运作期:""" MainCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='MainCode', column_type='varchar(10)', nullable=False, chn_name='基金主代码') """基金主代码:基金主代码(MainCode):与“证券主表(SecuMain)”中的“证券代码(SecuCode)”关联,得到基金的交易简称等信息。该字段记录基金季报中公布的基金主代码信息,当基金为非分级基金或分级基金主代码时,该字段与基金交易代码(交易所交易代码)(SecurityCode)一致。""" OperationPDUnitCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='OperationPDUnitCode', column_type='int', nullable=False, chn_name='运作期单位代码') """运作期单位代码:""" OperationPDUnitName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='OperationPDUnitName', column_type='varchar(20)', nullable=False, chn_name='运作期单位名称') """运作期单位名称:""" IfInitiatingFund: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='IfInitiatingFund', column_type='int', nullable=False, chn_name='是否发起式基金') """是否发起式基金:是否发起式基金(IfInitiatingFund),该字段固定以下常量:1-否;2-是""" IfPensionTarget: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='IfPensionTarget', column_type='int', nullable=False, chn_name='是否养老目标基金') """是否养老目标基金:是否养老目标基金(IfPensionTarget)该字段固定以下常量:1-是; 2-否""" IfFOF: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='IfFOF', column_type='int', nullable=False, chn_name='是否FOF') """是否FOF:是否FOF(IfFOF),该字段固定以下常量:1-是; 2-否""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" ExApplyingMarket: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ExApplyingMarket', column_type='int', nullable=False, chn_name='场内申购赎回场所') """场内申购赎回场所:场内申购赎回场所(ExApplyingMarket):与“系统常量表(CT_SystemConst)”中“代码(DM)”关联,令“LB=201”,得到证券市场具体描述:71-柜台交易市场,81-三板市场,83-上海证券交易所,84-其他市场,89-银行间债券市场,90-深圳证券交易所""" ExApplyingCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ExApplyingCode', column_type='varchar(10)', nullable=False, chn_name='场内申购赎回代码') """场内申购赎回代码:""" ExApplyingAbbr: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FundArchives', column_name='ExApplyingAbbr', column_type='varchar(100)', nullable=False, chn_name='场内申购赎回简称') """场内申购赎回简称:"""
class LC_MainOperIncome(SQLTableEntity): name: str = 'LC_MainOperIncome' chn_name: str = '公司主营业务构成' business_unique: str = 'CompanyCode,EndDate,DateType,IfMerged,IfAdjusted,Classification,Project' refresh_freq: str = """季更新""" comment: str = """1收录公司主营业务的收入来源、成本构成;主营业务收入、成本和利润与上年同期的对比较。 2.数据范围:1998-12-31至今 3.信息来源:招股说明书、定报、审计报告等""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" Project: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='Project', column_type='varchar(255)', nullable=False, chn_name='经营项目名称') """经营项目名称:""" Industry: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='Industry', column_type='int', nullable=False, chn_name='所属行业') """所属行业:""" RegionAndBusiness: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='RegionAndBusiness', column_type='int', nullable=False, chn_name='地区与业务性质') """地区与业务性质:地区与业务性质(RegionAndBusiness)与(CT_SystemConst)表中的DM字段关联,令LB = 1042,得到地区与业务性质的具体描述:11-国内,12-港澳台,13-国外,19-其他地区,30-进出口,31-进口,33-出口,51-内部抵减抵销,52-关联交易,59-其他性质,99-合计。""" MainOperIncome: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainOperIncome', column_type='decimal(19,4)', nullable=False, chn_name='主营业务收入(元)') """主营业务收入(元):""" MainOperCost: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainOperCost', column_type='decimal(19,4)', nullable=False, chn_name='主营业务成本(元)') """主营业务成本(元):""" MainOperProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainOperProfit', column_type='decimal(19,4)', nullable=False, chn_name='主营业务利润(元)') """主营业务利润(元):""" MainOperIncomeFormerYear: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainOperIncomeFormerYear', column_type='decimal(19,4)', nullable=False, chn_name='上年同期主营业务收入(元)') """上年同期主营业务收入(元):""" MainOperCostFormerYear: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainOperCostFormerYear', column_type='decimal(19,4)', nullable=False, chn_name='上年同期主营业务成本(元)') """上年同期主营业务成本(元):""" MainOperProfitFormerYear: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainOperProfitFormerYear', column_type='decimal(19,4)', nullable=False, chn_name='上年同期主营业务利润(元)') """上年同期主营业务利润(元):""" MainIncomeGrowRateYOY: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainIncomeGrowRateYOY', column_type='decimal(18,4)', nullable=False, chn_name='主营业务收入同比') """主营业务收入同比:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='CompanyCode', column_type='int', nullable=True, chn_name='公司代码') """公司代码:公司代码(CompanyCode):与“证券主表(SecuMain)”中的“公司代码(CompanyCode)”关联,得到上市公司的交易代码、简称等。""" MainICostGrowRateYOY: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainICostGrowRateYOY', column_type='decimal(18,4)', nullable=False, chn_name='主营业务成本同比') """主营业务成本同比:""" MainProfitGrowRateYOY: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='MainProfitGrowRateYOY', column_type='decimal(18,4)', nullable=False, chn_name='主营业务利润同比') """主营业务利润同比:""" GrossProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='GrossProfit', column_type='decimal(10,8)', nullable=False, chn_name='毛利率') """毛利率:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='修改日期') """修改日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='EndDate', column_type='datetime', nullable=True, chn_name='截止日期') """截止日期:""" DateType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='DateType', column_type='int', nullable=False, chn_name='日期类型') """日期类型:日期类型(DateType)与(CT_SystemConst)表中的DM字段关联,令LB = 1074,得到日期类型的具体描述:1-月份,2-季度,3-期末累计,4-当月及累计,5-日,6-周,7-旬,8-半月,9-年度,11-上年同月,12-上年同期,13-上年同季,14-期末,21-上月=100,22-2005年=100,23-2005年=100(季度)...""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='InfoSource', column_type='varchar(100)', nullable=False, chn_name='信息来源') """信息来源:""" IfMerged: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='IfMerged', column_type='int', nullable=False, chn_name='合并标志') """合并标志:合并标志(IfMerged)与(CT_SystemConst)表中的DM字段关联,令LB = 1189,得到合并标志的具体描述:1-合并,2-母公司,3-合并调整,4-母公司调整,5-合并修正前,6-母公司修正前,7-专项合并。""" IfAdjusted: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='IfAdjusted', column_type='int', nullable=False, chn_name='调整标志') """调整标志:调整标志(IfAdjusted):与“系统常量表(CT_SystemConst)”中的“代码(DM)”关联,令“LB=1188”,得到财务报表“调整标志”的具体描述。1-是,2-否,3-前,其中3-前代表数据更正的时候,会把之前的数据的调整标志改成前,此处理2010年开始废弃。""" Classification: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='Classification', column_type='int', nullable=False, chn_name='分类方式') """分类方式:分类方式(Classification)与(CT_SystemConst)表中的DM字段关联,令LB = 1046,得到分类方式的具体描述:10-按行业,20-按产品,30-按地区,50-按业务。""" SN: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_MainOperIncome', column_name='SN', column_type='int', nullable=False, chn_name='序号') """序号:"""
class MF_IssueAndListing(SQLTableEntity): name: str = 'MF_IssueAndListing' chn_name: str = '公募基金发行与上市' business_unique: str = 'InnerCode' refresh_freq: str = """日更新""" comment: str = """1.本表记录基金发行与上市相关信息,包括发行上市的日期、发行状态、发起人认购情况等相关信息。 2.历史数据:1998年3月起-至今。 3.信息来源:基金公司官网披露的产品说明书及相关临时公告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" IssueStartDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='IssueStartDate', column_type='datetime', nullable=False, chn_name='发行起始日') """发行起始日:""" IssueEndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='IssueEndDate', column_type='datetime', nullable=False, chn_name='发行截止日') """发行截止日:""" OrgIssueStartDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='OrgIssueStartDate', column_type='datetime', nullable=False, chn_name='机构发行起始日') """机构发行起始日:""" OrgIssueEndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='OrgIssueEndDate', column_type='datetime', nullable=False, chn_name='机构发行截止日') """机构发行截止日:""" IssueState: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='IssueState', column_type='int', nullable=False, chn_name='发行状态') """发行状态:发行状态(IssueState)与(CT_SystemConst)表中的DM字段关联,令LB = 1939,得到发行状态的具体描述:1-待募集,2-取消募集,3-募集中,4-募集结束,5-募集成功,6-募集失败。""" IssueCancelDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='IssueCancelDate', column_type='datetime', nullable=False, chn_name='取消发行时间') """取消发行时间:""" CurrencyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='CurrencyCode', column_type='int', nullable=False, chn_name='发行币种') """发行币种:发行币种(CurrencyCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1068,得到发行币种的具体描述:1000-美元,1100-港元,1110-印度卢比,1120-印度尼西亚卢比,1130-伊朗里亚尔,1140-波兰兹罗提,1150-匈牙利福林,1160-日本元,1161-欧洲日元(离岸),1170-约旦第纳尔,1180-科...""" CurrencyStyle: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='CurrencyStyle', column_type='int', nullable=False, chn_name='货币样式') """货币样式:货币样式(CurrencyStyle)与(CT_SystemConst)表中的DM字段关联,令LB = 1741,得到货币样式的具体描述:1-现汇,2-现钞。""" InitialParValue: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='InitialParValue', column_type='decimal(19,4)', nullable=False, chn_name='基金初始单位面值(元)') """基金初始单位面值(元):""" ParValue: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ParValue', column_type='decimal(19,4)', nullable=False, chn_name='基金单位面值(元)') """基金单位面值(元):""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" UnitIssuePrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='UnitIssuePrice', column_type='decimal(19,4)', nullable=False, chn_name='单位基金发行价格(元)') """单位基金发行价格(元):""" UnitIssueFee: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='UnitIssueFee', column_type='decimal(19,4)', nullable=False, chn_name='单位基金发行费用(元)') """单位基金发行费用(元):""" ShareIssued: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ShareIssued', column_type='decimal(18,4)', nullable=False, chn_name='基金单位发行总份额(份)') """基金单位发行总份额(份):""" InitiatorSubscribeVolume: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='InitiatorSubscribeVolume', column_type='decimal(18,0)', nullable=False, chn_name='发起人认购份额(份)') """发起人认购份额(份):""" InitiatorHoldFloatShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='InitiatorHoldFloatShares', column_type='decimal(18,0)', nullable=False, chn_name='发起人持有可流通份额数量(份)') """发起人持有可流通份额数量(份):""" InitiatorHoldTerm: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='InitiatorHoldTerm', column_type='decimal(18,4)', nullable=False, chn_name='发起人可流通份额持有期限(月)') """发起人可流通份额持有期限(月):""" MiniInitiatorHoldingRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='MiniInitiatorHoldingRatio', column_type='decimal(18,6)', nullable=False, chn_name='存续期发起人最低持有份额比例') """存续期发起人最低持有份额比例:""" FInstitutionQuota: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FInstitutionQuota', column_type='decimal(18,0)', nullable=False, chn_name='保险公司等机构配售份额(份)') """保险公司等机构配售份额(份):""" PublicOfferShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='PublicOfferShares', column_type='decimal(18,0)', nullable=False, chn_name='上网公开发行份额(份)') """上网公开发行份额(份):""" GeneralLegalPersonQuota: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='GeneralLegalPersonQuota', column_type='decimal(18,0)', nullable=False, chn_name='一般法人网下配售份额(份)') """一般法人网下配售份额(份):""" InitialInfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='InitialInfoPublDate', column_type='datetime', nullable=False, chn_name='首次信息发布日期') """首次信息发布日期:""" AbbrNameForApplying: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='AbbrNameForApplying', column_type='varchar(20)', nullable=False, chn_name='申购简称') """申购简称:""" ApplyingCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ApplyingCode', column_type='varchar(10)', nullable=False, chn_name='申购代码') """申购代码:""" ApplyingUnit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ApplyingUnit', column_type='int', nullable=False, chn_name='申购单位(份)') """申购单位(份):""" MinimumApplying: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='MinimumApplying', column_type='int', nullable=False, chn_name='单一帐户申购下限(份)') """单一帐户申购下限(份):""" MaximumApplying: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='MaximumApplying', column_type='int', nullable=False, chn_name='单一帐户申购上限(份)') """单一帐户申购上限(份):""" ApplyingTimes: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ApplyingTimes', column_type='int', nullable=False, chn_name='单一帐户申购次数') """单一帐户申购次数:单一帐户申购次数(ApplyingTimes)与(CT_SystemConst)表中的DM字段关联,令LB = 1191,得到单一帐户申购次数的具体描述:1-一次,2-多次。""" ValidlApplyingAccounts: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ValidlApplyingAccounts', column_type='int', nullable=False, chn_name='发行有效申购总户数(户)') """发行有效申购总户数(户):""" ValidApplyingVol: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ValidApplyingVol', column_type='decimal(18,0)', nullable=False, chn_name='发行有效申购总量(份)') """发行有效申购总量(份):""" OverApplyingMultiples: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='OverApplyingMultiples', column_type='decimal(18,4)', nullable=False, chn_name='发行超额认购倍数(倍)') """发行超额认购倍数(倍):""" FreezeFunds: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FreezeFunds', column_type='decimal(18,4)', nullable=False, chn_name='发行冻结资金(元)') """发行冻结资金(元):""" ProspectusIssuedDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ProspectusIssuedDate', column_type='datetime', nullable=False, chn_name='招募说明书发布日期') """招募说明书发布日期:""" HitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='HitRatio', column_type='decimal(18,9)', nullable=False, chn_name='发行中签率') """发行中签率:""" ListedDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ListedDate', column_type='datetime', nullable=False, chn_name='基金上市日期') """基金上市日期:""" ListedPlace: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ListedPlace', column_type='int', nullable=False, chn_name='基金上市地点') """基金上市地点:基金上市地点(ListedPlace)与(CT_SystemConst)表中的DM字段关联,令LB = 201 AND DM IN (83,90),得到基金上市地点的具体描述:83-上海证券交易所,90-深圳证券交易所。""" OutstandingShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='OutstandingShares', column_type='decimal(18,0)', nullable=False, chn_name='本次可流通份额(份)') """本次可流通份额(份):""" FirstDayOpenPrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FirstDayOpenPrice', column_type='decimal(18,3)', nullable=False, chn_name='上市首日开盘价(元)') """上市首日开盘价(元):""" FirstDayColsePrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FirstDayColsePrice', column_type='decimal(18,3)', nullable=False, chn_name='上市首日收盘价(元)') """上市首日收盘价(元):""" FirstDayTurnoverRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FirstDayTurnoverRatio', column_type='decimal(18,6)', nullable=False, chn_name='上市首日换手率') """上市首日换手率:""" EstablishmentDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='EstablishmentDate', column_type='datetime', nullable=False, chn_name='成立日期') """成立日期:""" ApplyOpeningDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ApplyOpeningDate', column_type='datetime', nullable=False, chn_name='申购开放起始日') """申购开放起始日:""" RedeemOpeningDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='RedeemOpeningDate', column_type='datetime', nullable=False, chn_name='赎回开放起始日') """赎回开放起始日:""" ListAnnouncementIssueDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='ListAnnouncementIssueDate', column_type='datetime', nullable=False, chn_name='上市公告书发布日期') """上市公告书发布日期:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" FundRaisingMethod: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FundRaisingMethod', column_type='int', nullable=False, chn_name='募资方式') """募资方式:募资方式(FundRaisingMethod)与(CT_SystemConst)表中的DM字段关联,令LB = 1211,得到募资方式的具体描述:1-基金发行,2-改制上市,3-封转开,4-基金转型,5-新增份额。""" FundType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='FundType', column_type='int', nullable=False, chn_name='发行基金类型') """发行基金类型:发行基金类型(FundType)与(CT_SystemConst)表中的DM字段关联,令LB = 1210,得到发行基金类型的具体描述:1-契约型封闭式,2-开放式,3-LOF,4-ETF,5-FOF,6-创新型封闭式,7-开放式(带固定封闭期),8-ETF联接基金,9-半开放式。""" IssueObject: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='IssueObject', column_type='varchar(100)', nullable=False, chn_name='发行对象') """发行对象:""" IssueWay: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_IssueAndListing', column_name='IssueWay', column_type='int', nullable=False, chn_name='发行方式') """发行方式:"""
class Fut_ConversionFactors(SQLTableEntity): name: str = 'Fut_ConversionFactors' chn_name: str = '期货交割转换因子' business_unique: str = 'InfoPublDate,ContractInnerCode,IBMarketInnerCode' refresh_freq: str = """不定时更新""" comment: str = """1.收录期货(包括金融期货)交易的转换因子。可查询该期货的合约信息和转换债券的相关信息。包括票面利率(%)、转换因子等指标信息。 2.数据范围:2014-01-07——至今。 3.信息来源:中国金融金融期货交易所。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" ConversionFactors: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='ConversionFactors', column_type='decimal(19,8)', nullable=False, chn_name='转换因子') """转换因子:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='修改时间') """修改时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" IssuanceOrg: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='IssuanceOrg', column_type='int', nullable=False, chn_name='发布机构') """发布机构:发布机构(IssuanceOrg)与(CT_SystemConst)表中的DM字段关联,令LB = 1324 AND DM = 20,得到发布机构的具体描述:20-中国金融期货交易所。""" ContractInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='ContractInnerCode', column_type='int', nullable=False, chn_name='合约内部编码') """合约内部编码:合约内部编码(ContractInnerCode):与“期货合约主表(Fut_ContractMain)”中的“合约内部编码(ContractInnerCode)”关联,得到该期货合约的基础信息。""" SerialNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='SerialNumber', column_type='int', nullable=False, chn_name='序号') """序号:""" IBMarketInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='IBMarketInnerCode', column_type='int', nullable=False, chn_name='银行间债券市场内部编码') """银行间债券市场内部编码:银行间债券市场内部编码(IBMarketInnerCode):与“债券代码对照表(Bond_Code)”中的“债券内部编码(InnerCode)”关联,得到债券的交易代码、债券简称等。""" SHExchangeInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='SHExchangeInnerCode', column_type='int', nullable=False, chn_name='上海证券交易所内部编码') """上海证券交易所内部编码:上海证券交易所内部编码(SHExchangeInnerCode):与“债券代码对照表(Bond_Code)”中的“债券内部编码(InnerCode)”关联,得到债券的交易代码、债券简称等。""" SZExchangeInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='SZExchangeInnerCode', column_type='int', nullable=False, chn_name='深圳证券交易所内部编码') """深圳证券交易所内部编码:深圳证券交易所内部编码(SZExchangeInnerCode):与“债券代码对照表(Bond_Code)”中的“债券内部编码(InnerCode)”关联,得到债券的交易代码、债券简称等。""" CouponRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='Fut_ConversionFactors', column_name='CouponRate', column_type='decimal(19,8)', nullable=False, chn_name='票面利率(%)') """票面利率(%):"""
class HK_CodeChange(SQLTableEntity): name: str = 'HK_CodeChange' chn_name: str = '港股证券代码变动表' business_unique: str = 'InnerCode,EffectiveDate' refresh_freq: str = """日更新""" comment: str = """1.记录港股公司证券代码的变动历史记录数据,包括信息发布时间、生效时间、变动前代码、变动后代码等。 2.数据范围:1997年至今。 3.信息来源:港交所。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" ExpiryDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='ExpiryDate', column_type='datetime', nullable=False, chn_name='失效日期') """失效日期:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='InnerCode', column_type='int', nullable=True, chn_name='证券内部编码') """证券内部编码:证券内部编码(InnerCode):与“港股证券主表(HK_SecuMain)”中的“证券内部编码(InnerCode)”关联,得到港股的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='InfoSource', column_type='int', nullable=False, chn_name='信息来源') """信息来源:信息来源(InfoSource)与(CT_SystemConst)表中的DM字段关联,令LB=1926,得到信息来源的具体描述:1-审计报告,2-第一季报,3-中期报告,4-第三季报,5-年度报告,6-第二季报,7-第四季报,8-第五季报,9-定期报告,10-申请版本,11-聆讯后资料集,12-招股章程,13-临时公告,14-审计报告(申报稿),15-公开转...""" SMAnnounceDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='SMAnnounceDate', column_type='datetime', nullable=False, chn_name='股东大会公告日期') """股东大会公告日期:""" IfEffected: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='IfEffected', column_type='int', nullable=True, chn_name='是否有效') """是否有效:是否有效(IfEffected)与(CT_SystemConst)表中的DM字段关联,令LB =999 and DM in (1,2),得到是否有效的具体描述:1-是,2-否。""" EffectiveDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='EffectiveDate', column_type='datetime', nullable=True, chn_name='生效日期') """生效日期:""" CodeBeforeChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='CodeBeforeChange', column_type='varchar(20)', nullable=False, chn_name='变更前代码') """变更前代码:""" CodeAfterChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_CodeChange', column_name='CodeAfterChange', column_type='varchar(20)', nullable=False, chn_name='变更后代码') """变更后代码:"""
class LC_ActualController(SQLTableEntity): name: str = 'LC_ActualController' chn_name: str = '公司实际控制人' business_unique: str = 'CompanyCode,InfoPublDate,EndDate,ControllerName' refresh_freq: str = """不定时更新""" comment: str = """1.收录根据上市公司在招投说明书、定期报告、及临时公告中披露的实际控制人结构图判断的上市公司实际控制人信息。 2.目前只处理实际控制人有变动的数据,下期和本期相比如无变化,则不做处理。 3.数据范围:2004-12-31至今 4.信息来源:招股说明书、上市公告书、定报、临时公告等。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" PermanentResidency: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='PermanentResidency', column_type='varchar(100)', nullable=False, chn_name='永久境外居留权') """永久境外居留权:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='CompanyCode', column_type='int', nullable=True, chn_name='公司代码') """公司代码:公司代码(CompanyCode):与“证券主表(SecuMain)”中的“公司代码(CompanyCode)”关联,得到上市公司的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='InfoPublDate', column_type='datetime', nullable=True, chn_name='信息发布日期') """信息发布日期:""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='EndDate', column_type='datetime', nullable=True, chn_name='截止日期') """截止日期:""" ControllerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='ControllerCode', column_type='int', nullable=False, chn_name='实际控制人代码') """实际控制人代码:实际控制人代码(ControllerCode):与“机构基本资料(LC_InstiArchive)”中的“企业编号(CompanyCode)”关联,得到实际控制人的名称,企业性质等信息。""" ControllerName: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='ControllerName', column_type='varchar(120)', nullable=True, chn_name='实际控制人') """实际控制人:""" EconomicNature: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='EconomicNature', column_type='int', nullable=False, chn_name='实际控制人经济性质') """实际控制人经济性质:实际控制人经济性质(EconomicNature)与(CT_SystemConst)表中的DM字段关联,令LB = 1581,得到实际控制人经济性质的具体描述:1-中央企业,2-地方国有企业,3-民营企业,4-集体企业,5-大学,6-外资,7-工会,99-其它。""" NationalityCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='NationalityCode', column_type='int', nullable=False, chn_name='国籍代码') """国籍代码:国籍代码(NationalityCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1023,得到国籍代码的具体描述:3-港澳台,4-中东地区,7-国际,100-亚洲,101-阿富汗,102-巴林,103-孟加拉国,104-不丹,105-文莱,106-缅甸,107-柬埔寨,108-塞浦路斯,109-朝鲜,110-中国香港,111-印度...""" NationalityDesc: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_ActualController', column_name='NationalityDesc', column_type='varchar(50)', nullable=False, chn_name='国籍描述') """国籍描述:"""
class MF_FinancialIndex(SQLTableEntity): name: str = 'MF_FinancialIndex' chn_name: str = '公募基金财务指标' business_unique: str = 'InnerCode,ReportDate' refresh_freq: str = """半年更新""" comment: str = """1.本表记录基金各类财务指标,包括基金单位指标、资产状况指标、收益分析指标、费用分析指标、盈利能力指标。 2.历史数据:1998年12月起-至今。 3.信息来源:基金公司披露的定期报告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" TotalAsset: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalAsset', column_type='decimal(19,4)', nullable=False, chn_name='基金资产总额(元)') """基金资产总额(元):""" TotalLiability: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalLiability', column_type='decimal(19,4)', nullable=False, chn_name='基金负债总额(元)') """基金负债总额(元):""" UnrealizedProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnrealizedProfit', column_type='decimal(19,4)', nullable=False, chn_name='基金未实现估值增值(元)') """基金未实现估值增值(元):""" TotalNetAsset: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalNetAsset', column_type='decimal(19,4)', nullable=False, chn_name='基金净资产值(元)') """基金净资产值(元):""" TotalShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalShares', column_type='decimal(18,4)', nullable=False, chn_name='基金单位总额(元)') """基金单位总额(元):""" TotalIncome: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalIncome', column_type='decimal(19,4)', nullable=False, chn_name='基金总收入(元)') """基金总收入(元):""" SecuSpreadIncome: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='SecuSpreadIncome', column_type='decimal(19,4)', nullable=False, chn_name='证券买卖价差收入(元)') """证券买卖价差收入(元):证券买卖价差收入=股票差价收入+债券差价收入""" InvestIncome: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='InvestIncome', column_type='decimal(19,4)', nullable=False, chn_name='投资收益(元)') """投资收益(元):投资收益=债券利息收入+股利收入""" NetProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='NetProfit', column_type='decimal(19,4)', nullable=False, chn_name='本期净收益(元)') """本期净收益(元):""" RetainedProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='RetainedProfit', column_type='decimal(19,4)', nullable=False, chn_name='期末未分配收益(元)') """期末未分配收益(元):""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" Performance: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='Performance', column_type='decimal(19,4)', nullable=False, chn_name='基金经营业绩(元)') """基金经营业绩(元):""" RealizedProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='RealizedProfitRatio', column_type='decimal(18,4)', nullable=False, chn_name='已实现收入比率') """已实现收入比率:已实现收入比率=[1-未实现估值增值/(经营业绩+费用)]×100%""" MainIncomeRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='MainIncomeRatio', column_type='decimal(18,4)', nullable=False, chn_name='主营收入比率') """主营收入比率:主营收入比率=(证券买卖价差收入+投资收益+未实现利得)/(经营业绩+费用)×100%""" StockInvestIncomeRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='StockInvestIncomeRatio', column_type='decimal(18,6)', nullable=False, chn_name='股票收入比率') """股票收入比率:股票收入比率=(股票差价收入+股息收入+股票投资估值增值)/(经营业绩+费用)×100%,其中股票投资估值增值=(本期股票投资市值-本期股票投资成本)-(上期股票投资市值-上期股票投资成本)""" BondInvestIncomeRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='BondInvestIncomeRatio', column_type='decimal(18,6)', nullable=False, chn_name='债券收入比率') """债券收入比率:债券收入比率=(债券差价收入+债券利息收入+债券投资估值增值)/(经营业绩+费用)×100%,其中债券投资估值增值=(本期债券投资市值-本期债券投资成本)-(上期债券投资市值-上期债券投资成本)""" ManagementFeeProportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='ManagementFeeProportion', column_type='decimal(18,6)', nullable=False, chn_name='管理费占总费用的比例') """管理费占总费用的比例:""" TrustFeeProportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TrustFeeProportion', column_type='decimal(18,6)', nullable=False, chn_name='托管费占总费用的比例') """托管费占总费用的比例:""" TradeExpenseProportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TradeExpenseProportion', column_type='decimal(18,6)', nullable=False, chn_name='交易费占总费用的比例') """交易费占总费用的比例:""" OtherExpenseProportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='OtherExpenseProportion', column_type='decimal(18,6)', nullable=False, chn_name='其他费用占总费用的比例') """其他费用占总费用的比例:""" ManagementFeeProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='ManagementFeeProfitRatio', column_type='decimal(18,6)', nullable=False, chn_name='管理费用收益比') """管理费用收益比:管理费用收益比=总收益/管理费用=(经营业绩+费用)/管理费用""" ReportDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='ReportDate', column_type='datetime', nullable=True, chn_name='报告期') """报告期:""" TrustFeeProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TrustFeeProfitRatio', column_type='decimal(18,6)', nullable=False, chn_name='托管费用收益比') """托管费用收益比:托管费用收益比=总收益/托管费用=(经营业绩+费用)/托管费用""" TradeExpenseProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TradeExpenseProfitRatio', column_type='decimal(18,6)', nullable=False, chn_name='交易费用收益比') """交易费用收益比:交易费用收益比=总收益/交易费用=(经营业绩+费用)/交易费用""" OtherExpenseProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='OtherExpenseProfitRatio', column_type='decimal(18,6)', nullable=False, chn_name='其他费用收益比') """其他费用收益比:其他费用收益比=总收益/其他费用=(经营业绩+费用)/其他费用""" TotalExpenseProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalExpenseProfitRatio', column_type='decimal(18,6)', nullable=False, chn_name='总费用收益比') """总费用收益比:总费用收益比=总收益/费用=(经营业绩+费用)/费用""" NVYield: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='NVYield', column_type='decimal(18,6)', nullable=False, chn_name='净值收益率') """净值收益率:""" PerformanceGrowthRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='PerformanceGrowthRate', column_type='decimal(18,6)', nullable=False, chn_name='经营业绩同比增长率') """经营业绩同比增长率:""" NVGrowthRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='NVGrowthRate', column_type='decimal(18,6)', nullable=False, chn_name='本期净值增长率') """本期净值增长率:""" AccumulatedNVGrowthRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='AccumulatedNVGrowthRate', column_type='decimal(18,6)', nullable=False, chn_name='累计净值增长率') """累计净值增长率:""" TotalAssetGrowthRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='TotalAssetGrowthRate', column_type='decimal(18,6)', nullable=False, chn_name='总资产增长率') """总资产增长率:总资产增长率=(本期总资产/上期总资产-1)×100%""" UnrealizedProfitRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnrealizedProfitRatio', column_type='decimal(18,6)', nullable=False, chn_name='未实现估值增值收入比率') """未实现估值增值收入比率:未实现估值增值收入比率=(未实现估值增值/基金本期净收益)×100%""" UnitNetProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnitNetProfit', column_type='decimal(19,4)', nullable=False, chn_name='单位基金净收益(元)') """单位基金净收益(元):""" StockTradeYield: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='StockTradeYield', column_type='decimal(18,6)', nullable=False, chn_name='股票交易收益率') """股票交易收益率:股票交易收益率={股票差价收入/[(期初净值+期末净值)/2]×0.8}×100%""" DividendRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='DividendRatio', column_type='decimal(18,6)', nullable=False, chn_name='分红率') """分红率:分红率=(收益分配金额/本期可分配收益)×100%""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" UnitDistributableProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnitDistributableProfit', column_type='decimal(19,4)', nullable=False, chn_name='单位基金可分配净收益(元)') """单位基金可分配净收益(元):""" UnitRetainedProfit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnitRetainedProfit', column_type='decimal(19,4)', nullable=False, chn_name='单位基金未分配收益(元)') """单位基金未分配收益(元):""" UnitNV: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnitNV', column_type='decimal(19,4)', nullable=False, chn_name='单位基金净值(元)') """单位基金净值(元):""" UnitAccumulatedNV: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='UnitAccumulatedNV', column_type='decimal(19,4)', nullable=False, chn_name='单位基金累计净值(元)') """单位基金累计净值(元):""" DiscountRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_FinancialIndex', column_name='DiscountRatio', column_type='decimal(18,4)', nullable=False, chn_name='基金升贴水率') """基金升贴水率:"""
class LC_AshareIPOBid(SQLTableEntity): name: str = 'LC_AshareIPOBid' chn_name: str = 'A股询价明细' business_unique: str = 'InnerCode,SerialNumber,InvestorName,BidderName' refresh_freq: str = """不定时更新""" comment: str = """1.收录新上市A股询价、网下配售明细,包括投资者名称、配售对象名称、申报价格、拟申购股数、总实际申购股数和总获配售股数等内容。 2.信息来源:上交所、深交所""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" PriceUnit: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='PriceUnit', column_type='decimal(19,4)', nullable=False, chn_name='申报价格') """申报价格:""" PlannedBidVol: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='PlannedBidVol', column_type='decimal(19,2)', nullable=False, chn_name='拟申购股数(股)') """拟申购股数(股):""" PremiumRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='PremiumRate', column_type='decimal(19,4)', nullable=False, chn_name='申报价折溢价比率') """申报价折溢价比率:申报价折溢价比率(PremiumRate)=申报价格/每股发行价格。""" BidVolEx: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='BidVolEx', column_type='decimal(19,2)', nullable=False, chn_name='被剔除申购股数(股)') """被剔除申购股数(股):""" ActualBidVol: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='ActualBidVol', column_type='decimal(19,2)', nullable=False, chn_name='总实际申购股数(股)') """总实际申购股数(股):""" ActualAllotment: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='ActualAllotment', column_type='decimal(19,2)', nullable=False, chn_name='总获配售股数(股)') """总获配售股数(股):""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='InnerCode', column_type='int', nullable=True, chn_name='证券内部编码') """证券内部编码:证券内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到证券的交易代码、简称等。""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='CompanyCode', column_type='int', nullable=False, chn_name='公司代码') """公司代码:""" SerialNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='SerialNumber', column_type='int', nullable=True, chn_name='序号') """序号:""" InvestorCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='InvestorCode', column_type='int', nullable=False, chn_name='投资者编码') """投资者编码:""" InvestorName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='InvestorName', column_type='varchar(200)', nullable=False, chn_name='投资者名称') """投资者名称:""" BidderCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='BidderCode', column_type='int', nullable=False, chn_name='配售对象代码') """配售对象代码:""" BidderName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='BidderName', column_type='varchar(200)', nullable=True, chn_name='配售对象名称') """配售对象名称:""" BidderCategory: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_AshareIPOBid', column_name='BidderCategory', column_type='int', nullable=False, chn_name='配售对象类别') """配售对象类别:配售对象类别(BidderCategory)与(CT_SystemConst)表中的DM字段关联,令LB = 1825,得到配售对象类别的具体描述:1-公募基金,2-社保基金或社保基金组合,3-个人或个人自有资金投资账户,4-其他,5-企业年金计划,6-机构自营投资账户,7-证券公司集合资产管理计划,8-基金公司或其资产管理子公司一对一,9-保险资金投资账户..."""
class HK_StoDiscInf(SQLTableEntity): name: str = 'HK_StoDiscInf' chn_name: str = '港股披露权益信息' business_unique: str = '无' refresh_freq: str = """日更新""" comment: str = """1.记录港股披露权益的基础信息,包括股份类型、持有人名称、持有性质、事件日期、持有人知悉日期等数据内容。该表为港股披露权益系列表的主表。 2.数据范围:1997年至今。 3.信息来源:港交所。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" EventDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='EventDate', column_type='datetime', nullable=True, chn_name='事件日期') """事件日期:""" HolderNotcDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='HolderNotcDate', column_type='datetime', nullable=False, chn_name='持有人知悉日期') """持有人知悉日期:""" SN: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='SN', column_type='int', nullable=True, chn_name='序号') """序号:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" Companyode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='Companyode', column_type='int', nullable=False, chn_name='公司代码') """公司代码:""" CompanyName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='CompanyName', column_type='varchar(200)', nullable=False, chn_name='公司名称') """公司名称:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='InnerCode', column_type='int', nullable=True, chn_name='港股内部代码') """港股内部代码:港股内部代码(InnerCode):与“港股证券主表(HK_SecuMain)”中的“证券内部编码(InnerCode)”关联,得到港股的交易代码、简称等。""" SecuCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='SecuCode', column_type='varchar(10)', nullable=False, chn_name='证券代码') """证券代码:""" ShareCategory: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='ShareCategory', column_type='varchar(200)', nullable=False, chn_name='股份类型') """股份类型:""" IssuedShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='IssuedShares', column_type='decimal(18,2)', nullable=False, chn_name='已发行股份(股)') """已发行股份(股):""" ChiHolderName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='ChiHolderName', column_type='varchar(200)', nullable=False, chn_name='持有人姓名') """持有人姓名:""" HolderCharacter: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_StoDiscInf', column_name='HolderCharacter', column_type='int', nullable=True, chn_name='持有人性质') """持有人性质:持有人性质(HolderCharacter)与(CT_SystemConst)表中的DM字段关联,令LB=1700,得到持有人性质的具体描述:101-董事,102-大股东,103-其他(含最高行政人員),104-个人大股东,105-法团大股东,106-董事-上市法团股份,107-董事-相联法团股份,108-董事-上市法团债券证,109-董事-相联法团债券证。"""
class LC_MainSHListNew(SQLTableEntity): name: str = 'LC_MainSHListNew' chn_name: str = '股东名单(新)' business_unique: str = 'CompanyCode,EndDate,InfoTypeCode,SHSerial' refresh_freq: str = """不定时更新""" comment: str = """1.收录公司主要股东构成及持股数量比例、持股性质等明细资料,包括发行前和上市后的历次变动记录。 2.数据范围:1992-06-30至今 3.信息来源:招股说明书、上市公告书、定报、临时公告等。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" SHList: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHList', column_type='varchar(200)', nullable=False, chn_name='股东名单') """股东名单:""" SHAttribute: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHAttribute', column_type='int', nullable=False, chn_name='股东属性') """股东属性:股东属性(SHAttribute)与(CT_SystemConst)表中的DM字段关联,令LB=1783,得到股东属性的具体描述:1-自然人,2-企业,3-证券品种,99-其他。""" SHKind: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHKind', column_type='varchar(50)', nullable=False, chn_name='股东性质') """股东性质:""" SHKindCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHKindCode', column_type='int', nullable=False, chn_name='股东性质编码') """股东性质编码:股东性质编码(SHKindCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1026,得到股东性质编码的具体描述:1-封闭式投资基金,2-开放式投资基金,3-金融机构—证券、信托公司,4-金融机构—保险公司,5-金融机构—期货公司,6-金融机构—银行,7-公益基金,8-投资、咨询公司,9-风险投资公司,10-金融机构—金融租赁公司,...""" SHTypeCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHTypeCode', column_type='int', nullable=False, chn_name='股东类别编码') """股东类别编码:股东类别编码(SHTypeCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1368,得到股东类别编码的具体描述:10-国有股东,20-外资股东,90-其他股东。""" SHType: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHType', column_type='varchar(50)', nullable=False, chn_name='股东类别') """股东类别:""" SecuCoBelongedCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SecuCoBelongedCode', column_type='int', nullable=False, chn_name='归属机构编码') """归属机构编码:归属机构编码(SecuCoBelongedCode):与“机构基本资料(LC_InstiArchive)”中的“企业编号(CompanyCode)”关联,得到归属机构的基本情况。""" SecuCoBelongedName: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SecuCoBelongedName', column_type='varchar(200)', nullable=False, chn_name='归属机构名称') """归属机构名称:""" SecuInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SecuInnerCode', column_type='int', nullable=False, chn_name='所属基金/股票内部编码') """所属基金/股票内部编码:所属基金/股票内部编码(SecuInnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到所属基金/股票的交易代码、交易简称等""" SecuCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SecuCode', column_type='varchar(10)', nullable=False, chn_name='所属基金/股票代码') """所属基金/股票代码:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='CompanyCode', column_type='int', nullable=True, chn_name='公司代码') """公司代码:公司代码(CompanyCode):与“证券主表(SecuMain)”中的“公司代码(CompanyCode)”关联,得到上市公司的交易代码、简称等。""" SecuAbbr: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SecuAbbr', column_type='varchar(20)', nullable=False, chn_name='所属基金/股票简称') """所属基金/股票简称:""" HoldSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldSum', column_type='decimal(16,0)', nullable=False, chn_name='持股数(股)') """持股数(股):持股数(股)(HoldSum):当“信息类别代码(InfoTypeCode)”=1时,持股数(股)=总股本当“信息类别代码(InfoTypeCode)”=2时,持股数(股)=无限售股数(股)""" RestrainedTShare: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='RestrainedTShare', column_type='decimal(16,0)', nullable=False, chn_name='其中:有限售股数(股)') """其中:有限售股数(股):""" UnstintedTShare: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='UnstintedTShare', column_type='decimal(16,0)', nullable=False, chn_name='其中:无限售股数(股)') """其中:无限售股数(股):""" HoldAShareSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldAShareSum', column_type='decimal(16,0)', nullable=False, chn_name='持有A股数量(股)') """持有A股数量(股):""" RestrainedAShare: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='RestrainedAShare', column_type='decimal(16,0)', nullable=False, chn_name='其中:有限售A股数(股)') """其中:有限售A股数(股):""" UnstintedAShare: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='UnstintedAShare', column_type='decimal(16,0)', nullable=False, chn_name='其中:无限售A股数(股)') """其中:无限售A股数(股):""" HoldBShareSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldBShareSum', column_type='decimal(16,0)', nullable=False, chn_name='持有B股数量(股)') """持有B股数量(股):""" HoldHShareSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldHShareSum', column_type='decimal(16,0)', nullable=False, chn_name='持有H股数量(股)') """持有H股数量(股):""" HoldOthterShareSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldOthterShareSum', column_type='decimal(16,0)', nullable=False, chn_name='持有其他股数量(股)') """持有其他股数量(股):""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='EndDate', column_type='datetime', nullable=True, chn_name='截止日期') """截止日期:""" HoldSumChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldSumChange', column_type='decimal(16,0)', nullable=False, chn_name='持股数量增减(股)') """持股数量增减(股):""" HoldSumChangeRate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='HoldSumChangeRate', column_type='decimal(16,6)', nullable=False, chn_name='持股数量增减幅度(%)') """持股数量增减幅度(%):""" PCTOfTotalShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='PCTOfTotalShares', column_type='decimal(10,6)', nullable=False, chn_name='占总股本比例(%)') """占总股本比例(%):占总股本比例(%)(PCTOfTotalShares):当“信息类别代码(InfoTypeCode)”=1时,持股数(股)/总股本*100当“信息类别代码(InfoTypeCode)”=2时,无限售股数(股)/总股本*100""" PCTOfFloatShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='PCTOfFloatShares', column_type='decimal(10,6)', nullable=False, chn_name='占流通A股比例(%)') """占流通A股比例(%):占流通A股比例(%)(PCTOfFloatShares)=无限售流通A股/已上市流通A股(不含高管股)*100""" ShareCharacterStatement: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='ShareCharacterStatement', column_type='varchar(50)', nullable=False, chn_name='股本性质描述') """股本性质描述:""" PledgeInvolvedSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='PledgeInvolvedSum', column_type='decimal(16,0)', nullable=False, chn_name='股权质押涉及股数(股)') """股权质押涉及股数(股):""" FreezeInvolvedSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='FreezeInvolvedSum', column_type='decimal(16,0)', nullable=False, chn_name='股权冻结涉及股数(股)') """股权冻结涉及股数(股):""" PFStatement: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='PFStatement', column_type='varchar(200)', nullable=False, chn_name='股权质押冻结情况说明') """股权质押冻结情况说明:""" ConnectionRelation: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='ConnectionRelation', column_type='varchar(50)', nullable=False, chn_name='股东关联关系') """股东关联关系:""" ConnectionStatement: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='ConnectionStatement', column_type='varchar(2000)', nullable=False, chn_name='与其他股东关联关系说明') """与其他股东关联关系说明:""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" ActInConcertStatement: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='ActInConcertStatement', column_type='varchar(2000)', nullable=False, chn_name='与其他股东同属一致行动人说明') """与其他股东同属一致行动人说明:""" Notes: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='Notes', column_type='varchar(255)', nullable=False, chn_name='备注') """备注:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='InfoSource', column_type='varchar(50)', nullable=False, chn_name='信息来源') """信息来源:""" InfoTypeCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='InfoTypeCode', column_type='tinyint', nullable=True, chn_name='信息类别编码') """信息类别编码:信息类别编码(InfoTypeCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1025,得到信息类别编码的具体描述:1-前十大股东,2-前十流通股东,3-前十大股东与流通股东,4-十大有限售条件股东,10-有限售股份,11-有限售股东。""" SHNo: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHNo', column_type='int', nullable=True, chn_name='股东排名') """股东排名:股东排名(SHNo):当“信息类别代码(InfoTypeCode)”=1时,“股东排名(SHNo)”表示前十大股东排名;当“信息类别代码(InfoTypeCode)”=2时,“股东排名(SHNo)”表示前十大流通股东排名。""" SHSerial: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='SHSerial', column_type='int', nullable=True, chn_name='股东序号') """股东序号:""" GDID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='LC_MainSHListNew', column_name='GDID', column_type='int', nullable=False, chn_name='股东ID') """股东ID:股东ID(GDID):当股东属性(SHAttribute)=2时,与机构基本资料(LC_InstiArchive)中的企业编号(CompanyCode)关联;股东属性(SHAttribute)=3时,与理财产品主表(SF_PlanMain)或证券主表(SecuMain)中的内部编码(InnerCode)关联。"""
class HK_SecuNameChange(SQLTableEntity): name: str = 'HK_SecuNameChange' chn_name: str = '港股公司名称变动表' business_unique: str = 'InnerCode,EffectiveDate,EventType' refresh_freq: str = """日更新""" comment: str = """1.记录港股公司名称的变动历史记录数据,包括中文名称、中文名称缩写、英文名称、英文名称缩写等数据。 2.数据范围:1999年至今。 3.信息来源:港交所。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" AbbrBeforeChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='AbbrBeforeChange', column_type='varchar(100)', nullable=False, chn_name='变更前名称缩写') """变更前名称缩写:""" NameAfterChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='NameAfterChange', column_type='varchar(200)', nullable=False, chn_name='变更后名称') """变更后名称:""" AbbrAfterChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='AbbrAfterChange', column_type='varchar(100)', nullable=False, chn_name='变更后名称缩写') """变更后名称缩写:""" ExpiryDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='ExpiryDate', column_type='datetime', nullable=False, chn_name='失效日期') """失效日期:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='InnerCode', column_type='int', nullable=True, chn_name='证券内部编码') """证券内部编码:证券内部编码(InnerCode):与“港股证券主表(HK_SecuMain)”中的“证券内部编码(InnerCode)”关联,得到港股的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='InfoSource', column_type='int', nullable=False, chn_name='信息来源') """信息来源:信息来源(InfoSource)与(CT_SystemConst)表中的DM字段关联,令LB=1926,得到信息来源的具体描述:1-审计报告,2-第一季报,3-中期报告,4-第三季报,5-年度报告,6-第二季报,7-第四季报,8-第五季报,9-定期报告,10-申请版本,11-聆讯后资料集,12-招股章程,13-临时公告,14-审计报告(申报稿),15-公开转...""" SMAnnounceDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='SMAnnounceDate', column_type='datetime', nullable=False, chn_name='股东大会公告日期') """股东大会公告日期:""" EventType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='EventType', column_type='int', nullable=True, chn_name='事项类别') """事项类别:事项类别(EventType)与(CT_SystemConst)表中的DM字段关联,令LB=1345,得到事项类别的具体描述:1100-公司名称,1105-中文全称,1110-英文全称,1115-中文证券简称,1120-英文证券简称,1300-公司地址,1305-注册办事处,1310-总办事处及主要营业地点,1500-通讯资料,1505-电话,1510-传真...""" IfEffected: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='IfEffected', column_type='int', nullable=True, chn_name='是否有效') """是否有效:是否有效(IfEffected)与(CT_SystemConst)表中的DM字段关联,令LB=999 and DM in (1,2),得到是否有效的具体描述:1-是,2-否。""" EffectiveDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='EffectiveDate', column_type='datetime', nullable=True, chn_name='生效日期') """生效日期:""" NameBeforeChange: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='HK_SecuNameChange', column_name='NameBeforeChange', column_type='varchar(200)', nullable=False, chn_name='变更前名称') """变更前名称:"""
class QT_GoldTradeMarket(SQLTableEntity): name: str = 'QT_GoldTradeMarket' chn_name: str = '上海黄金交易所交易行情' business_unique: str = 'TradeDate,DateType,TradeVariety' refresh_freq: str = """日更新""" comment: str = """1.收录上海黄金交易所下黄金、白银、铂等金属标准化交易的每日盘后行情,包括开盘价、收盘价、最高价、最低价、成交量、成交额等信息 2.数据范围:2002年10月-至今 3.数据源:上海黄金交易所""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" LowPrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='LowPrice', column_type='decimal(18,4)', nullable=False, chn_name='最低价(元/克)') """最低价(元/克):""" Change: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='Change', column_type='decimal(18,4)', nullable=False, chn_name='涨跌(元/克)') """涨跌(元/克):""" ChangePCT: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='ChangePCT', column_type='decimal(18,4)', nullable=False, chn_name='涨跌幅') """涨跌幅:""" PriceWeighted: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='PriceWeighted', column_type='decimal(18,4)', nullable=False, chn_name='加权价(元/克)') """加权价(元/克):""" TurnVol: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='TurnVol', column_type='decimal(18,4)', nullable=False, chn_name='成交量(千克)') """成交量(千克):""" TurnValue: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='TurnValue', column_type='decimal(18,4)', nullable=False, chn_name='成交金额(元)') """成交金额(元):""" OpenInterest: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='OpenInterest', column_type='decimal(18,4)', nullable=False, chn_name='持仓量') """持仓量:""" SettlementVol: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='SettlementVol', column_type='decimal(18,4)', nullable=False, chn_name='交收量') """交收量:""" SettleDirection: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='SettleDirection', column_type='varchar(20)', nullable=False, chn_name='交收方向') """交收方向:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" TradeDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='TradeDate', column_type='datetime', nullable=False, chn_name='交易日期') """交易日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='InfoSource', column_type='varchar(100)', nullable=False, chn_name='信息来源') """信息来源:""" DateType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='DateType', column_type='int', nullable=True, chn_name='日期类别') """日期类别:日期类别(DateType)与(CT_SystemConst)表中的DM字段关联,令LB = 1083 AND DM IN (3),得到日期类别的具体描述:3-日。""" TradeVariety: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='TradeVariety', column_type='int', nullable=True, chn_name='交易品种') """交易品种:交易品种(TradeVariety)与(CT_SystemConst)表中的DM字段关联,令LB = 1135,得到交易品种的具体描述:1-Au50g,2-Au99.95,3-Au99.99,4-Au(T+5),5-Au(T+D),6-Pt99.95,7-Ag(T+D),8-Ag99.9,9-Ag50g,10-Au100g,11-Au(T+N1),12-Au...""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='InnerCode', column_type='int', nullable=False, chn_name='内码编码') """内码编码:内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到现货的交易代码、交易简称等。""" OpenPrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='OpenPrice', column_type='decimal(18,4)', nullable=False, chn_name='开盘价(元/克)') """开盘价(元/克):""" ClosePrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='ClosePrice', column_type='decimal(18,4)', nullable=False, chn_name='收盘价(元/克)') """收盘价(元/克):""" HighPrice: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='QT_GoldTradeMarket', column_name='HighPrice', column_type='decimal(18,4)', nullable=False, chn_name='最高价(元/克)') """最高价(元/克):"""
class LC_IndexComponent(SQLTableEntity): name: str = 'LC_IndexComponent' chn_name: str = '指数成份' business_unique: str = 'IndexInnerCode,SecuInnerCode,InDate' refresh_freq: str = """不定时更新""" comment: str = """1.收录了市场上主要指数的成份证券构成情况,包括成份证券的市场代码、入选日期、删除日期以及成份标志等信息。 2.该表仅收录主指数成份信息,不收录与主指数关系(Relationship)为“1-币种不同,2-分红规则不同,3-分红规则和币种都不同,4-税后分红”的衍生指数的信息。 3.历史数据:1990年12月至今 4.数据源:中证指数有限公司、上海证券交易所、深圳证券交易所、中央国债登记结算有限责任公司、申银万国研究所等""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" IndexInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='IndexInnerCode', column_type='int', nullable=True, chn_name='指数内部编码') """指数内部编码:指数内部编码(IndexInnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到指数的代码、简称等。""" SecuInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='SecuInnerCode', column_type='int', nullable=True, chn_name='证券内部编码') """证券内部编码:证券内部编码(SecuInnerCode):当SecuMarket=83、90或89时,与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联;当SecuMarket=72时,与“港股证券主表(HK_SecuMain)”中的“证券内部编码(InnerCode)”关联。""" SecuMarket: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='SecuMarket', column_type='int', nullable=False, chn_name='成份股市场代码') """成份股市场代码:成份股市场代码(SecuMarket)与(CT_SystemConst)表中的DM字段关联,令LB = 201,得到成份股市场代码的具体描述:10-上海期货交易所,11-上海国际能源交易中心,12-中国银行间外汇市场,13-大连商品交易所,14-上海黄金交易所,15-郑州商品交易所,49-澳大利亚证券交易所,50-新西兰证券交易所,51-中国金融期货交易所,...""" InDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='InDate', column_type='datetime', nullable=False, chn_name='入选日期') """入选日期:""" OutDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='OutDate', column_type='datetime', nullable=False, chn_name='剔除日期') """剔除日期:""" Flag: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='Flag', column_type='int', nullable=True, chn_name='成份标志') """成份标志:成份标志(Flag),该字段固定常量以下常量:1-是;0-否""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IndexComponent', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:"""
class LC_IncomeStatementPS(SQLTableEntity): name: str = 'LC_IncomeStatementPS' chn_name: str = '利润分配表附注' business_unique: str = 'CompanyCode,EndDate,ItemCategory,ItemName' refresh_freq: str = """季更新""" comment: str = """1.描述新会计准则下,上市公司利润分配表附注的明细情况。 2.对于公告原文披露的项目名称,收录在“科目名称(ItemName)”中;“科目代码(ItemCode)”则对披露的科目进行了归类,以便于横向比较。 3.数据范围:1997-12-31至今 4.信息来源:招股说明书、定报、审计报告等""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" ValueLastPeriod: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='ValueLastPeriod', column_type='decimal(19,4)', nullable=False, chn_name='上年同期金额(元)') """上年同期金额(元):""" ValueThisPeriod: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='ValueThisPeriod', column_type='decimal(19,4)', nullable=False, chn_name='本期金额(元)') """本期金额(元):""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='CompanyCode', column_type='int', nullable=True, chn_name='公司代码') """公司代码:公司代码(CompanyCode):与“证券主表(SecuMain)”中的“公司代码(CompanyCode)”关联,得到上市公司的交易代码、简称等。""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='EndDate', column_type='datetime', nullable=True, chn_name='截止日期') """截止日期:""" DateType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='DateType', column_type='int', nullable=False, chn_name='日期类型') """日期类型:日期类型(DateType)与(CT_SystemConst)表中的DM字段关联,令LB = 1074 AND DM = 3,得到日期类型的具体描述:3-期末累计。""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='InfoSource', column_type='varchar(50)', nullable=False, chn_name='信息来源') """信息来源:""" ItemCategory: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='ItemCategory', column_type='int', nullable=True, chn_name='科目类别') """科目类别:科目类别(ItemCategory)与(CT_SystemConst)表中的DM字段关联,令LB = 1041,得到科目类别的具体描述:10100-货币资金,10110-现金,10130-银行存款,10150-非银行存款,10190-其他货币资金,10200-短期投资,10210-短期股票投资,10211-上市股票投资,10213-非上市股票投资,10220...""" ItemCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='ItemCode', column_type='int', nullable=False, chn_name='科目代码') """科目代码:科目代码(ItemCode):与“系统常量表(CT_SystemConst)”中的“代码(DM)”关联,当ItemCategory=18400时,令“LB=1134”,当ItemCategory为其他值时,令“LB=1041”,得到附注所属科目类别下具体科目的分类描述。""" ItemName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='ItemName', column_type='varchar(100)', nullable=True, chn_name='科目名称') """科目名称:""" CurrencyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_IncomeStatementPS', column_name='CurrencyCode', column_type='int', nullable=False, chn_name='计价货币') """计价货币:计价货币(CurrencyCode)与(CT_SystemConst)表中的DM字段关联,令LB = 1068,得到计价货币的具体描述:1000-美元,1100-港元,1110-印度卢比,1120-印度尼西亚卢比,1130-伊朗里亚尔,1140-波兰兹罗提,1150-匈牙利福林,1160-日本元,1161-欧洲日元(离岸),1170-约旦第纳尔,1180-科..."""
class MF_KeyStockPortfolio(SQLTableEntity): name: str = 'MF_KeyStockPortfolio' chn_name: str = '公募基金重仓股票组合' business_unique: str = 'InnerCode,ReportDate,SerialNumber,InvestType' refresh_freq: str = """季更新""" comment: str = """1.本表记录基金季报公布重仓股票组合信息,主要包括前十大持有股票的股票代码、数量、市值、占净资产的比例等数据。 2.历史数据:1998年6月起-至今。 3.数据来源:基金公司披露的定期报告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" RatioInNV: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='RatioInNV', column_type='decimal(18,6)', nullable=False, chn_name='占资产净值比例') """占资产净值比例:""" InvestType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='InvestType', column_type='int', nullable=True, chn_name='投资类型') """投资类型:投资类型(InvestType)与(CT_SystemConst)表中的DM字段关联,令LB = 1090,得到投资类型的具体描述:1-综合投资,2-积极投资,3-指数投资,4-境内投资,5-沪港通投资。""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='InfoSource', column_type='varchar(100)', nullable=False, chn_name='信息来源') """信息来源:""" ReportDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='ReportDate', column_type='datetime', nullable=True, chn_name='报告期') """报告期:""" SerialNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='SerialNumber', column_type='int', nullable=False, chn_name='序号') """序号:""" StockInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='StockInnerCode', column_type='int', nullable=True, chn_name='股票内部代码') """股票内部代码:股票内部代码(StockInnerCode): 当StockInnerCode<1000000时,与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得股票的交易代码、简称等;当StockInnerCode在1000000与2000000之间时,与“港股证券主表(HK_SecuMain)”中的“证券内部编码(InnerCode)...""" SharesHolding: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='SharesHolding', column_type='decimal(18,4)', nullable=False, chn_name='持股数量(股)') """持股数量(股):""" MarketValue: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_KeyStockPortfolio', column_name='MarketValue', column_type='decimal(19,4)', nullable=False, chn_name='市值(元)') """市值(元):"""
class MF_GradedFund(SQLTableEntity): name: str = 'MF_GradedFund' chn_name: str = '公募基金_分级基金主表' business_unique: str = 'InnerCode,InfoSource,InfoPublDate' refresh_freq: str = """不定时更新""" comment: str = """1.本表记录分级基金的特有信息,包括A份额约定年基准收益表达式、定期/不定期份额折算说明等; 2.历史数据:2007年7月起-至今。 3.数据来源:基金产品招募说明书。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='InfoSource', column_type='varchar(100)', nullable=True, chn_name='信息来源') """信息来源:""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='InfoPublDate', column_type='datetime', nullable=True, chn_name='信息发布日期') """信息发布日期:""" OperCycle: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='OperCycle', column_type='int', nullable=False, chn_name='运作周期长度') """运作周期长度:运作周期长度(OperCycle)与(CT_SystemConst)表中的DM字段关联,令LB=1087,得到运作周期长度的具体描述:1-一个月,2-两个月,3-季度,6-半年,12-年度,24-两年,36-三年,60-五年,99-成立至今,990-期内,993-截止时点,995-周,996-日,999-期末。""" AnnualEarningExp: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='AnnualEarningExp', column_type='varchar(1000)', nullable=False, chn_name='A份额约定年基准收益表达式') """A份额约定年基准收益表达式:""" AnnualEarningRemark: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='AnnualEarningRemark', column_type='varchar(1000)', nullable=False, chn_name='A份额约定年基准收益表达式备注') """A份额约定年基准收益表达式备注:""" RegularShareCon: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='RegularShareCon', column_type='varchar(1000)', nullable=False, chn_name='定期份额折算说明') """定期份额折算说明:""" TrampShareCon: TableColumnDeclarationEntity = TableColumnDeclarationEntity(tbl_name='MF_GradedFund', column_name='TrampShareCon', column_type='varchar(1000)', nullable=False, chn_name='不定份额折算说明') """不定份额折算说明:"""
class MF_StockPortfolioChange(SQLTableEntity): name: str = 'MF_StockPortfolioChange' chn_name: str = '公募基金股票组合重大变动' business_unique: str = 'InnerCode,ReportDate,ChangeType,StockInnerCode' refresh_freq: str = """半年更新""" comment: str = """1.本表记录中报、年报中公布报告期内股票投资组合的重大变动,比如买入了哪些股票、市值有多少、占净资产的比例等。 2.历史数据:2004年6月起-至今。 3.数据来源:基金公司披露的定期报告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" ReportDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='ReportDate', column_type='datetime', nullable=True, chn_name='报告期') """报告期:""" ChangeType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='ChangeType', column_type='int', nullable=True, chn_name='变动类型') """变动类型:变动类型(ChangeType)与(CT_SystemConst)表中的DM字段关联,令LB = 1095,得到变动类型的具体描述:1-买入,2-卖出。""" SerialNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='SerialNumber', column_type='int', nullable=False, chn_name='序号') """序号:""" StockInnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='StockInnerCode', column_type='int', nullable=True, chn_name='股票内部代码') """股票内部代码:""" AccumulatedTradeSum: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='AccumulatedTradeSum', column_type='decimal(19,4)', nullable=False, chn_name='累计买入/卖出金额(元)') """累计买入/卖出金额(元):""" RatioInNVAtBegin: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='RatioInNVAtBegin', column_type='decimal(18,6)', nullable=False, chn_name='占期初基金净值比例') """占期初基金净值比例:""" RatioInNVAtEnd: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_StockPortfolioChange', column_name='RatioInNVAtEnd', column_type='decimal(18,6)', nullable=False, chn_name='占期末基金净值比例') """占期末基金净值比例:"""
class MF_HolderInfo(SQLTableEntity): name: str = 'MF_HolderInfo' chn_name: str = '公募基金持有人结构信息' business_unique: str = 'InnerCode,EndDate' refresh_freq: str = """不定时更新""" comment: str = """1.本表记录基金份额持有人户数、持有人结构,包括机构、个人持有份额的详细数据、占比等。前十大持有的持有份额合计、占比等数据。 2.历史数据:2004年6月起-至今。 3.数据来源:基金公司披露的临时报告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" IndividualHoldRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='IndividualHoldRatio', column_type='decimal(18,6)', nullable=False, chn_name='个人持有比例(%)') """个人持有比例(%):""" UndefinedHoldShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='UndefinedHoldShares', column_type='decimal(18,4)', nullable=False, chn_name='未明确投资者持有份额(份)') """未明确投资者持有份额(份):""" UndefinedHoldRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='UndefinedHoldRatio', column_type='decimal(18,6)', nullable=False, chn_name='未明确投资者持有比例(%)') """未明确投资者持有比例(%):""" Top10HolderAmount: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='Top10HolderAmount', column_type='decimal(18,4)', nullable=False, chn_name='前十大持有人持有份额合计(份)') """前十大持有人持有份额合计(份):""" Top10HoldersProportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='Top10HoldersProportion', column_type='decimal(18,4)', nullable=False, chn_name='前十大持有人持有比例合计(%)') """前十大持有人持有比例合计(%):前十大持有人持有比例合计(Top10HoldersProportion)=(前十大持有人持有份额合计/基金总份额)*100%""" ProfessionalHoldShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='ProfessionalHoldShares', column_type='decimal(18,4)', nullable=False, chn_name='基金从业人员持有份额(份)') """基金从业人员持有份额(份):""" ProfessionalHoldRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='ProfessionalHoldRatio', column_type='decimal(18,6)', nullable=False, chn_name='基金从业人员持有比例(%)') """基金从业人员持有比例(%):""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='InfoSource', column_type='varchar(100)', nullable=False, chn_name='信息来源') """信息来源:""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='EndDate', column_type='datetime', nullable=False, chn_name='截止日期') """截止日期:""" HolderAccountNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='HolderAccountNumber', column_type='int', nullable=False, chn_name='持有人户数') """持有人户数:""" AverageHoldShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='AverageHoldShares', column_type='decimal(18,4)', nullable=False, chn_name='户均持有份额(份)') """户均持有份额(份):""" InstitutionHoldShares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='InstitutionHoldShares', column_type='decimal(18,4)', nullable=False, chn_name='机构持有份额(份)') """机构持有份额(份):""" InstitutionHoldRatio: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='InstitutionHoldRatio', column_type='decimal(18,6)', nullable=False, chn_name='机构持有比例(%)') """机构持有比例(%):""" IndividualHoldshares: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_HolderInfo', column_name='IndividualHoldshares', column_type='decimal(18,4)', nullable=False, chn_name='个人持有份额(份)') """个人持有份额(份):"""
class LC_FSpecialIndicators(SQLTableEntity): name: str = 'LC_FSpecialIndicators' chn_name: str = '金融类特有指标(新)' business_unique: str = 'CompanyCode,EndDate,Mark,IndicatorCode' refresh_freq: str = """季更新""" comment: str = """1.反映银行、证券公司、保险公司等特有的指标数据,包括指标名称、金额、比率等内容。 2.数据范围:1998-12-31至今 3.信息来源:定期报告、跟踪评级报告等""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" Amount: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='Amount', column_type='decimal(19,4)', nullable=False, chn_name='金额(元)') """金额(元):""" RatioEOP: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='RatioEOP', column_type='decimal(18,9)', nullable=False, chn_name='比率-期末(%)') """比率-期末(%):""" RatioAVG: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='RatioAVG', column_type='decimal(18,9)', nullable=False, chn_name='比率-平均(%)') """比率-平均(%):""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='CompanyCode', column_type='int', nullable=True, chn_name='公司代码') """公司代码:公司代码(CompanyCode):与“证券主表(SecuMain)”中的“公司代码(CompanyCode)”关联,得到上市公司的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" InfoSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='InfoSource', column_type='varchar(50)', nullable=False, chn_name='信息来源') """信息来源:""" EndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='EndDate', column_type='datetime', nullable=True, chn_name='截止日期') """截止日期:""" Mark: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='Mark', column_type='int', nullable=True, chn_name='合并调整标志') """合并调整标志:合并调整标志(Mark),该字段固定以下常量:1-合并调整;2-合并未调整;3-母公司调整;4-母公司未调整""" IndicatorType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='IndicatorType', column_type='int', nullable=True, chn_name='指标类别') """指标类别:指标类别(IndicatorType):与“系统常量表(CT_SystemConst)”中的“代码(DM)”关联,令“LB=1467”,得到金融指标的具体类别。10-银行类专项指标,11-银行贷款五级分类,20-证券类专项指标,30-保险类专项指标""" IndicatorName: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='IndicatorName', column_type='varchar(200)', nullable=False, chn_name='指标名称') """指标名称:""" IndicatorCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_FSpecialIndicators', column_name='IndicatorCode', column_type='int', nullable=False, chn_name='指标代码') """指标代码:指标代码(IndicatorCode):与“系统常量表(CT_SystemConst)”中的“代码(DM)”关联,令“LB=1468”,得到具体的指标名称。当IndicatorCode=15000时,代表《商业银行资本充足率管理办法》下披露的资本净额;当 IndicatorCode=20000时,代表《商业银行资本充足率管理办法》下披露的资本充足率。"""
class LC_ESOPConduct(SQLTableEntity): name: str = 'LC_ESOPConduct' chn_name: str = '员工持股计划实施情况' business_unique: str = 'InnerCode,InitialImpleDay,ImplementDate' refresh_freq: str = """不定时更新""" comment: str = """1.主要记录员工持股计划当期实施情况:包括相关日期、实施股份、实施价格等指标。 2.数据范围:2014.6-至今 3.信息来源:上市公司公告""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" ImpleEndDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='ImpleEndDate', column_type='datetime', nullable=False, chn_name='实施截止日') """实施截止日:""" ShareSource: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='ShareSource', column_type='varchar(2000)', nullable=False, chn_name='本次实施股票来源') """本次实施股票来源:""" PriceCelling: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='PriceCelling', column_type='decimal(19,4)', nullable=False, chn_name='本次实施价格上限(元)') """本次实施价格上限(元):""" PriceFloor: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='PriceFloor', column_type='decimal(19,4)', nullable=False, chn_name='本次实施价格下限(元)') """本次实施价格下限(元):""" ShareCelling: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='ShareCelling', column_type='decimal(19,2)', nullable=False, chn_name='本次实施股份上限(万股)') """本次实施股份上限(万股):""" ShareFloor: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='ShareFloor', column_type='decimal(19,2)', nullable=False, chn_name='本次实施股份下限(万股)') """本次实施股份下限(万股):""" Proportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='Proportion', column_type='decimal(9,6)', nullable=False, chn_name='本次实施占总股本比例') """本次实施占总股本比例:""" LockDuration: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='LockDuration', column_type='decimal(19,2)', nullable=False, chn_name='锁定期(月)') """锁定期(月):""" Counterpart: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='Counterpart', column_type='varchar(2000)', nullable=False, chn_name='股票实施赠与方') """股票实施赠与方:""" AccumulateShare: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='AccumulateShare', column_type='decimal(19,2)', nullable=False, chn_name='累计实施股份(万股)') """累计实施股份(万股):""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='InnerCode', column_type='int', nullable=False, chn_name='内部编码') """内部编码:内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到股票的交易代码、简称等。""" AccuProportion: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='AccuProportion', column_type='decimal(9,6)', nullable=False, chn_name='累计占总股本比例') """累计占总股本比例:""" Statement: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='Statement', column_type='varchar(4000)', nullable=False, chn_name='实施情况说明') """实施情况说明:""" UpdateTime: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='UpdateTime', column_type='datetime', nullable=True, chn_name='更新时间') """更新时间:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" CompanyCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='CompanyCode', column_type='int', nullable=False, chn_name='公司代码') """公司代码:公司代码(CompanyCode):与“证券主表(SecuMain)”中的“公司代码(CompanyCode)”关联,得到上市公司的交易代码、简称等。""" IniInfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='IniInfoPublDate', column_type='datetime', nullable=False, chn_name='首次信息发布日期') """首次信息发布日期:""" SerialNumber: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='SerialNumber', column_type='int', nullable=False, chn_name='序号') """序号:""" IfPeriod: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='IfPeriod', column_type='int', nullable=False, chn_name='是否分期实施') """是否分期实施:是否分期实施(IfPeriod)与(CT_SystemConst)表中的DM字段关联,令LB = 999 AND DM IN (1,2),得到是否分期实施的具体描述:1-是,2-否。""" Period: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='Period', column_type='int', nullable=False, chn_name='分期实施期次') """分期实施期次:""" InitialImpleDay: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='InitialImpleDay', column_type='datetime', nullable=False, chn_name='首次实施公告日') """首次实施公告日:""" ImplementDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='LC_ESOPConduct', column_name='ImplementDate', column_type='datetime', nullable=False, chn_name='实施公告日') """实施公告日:"""
class MF_AssetAllocation(SQLTableEntity): name: str = 'MF_AssetAllocation' chn_name: str = '公募基金资产配置' business_unique: str = 'InnerCode,ReportDate,AssetTypeCode' refresh_freq: str = """季更新""" comment: str = """1.本表记录基金资产的大类配置情况,包括股票、债券、银行存款和清算备付金、其他资产、买入返售证券、卖出回购证券、国债及货币资金、可转换债券等。 2.历史数据:1998年6月起-至今。 3.数据来源:基金公司披露的定期报告。""" ID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='ID', column_type='bigint', nullable=True, chn_name='ID') """ID:""" XGRQ: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='XGRQ', column_type='datetime', nullable=True, chn_name='更新日期') """更新日期:""" JSID: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='JSID', column_type='bigint', nullable=True, chn_name='JSID') """JSID:""" InnerCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='InnerCode', column_type='int', nullable=True, chn_name='基金内部编码') """基金内部编码:基金内部编码(InnerCode):与“证券主表(SecuMain)”中的“证券内部编码(InnerCode)”关联,得到基金的交易代码、简称等。""" InfoPublDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='InfoPublDate', column_type='datetime', nullable=False, chn_name='信息发布日期') """信息发布日期:""" ReportDate: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='ReportDate', column_type='datetime', nullable=True, chn_name='报告期') """报告期:""" AssetTypeCode: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='AssetTypeCode', column_type='int', nullable=False, chn_name='资产种类代码') """资产种类代码:资产种类代码(AssetTypeCode)与(CT_SystemConst)表中的DM字段关联,令LB = 302,得到资产种类代码的具体描述:10-权益类投资,30-固定收益类投资,40-金融衍生品投资,50-买入返售金融资产,10001-行业投资合计,10002-国债及货币资金,10003-非国债债券,10004-指数投资,10005-积极投资,1000...""" AssetType: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='AssetType', column_type='varchar(50)', nullable=True, chn_name='资产种类') """资产种类:""" MarketValue: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='MarketValue', column_type='decimal(19,4)', nullable=False, chn_name='资产市值(元)') """资产市值(元):""" RatioInTotalAsset: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='RatioInTotalAsset', column_type='decimal(18,6)', nullable=False, chn_name='占资产总值比例') """占资产总值比例:""" RatioInNV: TableColumnDeclarationEntity = TableColumnDeclarationEntity( tbl_name='MF_AssetAllocation', column_name='RatioInNV', column_type='decimal(18,6)', nullable=False, chn_name='占资产净值比例') """占资产净值比例:"""