...
| Column | Type | Description |
|---|---|---|
| id | varchar | uuid of this entry (one user could have ui and ws credential) |
| username | varchar | username or local entity system name |
| type | varchar | username or localEntity |
| is_hashed | varchar | T for is hashed, F for is public key |
| encryption_type | varchar | e.g. SHA-256 or RS-256 (key type) |
| the_salt | varchar | secure random prepended to hashed pass |
| the_password | varchar | encrypted public key or encrypted hashed salted password |
| ws_or_ui | varchar | ws (includes scim) or ui |
| allowed_from_cidrs | varchar | network cidrs where credential is allowed from |
| recent_source_addresses | varcahr | json with timestamps |
| failed_source_addresses | varchar | 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 |
...