service_auth table - SuperOffice

service_auth Table (493)

Authentication for a service (imap, smtp…)

Fields

Name	Description	Type	Nullable
service_auth_id	Primary key	PK	No
server	The mail server	String(255)	Yes
port	The server port	Int	Yes
auth_type	The type of authentication, plain-text, OAuth…	String(255)	Yes
username	The username	String(255)	Yes
password	The (encrypted) password or token	String(255)	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
associate_id	Associate who owns this authentication entry	FK associate	Yes
auth_status	The status of this authentication entry	Enum ServiceAuthStatus	Yes
encryptedCheck	Encrypted hash checksum	String(254)	No

service_auth table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
email_account	Email account information

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Enum ServiceAuthStatus Save Service Auth Enum values for ServiceAuthStatus Delete Service Auth Get Service Auth What's new in version 10.3.11.910

⌘I