《CAGS数据表分区设计.xls》由会员分享，可在线阅读，更多相关《CAGS数据表分区设计.xls（43页珍藏版）》请在三一文库上搜索。
1、分分区区编编号号分分区区内内容容对对应应代代码码数数据据量量 p_01江苏 000000000000101 p_02海南0000000000002532 p_03陕西0000000000003016 p_04福建0000000000001417 p_05云南0000000000002925 p_06湖北000000000000208 p_07重庆0000000000002624 p_08广东000000000000229 p_09黑龙0000000000000813 p_10江西0000000000001620 p_11甘肃0000000000003129 p_12河南000000000000
2、194 p_13广西0000000000002412 p_14安徽0000000000001321 p_15宁波0000000000001228 p_16浙江000000000000115 p_17吉林0000000000000715 p_18辽宁0000000000000518 p_19山东000000000000172 p_20厦门0000000000001531 p_21山西0000000000000410 p_22青岛0000000000001823 p_23天津0000000000000226 p_24北京000000000000017 p_25新疆0000000000003214
3、p_26湖南0000000000002119 p_27上海000000000000093 p_28大连0000000000000630 p_29四川0000000000002711 p_30贵州0000000000002822 p_31深圳0000000000002327 p_32河北000000000000036 p_33宁夏分公司(筹)12045192433901 p_34内蒙古分公司(筹)12045138254372 p_35常州分公司00000000002324 p_36苏州分公司00000000002325 p_37无锡分公司00000000002326 p_38Default 编编
4、号号表表名名记记录录数数一一年年后后表表含含义义分分区区数数 1 ACCTLIST 保单帐户信息(非银行账户,主要用 于万能等险种的记账明细)，能实 施历史数据归档(日期) 38 分区索引38 2 ALLRISKSPEC 保单特约约定(保单约定的文字描 述), 单个分区的最大数据量，能 实施历史数据归档(日期) 38 分区索引38 3 APP_CARD 定额保单信息表(DOCNO: 单证号) ，能实施历史数据归档(保单状态) 38 分区索引38 4 APP_RISK 投保单信息表，能实施失效数据 归档 38 分区索引38 5 APPNEXT保单主附险关系表38 分区索引38 6 CDELREC
5、保单应付表38 分区索引38 7 CHAGAPP 保单变更申请表，能实施历史数 据归档(日期) 38 分区索引38 8 CHGCON保单变更内容表38 分区索引38 9至至20 CHKPREACCT1999 CHKPREACCT2000 CHKPREACCT2001 CHKPREACCT2002 CHKPREACCT2003 CHKPREACCT2004 CHKPREACCT2005 CHKPREACCT2006 CHKPREACCT2007 CHKPREACCT2008 CHKPREACCT2009 CHKPREACCT2010 保单核保保额流水表38 分区索引38 21 CN_WATER
6、保单财务交易流水表，能实施历 史数据归档(交易日期) 38 分区索引38 22 CUSTSUP投保单客户补充信息表38 分区索引38 23 EFFECTIVE 保单生效记录表，能实施历史数 据归档(OPDATE) 38 分区索引38 24 GRPLIST团单清单明细表38 分区索引38 25 NEWPTC 转核原因(只insert)，能实施历史 数据归档(按日期) 38 分区索引38 26 P9550095500初始密码表38 分区索引38 27 PREPAY预缴保费表38 分区索引38 28 PREREC 保单缴费信息表，能实施失效数 据归档(按保单) 38 分区索引38 29 PRESEL
7、ECT团单可选责任表38 分区索引38 30 RELPAYRC保单实付表38 分区索引38 31 RISKCON 保单信息表，能实施失效数据归 档(按POLICYNO) 38 分区索引38 32 SPREREC 保单应缴信息表，能实施历史数 据归档(按保单) 38 分区索引38 33 TMPREC保单暂收费信息表38 分区索引38 34 WFWATER 保额流水中间表(只insert)，能实 施历史数据归档(按日期) 38 分区索引38 35 CONAGREE续保申请表 36 CLMPREACCT1999 CLMPREACCT2000 CLMPREACCT2001 CLMPREACCT2002
8、 CLMPREACCT2003 CLMPREACCT2004 CLMPREACCT2005 CLMPREACCT2006 CLMPREACCT2007 CLMPREACCT2008 CLMPREACCT2009 CLMPREACCT2010 保单理赔责任保额流水表38 37 PTCAMT核保结果金额表38 38 RISKSPEC个险保单特别约定表 39 GRPSHARE团单销售渠道表 40 CUSTMATL客户信息表 41 DISTRICT_BDH保单区域编码表 42 GRPCON团体保单信息表 43 CHANGEINTERFACE保单变更失效记录表 44 APPITEM投保单可约定项目表 4
9、5 PAY_ATTRIBUTE保单客户缴费方式 46 CN_BALANCE客户余额记录表 47 GAPP_CARD团体卡单记录表 48 DZ_INVOICE与单证系统接口的发票信息表 49 DZ_POLICYNO 与单证系统接口的发票信息关联 的保单信息表 50 GPOLI_LIST团体不记名定额保单信息 51 PRINT_RECORD集中出单打印记录表 52 EFFECTIVE_NO生效序号 53 INVESTWAY投资资金分配临时表 54 CHECK_EFFECTIVE保单有效性检查清单表 55 GDUMMY团单虚拟被保人 56 BANKHISTORY划帐历史表 57 CHEKOPIN 核
10、保信息/审核记录 58 EMPSUM业务员暂收汇总表 59 APPNOSTATUS投保单状态表 60 DZ_CARD* 卡单单证表 61 GCHKPREACCT 团单承保保额流水帐 62 CONENSDEAL 续保处理表 分分区区类类型型 分分区区字字段段分分区区调调整整分分区区记记录录数数现现有有数数据据量量P1_01 ListBRANCHID Footdate+BranchidD I ListBRANCHID D I Range, Hash BRANCHID,DOCNO 整理空间 索引 BRANCHID+APPNO Range, Hash BRANCHID BRANCHID，APPNOD
11、I ListBRANCHID D I ListBRANCHID D I Range, Hash BRANCHID,POLICYNO 整理空间 Range, Hash BRANCHID,POLICYNO 整理空间 Range, ListBRANCHID ENDDATE + BRANCHIDD I Range, ListBRANCHID DODATE + BRANCHIDD I Range, Hash BRANCHID,APPNO RANGE,ListOPDATE,BRANCHID ListBRANCHID D I Range, Hash BRANCHID,APPNO 整理空间 ListBRANC
12、HID D I ListBRANCHID D I ListBRANCHID 整理空间D I ListBRANCHID D I ListBRANCHID D I Range, Hash BRANCHID BRANCHID + POLICYNOD I ListBRANCHID 整理空间D I Range, Hash BRANCHID,APPNO RANGE,ListBRANCHID begdatebranchidD I List BRANCHID Range, Hash BRANCHID + PolicynoD List BRANCHID List BRANCHID List BRANCHID H
13、ashID List BRANCHID List BRANCHID List BRANCHID List BRANCHID List BRANCHID HashID List BRANCHID RangeUPDATE_TIMEsubstr(updatetime,1,8) RangeRECDATE Range, Hash OPERDATE + GAPPNO RangePRNDATE Range, List OPDATE+BRANCHID ListBRANCHID整理空间 ListBRANCHID 整理空间，加索引（BRANCHID Policyno，BRANCHID。） ListBRANCHID
14、整理空间 Range, List APPLDATE+BRANCHID ListBRANCHID RangeRDATE RangeUTIMEsubstr(utime,1,8) RangeUPDATE_TIMEsubstr(update_time,1,8) Range, List ENDDATE+BRANCHID ListBRANCHID整理空间 P1_02P1_03P1_04P1_05P1_06P1_07P1_08P1_09P1_10P1_11P1_12P1_13P1_14 DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDD
15、DDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIII
16、II DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD P1_15P1_16P1_17P1_18P1_19P1_20P1_21P1_22P1_23P1_24P1_25P1_26P1_27 DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIII
17、IIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD
18、 IIIIIIIIIIIII DDDDDDDDDDDDD P1_28P1_29P1_30P1_31P1_32P1_33P1_34P1_35P1_36P1_37P1_38P2_01P2_02 DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DD II DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DD II DD II DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DD II DD II DDDDDDD
19、DDDD IIIIIIIIIII DD II DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD IIIIIIIIIII DD II DDDDDDDDDDD IIIIIIIIIII DDDDDDDDDDD P2_03P2_04P2_05P2_06P2_07P2_08P2_09P2_10P2_11P2_12P2_13P2_14P2_15 D
20、DDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII DDDDDDDDDDDDD IIIIIIIIIIIII P2_16P2_17P2_18P2_19P2_20P2_21P2_22P2_23P2_24P2_25P2_26P2_27 DDDDDDDDDDDD IIIIIIIIIIII DDDDDDDDDDDD IIIII
21、IIIIIII DDDDDDDDDDDD IIIIIIIIIIII DDDDDDDDDDDD IIIIIIIIIIII DDDDDDDDDDDD IIIIIIIIIIII DDDDDDDDDDDD IIIIIIIIIIII DDDDDDDDDDDD IIIIIIIIIIII P2_28P2_29P2_30P2_31P2_32P2_33P2_34P2_35P2_36 DDDDDDDDD IIIIIIIII DDDDDDDDD IIIIIIIII DDDDDDDDD IIIIIIIII DDDDDDDDD IIIIIIIII DDDDDDDDD IIIIIIIII DDDDDDDDD IIIIIIIII DDDDDDDDD IIIIIIIII P2_37P2_38 DD II DD II DD II DD II DD II DD II DD II