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 c09.tex V2 - 11/21/2008 3:16am Page 508
508 Chapter 9 ■ Using the Patterns
PARTY RELATIONSHIP TYPE
PARTY RELATIONSHIP TYPE ID ID (PK)
* NAME CHAR
PARTY RELATIONSHIP
PARTY RELATIONSHIP ID ID (PK)
* FROM PARTY ROLE ID ID (FK)(UID)
* TO PARTY ROLE ID ID (FK)(UID)
* PARTY RELATIONSHIP TYPE ID ID (FK)(UID)
* FROM DATE DATE (UID)
THRU DATE DATE
the classification for
classified by
CONTEXTUAL ROLE PATTERN
STATUS PATTERN
STATUS TYPE
STATUS TYPE ID ID (PK)
PARENT STATUS TYPE ID ID (FK)
* NAME CHAR
.....................................
PARTY ROLE STATUS
PARTY ROLE STATUS ID ID (PK)
* PARTY ROLE ID ID (FK)(UID)
* STATUS TYPE ID ID (FK)(UID)
STATUS DATETIME DATETIME
STATUS FROM DATE DATE
STATUS THRU DATE DATE
* FROM DATE DATE (UID)
THRU DATE DATE
PARTY ROLE
PARTY ROLE ID ID (PK)
* PARTY ID ID (FK)(UID)
* ROLE TYPE ID ID (FK)(UID)
* FROM DATE DATE (UID)
THRU DATE DATE
a classification
for
classified by
a status for
classified by
in the state of
further
classified by
within
RECURSIVE
PATTERN
to
associated from
associated to
from
RECURSIVE
PATTERN
within
classified
by
a classification
for
CUSTOMER
.............................
SALES PERSON
.............................
ORDER ID ID (PK)
GEOGRAPHIC BOUNDARY ID ID (FK)
* ORDER NUMBER CHAR
ORDER DATE DATE
ORDER DESCRIPTION DESC
ORDER ROLE
ORDER ROLE ID ID (PK)
* PARTY ID ID (FK)(UID)
* ORDER ID ID (FK)(UID)
* ROLE TYPE ID ID (FK)(UID)
* FROM ...