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

User_ID	Balance
1	33
2	2