[Koha-devel] Patron attributes tables

[Galen Charlton]

Hi,

On Tue, Oct 21, 2008 at 9:19 AM, Owen Leonard <oleonard at myacpl.org> wrote:
> I would think there should be an auto-incrementing numeric id in the
> borrower_attribute_types table for each code which would get entered
> into the borrower_attributes table. Then you could freely edit
> "code"'s value without having to worry about updating every line in
> borrower_attributes.

code is the primary key of borrower_attribute_types, and there is a
foreign key relationship between borrower_attributes.code and
borrower_attribute_types.code set up to cascade updates.  This means
that if you change a code value in borrower_attribute_types, the
change will automatically propagate to affected borrower_attributes
rows.  I believe the user interface currently prevents one from
changing the code, but I did that mostly to avoid having to handle
several error reporting scenarios.

Regards,

Galen
-- 
Galen Charlton
VP, Research & Development, LibLime
galen.charlton at liblime.com
p: 1-888-564-2457 x709
skype: gmcharlt