You have chosen to sponsor your bid up to a maximum amount of .
I guess this is something simle for someone who is a bit experienced. Firstly I ll say what is my target with this and then what I am asking for. My target is to make a simple web based application and put it up on the internet so that a doctor will access it and add his customers, scheduled appointments and follow up for these appointments.The web files for this will be uploaded from me (I have the server background ready,) and I will also run the sql code for creating the database tables on a Mysql db that I will create on my server. What you need to do is:
a) Create 3 database tables:
1)Customers (Customer_ID=numeric-the table primary key), (Name&Surname=text), (Date of birth=date),(AMKA=numeric), (Phone=numeric), (Mobile=numeric), (Street & number = text), (City=text), (Email= text), (Main Comments = text)
From the above only Customer_ID will is not allowed to be empty will submiting a new customer
2)Appointments (Appointment_ID =numeric-the table primary key) (Date = date), (Customer_ID= taken automatically when the user will pick the customer), (Comments = text), (Done = binary) , (Cancelled=binary)
3)Medical history (Medical_history_ID =numeric-the table primary key)( Customer_ID = taken automatically when the user will pick the customer) , (Comments=text)
Create the below web pages:
It will have 3 buttons - "Customers" , "Appointments" , "Quich search"
When the user clicks on "Customers" it will open a page that will have a search field so that the user will be able to search for customers using all the fields found in "Customers" table. It will also have a button "add customer" so that he will be able to add customer.
The search results will give a catalogue with customers and the user will be able to click next to their name the buttons: "review". After this he will go into the customers page where he will be able to click and see all the appointments history and also medical history (using data from the tables mentioned above).
When the user clicks on "Appointments" he will be able to search for Appointments from the search field (using all the fields from the appointments tabel)
It will also have a button "add appointment" so that he will be able to add appointment.
The search results will give a catalogue with appointments and the user will be able to click next to them the button: "review". After this he will go into the appointment page where he will be able to click and right down comments about the appointment, make it "done" , cancel it, change its date etc. (using data from the tables mentioned above).
This is it! I will also provide some mockups regarding the above. The layout will be the simplest possible.If someone believes that he could make this using some other tool rather than php and mysql I could listen to any suggestion.
Additional Project Description:
09/08/2013 at 1:46 IST
We will need one more table in the database, that will store only one variable. It will be : Password_table , with only one field: "password" ---> text. In there I will put a password and the user would have to insert that specific password in a simple authentication page before entering the programm. The user will not be able to change the password. Also there will not be a "sign in" button. Only one password will exist for everyone. I will only know the password and in order to reset it I will do this directly from the database.
I also attach the mockups, please review them and provide your bids.