Clarity
Entity Relationship Diagrams (ERD)

ccppmop1593
An entity-relationship diagram (ERD) includes all relationships with only a few minor exceptions, such as not including simple lookups. Any incoming relationships from tables that are not primarily represented in a diagram are not shown. For example, if table A in the ABC diagram has a column that refers to table X in another diagram, table X is shown in the ABC diagram as an off-screen table. However, if table Y has a column that refers to table A, it is not shown. Instead, table A is shown as an off-screen table in the diagram for table Y.
For the following related content, see the
Classic PPM
Advanced Reporting and Database Schema Index
.
  • Database schema
  • Data warehouse schema
  • Data warehouse ERD
Legend
  • Table:
    A box with solid blue borders.
    This figure illustrates a table.
  • Off-screen Table:
    A box with dotted black borders.
    This figure illustrates an offscreen table.
  • View:
    A gray box with solid blue borders.
    This figure illustrates a view.
  • One to One Relationship:
    The indicator for a one-to-one relationship.
    This figure illustrates a one to one indicator.
  • Many to One Relationship:
    The indicator for a many-to-one relationship.
    This figure illustrates a many to one indicator.
  • Join:
    The join expression (column=column) is used to label the relationship. However, when the ID (or prID) column participates in the join, it is not listed. Many relationships indicate only one column name to describe a column=ID join.
(Principal_Type='User')
2
Action Items
This figure illustrates action items.
Applications
This figure illustrates applications.
Assets
This figure illustrates assets.
Audit Trail
This figure illustrates audit trail.
Capacity
This figure illustrates capacity.
Chargebacks
This figure illustrates chargebacks.
Content Packages
This figure illustrates content packages.
Content Add-ins
This figure illustrates content add-ins.
Datamart
This figure illustrates datamart.
Departments
This figure illustrates departments.
Discussions
This figure illustrates discussions.
Document Manager
This figure illustrates document manager.
Financial Administration
This figure illustrates financial administration.
Financial Configuration
This figure illustrates financial configuration.
Financial Planning
This figure illustrates financial planning.
General
This figure illustrates general.
Ideas
This figure illustrates ideas.
Investments
This figure illustrates investments.
ITIL
This figure illustrates ITIL.
Links and Notes
This figure illustrates links and notes.
Matrix Management
This figure illustrates matrix management.
Notifications
This figure illustrates notifications.
Organizational Breakdown Structure
This figure illustrates organizational breakdown structure.
Other Work
This figure illustrates other work.
Partitions
This figure illustrates partitions.
Portfolios
This figure illustrates portfolios.
Products
This figure illustrates products.
Projects
This figure illustrates projects.
Resources
This figure illustrates resources.
Security
This figure illustrates security.
Services
This figure illustrates services.
Studio
This figure illustrates studio.
Transactions
This figure illustrates transactions.