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.