JP2010191901A - Introduction history management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a system capable of disclosing membership information including the number of descendant members who sequentially join by chain introduction starting from a member to the member via a computer network. <P>SOLUTION: An introduction history management system has means for: giving a member ID to create a QR code including the member ID and access information when affiliation access is accepted; for creating a standby screen with the QR code to make the member download the screen; for adding a member ID of an existing member in the QR code as an introduction parent ID to be stored in a member information table in performing the affiliation access by an input of the QR code; for storing all chain parent IDs in an introduction history information table; and retrieving the number of descendant members by the introduction history information table, and retrieving information regarding the descendant members by the member information table to be displayed on a member terminal. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a referral history management system, method, and program for disclosing member information including the number of descendant members who joined sequentially through a computer network via a chained referral starting from the member.

Conventionally, the same information is sequentially shared by transferring information via a computer network. However, there is still a system in which a prior information sender knows the number of information receivers in a later order. Because it was not, it was practically impossible to confirm to whom the information was spread.
Incidentally, there is no prior art document information to be described.

  The present invention has been made in view of the conventional situation as described above, and member information including the number of descendant members who are sequentially joined to the member through a chained introduction starting from the member via the computer network. It is an object to provide an introduction history information management system, method, and program that can be disclosed.

The present invention is an introduction history management system for disclosing member information including the number of descendant members who have joined sequentially through a computer network through a chained introduction starting from the member, via a computer network,
Is there a member information database that has at least a member information table for each member and an introduction history information table, and whether or not the terminal identification number sent when receiving membership access from a terminal that wants to participate in the member information table? Depending on whether or not the means to determine whether the applicant is already a member,
If the applicant is an existing member, means for notifying the participant applicant terminal to that effect,
If the applicant is not an existing member, a means for displaying a member registration screen on the participant applicant terminal;
When a predetermined member registration information is input to the member registration screen from the participation applicant terminal, a member ID is assigned to the participation applicant and a My Page is created, and at least the terminal identification number and the member Means for storing registration information, the member ID, and the my page in the member information table;
If the membership access from the applicant terminal is an access by entering a QR code including the membership ID of the existing member and access information to the system, the membership ID of the existing member is used as the introduction parent ID Means for adding to the member ID and storing it in the member information table;
When the existing member information table is searched for whether or not a member ID of another existing member is further added as an introduction parent ID to the member ID of the existing member set as the introduction parent ID. Means for sequentially repeating the same introduction parent ID search, adding all the found introduction parent IDs as direct ancestor IDs to the member IDs of the applicants for participation and storing them in the introduction history information table;
Creating a QR code including the member ID of the applicant and access information to the system, creating a standby screen with the QR code, and displaying the download screen on the participation applicant terminal;
Means for allowing the participation applicant terminal to download the standby screen and a screen leading to the participation applicant's My Page when receiving input information for downloading the standby screen from the participation applicant terminal;
When a request for disclosure of information including the number of descendant members is received through the My Page from the member terminal, the information is retrieved by searching all the introduction history information tables in which the member ID of the member is added as a direct ancestor ID. The number of descendant members who joined sequentially through the chained introduction starting from the member is calculated and displayed on the member terminal. At the same time, information on the descendant member is retrieved from the member information table of the descendant member, and statistical processing is performed on the member terminal. The above-mentioned problem is solved by an introduction history management system characterized by having a display means.

Further, the present invention is an introduction history disclosure method for disclosing member information including the number of descendant members who are sequentially joined to a member through a chained introduction starting from the member via a computer network,
A procedure for determining whether or not the applicant who wants to participate is an existing member, depending on whether or not the terminal identification number transmitted when receiving membership access from the participant applicant terminal exists in the member information table;
If the interested applicant is an existing member, a procedure to notify the interested applicant terminal to that effect,
If the applicant is not an existing member, a procedure for displaying a member registration screen on the participant applicant terminal;
When a predetermined member registration information is input to the member registration screen from the participation applicant terminal, a member ID is assigned to the participation applicant and a My Page is created, and at least the terminal identification number and the member A procedure for storing the registration information, the member ID, and the My Page in the member information table;
If the membership access from the applicant terminal is an access by entering a QR code including the membership ID of the existing member and access information to the system, the membership ID of the existing member is used as the introduction parent ID A procedure for adding to the member ID and storing it in the member information table;
When the existing member information table is searched for whether or not a member ID of another existing member is further added as an introduction parent ID to the member ID of the existing member set as the introduction parent ID. In order to repeat the same introduction parent ID search, add all the found introduction parent IDs as direct ancestor IDs to the member IDs of those who wish to participate, and store them in the introduction history information table;
A procedure for creating a QR code including the member ID of the applicant who wants to participate and access information to the system, creating a standby screen with the QR code, and displaying the download screen on the participant request terminal;
When receiving input information for downloading the standby screen from the participation applicant terminal, a procedure for downloading the standby screen and a screen leading to the participation applicant's My Page to the participation applicant terminal;
When a request for disclosure of information including the number of descendant members is received through the My Page from the member terminal, the information is retrieved by searching all the introduction history information tables in which the member ID of the member is added as a direct ancestor ID. The number of descendant members who joined sequentially through the chained introduction starting from the member is calculated and displayed on the member terminal. At the same time, information on the descendant member is retrieved from the member information table of the descendant member, and statistical processing is performed on the member terminal. The above-mentioned problem is solved by an introduction history disclosure method characterized by having a display procedure.

