PFM_PORTFOLIO_MANAGERS

The table stores the relationships between the portfolios and their managers.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

PFM_PORTFOLIOS

PORTFOLIO_ID

PORTFOLIO_ID

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PORTFOLIO_ID

NOT NULL

NUMBER

ID of the portfolio

USER_ID

NOT NULL

NUMBER

ID of the user who is the manager of the portfolio.

Indexes

Index Name

Index Type

Sequence

Column Name

PFM_PORTFOLIO_MANAGERS_PK

UNIQUE

1

PORTFOLIO_ID

PFM_PORTFOLIO_MANAGERS_PK

UNIQUE

2

USER_ID

Sequences

This table uses no sequences.