RSC_RESOURCE_ROLES

This is the association table between the RSC_RESOURCES and RSC_ROLES tables.

Since the application is not supporting multiple roles per user currently, a resource has only one record in this table.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
RSC_RESOURCES	RESOURCE_ID	RESOURCE_ID
RSC_ROLES_NLS	ROLE_ID	ROLE_ID

Column Name	Null?	Data Type	Description
RESOURCE_ID	NOT NULL	NUMBER	This is the foreign key to RSC_RESOURCES table.
ROLE_ID	NOT NULL	NUMBER	This is the foreign key to RSC_ROLES table.
RESOURCE_ROLE_SEQ	NOT NULL	NUMBER	This column value is currently 0 as there is only one role for a resource in the system. If the system supports multiple roles per resource in the future, this seq will be used to order the roles as they are created.

Column Name

Null?

Data Type

Description

RESOURCE_ID

NOT NULL

NUMBER

This is the foreign key to RSC_RESOURCES table.

ROLE_ID

NOT NULL

NUMBER

This is the foreign key to RSC_ROLES table.

RESOURCE_ROLE_SEQ

NOT NULL

NUMBER

This column value is currently 0 as there is only one role for a resource in the system.

If the system supports multiple roles per resource in the future, this seq will be used to order the roles as they are created.

Index Name	Index Type	Sequence	Column Name
FK6B119AE926AE1775_I	NONUNIQUE	1	ROLE_ID
SYS_C005201581	UNIQUE	1	RESOURCE_ID
SYS_C005201581	UNIQUE	2	RESOURCE_ROLE_SEQ

This table uses no sequences.