Table: dbo.Firm_Preferences_Workforce_Hub_Login_Credentials | |||
This table contains login credentials used for WorkforceHUB. | |||
Columns | |||
Name | Type | Constraints | Description |
firm_KEY | int (4) | NOT NULL | Primary and foreign key. Foreign-keyed to Firm, which is home to WorkforceHUB login credentials. |
encrypted_api_key | nvarchar (-1) | NOT NULL | The API Key used to login in to WorkforceHUB. This value is encrypted. |
encrypted_api_password | nvarchar (-1) | NOT NULL | The API Password used to login to WorkforceHUB. This value is encrypted. |
Primary key | |||
Name | Columns | Description | |
PK_Firm_Preferences_Workforce_Hub_Login_Credentials$firm_KEY | firm_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Firm_Preferences_Workforce_Hub_Login_Credentials__Firm__firm_KEY | firm_KEY | Firm (firm_KEY) | Firm key on which WorkforceHUB login credentials are displayed, and it is Foreign-keyed to Firm. |