Using the 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 20.1

Database schema tables 20.2

Database schema tables 20.3

Database schema tables 20.4

Database schema tables 20.6

Database schema tables 20.7

Database schema tables 20.8

Database schema tables 20.9

Database schema tables 20.10

Database schema tables 20.11

Database schema tables 20.12

What is the reporting schema?

Here is information on the reporting schema.

HTML | PDF

Where can I download the reporting schema?

Here is the zip of the tables and fields that comprise the reporting schema.

P6 Extended Schema tables



Legal Notices | Your Privacy Rights
Copyright © 1999, 2022

Last Published Wednesday, December 14, 2022