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.