user_candidate Table (389)

• 1 minute to read
 • 1 minute to read

This table will hold user candidate secrets

Fields

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

user_candidate table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
person_id FK Index
secret_key String(255) Index

Relationships

Table Description
person Persons in a company or an organizations. All associates have a corresponding person record

Replication Flags

  • None

Security Flags

  • No access control via user's Role.