Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Schema DDL DDL example
U929-J-Z125-9-76 113
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k04
Figure 26: Schema of a mail order business
CUST-
ORDER-ITEM
SUBSET
Realms:
PURCH-ORD-
ITEM
COLORS MATERIALS
Realm: ARTICLE-RLM
Realm: CUSTOMER-ORDER-RLM
PURCHASE-
ORDER-RLM
Realm:
CLOTHING, HOUSEHOLD-GOODS,
SPORTS-ARTICLES, FOOD,
LEISURE, STATIONERY
CUSTOMER
INSTALLMENT
CUSTOMER-
ORDER
ARTICLE-
DESCR
ARTICLE-
SELECTION
SYSTEM
ARTICLE
ARTICLE-TYPE
SYSTEM
SUPPLIER
PURCHASE-
ORDER
CALC
CALC
CALC
SUPPLIERS
PURCH-
ORD-
RECEIVED
PURCH-ORD-
PLACED
SHORT-LIST
OFFER
PURCH-ORD-
SPECS
MIN-STOCK-
LEVEL
CONTAINS
CONTAINED-IN
REORDERED-
ARTICLES
HIRE-PURCHASE
CUSTOMER-
ORDERS-
PLACED
CUSTOMER-
ORDER-
CONTENTS
ORDERED-
ARTICELS
PURCH-ORD-
CONTENTS
ARTICLES-
AVAILABLE
OUTSTANDING
DIRECT-
LONG