[Health-dev] [bug #46009] Make specialty field required and cascade in hp_specialty

[Marc DM]

URL:
  <http://savannah.gnu.org/bugs/?46009>

                 Summary: Make specialty field required and cascade in
hp_specialty
                 Project: GNU Health
            Submitted by: marcdm
            Submitted on: Sun 20 Sep 2015 16:32:29 GMT
                Category: Programming / Tracebacks
                Severity: 3 - Normal
              Item Group: None
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                 Release: None
                  Module: health

    _______________________________________________________

Details:

The specialty field is optional on HealthProfessionalSpecialty. This can lead
to accidental records with this value as null. This causes an error in the
display and makes all other specialties of this HealthProf show blank.

It also causes the "Specialties by health professional" report to generate an
error and come up blank.

To reproduce the error, click the icon to add a specialty for a Health
Professional. Then just click Ok without selecting a specialty. Then save the
health professional. The same will happen if you select one, then click "New"
then Ok.

The patch attached makes both the name and specialty fields required and
ondelete='CASCADE'.

It also introduces a constraint that makes name + specialty unique. This is
done so the same specialty cannot be selected twice.





    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Sun 20 Sep 2015 16:32:29 GMT  Name: hp_specialty-001.patch  Size: 1kB  
By: marcdm

<http://savannah.gnu.org/bugs/download.php?file_id=34938>

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?46009>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/