Tables in the Accounts Module

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

ACCOUNTS Table

Structure

ACCOUNTS PK PK ACCOUNTKEY NAMESPACEKEY NAME ID DESCRIPTION DOMAIN COMMENTS SUSPENDED LOCKED CREATEUSER UPDATEUSER CREATEDATE UPDATEDATE ATTR_VALUES_HASH ENDPOINT_ID ENDPOINT_NAME LAST_SYNCHRONIZED ACCOUNTTYPE_ID

Index

Index PK Unique Keys PK_ACCOUNTS      ✓ Yes ACCOUNTKEY, NAMESPACEKEY IX_ACCOUNTS_ACCOUNTKEY Yes ACCOUNTKEY

Description

The ACCOUNTS table carries the accounts imported from the various Resource Types. Every account carries the Domain Name, Endpoint, and Status of the account. Also for audit purposes information about the account's Creation Date and Update Date, as well as the User who created the account and the user under which the account was updated is also saved in Oracle Identity Analytics. Each time the base accounts are updated, the ATTR_VALUES_HASH column is updated to keep track of the 'changed' accounts from the new feed. The account is also listed under its particular Resource Types by associating with the Namespace table using the NAMESPACEKEY as the reference.

Primary Keys

PK_ACCOUNTS - composite key on columns ACCOUNTKEY and NAMESPACEKEY

Foreign Keys

None

Indexes

IX_ACCOUNTS_ACCOUNTKEY - non unique index on column ACCOUNTKEY

ACCOUNT_TYPES Table

Structure

ACCOUNT_TYPES PK ID LABEL DESCRIPTION

Indexes

Index PK Unique Keys PK_ACCOUNT_TYPES      ✓ Yes ID

Description

The different account types imported into Oracle Identity Analytics are listed under the 'ACCOUNT_TYPES' table. The following out-of-the-box account types are supported:

1. Provisioning account

2. High Privileged

3. Service Account

4. System Account

By default, all account types are set to 'Provisioning account' if not explicitly specified in the import process.

Primary Keys

PK_ACCOUNT_TYPES on column ID

Foreign Keys

None

Indexes

None

ACCOUNT_ATTRIBUTES Table

Structure

ACCOUNT_ATTRIBUTES PK ID ACCOUNT_ID PARENT_ID ACCT_ATTR_HIER_ID UPDATE_DATE

Indexes

Index PK Unique Keys PK_ACCOUNT_ATTRIBUTES_T      ✓ Yes ID IX_ACCOUNT_ATTRIBUTES_ACID No ACCOUNT_ID IX_ACCOUNT_ATTRIBUTES_PID No PARENT_ID

Description

The ACCOUNTS table carries only the account name and the audit values for that particular account. The ACCOUNT_ATTRIBUTES table carries references to the various parent accounts, along with hierarchy information within an account. It references the ACCOUNTS and the ACCT_ATTR_HIER_NODES tables by using the columns ACCOUNT_ID and ACCT_ATTR_HIER_ID respectively. These references help pull up information from the accounts and reference them to a particular account parent-child relationship.

Primary Keys

PK_ACCOUNT_ATTRIBUTES_T - primary key on column ID

Foreign Keys

None

Indexes

IX_ACCOUNT_ATTRIBUTES_ACID - non-unique index on column ACCOUNT_ID

IX_ACCOUNT_ATTRIBUTES_PID - non-unique index on column PARENT_ID

ARC_ACCOUNT_ATTRIBUTES Table

Structure

ARC_ACCOUNT_ATTRIBUTES ID ACCOUNT_ID PARENT_ID ACCT_ATTR_HIER_ID UPDATE_DATE ARCHIVE_DATE

Index

Index PK Unique Keys IX_ARC_ACCT_ATTRIBUTES_ACID No ACCOUNT_ID IX_ARC_ACT_ATTRIBUTES_PID No PARENT_ID

Description

The ARC_ACCOUNT_ATTRIBUTES table archives 'old/changed' account_attribute data from the ACCOUNT_ATTRIBUTES table whenever an account is changed/updated.

Primary Keys

None

Foreign Keys

None

Indexes

IX_ARC_ACCT_ATTRIBUTES_ACID - non-unique index on column ACCOUNT_ID

IX_ARC_ACCT_ATTRIBUTES_PID - non-unique index on column PARENT_ID

ACCT_ATTR_HIER_NODES Table

Structure

ACCT_ATTR_HIER_NODES PK ID ROOT_ID PARENT_ID ATTRIBUTE_VALUE_ID LFT RGT UPDATE_DATE

Index

Index PK Unique Keys PK_ACCT_ATTR_HIER_NODES      ✓ Yes ID IX_ACT_ATT_HIER_AV_ID No ATTRIBUTE_VALUE_ID IX_ACT_ATT_HIER_RID No ROOT_ID IX_ACT_ATT_HIER_PID No PARENT_ID

Description

The ACCT_ATTR_HIER_NODES maintains hierarchy information between attributes of an account. It has a unique ID, a ROOT_ID, and a PARENT_ID representing the root nodes and parent nodes respectively in the hierarchy. The ATTRIBUTE_VALUE_ID is a reference key to the ATTRIBUTE_VALUES table that contains the actual values of the attributes in the accounts. UPDATE_DATE stores information in case of an account modification. The fields LFT and RGT are used to maintain hierarchy information as well.

Primary Keys

PK_ACCT_ATTR_HIER_NODES - primary key on column ID

Foreign Keys

None

Indexes

IX_ACT_ATT_HIER_AV_ID - non-unique index on column ATTRIBUTE_VALUE_ID

IX_ACT_ATTR_HIER_RID - non-unique index on column ROOT_ID

IX_ACT_ATTR_HIER_PID - non-unique index on column PARENT_ID