title: Database Design For Restaurant Menu
body: <p>I am trying to develop an admin panel for a coffee shop.
  I want to display the menu in a systematic manner.
  Example For Coffee- Espresso, Latte ... so on.
  Sandwiches - Northern lights , mumbai sandwich and soo on..
  I want to give the admin the right to add new category say Burgers and under that the types of burgers available.
  I am struggling to find the correct solution for this system.
  Right now i have on table </p>
  
  <pre><code>Menu
  CategoryId int(50),
  ParentId int(50),
  Name varchar(100)
  </code></pre>
  
  <p>I am able to display the menu on the front end like i want</p>
  
  <p><a href="https://i.stack.imgur.com/wjD0U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wjD0U.png" alt="like this"></a></p>
  
  <p>But i cannot figure out a way to make the admin add new categories without disrupting the database design</p>