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 518
STATUS TYPE ID ID (PK)
* NAME CHAR
.................................
STATUS TYPE
STATUS PATTERN
ORDER
TIME
CUSTOMER STATUS
CLASSIFICATION PATTERN
RECURSIVE
PATTERN
RECURSIVE
PATTERN
CUSTOMER
DECLARATIVE ROLE
PATTERN
RECURSIVE
PATTERN
CUSTOMER CATEGORY CLASSIFICATION
CUSTOMER CATEGORY TYPE
CUSTOMER STATUS ID ID (PK)
* CUSTOMER 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
GEOGRAPHIC BOUNDARY TYPE
GEOGRAPHIC BOUNDARY TYPE ID ID (PK)
* NAME CHAR
GEOGRAPHIC BOUNDARY ID ID (PK)
* GEOGRAPHIC BOUNDARY TYPE ID ID (FK)
* NAME CHAR
GEOGRAPHIC BOUNDARY CODE CHAR
ABBREVIATION CHAR
GEOGRAPHIC INTERNET REGION CODE CHAR
COUNTRY
* COUNTRY TELEPHONE CODE CHAR
GEOGRAPHIC BOUNDARY ASSOCIATION ID ID (PK)
* FROM GEOGRAPHIC BOUNDARY ID ID (FK)(UID)
* TO GEOGRAPHIC BOUNDARY ID ID (FK)(UID)
GEOGRAPHIC BOUNDARY ASSOCIATION TYPE ID ID (FK)(UID)
* FROM DATE DATE (UID)
THRU DATE DATE
CUSTOMER CATEGORY CLASSIFICATION ID ID (PK)
* CUSTOMER ID ID (FK)(UID)
* CUSTOMER CATEGORY ID ID (FK)(UID)
* FROM DATE DATE (UID)
THRU DATE DATE
CUSTOMER CATEGORY
CUSTOMER CATEGORY ID ID (PK)
PARENT CUSTOMER CATEGORY ID ID (FK)
* CUSTOMER CATEGORY TYPE ID ID (FK)
* FROM DATE DATE
THRU DATE DATE
* NAME CHAR
PRODUCT
CONTACT MECHANISM
WITH GEOGRAPHIC
BOUNDARY PATTERN
GEOGRAPHIC BOUNDARY ...