Point Event

The PointEvent table is designed to store point event information for the system. It includes columns for the point event code, reference, description, point value, status, modified by, and modified date, along with the corresponding user who created the point event and the date and time.

Table Structure

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

• [Point_Event_Code] (varchar(150), not null): Represents the point event code.

• [Reference] (nvarchar(255), nullable): Represents the reference of the point event.

• [Description] (nvarchar(max), nullable): Represents the description of the point event.

• [Point_Value] (int, not null): Represents the point value of the point event.

• [Status] (bit, not null): Represents the status of the point event.

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

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

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

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

Constraints

• [PK_Point_Matrix]: Primary key clustered constraint on the [ID] column

• [DF_Point_Matrix_Status]: Default constraint with a default value of 0 on the [Status] column

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

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

Example Data

Point_Event_Code	Reference	Description	Point_Value	Status
SIGN-UP	#UserRegisteredEvent	Earn ? points after registering.	1	1
DAILY-LOGIN		Earn ? points for logging in daily.	1	1
COMPLETE-PROFILE		Earn ? points for filling out your profile.	1	1
PURCHASE-LICENSE-STANDARD-30		Earn ? points for purchasing a package license.	30	1
PURCHASE-LICENSE-STANDARD-90		Earn ? points for purchasing a package license.	90	1
PURCHASE-LICENSE-STANDARD-180		Earn ? points for purchasing a package license.	180	1
PURCHASE-LICENSE-GOLD-30		Earn ? points for purchasing a package license.	60	1
PURCHASE-LICENSE-GOLD-60		Earn ? points for purchasing a package license.	120	1
PURCHASE-LICENSE-GOLD-180		Earn ? points for purchasing a package license.	360	1
REFER-A-FRIEND		Earn ? points when your referral signs up and verifies the email address.	2	1
WRITE-FEEDBACK		Earn ? points for each feedback.	1	1
SOCIAL-MEDIA-SHARE		Earn ? points by sharing content on social media.	1	1
ANNIVERSARY-BONUS		Earn ? points on the anniversary of your signup.	100	1
SERVICE-COMPENSATION		Earn ? points from the service compensation.	0	1
WALLET-TO-POINT		Earn ? points for each USD you want to exchange from your wallet.	9	1
REDEEM-LICENSE-STANDARD-7		Exchange ? points for a package license.	-14	1
REDEEM-LICENSE-STANDARD-30		Exchange ? points for a package license.	-60	1
REDEEM-LICENSE-STANDARD-90		Exchange ? points for a package license.	-120	1
REDEEM-LICENSE-STANDARD-180		Exchange ? points for a package license.	-360	1