PGM_PROGRAM_CONTENT

This table stores many-to-many relationships, connecting the
PGM_PROGRAMS table (programs) with the
PFM_LIFECYCLE_PARENT_ENTITY table (content).

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

PFM_LIFECYCLE_PARENT_ENTITY

LIFECYCLE_ID

CONTENT_ID

PGM_PROGRAMS

PROGRAM_ID

PROGRAM_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PROGRAM_ID

NOT NULL

NUMBER

ID of the program entity

CONTENT_ID

NOT NULL

NUMBER

ID of the content representing a proposal, project or asset

Indexes

Index Name

Index Type

Sequence

Column Name

PGM_PROGRAM_CONTENT_IDX1

NONUNIQUE

1

CONTENT_ID

SYS_C005201554

UNIQUE

1

PROGRAM_ID

SYS_C005201554

UNIQUE

2

CONTENT_ID

Sequences

This table uses no sequences.