Membership Database
Please refer to attached document for detail requirement.

Environment
1)	 Data repository stores in MySQL database
2)	 A web based application. Programming language can be any PHP, ASP, etc.
Requirements
1)	Only allow authenticated / authorized user to login to the web application. Administrator can define/create user account and assign permission to it (refer to #3a).
2)	Must practice secure coding when develop the web application. Do verification checks.
3)	Core application functionality:
a.	Type of access
The system must have a login page for authorized personnel only. For successful login, the follow type of account can be granted:

Level 1: Standard Access
1. Signup for new membership only (refer to #3b)
2. No access to the existing membership detail (refer to #3c)
3. No access to reports and Genealogy Map. (Refer to #3d)

Level 2: Shareholder Access
1. Signup for new membership (refer to #3b)
2. Read only to the existing membership detail (refer to #3c)
3. Can generate reports and Genealogy Map. (refer to #3d)

Level 3: Manager Access
1. Signup for new membership (refer to #3b)
2. Can modify to the existing membership detail. (refer to #3c)
3. Can generate reports and Genealogy Map. (refer to #3d)






Level 4: Maintenance Access
1. Include all rights stated in Level 2.
2. Can create/modify user account and reset password.
Below is the field required:-
a) Account ID
b) User Full Name
c) Mobile number
d) Email address
e) Password 
3. View Audit trail (user activity) log 
a) Login ID
b) Date & Time
c) Activity (i.e. modify XXX record etc)

b.	New member signup
i.	Web forms for new member signup
ii.	Information to be store in MySQL database
iii.	Record the submission Date & Time  in MySQL
c.	Query member status (Member ID)
i.	Display Maintenance Date
ii.	Display Member details 
iii.	Number of direct sponsor
d.	Genealogy Map & Reports
i.	Genealogy Map (display 6 levels per page, top-down approach)
ii.	Member’s down line Report
iii.	Account Maintenance Status (Maintenance / Not Maintenance)
iv.	Summary of Number of direct sponsor per member
e.	Reminder to Member via Email
i.	Remind Member two weeks before the maintenance expired
f.	Welcome Letter to New Member via Email (content must be able to dynamically added)
i.	Member Details
ii.	Introductory to system 
Optional
1)	Can make use of the open source Genealogy map.