Find Jobs
Hire Freelancers

Create a simple database - sqlite

$10-30 CAD

Cancelado
Publicado hace alrededor de 10 años

$10-30 CAD

Pagado a la entrega
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 del proyecto: 5723624

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
4 freelancers están ofertando un promedio de $206 CAD por este trabajo
Avatar del usuario
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 en 2 días
5,0 (511 comentarios)
7,5
7,5
Avatar del usuario
Greetings i am ready to develop database in sqlite as per your requirments Thanks
$33 CAD en 1 día
4,8 (28 comentarios)
4,8
4,8
Avatar del usuario
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 en 2 días
5,0 (4 comentarios)
3,4
3,4
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
0,8
0,8

Sobre este cliente

Bandera de CANADA
Toronto, Canada
5,0
3
Miembro desde abr 11, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.