On Fri, 20 May 2011 11:37:36 -0500,
Jack Christensen wrote:
[...]
> In a similar project I worked on start time for a loan was always the
> current time so overlaps weren't an issue. I don't have any firsthand
> experience with them, but it sounds like what you want are exclusion
> constraints.
On Fri, 20 May 2011 12:08:34 -0400,
Andrew Sullivan wrote:
[...]
> It could be that your analogy there is a little too simple (library
> management systems' circulation modules are often incredibly
> complicated, because of the different classes of restriction on
> circulation). Nevertheless, t
On 5/20/2011 10:15 AM, Seb wrote:
On Fri, 20 May 2011 09:48:45 -0500,
Jack Christensen wrote:
Use a loans table with unique partial index to ensure that only one
unreturned loan per item can exist at a time.
[...]
Thanks, this certainly avoids loaning an item before it's returned, but
it does
On Fri, May 20, 2011 at 08:41:06AM -0500, Seb wrote:
> Hi,
>
> I'm trying to implementing the checking in and checking out of items in
> a table, whereby an item cannot be checked out if it's not checked-in.
> I've searched for schemas for public libraries where this is a key
> requirement, but ha
On Fri, 20 May 2011 09:48:45 -0500,
Jack Christensen wrote:
> On 5/20/2011 8:41 AM, Seb wrote:
>> Hi,
>> I'm trying to implementing the checking in and checking out of items
>> in a table, whereby an item cannot be checked out if it's not
>> checked-in. I've searched for schemas for public libr
On 5/20/2011 8:41 AM, Seb wrote:
Hi,
I'm trying to implementing the checking in and checking out of items in
a table, whereby an item cannot be checked out if it's not checked-in.
I've searched for schemas for public libraries where this is a key
requirement, but haven't managed to hit the right
Hi,
I'm trying to implementing the checking in and checking out of items in
a table, whereby an item cannot be checked out if it's not checked-in.
I've searched for schemas for public libraries where this is a key
requirement, but haven't managed to hit the right keywords to get
relevant results.
