Point
The Point table is designed to store point-related information for users in the system. It includes columns for the user ID, balance, modified by, modified date, created by, and created date.
Table Structure
[ID](bigint,auto-incrementing,primary key): Represents the unique identifier for each point record.[User_ID](bigint,not null): Represents the ID of the user who earned the points.[Balance](bigint,not null): Represents the balance of the points earned.[Modified_By](bigint,nullable): Represents the ID of the user who last modified the point record.[Modified_Date](datetime,not null): Represents the date and time when the point record was last modified.[Created_By](bigint,nullable): Represents the ID of the user who created the point record.[Created_Date](datetime,not null): Represents the date and time when the point record was created.
Constraints
[PK_PointEarned]: Primary key constraint on the[ID]column[DF_PointEarned_Balance]: Default constraint on the[Balance]column, default value is 0[DF_PointEarned_ModifiedDate]: Default constraint on the[Modified_Date]column, default value is current UTC date and time[DF_PointEarned_CreatedDate]: Default constraint on the[Created_Date]column, default value is current UTC date and time
Example Data
1
33
2
2
Last updated