User credit Design

I hope you can give some comments on the design of one of my points. The main reason is to find a lot of inconvenient and complicated points in actual use, such as maintaining the points configuration items, in addition, it is complicated to manually add points from the background. Hope you can give me some advice!

I,Function module 

1. 1.Integral rule Index 

An index of a point rule refers to a set of corresponding points rules that are managed by an index object.

 

1. 2.Credit rules

A credit rule is used to create a specific credit rule and define the attributes such as the credit value and valid time for each rule (for example, to visit the customer selectively in the market, and then to earn 500 credits for this activity, valid Period: 2010-03-23 To 2010-03-30 ). You must specify the index of the corresponding credit rule when creating a credit rule.

 

 

1. 3.User credit details

User credit details refer to the fact that a user adds a credit record to a user after performing an activity or performing an action under a specified credit rule. There are two types:

L default credit items of the system. For example, (logon, open project, and new project are all default fixed credit items of the system when the operating budget reaches. net ).

L custom points are manually added by a dedicated administrator. For example, if an offline activity is performed on the market, the corresponding points are manually added to the corresponding user.

The process is as follows:

 

1. 4.Invite users

You can use QQ, MSN, and e-mail to recommend a budget pass to your friends. net. If a user successfully recommends a friend, the user will be rewarded with points or a small gift.

During the invitation to register, the URL address of the. NET registration page is budgeted, and the user ID (encrypted for security purposes) is added as a complete link address. The user can copy the link address and then recommend the budget to his friends through. net.

Technically, you need to obtain the address bar parameters on the registration page, obtain the user ID through encryption, and then you can call the user points service interface for user points. If you need to know which friends a user recommends, you need to maintain a User Friend relationship table so that you can query the number of friends a user recommends, we can launch related marketing activities for these activities.

 

II,User credit related objects 

1. 1.User credit object

Field name	Type	Field comment
XH	Int	Serial number
Userid	String	User ID
Username	String	User Name
Usercredits	Int	User points
Usermemo	String	Remarks

 

1. 2.Points details object

Field name	Type	Field comment
XH	Int	Serial number
Userid	String	User ID
Username	String	User Name
Creditsstate	Int	Point status (consumption points and adding points)
Creditsdt	Datetime	Point time
Creditscontent	String	Points
Creditsruleindexid	Int	Integral rule index ID
Creditsruleid	Int	Credit Rule ID
Creditsvalue	Int	Credit value
Memo	String	Remarks

 

1. 3.Points rule index object

Field name	Type	Field comment
XH	Int	Serial number
Creditsruleindexid	Int	Integral rule index ID
Creditsruleindexcontent	String	Points rule index content
Createdt	Datetime	Time Point creation rule
Memo	String	Remarks

 

1. 4.Points rule object

Field name	Type	Field comment
XH	Int	Serial number
Creditsruleid	Int	Credit Rule ID
Creditsruleindexid	Int	Integral rule index ID
Creditsrulecontent	String	Points rule content
Creditsvalue	Int	Credit value
Issetcreditsupper	Int	Whether to set the daily Credit Limit
Creditsuppervalue	Int	Daily credit Upper Limit
Startcreditsdt	Datetime	Start Point time
Endcreditsdt	Datetime	End Point time
Memo	String	Remarks

 

 

III,Invite friends to register related objects 

1. 1.Invite user records

Field name	Type	Field comment
XH	Int	Serial number
Userid	String	User ID
Username	String	User Name
USERSID	Int	User internal ID number
Inviteinfo	String	Invitation Information
Invitedt	Datetime	Invitation time
Memo	String	Remarks

 

1. 2.User Friend Object Record

Field name	Type	Field comment
XH	Int	Serial number
Userid	String	User ID
Username	String	User Name
Userfriendsid	String	User Friend ID
Userfriendsname	String	User Friend name
memo	string	remarks