← Back to Schema
Entitlements

entitlement_values

Stores the individual access values that exist on connected target systems, such as groups, roles, authorization objects, profiles, or other application-specific access items. Each entitlement value belongs to an entitlement type and represents a concrete piece of access that can be associated with accounts or governed by Saviynt.

Critical
79 Columns
1 Primary Keys
6 Indexed

Columns

Complete column definition for entitlement_values

79 columns ›
⌕ 79
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI ✓
2 varchar 255 — —
3 longtext — — —
4 bigint 20 — —
5 datetime — — —
6 longtext — — —
7 varchar 255 — —
8 varchar 255 — —
9 varchar 255 — —
10 varchar 255 — —
11 varchar 255 — —
12 varchar 255 — —
13 varchar 255 — —
14 varchar 255 — —
15 varchar 255 — —
16 varchar 255 — —
17 longtext — — —
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 longtext — — —
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 longtext — — —
40 varchar 255 — —
41 longtext — — —
42 varchar 255 — —
43 varchar 255 — —
44 varchar 255 — —
45 varchar 255 — —
46 longtext — — —
47 varchar 1024 — —
48 bigint 20 — —
49 varchar 255 — —
50 INDEX varchar 255 MUL —
51 longtext — — —
52 longtext — — —
53 INDEX varchar 255 MUL —
54 INDEX bigint 20 MUL —
55 bigint 20 — —
56 INDEX bigint 20 MUL —
57 varchar 255 — —
58 datetime — — —
59 datetime — — —
60 bigint 20 — —
61 varchar 255 — —
62 bit 1 — —
63 bigint 20 — —
64 bigtin 20 — —
65 varchar 255 — —
66 INDEX bigint 20 MUL —
67 bigint 20 — —
68 bigint 20 — —
69 bigint 20 — —
70 datetime — — —
71 varchar 255 — —
72 longblob — — —
73 bit 1 — —
74 bigint 20 — —
75 INDEX bigint 20 MUL —
76 bigint 20 — —
77 datetime — — —
78 bigint 20 — —
79 longtext — — —

Related Tables

Verified relationships connected to entitlement_values

6 relationships
›
Logical Reference
entitlement_values ENTITLEMENT_VALUEKEY
account_entitlements1 ENTITLEMENT_VALUEKEY

Links an account-entitlement grant to the specific entitlement value assigned to the account.

Logical Reference
entitlement_values ENTITLEMENTTYPEKEY
entitlement_types ENTITLEMENTTYPEKEY

Links an individual entitlement value to the entitlement type/category it belongs to.

Logical Reference
entitlement_values ENTITLEMENT_VALUEKEY
role_entitlements ENTITLEMENT_VALUEKEY

Links a role-entitlement membership record to the entitlement contained in the role.

Logical Reference
entitlement_values ENTITLEMENT_VALUEKEY
customer_entitlementvalues ENTITLEMENT_VALUES

Links a customer-entitlement association to the entitlement value scoped to that customer.

Logical Reference
entitlement_values ENTITLEMENT_VALUEKEY
usergroup_entitlements ENTITLEMENT_VALUEKEY

Links a user-group entitlement association to the entitlement value granted through the group.

Ownership Reference
entitlement_values ENTITLEMENT_VALUEKEY
entitlement_owners ENTITLEMENT_VALUEKEY

Links an entitlement ownership record to the entitlement value being owned.