RSC_RESOURCE_POOL_MANAGERS
This is the association table between the KNTA_USERS and RSC_RESOURCE_POOLS tables to support the many to many relation ship between them. This table stores the unique combination of the USER_ID and RESOURCE_POOL_ID.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
MANAGER_USER_ID |
RSC_RESOURCE_POOLS |
RESOURCE_POOL_ID |
RESOURCE_POOL_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
RESOURCE_POOL_ID |
NOT NULL |
NUMBER |
This is the foreign key to RSC_RESOURCE_POOLS table. |
MANAGER_USER_ID |
NOT NULL |
NUMBER |
This is the foreign key to KNTA_USERS table. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
FKE8CAFF55DF6D5068_I |
NONUNIQUE |
1 |
MANAGER_USER_ID |
SYS_C005201580 |
UNIQUE |
1 |
RESOURCE_POOL_ID |
SYS_C005201580 |
UNIQUE |
2 |
MANAGER_USER_ID |
Sequences
This table uses no sequences.