Find Jobs
Hire Freelancers

Write some Software

$30-250 USD

Cancelado
Publicado hace más de 9 años

$30-250 USD

Pagado a la entrega
I need you to develop a simple database in PostgreSQL 9.3 for a massage reservation system. The result of this project should ONLY be a PostgreSQL database SCHEMA with at least 20 rows for main tables and a couple of SQL QUERIES as outlined below. No additional software is required Database is required for the software system which allows user to select a date, a massage type, a masseur (from the ones who are available on that date) and pick a 20-minutes long time-slot (not reserved by another user) Specific tasks: 1. Database schema should contain some or all of the following tables: user, massage type, masseur, reservations, time-slots(predefined, ranging from 9:00 to 17:00 with 20 minutes interval) 2. I need the following SQL queries for this database: - mark masseur available/unavailable on a specific day - for the purpose of making a reservation: find a matrix of available masseurs (marked as available), massage types they can perform, and their open timeslots (20 minutes each) on specific date between start and end time. Considering the following input: (date, massage-type, startTime, endTime) I need the output to look like this: (John, 'chair, swedish', (9:00, 9:20, 9:40, 10:00)), (Barabara: 'shiatsu, chair', (9:00, 10:20)) etc. The output should only list time slots not already taken by other user. If there are no open time slots for some masseur, don't return it in the result - for a specific date and a masseur, find all his appointments. I.e., provided the following input: (masseur-name, date) get the following output: (9:00, 13:00) - mark reservation as cancelled - get all reservations starting in the next 30 minutes. The result should contain: masseur-name, massage-type, user-name and start time - Find all past reservation of a user - find all future reservation of a user - find all past reservations of a masseur - final all future reservations of a masseur This task is time sensitive, I expect it to require not more that 3-4 days to complete. If you can't complete it in that timeframe, please don't apply. To make sure, you read all of the above, please put a word GONDOLA at the beginning of your message. Let me know if something is unclear Thank you
ID del proyecto: 6596626

Información sobre el proyecto

Proyecto remoto
Activo hace 9 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

Sobre este cliente

Bandera de UKRAINE
Kharkiv, Ukraine
5,0
3
Forma de pago verificada
Miembro desde ene 7, 2010

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.