HP 3000 Manuals HP 3000 Manuals
Appendix B SALES Database Schema
The SALES database is used in the examples throughout this guide. The
schema for this database is shown below:
_____________________________________________
| |
| BEGIN DATA BASE SALES ; |
| PASSWORDS: |
| 11 CREDIT ; |
| 12 BUYER ; |
| 13 dockhand; |
| 14 CLERK ; |
| 18 manager ; |
| |
| ITEMS: |
| CITY , X12(12,13,14/11);|
| CREDIT-RATING , R2(/14); |
| CUSTOMER# , J2; |
| DATE , X6; |
| DELIVERED-DATE , X6(/14); |
| FIRST-NAME , X10(14/11); |
| INITIAL , U2(14/11); |
| LAST-NAME , X16(14/11); |
| LAST-SHIP-DATE , X6(12/); |
| LOCATION-BIN , Z2(/13); |
| ON-HAND-QTY , J2(14/12); |
| OTHER-VENDORS , 3X16; |
| PART-INFO , X60; |
| PRICE , J2(14/); |
| PRODUCT# , U8; |
| PRODUCT-DESCRIPT , X20; |
| PURCHASED-DATE , X6(11/14); |
| QUANTITY , I1(/14); |
| STATE , X2(12,13,14/11); |
| STREET , X26(12,13,14/11);|
| TAX , J2(14/); |
| TOTAL , J2(11,14/); |
| UNIT-COST , P8(/12); |
| VENDOR , X16(12,13/); |
| ZIP , X6(12,13,14/11); |
| |
_____________________________________________
_________________________________________________________________________
| |
| SETS: |
| |
| NAME: DATE-MASTER ,A; |
| ENTRY: DATE (3) ;|
| CAPACITY: 365(19); |
| |
| |
| NAME: CUSTOMER ,M(14/11,18); |
| ENTRY: CUSTOMER# (1) ,|
| LAST-NAME ,|
| FIRST-NAME ,|
| INITIAL ,|
| STREET ,|
| CITY ,|
| STATE ,|
| ZIP ,|
| CREDIT-RATING ;|
| CAPACITY: 201(7); |
| |
| |
| NAME: PRODUCT ,M(13,14/12,18); |
| ENTRY: PRODUCT# (2) ,|
| PRODUCT-DESCRIPT ;|
| CAPACITY: 300(16); |
| |
| |
| NAME: VENDOR ,M(13/12,18); |
| ENTRY: VENDOR (1) ,|
| STREET ,|
| CITY ,|
| STATE ,|
| ZIP ;|
| CAPACITY: 201(12); |
| |
| |
| NAME: INVENTORY ,D(12,14/13,18); |
| ENTRY: PRODUCT# ( PRODUCT ),|
| ON-HAND-QTY ,|
| VENDOR (!VENDOR ),|
| OTHER-VENDORS ,|
| UNIT-COST ,|
| LAST-SHIP-DATE ( DATE-MASTER ),|
| LOCATION-BIN ,|
| PART-INFO ;|
| CAPACITY: 452(4); |
| |
_________________________________________________________________________
_________________________________________________________________________
| |
| NAME: SALES ,D(11/14,18); |
| ENTRY: CUSTOMER# ( CUSTOMER (PURCHASED-DATE )),|
| PRODUCT# (!PRODUCT ),|
| QUANTITY ,|
| PRICE ,|
| TAX ,|
| TOTAL ,|
| PURCHASED-DATE ( DATE-MASTER ),|
| DELIVERED-DATE ( DATE-MASTER );|
| CAPACITY: 504(14); |
| |
| END. |
| |
_________________________________________________________________________