RSC_STAFF_PROF_MANAGERS

This is a many to many association table between the RSC_STAFFING_PROFILES and KNTA_USERS tables. These are the managers for staffing profiles.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

RSC_STAFFING_PROFILES

STAFFING_PROFILE_ID

STAFFING_PROFILE_ID

KNTA_USERS

USER_ID

MANAGER_USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

STAFFING_PROFILE_ID

NOT NULL

NUMBER

Foreign key to RSC_STAFFING_PROFILE table.

MANAGER_USER_ID

NOT NULL

NUMBER

Foreign key to KNTA_USERS table.

Indexes

Index Name

Index Type

Sequence

Column Name

FK88D1C7F0DF6D5068_I

NONUNIQUE

1

MANAGER_USER_ID

SYS_C005201592

UNIQUE

1

STAFFING_PROFILE_ID

SYS_C005201592

UNIQUE

2

MANAGER_USER_ID

Sequences

This table uses no sequences.