posted 11 years ago
I would create a table of users, a table of websites, and a mapping table. The user table has data about the user, and in integer primary key. The website table has a varchar for url, and an integer primary key. The mapping table can be a ManyToMany in JPA, or you can do it manually with an integer primary key, and then two foreign keys, one for users, and one for websites.
Each time you see a totally new website, add a row to the websites table, and add a row to the mapping table.
Each time you see an existing website, you only need to add a row to the mapping table.
Does this make things more clear?