Tracking Event

Tracking events are used to track interactions and activities within the system. These events can be used to monitor user behavior, system performance, and other important metrics.

Table Structure

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

• [Group_Code] (varchar(150), not null): Represents the group code of the tracking event.

• [Code] (varchar(150), not null): Represents the code of the tracking event.

• [Name] (nvarchar(500), nullable): Represents the name of the tracking event.

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

• [Tracking_Level] (smallint, not null): Represents the tracking level of the tracking event.

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

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

• [Is_System] (bit, not null): Indicates whether the tracking event is a system event.

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

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

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

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

Constraints

• [PK_Pattern]: primary key constraint on the [ID] column.

• [DF_TrackingEvent_Tracking_Level]: default constraint on the [Tracking_Level] column with a default value of 0.

• [DF_Pattern_IsSystem]: default constraint on the [Is_System] column with a default value of 0.

• [DF_Pattern_ModifiedDate]: default constraint on the [Modified_Date] column with the current UTC date and time as the default value.

• [DF_Pattern_CreatedDate]: default constraint on the [Created_Date] column with the current UTC date and time as the default value.

Example Usage

Group_Code	Code	Name	Description	Tracking_Level	ZOrder	Status	Is_System
ACCOUNT	REGISTRATION	User Registration	User registers an account	1	1000	1	1
ACCOUNT	REGISTRATION-SUCCESS	User Registration Success	User successfully registers an account	1	1000	2	1
ACCOUNT	FORGOT-PASSWORD-1	Forgot Password	User attempts to reset password	1	1000	1	1
ACCOUNT	FORGOT-PASSWORD-NOT-EXISTED	Forgot Password - User Not Existed	User attempts to reset password but user does not exist	1	1000	2	1
ACCOUNT	CHANGE-PASSWORD	Change Password	User changes password	1	1000	1	1
ACCOUNT	EMAIL-TO-EXPIRED-USER	Email to Expired User	Email sent to expired user	1	1000	1	1
ACCOUNT	EMAIL-TO-USER-WILL-BE-EXPIRED	Email to User Will Be Expired	Email sent to user who will be expired	1	1000	1	1
ACCOUNT	EMAIL-TO-EXPIRED-USER-TO-DEACTIVE	Email to Expired User to Deactive	Email sent to expired user to deactivate	1	1000	1	1
ACCOUNT	EMAIL-TO-USER-ABOUT-ACCOUNT-INFO-CHANGED	Email to User About Account Info Changed	Email sent to user about account info changed	1	1000	1	1
ACCOUNT	EMAIL-TO-ASK-USER-AFTER-PAYMENT	Email to Ask User After Payment	Email sent to user after payment	1	1000	1	1
ACCOUNT	LOGIN-SUCCESS-NOTIFICATION	Login Success Notification	Notification sent after successful login	1	1000	1	1
ACCOUNT	SEND-EMAIL-WITH-USER-STATUS-DELETED	Send Email with User Status Deleted	Email sent with user status deleted	1	1000	1	1
ACCOUNT	SEND-THE-EMAIL-TO-INACTIVE-USER	Send the Email to Inactive User	Email sent to inactive user	1	1000	1	1
ACCOUNT	SIGN-IN-DETECTION	Sign-in Detection	Detection of user sign-in	1	1000	1	1
ACCOUNT	SEND-VERIFICATION-EMAIL	Send Verification Email	Email sent for verification	1	1000	1	1
ACCOUNT	RESET-PASSWORD	Reset Password	User resets password	1	1000	1	1
ACCOUNT	SEND-EMAIL-TO-USER-ABOUT-COUPON	Send Email to User About Coupon	Email sent to user about coupon	1	1000	1	1
ACCOUNT	SEND-EMAIL-A-TICKET-TO-USER	Send Email a Ticket to User	Email sent a ticket to user	1	1000	1	1
PURCHASE	REMOVE-ACCOUNT	Remove Account	Remove user account	1	1000	1	1
PURCHASE	DISCOUNT-COUPON	Discount Coupon	Discount coupon applied	1	1000	1	1
PURCHASE	ORDER-INFO-AFTER-PAID	Order Info After Paid	Order information after payment	1	1000	1	1
PURCHASE	THANKS-FOR-PURCHASE	Thanks for Purchase	Thank you message after purchase	1	1000	1	1
PURCHASE	THANKS-FOR-PURCHASE-WITH-LICNESE-CODE	Thanks for Purchase with License Code	Thank you message after purchase with license code	1	1000	1	1
PURCHASE	APPLY-LICENSE-SUCCESSSFULLY	Apply License Successfully	License applied successfully	1	1000	1	1
PURCHASE	PURCHASE-NOTIFICATION	Purchase Notification	Notification after purchase	1	1000	1	1
SUPPORT	EXCEPTION-TO-DEV	Exception to Dev	Exception sent to developer	1	1000	1	1
SUPPORT	MESSAGE-TO-SUPPORT-TEAM	Message to Support Team	Message sent to support team	1	1000	1	1
EMAIL EXAMPLE	SEND-EMAIL-TEST-SMTP	Send Email Test SMTP	Send email test SMTP	1	1000	1	1
PURCHASE	PURCHASE-NOTIFICATION-SUCCESSFULLY	Purchase Notification Successfully	Notification after successful purchase	1	1000	1	1
PURCHASE	SEND-INVOICE-TO-USER	Send Invoice to User	Send invoice to user	1	1000	1	1
EXPORT DATA	EXPORT-INVOICE-PDF	Export Invoice PDF	Export invoice to PDF	1	1000	1	1
ACCOUNT	FORGOT-PASSWORD	Forgot Password	User forgot password	1	1000	1	1
ACCOUNT	REGISTRATION-CONFIRMATION	Registration Confirmation	User registration confirmation	1	1000	1	1
PURCHASE	PURCHASE-LICENSE-DIRECT-APPLY	Purchase License Direct Apply	Purchase license directly applied	1	1000	1	1
PURCHASE	PURCHASE-LICENSE-KEY	Purchase License Key	Purchase license key	1	1000	1	1
PURCHASE	REDEEM-GIFT	Redeem Gift	Redeem gift	1	1000	1	1
ACCOUNT	INVITE-FRIEND-VIA-CODE	Invite Friend via Code	Invite friend via code	1	1000	1	1
ACCOUNT	INVITE-FREIND-VIA-LINK	Invite Friend via Link	Invite friend via link	1	1000	1	1
MAINTENANCE	UPDATE-VERSION	Update Version	Update version	1	1000	1	1
MAINTENANCE	POLICY	Policy	Policy	1	1000	1	1