TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

90 Chapter3
Defining a Database
Schema Processor Output
NAME: CUSTOMER,MANUAL /INDEXED (14/11,18),DISC1; <<CUSTOMER MASTER>>
ENTRY: ACCOUNT(1),
LAST-NAME,
FIRST-NAME,
INITIAL,
STREET-ADDRESS,
CITY,
STATE,
ZIP,
CREDIT-RATING;
CAPACITY: 201;
PAGE 2 SCHEMA FOR DATABASE ORDERS
NAME: PRODUCT,MANUAL(13,14/12,18),DISC1;<<PRODUCT MASTER>>
ENTRY: STOCK#(2),
DESCRIPTION;
CAPACITY: 300;
NAME: SUP-MASTER,MANUAL(13/12,18),DISC1; <<SUPPLIER MASTER>>
ENTRY: SUPPLIER(1),
STREET-ADDRESS,
CITY,
STATE,
ZIP;
CAPACITY: 201;
NAME: INVENTORY,DETAIL(12,14/13,18),DISC2; <<INVENTORY DETAIL>>
ENTRY: STOCK#(PRODUCT),
ONHANDQTY,
SUPPLIER(!SUP-MASTER), <<PRIMARY PATH>>
UNIT-COST,
LASTSHIPDATE(DATE-MASTER),
BINNUM;
CAPACITY: 1800,450,10%;
NAME: SALES,DETAIL(11/14,18),DISC2; <<SALES DETAIL>>
ENTRY: ACCOUNT(CUSTOMER(PURCH-DATE)),
STOCK#(PRODUCT),
QUANTITY,
PRICE,
TAX,
TOTAL,
PURCH-DATE(DATE-MASTER),
DELIV-DATE(DATE-MASTER);
CAPACITY: 1008,504,112;
END.