PROFILE_ORGANIZATION

1228 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_7R

The ID of the Profile associated

ORGANIZATION_OBJECT_ID VARCHAR2 30 null
ORGANIZATION.OBJECT_ID FK_ASS_8R

The ID of the Organization 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_ORGANIZATION_PK Primary key Asc OBJECT_ID
PRF_ORG_UNIQUE Must be unique Asc/Asc PROFILE_OBJECT_ID + ORGANIZATION_OBJECT_ID

Relationships