Table: dbo.Firm_Preferences_Swipe_Clock_Partner_Login_Credentials
This table contains partner logininformation/credentials associated with Swipeclock application, needed while establishing connection from ACS. This table has a 0..1 to 1 relationship with Firm.
Columns
Name | Type | Constraints | Description
firm_KEY | int (4) | NOT NULL | Primary and foreign key. Foreign-keyed to Firm, which is home to Swipeclock partner login credentials.
encrypted_accountant_secret | nvarchar (-1) | NOT NULL | The accountant secret of swipeclock partner login, which is an auto generated field in Swipeclock application entered while requesting data into ACS from Swipeclock application, for connection purposes. This value is encrypted.
accountant_id | bigint (8) | NOT NULL | An UnquotedJSON Number is to be provided as specified by the Swipeclock documentation
is_synced | bit (1) | NOT NULL | This should be set to boolean based on data saved in swipeclock microservice. Value of this column will be used to determine whether data is synced or not to microservice database.

Primary key
Name | Columns | Description
PK_Firm_Preferences_Swipe_Clock_Partner_Login_Credentials$firm_KEY | firm_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm_Preferences_Swipe_Clock_Partner_Login_Credentials__Firm__firm_KEY | firm_KEY | Firm (firm_KEY) | Firm key on which Swipeclock partner login credentials are displayed, and it is Foreign-keyed to Firm.