Skip to main content
Inspiring
Mar 6, 2023 4:17 AM UTC
Question

Need to add multiple phone numbers.. on screen and want to store in DB .. what could be the best approach

Need to add multiple phone numbers.. on screen  and want to store in DB .. what could be the best approach

6 replies

harshitb6843
Brainy
Mar 6, 2023 5:26 AM UTC

Use a one-to-many relationship with your main table. The main table will hold the ID of the person/entity and then another table will hold the primary key of your main table where you will have multiple rows, one for each phone number, having the same personID. 

Hope that helps!

Inspiring
Mar 6, 2023 11:38 PM UTC

yea frm DB side i am also thinking to do the same .. to maintain normalization