Closed

MySQL DB & Web Administration Console

The project consists on creation od MySQL DB and web administration console that will allow, on future the design of a restaurants and their menus directory site frontend. This is just for DB & WEB Console, however we pretend to delire the next phase (site frontend) to the same team.

MySQL DB Tables (Definition of the database structure. This should be analysed and in order to obtain the best structure keeping in mind growth possibilities and scalability).

USERS

User Code

User Type Code

Name

VAT Number

Mobile | Telephone

Email

Address

Postal Code

State

Country Code

Coordinates

USERS TYPE

User Type Code

Description

SUPPLIERS (Restaurants)

Supplier Code

Suplier Name

VAT Number

Suplier Type Code

SHOPS (Suppliers)

Shop Code

Shop Name

Suplier Code

Contact Telephone

Email

Address

Postal Code

State

Country Code

Web

Coordinates

USERS-SHOP

User Code

Shop Code

POSTAL CODES

Postal Code

Description

STATES

State Code

State Name

Countries

Country Code

Country Name

PRODUCTS (Meals)

Product Code

Product Name

Shop Code

Availability (Y/N)

Begin Date

End Date

Price

INGREDIENTS

Ingredient code

Ingredient Name

Calories

PRODUCTS-INGREDIENTS

Product Code

Ingredient Code

Optional (Y/N)

Default (Y/N)

ORDERS

Order Code

Client Code

Shop Code

Order Date

Delivery Date

Total Price

ORDERS-PRODUCTS

Order Code

Product Code

Ingredient Code

Quantity

Price

Status

SUPPLIERS TYPE

Suplier Type Code

Description

WEB Administration Console options

The administration console goal is to allow users, mostly supliers, to manage their menus, shops and orders. The main operations are the following:

The administration console welcome screen should be composed by 2 comuns: Orders (fifo ordering) and Products (according to user shop and in a week list ordering).

Administration Menu

Manage Users

Manage Supliers

Manage Shops

Manage Countries, States and Postal Codes

Manage Products

Manage Orders

Manage Ingredients

Supliers Menu

Manage Shops (Only Shops Assingned to Suplier)

Manage Products (Only Products Assigned to Shop)

Manage Orders (Only Orders Assigned to Shop)

Add Ingredients

User Menu

Manage Personal Information

Skills: HTML5, MySQL, PHP

See more: web shop best design, web shop 2014 best design, the best web design 2014, the best contact design in web site, restaurants best web site, mysql db, manage client information, fifo administration, code web, best web menu, best restaurants web design, best design web shop, web design for shops, best web design 2014, web administration, personal growth, FIFO, email administration, console c, code web php, c# console, administration, project product description shop, fifo project, order number mysql

About the Employer:
( 6 reviews ) Povoa de Varzim, Portugal

Project ID: #5404206

15 freelancers are bidding on average €533 for this job

buraqtech

1. Crowd Funding Site In these days we are already near to finish a full CMS based crowd funding site which is a clone of kickstarter but we implemented many unique features in this project to distinguish it from kic More

€489 EUR in 15 days
(86 Reviews)
7.9
itcslive

Dear sir, At first we like to say that we are a very experienced in programming languages ( php & mysql, ajax, JS, curl ) and expert in making custom cms with php script and can customize all major CMS like(joomla,w More

€421 EUR in 9 days
(118 Reviews)
7.5
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

€1030 EUR in 5 days
(481 Reviews)
7.4
Infenixwebs

Hi, I have experience in web projects, if you check my reviews you will see that I have gotten excellent results from other employers, should you have any questions, please do not hesitate to contact me, thanks!

€320 EUR in 8 days
(69 Reviews)
6.7
AcuityInfotech

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution.    We are a professional development company headquartered in Virginia and have more than 900 jobs under o More

€421 EUR in 7 days
(26 Reviews)
6.7
sainathkohta

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget More

€515 EUR in 15 days
(40 Reviews)
6.6
ranganathp

Can help... I am an Expert... Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... More

€1250 EUR in 30 days
(30 Reviews)
6.3
mindprogram

Hi. I have done a few projects like this before. I can show you live examples. I have a few doubts - 1. In the Manage Users, Manage Suppliers etc, the functions will be Create User, Delete User, Edit User? 2. Wil More

€500 EUR in 10 days
(41 Reviews)
6.1
adelline

Hello, I have experience developing PHP&MySQL administration interface and I would be interested to work on your restaurants administration system. Your tables structure and interface options description is prett More

€500 EUR in 14 days
(66 Reviews)
5.5
eComOS

Dear sir, I will complete your project within 9 days and provide ONE YEAR free bug guarantee.. I have gone through your outsourced requirement "MySQL DB & Web Administration Console" and have analyzed that I hav More

€492 EUR in 365 days
(66 Reviews)
5.5
elboukharimu

Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfol More

€368 EUR in 12 days
(20 Reviews)
4.8
pointcode

Hello, Greetings from geniuskline webtech solutions pvt ltd. !!! Following are our past work, have a look. [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] More

€515 EUR in 15 days
(15 Reviews)
4.2
hossainjamil

I'm ready to start now... I'm highly experienced in html5,css3,php,mysql,jquery. I'm confident about this project. Must complete it within next 7 days after hiring. I'll do this for €166.00. if you hire me, I'll do More

€166 EUR in 7 days
(5 Reviews)
3.7
nf4code

Hello hmbsantos, I am very experienced in PHP and MySQL. I am also experienced in HTML and CSS. I have built a simple accounting website that has very similar features in its back-end as your requirements. It had u More

€180 EUR in 7 days
(8 Reviews)
2.9
shukaibzafar

Hello Hiring Manager! i have done graduation in computer science and can easily design big databases for large scale applications. i have an experience of 4+ years in web designing and web development and have been d More

€250 EUR in 15 days
(6 Reviews)
3.0
avalanworld

Hello Sir, We can do your project. We are very good team with very good experience of more then 2 years in PHP,HTML5,MySQL,CSS,J-Query,AJAX,JavaScript,PSD to HTML etc.. We ensure that we will complete your projec More

€188 EUR in 10 days
(10 Reviews)
2.1
deepakgoyal92

A proposal has not yet been provided

€206 EUR in 3 days
(3 Reviews)
1.5
ktech2016

Online web Designing & Web Development Expert in AJAX ,PHP/MySql,Codeignitor,Cake php, ASP.NET,dot net framework more than 12 years working experience along with online promotion and Search Engine optimization Som More

€247 EUR in 13 days
(0 Reviews)
0.0
mohdirshadq

Hi, Lets Start ! Are you looking Good Work on your Budget ?? I can do this task as I have similar work [url removed, login to view] me so that I show you similar work done. And Award me So that i can show you my best work to you More

€226 EUR in 3 days
(0 Reviews)
0.0
CREAZ

I can do it for you . We can discuss about that on Skype or other chat . Regards, CREAZ . Web Agency (php/JS)

€1333 EUR in 20 days
(0 Reviews)
0.0