January 2009
Beginner to intermediate
641 pages
26h 48m
English
book
The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
by Paul Agnew, Len Silverston
Content preview from The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Silverston c06.tex V2 - 11/21/2008 3:09am Page 291
Table 6-8 (Continued)
STATUS TYPE STATUS STATUS TYPE STATUS STATUS TYPE STATUS TYPE STATUS TYPE
ASSOCIATION. FROM TYPE. NAME ASSOCIATION. TO TYPE. CATEGORY. ASSOCIATION ASSOCIATION
STATUS TYPE ID (FROM) STATUS TYPE ID NAME (TO) NAME RULE. NAME TYPE. NAME
30 Order
Confirmed
70 Order
Cancelled
Order
Fulfillment
Compatible Peer-to-Peer
Association
70 Order
Cancelled
102 Order Revenue
Recorded
Order
Fulfillment
Exclusion Peer-to-Peer
Association
70 Order
Cancelled
37 Order
Cancelled Due
to
Backordered
Inventory
Order
Fulfillment
Exclusion Aggregation
88 Open Order 10 Order Opened Order
Fulfillment
Obsolescent Peer-to-Peer
Association
77 Cancelled
Purchase
Order
70 Order
Cancelled
Order
Fulfillment
Implied Peer-to-Peer
Association
20 Order Entered 66 Order Inputted Order
Fulfillment
Substitution Peer-to-Peer
Association
Silverston c06.tex V2 - 11/21/2008 3:09am Page 292
292 Chapter 6 ■ Status: The States of Data
must precede the ‘‘Order Confirmed’’ status. The fourth row of this table shows
that ‘‘Order Entered’’ and ‘‘Order Confirmed’’ are also ‘‘Compatible’’ (along
with many other pairs of status types that are also compatible). This means that
the association between ‘‘Order Entered’’ and ‘‘Order Confirmed’’ status types
may exist within the ‘‘Order Fulfillment’’ set of statuses, and thus the