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
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
Last updated