Find Jobs
Hire Freelancers

Create a simple database - sqlite

$10-30 CAD

Скасований
Опублікований about 10 years ago

$10-30 CAD

Оплачується при отриманні
Please make a database for a sample menu. The instructions are below. Please make it as if it were a real database with the start time and end time or duration etc. Database Menus - Every menu (Category) must have at least one sub Category startDate is the time of the day in seconds that the category/sub category is available Duration is how long in seconds it is available from that time Items - About 6-12 items per menu - Items are only added to the sub Categories - At least one or two menus with 24+ items (These can be split across multiple sub categories) - All of the relevant information for the items needs to be filled in (Name, descriptions, price, startdate/duration, refilprice, subid) StartDate - If the item is only to be offered after a certian time (Input the time in seconds from the start of the day) (-1 if always available) Duration - Amount of seconds the item is to be available (-1 if always available) refilprice - (-1) if not refillable subId - Id of the Sub Category that the item belongs to Items will need 3 images Small images - Needs to be called sml_(id in table) Ex (If the id of the item is 5 then the name will be “sml_5” Large Images - Needs to be called lrg_(id in table) Ex (If the id of the item is 5 then the name will be “lrg_5” Nutrition Images - Needs to be called nut_(id in table) Ex (If the id of the item is 5 then the name will be “nut_5” The small images should be around 16/9 to 8/5 (in our case since we will be showing it on my phone use around 640x200 for best results (it might be cropped slightly) The large Images should be around 1280x635 for best results (it might be cropped slightly) Customizations We will also need customizations for the items. These need Name, reduction price, addition price; Reduction and addition prices are only needed if they change the cost of the item when added/removed, otherwise set to 0 The ItemCustomization table is used to link a customization to an item since multiple items can use the same customization Promotions Promotions need start and end date in milliseconds There are multiple websites that can convert such as: [login to view URL] PriceAdjust - This is a percentage Ex: 100 is a 100% price reduction 25 is a 25% price reduction itemPromotions table is used to link promotions with items
ID проекту: 5723624

Про проект

4 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
4 фрілансерів(-и) готові виконати цю роботу у середньому за $206 CAD
Аватарка користувача
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 wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$618 CAD за 2 дні(-в)
5,0 (511 відгуки(-ів))
7,5
7,5
Аватарка користувача
Greetings i am ready to develop database in sqlite as per your requirments Thanks
$33 CAD за 1 день
4,8 (28 відгуки(-ів))
4,8
4,8
Аватарка користувача
Hi - I am a recent graduate with a degree in Computer Science. I have looked at all the websites, and I would love to help you with this project. I have experience using sqLite, PostGres and MySQL databases. Can you clarify - you'd like more than the schema, you'd like an actual database exported filled with made-up information? Additionally, do the images need to be placed in a specific folder, or just named like (sml_5) [although, I am not sure why you would need a database then if you know the naming convention]. Thanks, Tally
$24 CAD за 2 дні(-в)
5,0 (4 відгуки(-ів))
3,4
3,4
Аватарка користувача
I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$20 CAD за 1 день
5,0 (3 відгуки(-ів))
0,8
0,8

Про клієнта

Прапор CANADA
Toronto, Canada
5,0
3
На сайті з квіт. 11, 2013

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.