Table: dbo.Firm_Preferences_Workforce_Hub_Login_Credentials
This table contains login credentials used for WorkforceHUB.
Columns
NameTypeConstraintsDescription
firm_KEYint (4)NOT NULLPrimary and foreign key. Foreign-keyed to Firm, which is home to WorkforceHUB login credentials.
encrypted_api_keynvarchar (-1)NOT NULLThe API Key used to login in to WorkforceHUB. This value is encrypted.
encrypted_api_passwordnvarchar (-1)NOT NULLThe API Password used to login to WorkforceHUB. This value is encrypted.
Primary key
NameColumnsDescription
PK_Firm_Preferences_Workforce_Hub_Login_Credentials$firm_KEYfirm_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Preferences_Workforce_Hub_Login_Credentials__Firm__firm_KEYfirm_KEYFirm (firm_KEY)Firm key on which WorkforceHUB login credentials are displayed, and it is Foreign-keyed to Firm.

Schema diagram