The data input is also another issue, but it seems designing a form of some sort wouldn't be impossible. Since reading your post I've come up with this where + is a foreign key; restaurant names and addresses would go into the existing "sources" table:

meals:

  • mealid
    + time    ofday
    + order    style (à la carte, set menu)

  • order_description (i.e. name of the set menu)

  • bill_currency
  • bill_value

meals_courses:

  • meal_id

  • course_number
    + course_type

  • course_description

  • coursenotes
    + wine    key (links to table "wines")

  • winepairingnotes

course_types: main, amuse-bouche, hors d'œuvre

Not easy.
//

2017-02-11T13:42:49Z