> Separating makes searching/indexing on last name easier. What do you mean "las... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		henrikschroder on April 8, 2020 \| parent \| context \| favorite \| on: A humble guide to database schema design > Separating makes searching/indexing on last name easier. What do you mean "last name"? If you have two last names, then what? If you have no last name, then what? > Keeping them separate inevitably results in a convention to put company names in the last name field for corporations If you only have a single field for name, this problem disappears.

codr7 on April 8, 2020 [–]

I mean everything but the first name.

Yes, but then you have to deal with the indexing/search problem instead.

henrikschroder on April 8, 2020 | [–]

Yeah, but if you only have one last name field, you can only index on people's first last name, not their second last name? How are you going to solve that?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact