CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    1

    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
    Location
    Netherlands
    Posts
    865

    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
  •  





Click Here to Expand Forum to Full Width

Featured