List of things, which in turn have properties

[lutl88]

I have this Table called User. 

User have a list of Interests. I intend to have each Interest have an intensity level - that can be an integer. How do I program it? 

Thanks

[deemuss]

Hello!

In my opinion it is a good idea to have a lookup table for such cases: it is simple to set up and it is really scalable: you can add or remove some entries without need to review all the data. Try using Relationships for that: https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/

Once you set up the database relationships, it will be possible to use readable values, but store numbers in the table.

[lutl88]

So does that mean in the User ID Table, I would have to have multiple entries for just one user? (See example below)

But then the problem would be, I would have to make User Name and User Email non-unique. 

How do I then prevent duplicate users from registering?