Web Database

Build a reporting website.

Database Tables (Users, Cities, Departments, Reports, Report_Types, City_Report_Type)

Users will be able to create and manage user profiles (User_ID, Name, Address, City, State, Zip, Phone, Email, UserName, User_Type, User_Notification_Type )


The site admin user will manage the creation of cities, and each city user or the admin user will be able to create departments that are linked to the city.

The Admin, City Admin, or Department Admin user will manage the Department profile.

Cities (City_ID, User_ID, Name, Address, City, State, Zip, Phone, Email, City_Lat, City_Long, City_Description, City_Mayor, City_Logo) and

Departments (Department_ID, City_ID, User_ID, Department_Name, Department_Address, Department_City, Department_State, Department_Zip, Department_Phone, Department_Email, Department_Logo, Department_Type, Department_Status, Department_Rating, Department_Response_Time, Department_Notification_Type)

Report_Types (Report_Type_ID, Report_Type_Label, Report_Type_Description, Report_Type_Icon)

Report (Report_ID, Report_Department_ID, Report_User_ID, Report_Title, Report_Comments, Report_Create_Date(TimeStamp), Report_Type, Report_Status, Report_Lat, Report_Long, Report_Address, Report_City, Report_State, Report_Zip, Report_Action_Desired, Report_Public)

Anyone will be able to create a report by fill out a form that has the City information based on the location of the report, and the Department will be populated by a pull down list of report types (Street issues will be delivered to the Streets Department etc.) The user can make his post public or private, and it will be listed in the control panel for the Department that the report type goes to. The user will be able to use IOS6 to upload photos, and use the Map function to enter the lat/long of the report by clicking on the map if he has a device with a GPS, and if not, he will be able to use Google Maps to drop a pin where the location is, or enter in the address of the report.

User can upload Photo, location, comments, title, report type of the report. (IOS6 FILE UPLOAD)

The user will be able (if he creates a user profile) to list/edit/update/delete reports in a table that he has reported. They will be color coded based on the status of each report. If the status of a report is changed by the department user, the reporting user will be notified by email if he so wishes.

This site is a way for the public to post reports about things that matter in a city. There will be many cities, and each city will have many departments, Each department will have a report type associated with it.

Beceriler: MySQL, PHP

Daha fazlasını gör: mysql city state database, google web creation, web database, pin down, lat long, google map creation, build a website public database, report mysql php database, mysql edit database, drop list database, edit user profile php mysql, state city website drop, mysql function update, delete mysql tables, create report database php, control pin, google maps panel, mysql delete mysql database tables, GPS Function, mysql web admin, mysql create database user, mysql update function, mysql update database, post timestamp, location reporting database

İşveren Hakkında:
( 31 değerlendirme ) United States

Proje NO: #4390108



This seems like an interesting website. I am build it with good quality and as per your expectations. We can discuss more features once the basic required infrastructure is in place.

%selectedBids___i_period_sub_7% gün içinde 180%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(29 Değerlendirme)

3 freelancers are bidding on average $282 for this job


Hi, please check your pmb

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)

Hi . i'm a web developer with more than 5 years experience in this field. i'm ready to start if you're interested !

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

I am really willing to do this project.

in %bids___i_period_sub_35% gün içinde165%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)