《数据库模式.doc》由会员分享，可在线阅读，更多相关《数据库模式.doc（6页珍藏版）》请在三一文库上搜索。
1、TPCH数据库模式关系图TPCH数据库模式详细说明PART零件表字段名数据类型要求说明P_PARTKEYidentifier零件号P_NAMEvariable text, size 55零件名称PJdFGRfixed text, size 25制造商名称P.BRANDfixed text, size 10品牌P_TYPEvariable text, size 25类型P_SIZEinteger尺寸P CONTAINERfixed text, size 10包装P_RET?1LPRICEdecimal零售价格P.COMMENTvariable text, size 23 备注Primary Ke
2、y：P_PARTKEYSUPPLIER供应商表字段名数据类型要求说明S_SUPPKEYidentifier供应商号S_NAMEfixed text, size 25名称S_ADDRESSvariable text, size 40:S_NATIONKEYIdentifier国家代码S_PHONEfixed text, size 15S_ACCTBALdecimal账户余额S_COMMENTvariable text, size 101备注Primary Key： S.SLPPKEYPARTSUPP供应商-卑件表字段名数据类型要求说明PS.PARTKEYIdentifierForeign Key
3、to P_PARTKEYPS.SUPPKEYIdentifierForeign Keyto S.SUPPKEYPS_AV/1LQTYinteger可用数呈PS.SUPPLYCOSTDecimal供应价格PS.COMMENTvariable text, size 199备注Primary Key： PS_PARTKE PS_SUPPKEYCUSTOMER客户字段名数据类型要求说明C_CUSTKEYIdentifierSF*150.000 are populatedC_NAMEvariable text, size 25顾客C_ADDRESSvariable text, size 40地址C_NA
4、TIONKEYIdentifierForeign Key to N_NAT10NKEYC_PHONEfixed text, size 15C.ACCTIWLDecimal账户余额C_MKTSEGMEXTfixed text, size 10市场区块（如中国区、南美区、北美区等）C.COMMENTvariable text, size 117备注Primary Key： C.CUSTKEYORDERS订单表字段名数据类型要求说明O_ORDERKEYIdentifierO_CUSTKEYIdentifierForeign Key to C.CUSTKEYO_ORDERSTATUSfixed tex
5、t, size 1订单状态O.TOTALPRICEDecimal总金额O.ORDERDATEDate订单日期O_ORI)ERPRIOR1TYfixed text, size 15订单优先级O_CLERKfixed text, size 15记账员O_SH1PPR1ORITYInteger装运优先级O.COMMENTvariable text, size 79备注Primary Key： O_ORDERKEYLINEITEM字段名L_ORDERKEY订单明细 数据类型要求 identifier说明Foreign Key to O_ORDERKEYL_PARTKEYidentifierL_SUPP
6、KEYIdentifierL_LIXENLiMBERintegerL.QUANTITYdecimalL_EXTEXDEDPR1CEdecimalL_DISCOUXTdecimalL_T/XdecimalL RETURNFLAGfixed text, size 1L_LINESTATUSfixed text, size 1L.SHIPDATEdateL_COMM1TDATEdateL_RECE1PTDATEdateL.SHIPINSTRUCTfixed text, size 25L_SHIPMODEfixed text, size 10COMMENTvariable text size 44Pr
7、imary Key： L_ORDERKEY. L_LINENUMBERForeign key to P_PARTKEY, first part of the compound Foreign Key to (PS_PARTKEY, PS_SUPPKEY) with L_SUPPKEYForeign key to S_SUPPKEY. second part of the compound Foreign Key to (PS_PARTKEY. PS.SUPPKEY) with L-PARTKEY订单明细号数量金 额(L_EXTENDEDPRICE = QUANTITY 拿P.RETAILPRI
8、CE)折扣0. 000. 10.税率0. 00-0. 08退 货标志(1 f L_RECE I PTDATE <=CURRENTDATE then either WRW or *AW is selected at random else "Nw is selected) 明 细状态 CO* if L_SHIPDATE > CURRENTDATE 9F9 otherwise)装运日期委托日期签收日期装运说明(如deliver in person)装运方式(如空运，陆运，海运)NATION字段名N_NATIONKEYN_N/ME国家表数据类型要求identifierfixed text, size 25说明25 nations are populated备注REGION地区表字段名数据类型要求说明R REGIONKEYidentifier5 regions are populatedRENAMEfixed text, size 25ILCOMMENTvariable text, size 152Primary Key：R.REGIOXKEYN REGIONKEYidentifierForeign Key to R_REGIONKEYN COMMENTvariable text, size 152Primary Key：N_NAT1ONKEY