ProductReview Example
From DataFlex Wiki
ProductReview Example page under construction
Introduction
In this example the overall goal is to be able to see what users think about a particular item . As an added benefit - users can also share information about where to buy the particular items.
To accomplish this, then users should be able to:
- login
- choose an item from a list
- enter information about a known item
- supply information about the place where an item was bought.
- supply a rating of an item
- Overview supplied ratings from other users
Data Dictionaries
We want to store information about users, places and known items. The other tables should hold sufficient information about the items and how the users liked them.
The following data dictionaries should now be available:
Address
- Place_id
- Name
- StreetAddress
- City
- ZIPCode
- Longitude
- latitude
User
- User_id
- LoginName
- FirstName
- LastName
- EmailAddress
- Address_id
- Rights (system user?)
Shop
- Shop_id
- Name
- Type (Beer , pizza ... )
- Description
- Address_id
Item
- Item_id
- Name
- Type (Beer, pizza, ...)
- Description
- Manufacturer
- Price
Review
- Item_Id
- User_id
- Rating
- Comment
