Price

The Price table is designed to store price information for the system. It includes columns for the brand ID, payment method ID, package ID, subscription type ID, code, name, description, amount, currency, checkout link, z-order, status, modified by, and modified date, along with the corresponding user who created the price and the date and time.

Table Structure

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

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

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

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

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

• [Code] (varchar(50), not null): Represents the price code.

• [Name] (nvarchar(50), nullable): Represents the price name.

• [Description] (nvarchar(1000), nullable): Represents the description of the price.

• [Amount] (float, nullable): Represents the amount of the price.

• [Currency] (varchar(3), nullable): Represents the currency of the price.

• [Checkout_Link] (nvarchar(1000), nullable): Represents the checkout link of the price.

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

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

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

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

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

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

Constraints

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

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

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

• [FK_Price_Package]: Foreign key constraint on the [Package_ID] column referencing the [ID] column of the Package table.

• [FK_Price_Payment_Method]: Foreign key constraint on the [Payment_Method_ID] column referencing the [ID] column of the PaymentMethod table.

• [FK_Price_Subscription]: Foreign key constraint on the [Subscription_Type_ID] column referencing the [ID] column of the SubscriptionType table.

Example Data

Brand_ID	Payment_Method_ID	Package_ID	Subscription_Type_ID	Code	Name	Description	Amount	Currency	Checkout_Link	ZOrder	Status
1	1	1	1	FREE	FREE	The free package in JFW.	0	USD	https://checkout.jframework.live/	1	1
1	1	2	1	STANDARD	STANDARD	The standard package in JFW.	10	USD	https://checkout.jframework.live/	2	1
1	1	3	1	GOLD	GOLD	The gold package in JFW.	20	USD	https://checkout.jframework.live/	3	1