MySQL DB & Web Administration Console

CLOSED
Bids
20
Avg Bid (EUR)
481
Project Budget (EUR)
€30 - €250

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

Skills required:
HTML5, MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


€ 489
in 15 days
€ 421
in 9 days
Hire rajeshsonisl
€ 1030
in 5 days
€ 320
in 8 days
€ 421
in 7 days
€ 515
in 15 days
€ 1250
in 30 days
€ 500
in 10 days
Hire adelline
€ 500
in 14 days
€ 492
in 365 days