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