how do I use Time in a booking system? (MYSQL)
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 2 of 2

Thread: how do I use Time in a booking system? (MYSQL)

Hybrid View

  1. #1
    Join Date
    Jan 2010

    Question how do I use Time in a booking system? (MYSQL)

    Hi this is my first computing project for A-levels to create database for a website which allows me to book salon appointments, (using phpmyadmin)

    each customer is registered and can book apointments on when to have there appointment and by which salon specialist, although one salon specialist(staff)can only serve one customer at a time.

    *** for example betty books a a appointment at 9:30am-10:00am with staff member cathrine

    so the tables I have are:

    Customer, Staff, Booking
    Customer: CustomerID (P), password, fname, sname

    Staff: StaffID (P), fanme, sname

    Booking: BookingID (P), CustomerID, StaffID, ???BookingTime???

    ^Does this look ok? I really don't know how time would work in this table with mysql, would it be better to have time as a seperate table or to have time start and end for each staff member?

    major thanks for replies

  2. #2
    Join Date
    Sep 2008

    Re: how do I use Time in a booking system? (MYSQL)

    I would create 2 colomns, starttime and endtime, both DateTime

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

This is a survey!

HTML5 Development Center