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 Descriptions

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.

Indexes

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

Sequences

This table uses no sequences.