Further, the present invention is an introduction history management program for disclosing member information including the number of descendant members sequentially joined by chained introduction starting from the member to the member via a computer network.
When membership access is received from a candidate applicant terminal via a computer network, it is determined whether or not the applicant is an existing member based on whether or not the transmitted terminal identification number exists in the member information table. And the steps to
If the interested applicant is an existing member, a procedure to notify the interested applicant terminal to that effect,
If the applicant is not an existing member, a procedure for displaying a member registration screen on the participant applicant terminal;
When a predetermined member registration information is input to the member registration screen from the participation applicant terminal, a member ID is assigned to the participation applicant and a My Page is created, and at least the terminal identification number and the member A procedure for storing the registration information, the member ID, and the My Page in the member information table;
If the membership access from the applicant terminal is an access by entering a QR code including the membership ID of the existing member and access information to the system, the membership ID of the existing member is used as the introduction parent ID A procedure for adding to the member ID and storing it in the member information table;
When the existing member information table is searched for whether or not a member ID of another existing member is further added as an introduction parent ID to the member ID of the existing member set as the introduction parent ID. In order to repeat the same introduction parent ID search, add all the found introduction parent IDs as direct ancestor IDs to the member IDs of those who wish to participate, and store them in the introduction history information table;
A procedure for creating a QR code including the member ID of the applicant who wants to participate and access information to the system, creating a standby screen with the QR code, and displaying the download screen on the participant request terminal;
When receiving input information for downloading the standby screen from the participation applicant terminal, a procedure for downloading the standby screen and a screen leading to the participation applicant's My Page to the participation applicant terminal;
When a request for disclosure of information including the number of descendant members is received through the My Page from the member terminal, the information is retrieved by searching all the introduction history information tables in which the member ID of the member is added as a direct ancestor ID. The number of descendant members who joined sequentially through the chained introduction starting from the member is calculated and displayed on the member terminal, and information on the descendant member is searched from the member information table of the descendant member, and statistical processing is performed on the member terminal. The above-mentioned problem is solved by an introduction history management program for executing the procedure displayed on the screen.

  According to the present invention, a member shows a standby screen to a candidate who wants to participate, and the member ID of the member in the QR code is introduced by causing the QR code in the standby screen to be taken into a terminal such as a mobile phone of the applicant. Since the information is sequentially stored in the member information database as a parent, the member can know the total number of descendant members who have joined sequentially through a computer network through a chained introduction starting from the self. In addition, the member can know member information including the number of members by prefecture where the descendant member is located, the number of members by male / female, and the number of members by age group from the member information database.

  Therefore, for example, when a family restaurant releases a new product “hamburger”, the “hamburger association” is established to operate the present invention system, and a standby screen in which advertisement information of the new product “hamburger” is taken in is displayed. If created, when the QR code in the standby screen is input to a terminal such as a mobile phone of a candidate who wants to participate, that is, the advertisement of the “hamburger” in the standby screen is sequentially viewed by the descendant members when introducing the descendants, The chained childhood introduction inevitably advertises the hamburger, so if you give points that can be exchanged for the hamburger according to the number of descendant members, you can promote the hamburger. Can also be used. Incidentally, the member introduction network in this case is the member network of the “hamburger association”.

  In particular, if the member registration information that should be entered includes questionnaire items such as “whether you have eaten” or “price is reasonable” for the “hamburger”, the “hamburger association” The family restaurant serving as the operator can also obtain information on consumer trends and evaluations or improvements regarding the “hamburger”.

