Table: dbo.Client_Staff_Intercept_Credentials | |||
Table for InterceptEFT credentials for client staff. | |||
Columns | |||
Name | Type | Constraints | Description |
staff_KEY | int (4) | NOT NULL | Key to staff owning these credetials. |
intercept_login | nvarchar (50) | NOT NULL | Login for InterceptEFT |
intercept_pin | nvarchar (50) | NOT NULL | PIN for InterceptEFT |
intercept_multifactor_authorization | nvarchar (100) | NOT NULL | Multifactor authorization for InterceptEFT |
encrypted_intercept_password | nvarchar (-1) | NOT NULL | A field to store the encrypted password for National Payment Corporation authentication. |
Primary key | |||
Name | Columns | Description | |
PK_Client_Staff_Intercept_Credentials$staff_KEY | staff_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Client_Staff_Intercept_Credentials__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |