Closed grounded042 closed 8 years ago
an event should have menu options tied to it
menu_items
menu_item_id
fk_event_id
order
name
num_choices
menu_item_options
menu_item_option_id
fk_menu_item_id
description
an event should have menu options tied to it
menu_items
table should be created with the columns:menu_item_id
fk_event_id
- the foreign key of the event the menu belongs toorder
- the numerical place on the menu in which this item appearsname
- the name of the itemnum_choices
- the number of choices for this itemmenu_item_options
table should be created with the columns:menu_item_option_id
fk_menu_item_id
- the foreign key of the menu item to which the option belongs toname
- the name of the optiondescription
- a short description of the option