Payment Method

The PaymentMethod table is designed to store payment method information for brands. It includes columns for the brand ID, payment provider ID, payment information, IPN listener link, cancel link without login, cancel link, return link, public key, private key, internal note, z-order, status, and flags to indicate the user who created or last modified the payment method, along with the corresponding date and time.

Table Structure

• [ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each payment method record.

• [Brand_ID] (bigint, not null): Foreign key referencing the [ID] column of the Brand table.

• [Payment_Provider_ID] (bigint, not null): Foreign key referencing the [ID] column of the PaymentProvider table.

• [Payment_Info] (varchar(150), nullable): Represents the payment information.

• [Ipn_Listener_Link] (nvarchar(1000), nullable): Represents the IPN listener link.

• [Cancel_Link_Without_Login] (nvarchar(1000), nullable): Represents the cancel link without login.

• [Cancel_Link] (nvarchar(1000), nullable): Represents the cancel link.

• [Return_Link] (nvarchar(1000), nullable): Represents the return link.

• [Public_Key] (varchar(150), nullable): Represents the public key.

• [Private_Key] (varchar(150), nullable): Represents the private key.

• [Interal_Note] (nvarchar(max), nullable): Represents the internal note.

• [ZOrder] (bigint, nullable): Represents the z-order.

• [Status] (smallint, not null): Represents the status of the payment method.

• [Is_Default] (bit, not null): Indicates whether the payment method is the default for the brand.

• [Modified_By] (bigint, nullable): Represents the user who last modified the payment method.

• [Modified_Date] (datetime, not null): Represents the date and time when the payment method was last modified.

• [Created_By] (bigint, nullable): Represents the user who created the payment method.

• [Created_Date] (datetime, not null): Represents the date and time when the payment method was created.

Constraints

• [PK_PaymentMethod]: Primary key constraint on the [ID] column.

• [DF_MerchantMethod_IsDefault]: Default constraint on the [Is_Default] column with a default value of 0.

• [DF_PaymentMethod_ModifiedDate]: Default constraint on the [Modified_Date] column with the current UTC date and time as the default value.

• [DF_PaymentMethod_CreatedDate]: Default constraint on the [Created_Date] column with the current UTC date and time as the default value.

• [FK_PaymentMethod_Brand]: Foreign key constraint on the [Brand_ID] column referencing the [ID] column of the Brand table.

• [FK_PaymentMethod_Provider]: Foreign key constraint on the [Payment_Provider_ID] column referencing the [ID] column of the PaymentProvider table.

Example Data

Brand_ID	Payment_Provider_ID	Payment_Info	Ipn_Listener_Link	Cancel_Link_Without_Login	Cancel_Link	Return_Link	Public_Key	Private_Key	Interal_Note	ZOrder	Status	Is_Default
1	1	acct_1KKkT3XQsl86R7ov	https://api.jframework.live/api/v1/webhooks/stripe	https://jframework.live	https://my.jframework.live/billing/package	https://my.jframework.live/billing/license	pk_test_TYooMQauvdEDq54NiTphI7jx	pk_test_TYooMQauvdEDq54NiTphI7jx	This is the test payment method for the JFW system.	10	1	1