[Koha-bugs] [Bug 20581] Allow manual selection of custom ILL request statuses

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20581

--- Comment #159 from Andrew Isherwood <andrew.isherwood at ptfs-europe.com> ---
Hmmm, prefixes feels like a hack.

Using a composite primary key as you suggest might be a step in the right
direction. However, as I understand it, to then use that as a foreign key in
other tables would require each table to have a corresponding column for each
of the authorised_values columns that comprise the key.

As an aside, I'm not convinced the category and authorised_value columns do
currently have any unique constraint on them. Looking at the schema, it looks
like category, authorised_value and lib are defined as keys, but I can only
think that was does to create indexes on them as there appears to be no unique
constraints on them.

Definitely worth a discussion I think...

-- 
You are receiving this mail because:
You are watching all bug changes.