开发者

sql Database to save different contact details for a message sending site

开发者 https://www.devze.com 2022-12-24 06:38 出处:网络
I am working for a project to create a database f开发者_StackOverflowor saving different persons contact details in SQL.

I am working for a project to create a database f开发者_StackOverflowor saving different persons contact details in SQL. For example, X person saves 10 contacts, Y persons save 15 contacts, z persons save 20 contacts and so on. I cant create separate tables to save contacts of x,y,z and so on. But i just want to know the alternative method to do that. Is there any easy method to save different contacts and is there any easy method to retrieve it. I'm just a student, I don't know much about sql and don't have much experience in this. So I need your help to know much about this.


You need one table of contacts, with a column of user ID.

Another Table of Users (Persons) and a FK between them.

This is better.

0

精彩评论

暂无评论...
验证码 换一张
取 消