The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling

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 ...