Re: [Koha-devel] Constraints on issues tables

2008-10-16 Thread Paul POULAIN
Galen Charlton a écrit : > Hi, > > I've found at least one Koha database that has multiple issues rows > for the same item but different patrons. This doesn't map well to the > reality of loaning physical items, unless somebody's slipped in a Star > Trek-style replicator feature, so I propose the

Re: [Koha-devel] Constraints on issues tables

2008-10-15 Thread Chris Nighswonger
On Wed, Oct 15, 2008 at 6:37 PM, Galen Charlton <[EMAIL PROTECTED]> wrote: > Hi, > > I've found at least one Koha database that has multiple issues rows > for the same item but different patrons. This doesn't map well to the > reality of loaning physical items, unless somebody's slipped in a Star

Re: [Koha-devel] Constraints on issues tables

2008-10-15 Thread Ryan Higgins
++ here. I would suggest going just a bit further: let's fix the other columns in the table while we're there. * what is the difference between branchcode and issuingbranch ? A transaction can only happen at one location, so that should be NOT NULL and the other should be removed. issues.retu

Re: [Koha-devel] Constraints on issues tables

2008-10-15 Thread Galen Charlton
Hi, On Wed, Oct 15, 2008 at 7:12 PM, Chris Cormack <[EMAIL PROTECTED]> wrote: > Does the issues table now only contain current issues? > Ie no history of past issues Past issues were moved to old_issues a while back, so the reading history is still retained until purged or anonymized. Regards,

Re: [Koha-devel] Constraints on issues tables

2008-10-15 Thread Chris Cormack
Hi Galen Does the issues table now only contain current issues? Ie no history of past issues How do we find out a borrowers reading history then? (People in NZ like this feature a lot, especially places like retirement homes so the library doesnt send them the same books all the time) Im hoping

Re: [Koha-devel] Constraints on issues tables

2008-10-15 Thread Joe Atzberger
All sound good to me. On Wed, Oct 15, 2008 at 6:37 PM, Galen Charlton <[EMAIL PROTECTED]>wrote: > Hi, > > I've found at least one Koha database that has multiple issues rows > for the same item but different patrons. This doesn't map well to the > reality of loaning physical items, unless somebo

[Koha-devel] Constraints on issues tables

2008-10-15 Thread Galen Charlton
Hi, I've found at least one Koha database that has multiple issues rows for the same item but different patrons. This doesn't map well to the reality of loaning physical items, unless somebody's slipped in a Star Trek-style replicator feature, so I propose the following changes to constraints on