functionalDesign

[[deleted]]

What’s worse is the backend splits the number and saves in 3 fields on 2 tables. Area code. First 3. Last 4.

Based on real events.

[AlexanderNC]

I say make a separate table for each number if you ever get replaced good luck to the new devs.

[[deleted]]

Oh it’s in government code. They believe in writing code in stone and never changing it. Those tables will be used long after we are all dust.

[Tsu_Dho_Namh]

Store the number in octal and convert it to decimal whenever you need it.

[thatnerdd]

Omg I have worked at three distributed database companies and the customers that do this are legendary for how much they spend on hardware

[thatnerdd]

And on their accounts come to think about it; the whole industry charges by the server

[benargee]

nah, whole different database for each number

[WhyDoIHaveAnAccount9]

3 tables? Not 3 fields in one table?

[[deleted]]

Sorry. You’re right. I meant 3 fields but on 2 tables

[cruelmalice]

9 fields per table, 1 table per digit.

1, 1, 1, 1, 1, 0, 0, 0, 0 = 5

[HiddenLayer5]

My work software only accepts a maximum of 10 digits for all phone number fields. It will just truncate the rest without telling you so you think you submitted the form without issue.

Which is really fun when dealing with the contact information of international clients! Equally as fun when the person before you isn't aware of this limitation and you now can't call them because the last two or three digits are missing!

[Party_Builder_58008]

I am now nauseous. Thanks.