Payment Provider

This script creates a table named [JFW].[PaymentProvider] in the [JFW_live] database. The table has the following columns:

• [ID]: bigint, auto-incrementing primary key

• [Merchant_Type]: smallint, not null

• [Code]: varchar(50), not null

• [Name]: nvarchar(50), nullable

• [Description]: nvarchar(500), nullable

• [Website]: nvarchar(250), nullable

• [ZOrder]: bigint, nullable

• [Status]: smallint, not null

• [Is_Default]: bit, not null

• [Is_System]: bit, not null

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null

The table also has the following constraints:

• [PK_Merchant]: primary key constraint on the [ID] column

• [DF_Merchant_IsDefault]: default constraint on the [Is_Default] column with a default value of 0

• [DF_Merchant_IsSystem]: default constraint on the [Is_System] column with a default value of 0

• [DF_Merchant_ModifiedDate]: default constraint on the [Modified_Date] column with a default value of the current UTC date and time

• [DF_Merchant_CreatedDate]: default constraint on the [Created_Date] column with a default value of the current UTC date and time