BRIEF DESCRIPTION OF THE DRAWINGS Schematic structure explanatory drawing of this invention system. The general | schematic flowchart of a new member registration process step. The schematic structure explanatory drawing of a member information table. The schematic flowchart which shows the search method of direct ancestor ID. Explanatory drawing of schematic structure of an introduction history information table. 4 is a schematic flowchart of an introduction history disclosure processing step. Schematic diagram of member introduction network.

  Embodiments of the present invention will be described below with reference to the drawings.

  FIG. 1 is an explanatory diagram of the schematic configuration of the system of the present invention. In FIG. 1, 1 is an introduction history management server for controlling the entire system in an integrated manner, which stores an introduction history management program for executing the above processing procedure, and at least a member information table 2a and introduction history for each member. A member information database 2 having an information table 2b and storing a member registration screen is provided. In addition, the applicant history terminal 3 and the member terminal 4 can connect and communicate with the introduction history management server 1 via the Internet 5. In addition, although it does not specifically limit as the said participation applicant terminal 3 and the member terminal 4, A mobile telephone is simple.

  Next, an operation example of the new member registration process in the system of the present invention will be described with reference to FIG. 2 showing a schematic flowchart of the new member registration process step.

  First, when the introduction history management server 1 receives a membership access from the terminal 3 such as a mobile phone via the Internet 5, the introduction history management server 1 starts operating (step 10), and the participation applicant sent It is searched whether or not the terminal identification number of the terminal 3 exists in the member information table 2a (step 11). If the terminal identification number is found, it is determined that the applicant who wants to participate is an existing member. This is notified to the participation applicant terminal 3 (step 12). In this case, the member's My Page that has already been created from the member information table 2a of the member may be retrieved and displayed on the participation applicant terminal 3 to prompt for disclosure of member information (step 12a). ). This prevents the double registration of existing members.

  On the other hand, if the terminal identification number is not found, the introduction history management server 1 determines that the applicant who wants to participate is not an existing member, and is required to join the applicant terminal 3 from the member information database 2. A member registration screen for receiving provision of various member information is displayed (step 13).

  Next, when the introduction history management server 1 receives input of predetermined member registration information on the member registration screen from the participation applicant terminal 3, the introduction history management server 1 gives a member ID unique to the member to the participation applicant. At the same time as creating a My Page, at least the terminal identification number of the applicant who wishes to participate, the member registration information that has received the input, the member ID assigned, and the created My Page are stored in the member information table 2a (step 14).

  Here, the member registration information to be input is appropriately selected according to the purpose of the association. For example, the member's prefecture name, gender, age, questionnaire items, and the like can be given.

Further, the introduction history management server 1 identifies whether or not the membership access from the applicant terminal 3 is based on the input of a QR code including the member ID of the existing member and access information (URL) to the system. If the access is made by entering a code (step 15), the member ID of the existing member is added as the introduction parent ID to the member ID of the applicant who wants to participate and stored in the member information table (step 16).
Thus, in this case, if the member E1 shown in FIG. 7 is a member who wants to participate, the member information table 2a of the applicant who wants to participate, as shown in FIG. It consists of the member ID 0031 of the parent member D1 who introduced the applicant, the terminal identification number of the applicant, the member registration information entered by the applicant, and the My Page of the applicant.
On the other hand, if the access is not based on the input of the QR code, the process proceeds to step 19 described later without going through the following steps 16 to 18.

In addition, as shown in FIG. 4, the introduction history management server 1 uses a member information table 2a of the existing member to introduce the member ID of the other existing member into the introduction ID of the existing member as the introduction parent ID. It is searched whether or not it has been added as an ID (step 17), and if it has been added, the same search is repeated in order, and all the introduced parent IDs that have been found are used as direct ancestor IDs, and generations from those who wish to participate Along with the number, it is added to the member ID of the applicant who wishes to participate and is stored in the introduction history information table 2b (step 18).
Thus, in this case, for example, in the example shown in FIG. 4, the member ID 0021 of the existing member C1 as the introduction parent ID is further added to the member ID 0031 of the existing member D1 as the introduction parent ID, and the member ID 0021 of the existing member C1. Since the member ID 0011 of the existing member B1 is added as the introduction parent ID and the member ID 0001 of the existing member A1 is added as the introduction parent ID to the member ID 0011 of the existing member B1, the introduction history information table of the applicant E1 who wants to participate. 2b, for example, as shown in FIG. 5 (1), the member ID 0041 of the applicant who wants to participate, all direct ancestor IDs 0031, 0021, 0001, and the number of generations from the applicant who wants to participate to the existing participants that are the starting point. , 2, 3 and 4. Similarly, the introduction history information table of the member D1 is configured as shown in FIG. 5 (2), and the introduction history information table of the member D2 is configured as shown in FIG. 5 (3). This introduction history information table enables high-speed calculation processing of the number of descendant members.
On the other hand, if another member is not added as an introduction parent ID, the process proceeds to the following step 19 without going through the above step 18.

  In addition, the introduction history management server 1 creates a QR code including the member ID of the applicant who wants to participate and access information (URL) to the system, creates a standby screen with the QR code, and displays the download screen. The information is displayed on the participation applicant terminal 3 (step 19). In this case, if the advertisement information is taken into the standby screen, the chained advertisement effect as described above can be obtained.

  Next, when the introduction history management server 1 receives the input information for downloading the standby screen from the participation applicant terminal 3, the introduction history management server 1 displays the screen that leads to the standby screen and the participation applicant's My Page. 3 is downloaded (step 20), and the member registration process is terminated (step 21).

  Next, an operation example of the introduction history disclosure process in the system of the present invention will be described with reference to FIG. 6 showing a schematic flowchart of the introduction history disclosure process step.

  First, when a request for disclosure of member information including at least the number of descendant members is received from the member terminal 4 through the member's My Page, the introduction history management server 1 starts operating (step 100), and the member ID of the member is directly connected. By searching all the introduction history information tables 2b added as ancestor IDs, the number of descendant members who have joined sequentially by the chained introduction starting from the member is calculated and displayed on the member terminal 4 (step 101). ).

