News for hackers. Stuff that matters.
Re:You Win, Broken Database Schemas by adoxyz on Monday January 10, 2022 @07:39PM (#29885408)
I think full_name or just name would be sufficient. And optionally allow given_name, middle_name, family_name if you really need it/want it for some purpose.

But for a lot of common use cases, there's really no need to separate first and last name in a database imo.

Re:You Win, Broken Database Schemas by oogetyboogety on Monday January 10, 2022 @07:47PM (#29885494)
These names follow with schema.org attributes. https://schema.org/givenName ( first ) https://schema.org/additionalName ( middle or alias ) https://schema.org/familyName ( last )
Re:You Win, Broken Database Schemas by sokoloff on Monday January 10, 2022 @08:07PM (#29885690)
I’ve had to have a name field and a sortable name field before:

Name: The Who, Sort_Name: Who