HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 31

DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers Appendix A LINEITEM Table Layout Column Name Datatype Requirements Comment L_ORDERKEY identifier Foreign key reference to O_ORDERKEY L_PARTKEY identifier Foreign key reference to PS_PARTKEY L_SUPPKEY identifier Foreign key reference to PS_SUPPKEY L_LINENUMBER decimal L_QUANTITY decimal L_EXTENDEDPRICE decimal L_DISCOUNT decimal L_TAX fixed text, size 1 L_RETURNFLAG fixed text, size 1 L_LINESTATUS fixed text, size 1 L_SHIPDATE date L_COMMITDATE date L_RECEIPTDATE date L_SHIPINSTRUCT fixed text, size 25 L_SHIPMODE fixed text, size 10 L_COMMENT variable text, size 44 Compound Primary Key: L_ORDERKEY, L_LINENUMBER NATION Table Layout Column Name Datatype Requirements Comment N_NATIONKEY identifier 25 nations are populated N_NAME fixed text, size 25 N_REGIONKEY identifier Foreign key reference to R_REGIONKEY N_COMMENT variable text, size 152 Compound Primary Key: L_ORDERKEY, L_LINENUMBER © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398