For example, in the case of a member introduction network as shown in FIG. 7, in the introduction history information table of member ID 0041 (member E1), as shown in FIG. 0021 and 0001 are stored together with their respective generation numbers 1, 2, 3, and 4.
In addition, in the introduction history information table of the member ID 0031 (member D1), as shown in FIG. 5 (2), the introduction parent IDs 0021, 0011 and 0001 are sequentially assigned as the direct generation ancestor IDs. Is stored with.
In addition, in the introduction history information table of the member ID 0032 (member D2), as shown in FIG. 5 (3), the introduction parent IDs 0021, 0011 and 0001 are sequentially assigned as the direct generation ancestor IDs. 3 is stored together.

  Thus, for example, when there is a disclosure request access from the member terminal of the member ID 0021 (member C1), according to the system of the present invention, the introduction history information table in which the member ID 0021 is additionally stored as a direct ancestor ID is shown in FIG. Because it is the three tables of member ID 0041, member ID 0031, and member ID 0032 shown in 5 (1) to (3), it is immediately determined that the total number of descendants who joined sequentially by chained introduction starting from member ID 0021 is three. The number of generations up to the member ID 0021 is 2 for the farthest offspring (member ID 0041) and 1 for the latest offspring (member IDs 0031 and 0032).

  Further, the introduction history management server 1 searches the member information table 2a of all the descendant members for information related to the descendant members, performs statistical processing, and displays the result on the member terminal 4 (step 102). For example, the number of members by prefecture where the descendant member of the member ID 0021 (member C1) is located, the number of members by male / female, the number of members by age group, and the like are displayed on the member terminal 4.

  The introduction history disclosure process is terminated by the above information display (step 103).

1: Introduction history management server 2: Member information database 2a: Member information table 2b: Introduction history information table 3: Participant terminal 4: Member terminal 5: Internet

Claims (3)

