• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

Credentials Table (250)

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(254)
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) ●

Credentials table relationship diagram

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 in a company or an organizations. All associates have a corresponding person record

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top