(Menu) Category by jayt137

VIEWS: 11 PAGES: 7

									(Menu) Category
             Field 1       Field 2                   Field 3          Field 4          Field 5
Field name   Cat_ID        Cat_Name                  Cat_Image        Cat_Active       ParentID
Row 1        C1            Appetizer                                                               -1
Row 2        C2            Fresh From the Garden                                                   -1
Row 3        C3            Finger Foods                                                            -1
Row 4        C4            12" Pizza                                                               -1
Row 5        C5            Wraps                                                                   -1
             Comments:     Comments:                 Comments:        Comments:        Comments:
             This is the   This is the name of the   This is the      Note: By         If the
             Unique        Category on the front     image file       default all 5    Category is a
             Identifier    end of the site.          associated       sample           Main
             Number of                               with the         Categories       Category
             the category.                           Category.        will be made     (Lunch,
                                                     The image        active           Diner) enter
                                                     must be a        (appear on       -1. For a sub-
                                                     .gif or .jpg,    the front end)   category,
                                                     and will be                       please enter
                                                     displayed on                      a Category's
                                                     the front end.                    Unique
                                                                                       Identifier
                                                                                       Number.


             Functional Description:
             This table describes the Category and Sub Category structure of the Menu items. All main Categories will have a Unique Identifier Number (field
             1), and a ParentID value of -1 (to indicate no Parent Category above it). All Sub-Categories will have a Unique Identifier Number, and a Parent ID
             value of the Cat_ID of the Category which it is a direct sub-category of.




                                                                                                                                             FD Version 1.0
         (Menu) Category

         Field name
         Row 1
         Row 2
         Row 3
         Row 4
         Row 5




           r Number (field
                        This table describes the Category and Sub Category structure of the Menu items. All main Categories will have a Unique Identi
er Number, and a Parent ID
                        1
                        value of the Cat_ID of the Category which it is a direct sub




                                                                                                                                                        FD Version 1.0
Menu
             Field 1       Field 2        Field 3         Field 4              Field 5      Field 6            Field 7        Field 8
                                          Menu_Descriptio                                                      Menu_Special
Field name   Menu_ID       Menu_Name      n               Menu_Price           Menu_Image   Menu_TakeOut       Day            Cat_ID
                                          Marinated
                                          Brushetta Mix
                                          served on
                                          Vienna Bread
                                          with Marble
Row 1                     1 Bruschetta    Cheese                       $3.99                               0                  C1
                                          Fresh Iceberg
                                          Lettuce and
                                          Vegetables.
                                          Served with
                                          Dressing of
Row 2                    12 House Salad   Your Choice.                 $3.75                               0                  C2


                                          Crispy Nachos
                                          Covered with
                                          Marble Cheese.
                                          Served with
                            Nachos &      Salsa and Sour
Row 3                    15 Cheese        Cream.                       $6.50                               0                  C3
                                          Topped with
                                          Pepperoni and
                                          Mozezarella
Row 4                    21 Pepperoni     Cheese.                      $6.75                               0                  C4
                                          Tortilla Shell
                                          Filled with
                                          Breast of
                                          Chicken,
                                          Tomatoes,
                                          Onions, Marble
                                          Cheese and
Row 5                    26 Chicken       Salsa.                       $5.95                               0                  C5
             Comments:      Comments:     Comments:        Comments:           Comments:    Comments:          Comments:      Comments:
Enter a        This is the     This is the     This is the     This is the       0 = Available 1 = Monday        Enter the
Unique         name which      description     Price of the    image file        as Take out    2 = Tuesday      Unique
Identifier     will be         for the menu    menu item. It   associated        1 = Not                         Identifier
Number for     displayed for   item. It is     is displayed    with the          Avialable for 3=Wednesda        Number
each Item on   this menu       displayed in    in the front    item. It must     Take Out      y 4=              from the
the Menu.      item on the     the front end   end on the      be in a .gif or                 Thursday 5        Category
               front end on    on the item     item details    .jpg format.                    = Friday      6   Table for the
               the item list   details page.   page.           It is                           = Saturday        Category or
               page.                                           displayed in                    7 = Sunday        Sub
                                                               the front end                        Enter        Category
                                                               on the item                     the number        that this item
                                                               details page.                   of the day        is associated
                                                                                               that this item    with.
                                                                                               is featured
Functional Description:
WineCat
             Field 1       Field 2         Field 3         Field 4          Field 5

Field name   WineCat_ID    WineCat_Name WineCat_Image WineCat_Active ParentID
Row 1        w1            Beer
Row 2        w2            Soda
Row 3        w3            Juice
Row 4        w4            Coffee
Row 5        w5            Tea
             Comments:     Comments:       Comments:       Comments:        Comments:
             This is the   This is the     This is the     Note: By         If the
             Unique        displayed       image file      default all 5    Category is a
             Identifier    name of the     associated      sample           Main
             Number of     Wine            with the        Categories       Category
             the Wine      Category on     Wine            will be made     (Red, White)
             category.     the Wine List   Category.       active.          enter -1.
                           page.           The image       These            For a sub-
                                           must be a       appear on        category,
                                           .gif or .jpg,   the front end.   please enter
                                           and will be                      a Category's
                                           displayed on                     Unique
                                           the Wine List                    Identifier
                                           page.                            Number.


             Functional Description:
WineList
             Field 1        Field 2         Field 3           Field 4           Field 5           Field 6           Field 7            Field 8          Field 9

Field name   WineList_ID    WineList_Name   WineList_Year     WineList_Color    WineList_Country WineList_Size      WineList_Price     WineList_Image   WineCat_ID
Row 1                       Labatt's Blue                                                                           $          5.25                     w1
Row 2                       Coca-Cola                                                                               $          1.50                     w2
Row 3                       Orange Juice                                                                                       $1.50                    w3
Row 4                       Coffee Decaf                                                                            $          1.75                     w4
Row 5                       Earl Grey Tea                                                                           $         1.25                      w5
             Comments:      Comments:       Comments:         Comments:         Comments:         Comments:         Comments:      Comments:            Comments:
             This is the    This is the     This is the       This is the       This is the       This is the       This is the        This is the      Enter the
             Unique         displayed       Year              colour            country           size              Price              image file       Unique
             Identifier     name of the     information       information       information       information       information        associated       Identifier
             Number of      Wine Item on    for the item.     for the item.     for the item.     for the item.     for the item.      with the Wine    Number from
             the Wine       the Wine List   It is displayed   It is displayed   It is displayed   It is displayed   It is displayed    Item. The        the Wine
             item.          page.           on the Wine       on the Wine       on the Wine       on the Wine       on the Wine        image must       Category
                                            Details page.     Details page.     Details page.     Details page.     Details page.      be a .gif or     Table for the
                                                                                                                                       .jpg, and will   Category or
                                                                                                                                       be displayed     Sub Category
                                                                                                                                       on the Wine      that this item
                                                                                                                                       details page.    is associated
                                                                                                                                                        with.



             Functional Description:
WineList


Field name
Row 1
Row 2
Row 3
Row 4
Row 5

								
To top