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.
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
On Fri, 20 May 2011 09:48:45 -0500,
Jack Christensen ja...@hylesanderson.edu 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
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 haven't
On 5/20/2011 10:15 AM, Seb wrote:
On Fri, 20 May 2011 09:48:45 -0500,
Jack Christensenja...@hylesanderson.edu 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
On Fri, 20 May 2011 12:08:34 -0400,
Andrew Sullivan a...@crankycanuck.ca 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).
On Fri, 20 May 2011 11:37:36 -0500,
Jack Christensen ja...@hylesanderson.edu 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