Credentials table

Credentials Table (250)

Alternative credentials

Name	Description	Type	Nullable
Credentials_id	Primary key	PK	No
associateId	Associate that these credentials iare an alternative identification for	FK associate	No
credentialType	What type of credentials is this	String(254)	No
searchName	Searchable (plaintext) representation of credentials	String(254)	No
secret	Encrypted secret	String(2000)	No
validFrom	Start of validity for these credentials	DateTime	No
validTo	End of validity for these credentials	DateTime	No
isActive	What kind of usage are these credentials for; see enum CredentialUsage for details	Enum CredentialUsage	No
encryptedCheck	Encrypted checksum; tampering will block system usage	String(254)	No
lastUsedDate	When were these credentials last used for login	DateTime	Yes
lastusedInfo	Provider-specific usage information, for instance an IP adrdess or other location	String(254)	Yes
comment	Free text comment	String(254)	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
personId	Associates’ person; or just the person, if this points to a potential associate (created on-demand on first login)	FK person	Yes
extraId	Spare field, used at the plugins discretion	Id	Yes
displayType	Lead-text used in GUI, originally from plugin. Used as fallback when plugins are missing	String(254)	Yes
displayName	Friendly name of credentials (searchname could be a SID, this should be a real name)	String(254)	Yes

Fields	Types	Description
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

Table	Description
associate	Employees, resources and other users - except for External persons
person	Persons

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.