Credentials Table (250)
•
Environment: onsite, online
Some tooltip text!
• 3 minutes to read
• 3 minutes to read
Alternative credentials
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| Credentials_id | Primary key | PK | |
| associateId | Associate that these credentials iare an alternative identification for | FK associate | |
| credentialType | What type of credentials is this | String(254) | |
| searchName | Searchable (plaintext) representation of credentials | String(254) | |
| secret | Encrypted secret | String(2000) | |
| validFrom | Start of validity for these credentials | DateTime | |
| validTo | End of validity for these credentials | DateTime | |
| isActive | What kind of usage are these credentials for; see enum CredentialUsage for details | Enum CredentialUsage | |
| encryptedCheck | Encrypted checksum; tampering will block system usage | String(254) | |
| lastUsedDate | When were these credentials last used for login | DateTime | ● |
| lastusedInfo | Provider-specific usage information, for instance an IP adrdess or other location | String(254) | ● |
| comment | Free text comment | String(254) | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort | |
| personId | Associates' person; or just the person, if this points to a potential associate (created on-demand on first login) | FK person | ● |
| extraId | Spare field, used at the plugins discretion | Id | ● |
| displayType | Lead-text used in GUI, originally from plugin. Used as fallback when plugins are missing | String(254) | ● |
| displayName | Friendly name of credentials (searchname could be a SID, this should be a real name) | String(254) | ● |
What kind of usage is this credential for
| Credential type | ID | Comment |
|---|---|---|
| Outbound | 0 | Credentials saved on behalf of an external system, not for authentication into NetServer |
| Inbound | 1 | Credentials to be used for authentication into NetServer, by a related plugin |
| Session | 2 | Session ticket, for re-authentication of an existing session (automatically purged at first full authentication after validity expiration) |
Indexes
| Fields | Types | Description |
|---|---|---|
| Credentials_id | PK | Clustered, Unique |
| searchName | String(254) | Index |
| credentialType, personId | String(254), FK | Index |
| credentialType, searchName | String(254), String(254) | Unique |
| credentialType, isActive, Credentials_id, validFrom, validTo | String(254), Enum, PK, DateTime, DateTime | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| person | Persons |
Replication Flags
- Area Management controlled table. Contents replicated to satellites and traveller databases.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.