Skip to main content
Inspiring
March 6, 2023
Question

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

  • March 6, 2023
  • 6 replies
  • 3 views

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

6 replies

harshitb6843
Brainy
March 6, 2023

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
March 6, 2023

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