External Login Provider - User
The ExternalAuthenticationProviderUser table is designed to store the relationship between external authentication providers and users. Each record represents a user who has been authenticated by an external authentication provider.
Table Structure
[ID](bigint,auto-incrementing,primary key): Represents the unique identifier for each record.[External_Authentication_Provider_ID](bigint,not null): Represents the ID of the external authentication provider.[User_ID](bigint,not null): Represents the ID of the user associated with the external authentication provider.[External_Authentication_User_ID](varchar(50),not null): Represents the ID of the user in the external authentication provider's system.[Modified_By](bigint,nullable): Represents the ID of the user who last modified the record.[Modified_Date](datetime,not null): Represents the date and time when the record was last modified.[Created_By](bigint,nullable): Represents the ID of the user who created the record.[Created_Date](datetime,not null): Represents the date and time when the record was created.
Constraints
[PK_ExternalAuthenticationProviderUser]: Primary key constraint on the[ID]column.[DF_UserExternalLogin_ModifiedDate]: Default constraint to set[Modified_Date]to the current UTC date and time.[DF_UserExternalLogin_CreatedDate]: Default constraint to set[Created_Date]to the current UTC date and time.[FK_ExternalAuthenticationProviderUser_ProviderID]: Foreign key constraint on the[External_Authentication_Provider_ID]column, referencing the[ID]column of the[JFW].[ExternalAuthenticationProvider] table.[FK_ExternalAuthenticationProviderUser_UserID]: Foreign key constraint on the[User_ID]column, referencing the[ID]column of the[JFW].[User] table.
Last updated