← Back to Schema
Accounts

user_accounts

Maps Saviynt users to the accounts associated with them. Each record links a user identity to one of that user's accounts, making this the bridge between the identity record in users and the account record in accounts.

Critical
7 Columns
2 Primary Keys
1 Indexed

Columns

Complete column definition for user_accounts

7 columns ›
⌕ 7
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI —
2 PK bigint 20 PRI —
3 datetime — — —
4 varchar 255 — —
5 INDEX bigint 20 MUL —
6 datetime — — —
7 varchar 255 — —

Related Tables

Verified relationships connected to user_accounts

2 relationships
›
Logical Reference
user_accounts USERKEY
users USERKEY

Links an account-association record to the Saviynt user who owns or is associated with the account.

Logical Reference
user_accounts ACCOUNTKEY
accounts ACCOUNTKEY

Links a user-account association to the corresponding account record.