Table: dbo.Firm_Preferences_Swipe_Clock_Partner_Login_Credentials
This table contains partner login["BR"] information/credentials associated with SwipeClock application, needed while establishing connection from ACS. This["BR"] table has a 0..1 to 1 relationship with Firm.
Columns
NameTypeConstraintsDescription
firm_KEYint (4)NOT NULLPrimary and foreign["BR"] key. Foreign-keyed to Firm, which is home to SwipeClock partner login credentials.
encrypted_accountant_secretnvarchar (-1)NOT NULLThe["BR"] accountant secret of swipe clock partner login, which is an auto generated field in SwipeClock application["BR"] entered while requesting data into ACS from SwipeClock application, for connection purposes. This value is encrypted.
accountant_idbigint (8)NOT NULLAn UnquotedJSON Number is to be provided as specified by the SwipeClock documentation
is_syncedbit (1)NOT NULLThis 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
NameColumnsDescription
PK_Firm_Preferences_Swipe_Clock_Partner_Login_Credentials$firm_KEYfirm_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Preferences_Swipe_Clock_Partner_Login_Credentials__Firm__firm_KEYfirm_KEYFirm (firm_KEY)Firm["BR"] key on which SwipeClock partner login credentials are displayed, and it is Foreign-keyed to Firm.

Schema diagram