An introduction history management system for disclosing member information including the number of descendant members who have joined sequentially through a chained introduction starting from the member to the member via a computer network,
Is there a member information database that has at least a member information table for each member and an introduction history information table, and whether or not the terminal identification number sent when receiving membership access from a terminal that wants to participate in the member information table? Depending on whether or not the means to determine whether the applicant is already a member,
If the applicant is an existing member, means for notifying the participant applicant terminal to that effect,
If the applicant is not an existing member, a means for displaying a member registration screen on the participant applicant terminal;
When a predetermined member registration information is input to the member registration screen from the participation applicant terminal, a member ID is assigned to the participation applicant and a My Page is created, and at least the terminal identification number and the member Means for storing registration information, the member ID, and the my page in the member information table;
If the membership access from the applicant terminal is an access by entering a QR code including the membership ID of the existing member and access information to the system, the membership ID of the existing member is used as the introduction parent ID Means for adding to the member ID and storing it in the member information table;
When the existing member information table is searched for whether or not a member ID of another existing member is further added as an introduction parent ID to the member ID of the existing member set as the introduction parent ID. Means for sequentially repeating the same introduction parent ID search, adding all the found introduction parent IDs as direct ancestor IDs to the member IDs of the applicants for participation and storing them in the introduction history information table;
Creating a QR code including the member ID of the applicant and access information to the system, creating a standby screen with the QR code, and displaying the download screen on the participation applicant terminal;
Means for allowing the participation applicant terminal to download the standby screen and a screen leading to the participation applicant's My Page when receiving input information for downloading the standby screen from the participation applicant terminal;
When a request for disclosure of information including the number of descendant members is received through the My Page from the member terminal, the information is retrieved by searching all the introduction history information tables in which the member ID of the member is added as a direct ancestor ID. The number of descendant members who joined sequentially through the chained introduction starting from the member is calculated and displayed on the member terminal. At the same time, information on the descendant member is retrieved from the member information table of the descendant member, and statistical processing is performed on the member terminal. And an introduction history management system characterized by comprising: There is an introduction history disclosure method for disclosing member information including the number of descendant members who joined sequentially through a computer network via a chained introduction starting from the member,
A procedure for determining whether or not the applicant who wants to participate is an existing member, depending on whether or not the terminal identification number transmitted when receiving membership access from the participant applicant terminal exists in the member information table;
If the interested applicant is an existing member, a procedure to notify the interested applicant terminal to that effect,
If the applicant is not an existing member, a procedure for displaying a member registration screen on the participant applicant terminal;
When a predetermined member registration information is input to the member registration screen from the participation applicant terminal, a member ID is assigned to the participation applicant and a My Page is created, and at least the terminal identification number and the member A procedure for storing the registration information, the member ID, and the My Page in the member information table;
If the membership access from the applicant terminal is an access by entering a QR code including the membership ID of the existing member and access information to the system, the membership ID of the existing member is used as the introduction parent ID A procedure for adding to the member ID and storing it in the member information table;
When the existing member information table is searched for whether or not a member ID of another existing member is further added as an introduction parent ID to the member ID of the existing member set as the introduction parent ID. In order to repeat the same introduction parent ID search, add all the found introduction parent IDs as direct ancestor IDs to the member IDs of those who wish to participate, and store them in the introduction history information table;
A procedure for creating a QR code including the member ID of the applicant who wants to participate and access information to the system, creating a standby screen with the QR code, and displaying the download screen on the participant request terminal;
When receiving input information for downloading the standby screen from the participation applicant terminal, a procedure for downloading the standby screen and a screen leading to the participation applicant's My Page to the participation applicant terminal;
When a request for disclosure of information including the number of descendant members is received through the My Page from the member terminal, the information is retrieved by searching all the introduction history information tables in which the member ID of the member is added as a direct ancestor ID. The number of descendant members who joined sequentially through the chained introduction starting from the member is calculated and displayed on the member terminal. At the same time, information on the descendant member is retrieved from the member information table of the descendant member, and statistical processing is performed on the member terminal. An introduction history disclosure method characterized by comprising: An introduction history management program for disclosing member information including the number of descendant members who joined sequentially through a chained introduction starting from the member to a member via a computer network,
When membership access is received from a candidate applicant terminal via a computer network, it is determined whether or not the applicant is an existing member based on whether or not the transmitted terminal identification number exists in the member information table. And the steps to
If the interested applicant is an existing member, a procedure to notify the interested applicant terminal to that effect,
If the applicant is not an existing member, a procedure for displaying a member registration screen on the participant applicant terminal;
When a predetermined member registration information is input to the member registration screen from the participation applicant terminal, a member ID is assigned to the participation applicant and a My Page is created, and at least the terminal identification number and the member A procedure for storing the registration information, the member ID, and the My Page in the member information table;
If the membership access from the applicant terminal is an access by entering a QR code including the membership ID of the existing member and access information to the system, the membership ID of the existing member is used as the introduction parent ID A procedure for adding to the member ID and storing it in the member information table;
When the existing member information table is searched for whether or not a member ID of another existing member is further added as an introduction parent ID to the member ID of the existing member set as the introduction parent ID. In order to repeat the same introduction parent ID search, add all the found introduction parent IDs as direct ancestor IDs to the member IDs of those who wish to participate, and store them in the introduction history information table;
A procedure for creating a QR code including the member ID of the applicant who wants to participate and access information to the system, creating a standby screen with the QR code, and displaying the download screen on the participant request terminal;
When receiving input information for downloading the standby screen from the participation applicant terminal, a procedure for downloading the standby screen and a screen leading to the participation applicant's My Page to the participation applicant terminal;
When a request for disclosure of information including the number of descendant members is received through the My Page from the member terminal, the information is retrieved by searching all the introduction history information tables in which the member ID of the member is added as a direct ancestor ID. The number of descendant members who joined sequentially through the chained introduction starting from the member is calculated and displayed on the member terminal. At the same time, information on the descendant member is retrieved from the member information table of the descendant member, and statistical processing is performed on the member terminal. An introduction history management program for executing the procedure displayed on the screen.

Images