HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 30
O_orderkey
![]() |
View all HP ProLiant 3000 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 30 highlights
Appendix A DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers CUSTOMER Table Layout Column Name C_CUSTKEY C_NAME C_ADDRESS C_NATIONKEY Datatype Requirements identifier variable text, size 25 variable text, size 40 identifier C_PHONE fixed text, size 15 C_ACCTBAL decimal C_MKTSEGMENT fixed text, size 10 C_COMMENT variable text, size 117 Primary Key: C_CUSTKEY ORDER Table Layout Column Name O_ORDERKEY Datatype Requirements identifier O_CUSTKEY identifier O_ORDERSTATUS fixed text, size 1 O_TOTALPRICE decimal O_ORDERDATE date O_ORDERPRIORITY fixed text, size 15 O_CLERK fixed text, size 15 O_SHIPPRIORITY integer O_COMMENT variable text, size 79 Primary Key: O_ORDERKEY Comment SF*150,000 are populated Foreign key reference to N_NATIONKEY Comment SF*1,500,000 are sparsely populated Foreign key reference to C_CUSTKEY © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398
![](/manual_guide/products/hewlettpackard-proliant-3000-dss-sizing-tuning-oracle8-windows-nt-compaq-servers-5d905ed/30.png)