Need advice for a small database in SQLite
<p>Im making a simple app for managing food consumption. Im using SQLite and have trouble thinking how the database should be. I was thinking something like this:</p>

<pre><code>Food: foodId(pk),catId(fk), foodName, calories, protein, carbohydrates, fat
Category: catId(pk), catName
Diary: entryId, foodId(fk), catId(fk)
</code></pre>

<p>Im thinking that one category can be assigned to many foods, and many foods can be added to one category. Im not sure about the Diary table, Im thinking you can add a food to the diary and thats it.</p>

<p>Is this a correct way to make the db?</p>