On Thu, Apr 15, 2021 at 6:47 AM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
>
> - Boolean is not possible as this is phone number.
>
>
Phone numbers, despite the word "number" in the name, aren't numbers. Use
text for them. Or, in the off chance you truly find the performance hit to
be unacceptable (I doubt this to be the case) use a made-up integer-like
identifier as the PK but then store the actual phone number as a second
text field.
David J.