PROFILE_ROLE

1647 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_ID VARCHAR2 30 null

The unique ID for the relation.

PROFILE_OBJECT_ID VARCHAR2 30 null
PROFILE.OBJECT_ID FK_ASS_13R

The ID of the Profile associated

ROLE_OBJECT_ID VARCHAR2 30 null
ROLE.OBJECT_ID FK_ASS_14R

The ID of the Role associated

ACTIVE CHAR 1 null

Indicates if this Relationship is active or deleted

LAST_CHANGED TIMESTAMP(6) 11,6 null

The date and time of the last change of the record.

Indexes

Constraint Name Type Sort Column(s)
PROFILE_ROLE_PK Primary key Asc OBJECT_ID
PRF_ROL_UNIQUE Must be unique Asc/Asc PROFILE_OBJECT_ID + ROLE_OBJECT_ID

Relationships