Using the Database Schemas

These documents describe the tables and fields that comprise the core database schema and the reporting schema.

Users who want to understand the P6 database schema and users who want to create reports should read these documents.

Download the Oracle SQL Developer Data Modeler Viewer to view these schemas.

What is the core database schema?

Here are zips of the the tables and fields that comprise the core database schema.

Database Schemas

Database schema tables 19.8

Database schema tables 19.7

Database schema tables 19.6

Database schema tables 19.5

Database schema tables 19.4

Database schema tables 19.3

Database schema tables 19.2

Database schema tables 19.1

What is the reporting schema?

Here is information on the reporting schema.

HTML | PDF



Legal Notices | Your Privacy Rights
Copyright © 1999, 2019, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, July 18, 2019