http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10603 Bug ID: 10603 Summary: required fields in the courses table should be not null Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Course reserves Assignee: koha-bugs@lists.koha-community.org Reporter: gmcharlt@gmail.com QA Contact: testopia@bugs.koha-community.org There are three fields in the courses table that the UI marks as required: - department - course number - course name However, the corresponding columns in all three of these tables are nullable. If these must be required for reasons of business logic, the columns should be not null. Of course, it's not quite clear if all three of these columns are actually required. Making course name required makes sense, but I'm not sure if making the department and course number required is baking in an assumption about how all academic institutions organize their course lists. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.