user_candidate table - SuperOffice

user_candidate Table (389)

This table will hold user candidate secrets

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
person_id	Foreign key. Id of a person representing Customer Center User.	FK person	No
secret_key	Username of a Customer Centre User.	String(255)	Yes
secret_value	Password of a Customer Centre User.	String(255)	Yes

Indexes

Fields	Types	Description
person_id	FK	Index
secret_key	String(255)	Index

Relationships

Table	Description
person	Persons

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Create Or Update User Candidate Get User Candidate By Person Protected tables person table Blocked tables list OwnerContactLink table

⌘I