← Back to Schema
SoD, Risk & Controls
jmrules
Stores Job Role Matrix (JRM) rule definitions used in role-mining or recommendation processing. The rules relate job or identity attributes to access patterns considered by Saviynt's role-analysis processes.
Medium
13
Columns
1
Primary Keys
4
Indexed
Columns
Complete column definition for
jmrules
13
columns
›
Columns
Complete column definition for
jmrules
13
| # | Column | Data Type | Size | Key | Auto Increment |
|---|---|---|---|---|---|
| 1 | PK | bigint | 20 | PRI | ✓ |
| 2 | datetime | — | — | — | |
| 3 | INDEX | bigint | 20 | MUL | — |
| 4 | varchar | 255 | — | — | |
| 5 | bigint | 20 | — | — | |
| 6 | varchar | 255 | UNI | — | |
| 7 | mediumtext | — | — | — | |
| 8 | INDEX | bigint | 20 | MUL | — |
| 9 | bigint | 20 | — | — | |
| 10 | INDEX | bigint | 20 | MUL | — |
| 11 | bigint | 20 | — | — | |
| 12 | datetime | — | — | — | |
| 13 | INDEX | bigint | 20 | MUL | — |