| 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. |