Closed

MySQL DB & Web Administration Console

This project received 19 bids from talented freelancers with an average bid price of €479 EUR.

Get free quotes for a project like this
Employer working
Project Budget
€30 - €250 EUR
Total Bids
19
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online