External Login Provider

Script: JFW.ExternalAuthenticationProvider.Table.sql

Description: This script creates the [JFW].[ExternalAuthenticationProvider] table in the [JFW_live] database. The table is used to store external authentication provider information.

Table Structure:

• [ID]: bigint, identity column, unique identifier for each record

• [Brand_ID]: bigint, nullable, foreign key to the brand table

• [Code]: varchar(50), not null, code of the authentication provider

• [Name]: varchar(50), not null, name of the authentication provider

• [Description]: nvarchar(250), nullable, description of the authentication provider

• [Client_ID]: varchar(200), not null, client ID for authentication

• [Client_Secret]: varchar(200), not null, client secret for authentication

• [Redirect_Uri]: nvarchar(100), not null, redirect URI for authentication

• [Scope]: nvarchar(200), nullable, scope for authentication

• [Auth_Endpoint]: nvarchar(200), nullable, authentication endpoint URL

• [Token_Endpoint]: nvarchar(200), nullable, token endpoint URL

• [Icon_Url]: nvarchar(200), nullable, URL of the authentication provider's icon

• [Status]: smallint, not null, status of the authentication provider

• [Modified_By]: bigint, nullable, foreign key to the user table who modified the record

• [Modified_Date]: datetime, not null, date and time when the record was last modified (default value: current UTC date and time)

• [Created_By]: bigint, nullable, foreign key to the user table who created the record

• [Created_Date]: datetime, not null, date and time when the record was created (default value: current UTC date and time)

Default Constraints:

• [Status]: default value of 1

• [Modified_Date]: default value of current UTC date and time

• [Created_Date]: default value of current UTC date and time

Primary Key:

• [ID]

Database: JFW_live