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
Skills Required
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