Find Jobs
Hire Freelancers

Create a simple database - sqlite

$10-30 CAD

已取消
已发布大约 10 年前

$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 年前

想赚点钱吗?

在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
会员自4月 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)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。