Need web accessible database:
1) User & Owner Data Entry forms
2) Searchable Membership database
3) Searchable data entered via forms
4) MySQL Database
5) Prefer [url removed, login to view] or java app
Source code must be provided at completion of project.
Need a web app (utilizing a mysql database) that can run on Windows (xp, etc.) & be accessible via web [please advise on
this requirement]. We don't need it hosted... we just want remote usability/access to a single database app.
Data & members must be fully searchable (ie: any data field of a record can help locate that record).
I. MEMBERS FORM(s)
I.a. Administrator (two App Editor's accounts with equal & unlimited rights - 1 for purchasing organization & 1 for app
I.b. Owners (Main users' accounts, assignable by Organization editor - unlimited members, unlimited rights to data)
I.c. Affiliate (Limited access/data entry - unlimited members) - NOTE: Affiliate has a 'subclass' "R".
I.d. Non-members (Limited access/data entry - unlimited members) - NOTE: Non-member has a 'subclass' "M".
I.e. Account details (data record):
I.e.1 Personal Data: First name, Middle name, Last name, Date of Birth, Age, Gender, Race, Personal Email, Phone & Address
(viewable by Owners & Admin only);
I.e.2 Employee Data: EID (Employee ID is Record KEY), Employer, Work location, Workplace phone, workplace email, employee
title, workplace contact, number of years employed by Employer, Employee Status (Employed, Unemployed);
I.e.3 Organization Related Data: number of years with Organization, number of events by Member (Ia-d) [appear as
number of successes by Member (Ia-d), number of failures by Member (Ia-d), Class (Ia-d) & subclass "R";
I.e.4 History of Member (Affiliate/Non-member/Owner): Attachable word or pdf docs and ~256 data entry field. Attachments
will appear accessible/viewable as links;
I.f. Member sign up form: All data entered by member (or non-member) and approved by Owner; Attachments will be uploaded.
I.g. Member search form: Accessible only by Owners & Admin - ANY data field of Member records will present other related
data in associated 'Account Details' fields [similar to kellybluebook (automobile search) drop down fields, but with more
versatility. Clicking 1 drop down box of any Account Detail Field will sort the other associated fields (like windows
"auto-complete". While searching an 'EID' would present an 'exact' match, searching by 'Employer' would build a record set
of all employees for that 'Employer'].
I.h. 'Employer' is itself a record set of various employers with a basic (sequential) unique ID [Editable/Expandable by
Owners & Admin]. Each Member Class would also be a record set or sub database with inherent relationships to all other
II. EVENTS FORM(s)
II.a. Class I Altercation
II.b. Class II Grievance
II.c. Class III Response
II.d. Class IV Resolution
II.e. Class V Organization Meetings
II.f. Class VI Other Meetings
II.g. All Classes include Event's fields: Title, Date, Time, Event Members (I.a-d) [multiple members may be listed for one
event & subclass must be visible], Address of Event Location, Event specific location (room etc.), [automatic links
displayed for other event classifications & member data (I.e.3, etc.)], Upload/Download section for including xls, word, &
pdf files - accessible/viewable as links;
III.h. Class I Event's fields include: Employer, Employee Status, Altercation Description/Notes of Event - Text Field
(Searchable), Significance to altercation;
III.i. Class I Event's fields include: Employer, Employee Status, Affiliate "R" subclass, Non-Member "M" subclass,
Grievance Request/Demands - Text Field (Searchable);
III.j. Class II Event's fields include: Employer, Employee Status, Affiliate "R" subclass, Non-Member "M" subclass,
Response - Text Field (Searchable);