Share this page
RPT_PM_PROJECT_MANAGERS
RPT_PM_PROJECT_MANAGERS keeps information about manager(s) of a PPM projects.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
PROJECT_ID |
NOT NULL |
NUMBER |
ID of a PPM project and it is mapped to project_id column of PM_PROJECTS table |
|
MGR_USER_ID |
NULLABLE |
NUMBER |
User ID of a project manager of a PPM project and it is related to user_id of KNTA_USERS table |
|
ALL_PROJECT_MGR |
NULLABLE |
VARCHAR2(4000) |
It keeps all managers name of a PPM project. Names are separated by comma |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
RPT_PM_PROJ_MGRS_N1 |
NONUNIQUE |
1 |
PROJECT_ID |
|
RPT_PM_PROJ_MGRS_N2 |
NONUNIQUE |
1 |
MGR_USER_ID |
Sequences
This table uses no sequences.
