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 printed 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. | | | _________________________________________________________________________