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 259
Level 2 Status Pattern, Current Status 259
Table 6-2 Example of Using the Level 2 Status Pattern, Current Status
ORDER. ORDER. ORDER. STATUS TYPE. STATUS
ORDER ORDER STATUS STATUS TYPE.
ID DESCRIPTION DATETIME TYPE ID NAME
12560 Deluxe Mobile
Phone
Feb. 2, 2010, 2 p.m. 10 Order Opened
12560 Deluxe Mobile
Phone
Feb. 2, 2010, 3 p.m. 55 Order Received
12560 Deluxe Mobile
Phone
Feb. 2, 2010, 4 p.m. 20 Order Entered
12560 Deluxe Mobile
Phone
Feb. 3, 2010, 9 a.m. 30 Order Confirmed
12560 Deluxe Mobile
Phone
Feb. 19, 2010, 6
p.m.
60 Order Closed
23000 Mobile Phone
Standard
Feb. 2, 2010, 2 p.m. 10 Order Opened
23000 Mobile Phone
Standard
Feb. 2, 2010, 2 p.m. 55 Order Received
23000 Mobile Phone
Standard
Feb. 2, 2010, 6 p.m. 20 Order Entered
23000 Mobile Phone
Standard
Feb. 3, 2010, 9 a.m. 30 Order Confirmed
23000 Mobile Phone
Standard
Feb. 4, 2010, 2 p.m. 70 Order Cancelled
23000 Mobile Phone
Standard
Feb. 14, 2010 60 Order Closed
32999 Mobile Phone
Accessories
Mar. 3, 2010, 3 p.m. 10 Order Opened
InthecaseoftheinstanceofORDERwithorder id of ‘‘23000’’ the order life
cycle encompasses six different states: ‘‘Order Opened,’’ ‘‘Order Received,’’
‘‘Order Entered,’’ ‘‘Order Confirmed,’’ ‘‘Order Cancelled,’’ and the final status
‘‘Order Closed.’’ This again complies with Figure 6-1. The last row in the
table shows an instance of ORDER with order id ‘‘32999’’ for ‘‘Mobile Phone
Accessories’’