Re: appointments availability
Posted by: Dimitris Papageorgiou
Date: November 13, 2015 10:18AM

Dimitris Papageorgiou Wrote:
-------------------------------------------------------
> Peter Brawley Wrote:
> --------------------------------------------------
> -----
> > dates:times is 1:many
>
> >
> > dates(date date pk)
> >
> > times(time time pk)
>
> I am going to focus on the above as some questions
> arise.
>
> First of all the above design...with 2
> tables...comes in contrast with this
> http://www.artfulsoftware.com/infotree/qrytip.php?
> id=98 where there is one dates table(with 2
> columns).
>
> Second.I assume the times table stores the format
> like this:12:00:00 and it has one column...time.
>
> How am I going to connect these two...don't we
> need additional columns.Just show me an example to
> understand better...

Will there be a foreign key between the dates and the times table?

Options: ReplyQuote


Subject
Written By
Posted
November 02, 2015 01:52PM
November 03, 2015 10:59AM
November 03, 2015 01:14PM
November 11, 2015 11:33AM
November 12, 2015 03:50PM
Re: appointments availability
November 13, 2015 10:18AM
November 13, 2015 12:21PM
November 16, 2015 12:38PM
November 17, 2015 12:15PM
November 18, 2015 04:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.