Tables in the Applications Module

This chapter describes the tables that make up the Oracle Identity Analytics Applications module.

APPLICATIONS Table

Structure

APPLICATIONS PK ID APPLICATION_NAME APPLICATION_VERSION VENDOR ENVIRONMENT COMMENTS STATUS_ID DESCRIPTION UPDATE_DATE CREATE_DATE

Index

Index PK Unique Keys PK_APPLICATIONS      ✓ Yes ID

Description

The APPLICATIONS table contains general information about the applications in Oracle Identity Analytics.

Primary Keys

PK_APPLICATIONS - primary key on column ID

Foreign Keys

None

Indexes

None

APPLICATION_ATTRIBUTES Table

Structure

APPLICATION_ATTRIBUTES PK PK PK APPLICATION_ID ENDPOINT_ID ATTRIBUTE_VALUE_ID

Index

Index PK Unique Keys PK_APP_ATTRIBUTES      ✓ Yes APPLICATION_ID, ENDPOINT_ID, ATTRIBUTE_VALUE_ID

Description

The APPLICATION_ATTRIBUTES table stores information about the endpoints (resources) and attribute values that define the conditions by which applications are linked to users. It references the ENDPOINTS table and the ATTRIBUTE_VALUES table by their respective IDs.

Primary Keys

PK_APP_ATTRIBUTES - composite primary key on columns APPLICATION_ID, ENDPOINT_ID, ATTRIBUTE_VALUE_ID

Foreign Keys

None

Indexes

None

APPLICATION_ACCOUNTS Table

Structure

APPLICATION_ACCOUNTS APPLICATION_ID USER_ID ACCOUNT_ID

Index

None

Description

The APPLICATION_ACCOUNTS table saves information about user accounts, which is used to provide access to applications. This table references the APPLICATIONS, GLOBALUSERS, and ACCOUNTS tables by their corresponding IDs.

Primary Keys

None

Foreign Keys

None

Indexes

None

APPLICATION_OWNERS Table

Structure

PK_APPLICATION_OWNERS PK ID APPLICATION_ID OWNER_ID OWNER_TYPE

Index

Index PK Unique Keys PK_APPLICATION_OWNERS      ✓ Yes ID

Description

The APPLICATION_OWNERS table contains information about the owner of every application. The OWNER_ID field contains the ID of the user (as found in the GLOBALUSERS table) who is the owner of the application. Every application-to-owner relationship is identified by a unique ID in this table.

Primary Keys

PK_APPLICATION_OWNERS - primary key on column ID

Foreign Keys

None

Indexes

None

APPLICATIONSTATUSES Table

Structure

PK_APPLICATIONSTATUSES PK ID APPLICATION_ID OWNER_ID OWNER_TYPE

Index

Index PK Unique Keys PK_APPLICATIONSTATUSES      ✓ Yes ID

Description

The APPLICATIONSTATUSES table contains status labels of applications saved in the APPLICATIONS table.

Primary Keys

PK_APPLICATIONSTATUSES - primary key on column ID

Foreign Keys

None

Indexes

None