
Silverston c09.tex V2 - 11/21/2008 3:16am Page 477
ORDER
ORDER ID ID (PK)
* BILL TO CUSTOMER ID ID (FK)
* SHIP TO CUSTOMER ID ID (FK)
END USER CUSTOMER ID ID (FK)
* ORDER NUMBER CHAR
ORDER DATE DATE
ORDER DESCRIPTION DESC
...........................................
PARENT COMPANY
PARENT COMPANY ID ID (PK)
* PARENT COMPANY NAME CHAR
STATUS TYPE ID ID (FK)
STATUS DATETIME DATETIME
* CUSTOMER SIZE ID ID (FK)
BILL TO SUITE-APARTMENT CHAR
BILL TO POST OFFICE BOX CHAR
* BILL TO STREET ADDRESS PART CHAR
BILL TO ADDRESS PART CHAR
* BILL TO CITY CHAR
BILL TO STATE–REGION CHAR
* BILL TO COUNTRY CHAR
* BILL TO POSTAL CODE CHAR
* WORK COUNTRY TELEPHONE CODE CHAR
* WORK AREA CODE CHAR
* WORK TELEPHONE NUMBER CHAR
* WORK EMAIL ADDRESS CHAR
CONTEXTUAL
ROLE PATTERN
billed
to
billed
to
the payee for
the payee
for
XOR
the
parent
of
shipped to
the receiver
for
ordered for
use by
RECURSIVE
PATTERN
(A SIMPLE
HIERARCHY)
DECLARATIVE ROLE PATTERN
CLASSIFICATION PATTERN
CONTACT MECHANISM PATTERN
CONTACT MECHANISMS PATTERN
STATUS PATTERN
STATUS PATTERN
in the state of
a status for
DECLARATIVE ROLE PATTERN
STATUS PATTERN
classified by
a classification
for
the
child
of
a status for
in the state of
classified by
classified by
classified
by
a classification
for
a
classification
for
a
classification
for
a classification
for
classified
by
STATUS TYPE
PARENT COMPANY ...