恒生核心表索引列表
序号表名索引列表
1TFUNDINFO(基金信息表)IDX_FUND_CODEPK_TFUNDINFO
2TASSET(资产单元基本信息表)PK_TASSET
3TCOMBI(投资组合表)IDX_COMBI_IDPK_TCOMBI
4TINSTRUCTION(指令表)PK_TINSTRUCTION
5TINSTRUCTIONSTOCK(指令证券表)IDX_TINSTRUCTIONSTOCKPK_TINSTRUCTIONSTOCK
6TINSTRUCTIONAPPROVE(指令审批表)PK_TINSTRUCTIONAPPROVEIDX_TINSTRUCTIONAPPROVEIDX_TINSTRAPPROVE_CREATEDATE
7TENTRUSTS(委托表)PK_TENTRUSTSIDX_TENTRUSTS_STATUSIDX_TENTRUSTS_CONFIRM_NOIDX_TENTRUSTS_INSTRUCTION_NOIDX_TENTRUSTS_BATCHSERIALNOIDX_TENTRUSTS_REPORTNOIDX_TENTRUSTS_INTER_CODEIDX_TENTRUSTS_REPORT_BRANCH
8TRISKCONTROL(风险控制表)PK_TRISKCONTROL
9TRISKDEFINE(风控类型定义表)PK_TRISKDEFINE
10TFUNDSTOCK(基金证券表)PK_TFUNDSTOCKIDX_TFUNDSTOCK_INTERCODE
11TASSETDAY(资产单元日信息表)IDX_TASSETDAY_FUNDIDPK_TASSETDAY
12TCURRENTS(证券资金流水表)PK_TCURRENTSIDX_TCURRENTS_BUSINNOIDX_TCURRENTS_EXTERNALNO
13TENTRUSTDIRECTION(委托方向表)PK_TENTRUSTDIRECTION
14TREALDEAL(实时成交流水表)PK_TREALDEALIDX_TREALDEAL_INSTRUCTION_NOIDX_TREALDEAL_DEALNO
15TASSETFCSET(资产单元分仓设置表)PK_TASSETFCSET
16TOPFUNDRIGHT(操作员基金权限表)PK_TOPFUNDRIGHT
17TSUBJECTDATA(系统科目数据)TSUBJECTDATA
18TFUNDASSET(基金资产信息表)PK_TFUNDASSET
19TBANKREALDEAL(银行间成交回报)IDX_TBANKREALDEAL_BUSINPK_TBANKREALDEALIDX_TBANKREALDEAL_SERIALNO
20TUNITSTOCK(投资单元证券表)PK_TUNITSTOCKIDX_TUNITSTOCK_COMBI_IDIDX_TUNITSTOCK_COMBI_STOCK
21TOPERATOR(操作员表)PK_TOPERATORIDX_TOPERATOR_OPERATORNO
22TROLE(角色表)PK_TROLE
23TOPROLERIGHTS(操作员角色关系表)PK_TOPROLERIGHTS
24THGREGISTER(在途回购表)PK_THGREGISTERIDX_HGREGISTER_CODE
25TSEAT(席位信息表)PK_TSEAT
26TSTOCKHOLDER(股东信息表)PK_TSTOCKHOLDER
27TSTOCKINFO(证券信息表)PK_TSTOCKINFOIDX_TSTOCKINFO_REPORTCODEIDX_TSTOCKINFO_PRICECODEIDX_TSTOCKINFO_COMPANYIDX_TSTOCKINFO_ASSIGNCODE
28TBONDPROPERTY(债券属性表)PK_TBONDPROPERTYIDX_TBONDPROPERTY_GUARANTOR
29TSTOCKTYPE(证券类别表)PK_TSTOCKTYPE
30TBUSINFLAG(业务类别表)PK_TBUSINFLAG
31TDICTIONARY(数据字典表)PK_TDICTIONARY
32TSETTLEUNITSTOCK(结算币种持仓表)PK_TSETTLEUNITSTOCKIDX_TSETTLEUNITSTOCK_STK
33TTRADETYPES(维度定义表)IDX_TTRADETYPES_TRADETYPEPK_TTRADETYPESIDX_TTRADETYPES_PARENTID
34TTRADESTOCK(维度证券表)PK_TTRADESTOCKIDX_TTRADESTOCK
感谢分享
页:
[1]