Accounts

accounts

Stores accounts that represent a login or identity on a specific target application, such as an SAP user ID or an Active Directory account. Use this table when you need account-level information for identities that Saviynt imports or manages on connected systems.

Critical

99 Columns

1 Primary Keys

7 Indexed

Columns

Complete column definition for accounts

99 columns ›

⌕ 99

#	Column	Data Type	Size	Key	Auto Increment
1	PK	bigint	20	PRI	✓
2		longtext	—	—	—
3		varchar	255	—	—
4		varchar	255	—	—
5		varchar	255	—	—
6	INDEX	bigint	20	MUL	—
7	INDEX	bigint	20	MUL	—
8		varchar	255	—	—
9		datetime	—	—	—
10		varchar	255	—	—
11		varchar	255	—	—
12		varchar	255	—	—
13		varchar	255	—	—
14		varchar	255	—	—
15		varchar	255	—	—
16		varchar	255	—	—
17		varchar	255	—	—
18		varchar	255	—	—
19		varchar	255	—	—
20		varchar	255	—	—
21		varchar	255	—	—
22		varchar	255	—	—
23		varchar	255	—	—
24		varchar	255	—	—
25		varchar	255	—	—
26		varchar	255	—	—
27		varchar	255	—	—
28		varchar	255	—	—
29		varchar	255	—	—
30		varchar	255	—	—
31		varchar	255	—	—
32		varchar	255	—	—
33		varchar	255	—	—
34		varchar	255	—	—
35		varchar	255	—	—
36		varchar	255	—	—
37		varchar	255	—	—
38		varchar	255	—	—
39		varchar	255	—	—
40		varchar	255	—	—
41		varchar	255	—	—
42		varchar	255	—	—
43		varchar	255	—	—
44		varchar	255	—	—
45		varchar	255	—	—
46		mediumtext	—	—	—
47		mediumtext	—	—	—
48		mediumtext	—	—	—
49		mediumtext	—	—	—
50		mediumtext	—	—	—
51		mediumtext	—	—	—
52		mediumtext	—	—	—
53		mediumtext	—	—	—
54		mediumtext	—	—	—
55		varchar	255	—	—
56		mediumtext	—	—	—
57		longtext	—	—	—
58		longtext	—	—	—
59		longtext	—	—	—
60		longtext	—	—	—
61		longtext	—	—	—
62		longtext	—	—	—
63		mediumtext	—	—	—
64		mediumtext	—	—	—
65		mediumtext	—	—	—
66		varchar	255	—	—
67		mediumtext	—	—	—
68		varchar	255	—	—
69		varchar	255	—	—
70		varchar	255	—	—
71		longtext	—	—	—
72		varchar	255	—	—
73	INDEX	bigint	20	MUL	—
74		bigint	20	—	—
75		bigint	20	—	—
76		datetime	—	—	—
77		datetime	—	—	—
78		bigint	20	—	—
79	INDEX	varchar	255	MUL	—
80		bit	1	—	—
81		varchar	255	—	—
82		datetime	—	—	—
83		varchar	255	—	—
84		varchar	255	—	—
85	INDEX	bigint	20	MUL	—
86		bigint	20	—	—
87		datetime	—	—	—
88	INDEX	bigint	20	MUL	—
89	INDEX	varchar	255	MUL	—
90		bigint	20	—	—
91		varchar	255	—	—
92		varchar	255	—	—
93		datetime	—	—	—
94		varchar	255	—	—
95		bigint	20	—	—
96		datetime	—	—	—
97		datetime	—	—	—
98		datetime	—	—	—
99		bigint	20	—	—
⌕ No columns found Try a different search term.

Related Tables

Verified relationships connected to accounts

5 relationships

›

Logical Reference

accounts ACCOUNTKEY

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

Logical Reference

accounts ENDPOINTKEY

Links an account to the endpoint on which the account exists.

Logical Reference

accounts ACCOUNTKEY

Links an account-entitlement grant to the account receiving the access.

Logical Reference

accounts ACCOUNTKEY

Links a role assignment record to the account on which the role is represented or assigned.

Ownership Reference

accounts ACCOUNTKEY

Links an account ownership record to the account being owned.