Bug 39150 - Should borrowers.contacttitle be removed?
Summary: Should borrowers.contacttitle be removed?
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-02-17 17:34 UTC by Caroline Cyr La Rose
Modified: 2025-02-17 17:34 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Caroline Cyr La Rose 2025-02-17 17:34:41 UTC
As far as I know, the contacttitle in borrowers is not used anywhere and I'm not sure it is even possible to edit it in the interface. I might be wrong, but this seems like a leftover from when guarantors were stored directly in the borrowers table?

To recreate:
1. Go to Patrons > New patron > Kid
   --> Under Non-patron guarantor, there is only surname and firstname 
2. Fill out only the mandatory fields and the Non-patron guarantor fields
3. Save the new patron
4. In the database, view the record for this patron

   `select * from borrowers where borrowernumber = 54 \G;`

   --> Only contactname, contactfirstname and relationship are filled out
   --> contacttitle is NULL

MariaDB [koha_kohadev]> select * from borrowers where borrowernumber = 54 \G;
*************************** 1. row ***************************
             borrowernumber: 54
                 cardnumber: q
                    surname: q
                  firstname: 
             preferred_name: 
                middle_name: 
                      title: 
                 othernames: 
                   initials: 
                   pronouns: 
               streetnumber: 
                 streettype: NULL
                    address: 
                   address2: 
                       city: 
                      state: 
                    zipcode: 
                    country: 
                      email: 
                      phone: 
                     mobile: 
                        fax: 
                   emailpro: 
                   phonepro: 
             B_streetnumber: 
               B_streettype: NULL
                  B_address: 
                 B_address2: 
                     B_city: 
                    B_state: 
                  B_zipcode: 
                  B_country: 
                    B_email: 
                    B_phone: 
                dateofbirth: NULL
                 branchcode: CPL
               categorycode: K
               dateenrolled: 2025-02-17
                 dateexpiry: 2033-05-17
   password_expiration_date: NULL
               date_renewed: NULL
              gonenoaddress: NULL
                       lost: NULL
                   debarred: NULL
            debarredcomment: NULL
                contactname: guarantor surname
           contactfirstname: guarantor firstname
               contacttitle: NULL
              borrowernotes: 
               relationship: father
                        sex: 
                   password: !
                     secret: NULL
                auth_method: password
                      flags: NULL
                     userid: q
                   opacnote: 
                contactnote: 
                      sort1: 
                      sort2: 
        altcontactfirstname: 
          altcontactsurname: 
         altcontactaddress1: 
         altcontactaddress2: 
         altcontactaddress3: 
            altcontactstate: 
          altcontactzipcode: 
          altcontactcountry: 
            altcontactphone: 
             smsalertnumber: NULL
            sms_provider_id: NULL
                    privacy: 1
    privacy_guarantor_fines: 0
privacy_guarantor_checkouts: 0
          checkprevcheckout: inherit
                 updated_on: 2025-02-17 17:31:26
                   lastseen: NULL
                       lang: default
             login_attempts: 0
       overdrive_auth_token: NULL
                 anonymized: 0
        autorenew_checkouts: 1
     primary_contact_method: 
                  protected: 0
1 row in set (0.001 sec)