...
| Column | Type | Description |
|---|---|---|
| id | varchar (40) | uuid of this entry (one user could have ui and ws credential) |
| username | varchar (255) | username or local entity system name |
| type | varchar (20) | username or localEntity |
| is_hashed | varchar (1) | T for is hashed, F for is public key |
| encryption_type | varchar (20) | e.g. SHA-256 or RS-256 (key type) |
| the_salt | varchar (255) | secure random prepended to hashed pass |
| the_password | varchar (4000) | encrypted public key or encrypted hashed salted password |
| ws_or_ui | varchar (2) | ws (includes scim) or ui |
| allowed_from_cidrs | varchar (255) | network cidrs where credential is allowed from |
| recent_source_addresses | varcahr (4000) | json with timestamps |
| failed_source_addresses | varchar (4000) | if restricted by cidr, this was failed IPs (json with timestamp?) |
| last_authenticated | timestamp | when last authenticated |
| last_edited | timestamp | when this was last edited |
| failed_logins | varchar (4000) | json of failed attempts |
JWT table recently used in Grouper: grouper_password_recently_used
...
| Column | Type | Description |
|---|---|---|
| jwt_jti | varchar (100) | e.g. uuid of this entry (sent from client) |
| jwt_iat | integer (11) | seconds since 1970 that this was issued |
...