The best way to maintain data integrity is to separate the known/unknown into a separate column. The reason is that the concept of known/unknown is not the same as the concept of a writer's proper name, and therefore needs to be a separate field.
Especially since you want to use unknown as a choice for name, moving their status to a separate flag column will give you maximum flexibility for the future, as well as aggregability.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
branchandroot
(no subject)
Date: 2017-09-17 04:31 am (UTC)Especially since you want to use unknown as a choice for name, moving their status to a separate flag column will give you maximum flexibility for the future, as well as aggregability.