I have a table in which I store user's favorite dishes. A user can make more than one entry in the table. I have created a view to show all the entries in the table, but how can I create a view to show the list of users. I do not have any tables to save users, so I have to use DISTINCT to get the names of users of another one table.
Looks like you learn a lot about relational databases, schema designs and data modeling, so this answer can not help much, but it goes here ...
You are a point where you want your schema And users should put them on their desk, then a user_id
field in the Consonant table will have the ID
behind the code that it does related_to
.
Therefore, you will have a user model that is the _may
dish and a dish model that is related_to
with that user you can add that data to the dish table Without making a slightly more complicated question to achieve, users will be able to make a scene more easily.
Comments
Post a Comment