ProductReview Example: Difference between revisions
m
Changed from Web Programming to Web Applications category
m (→Goal) |
Hsymington (talk | contribs) m (Changed from Web Programming to Web Applications category) |
||
| (131 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
= Introduction = | |||
This page contains a description of an example project that can be used to study different implementation techniques using VDF as a backend. | |||
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: | To accomplish this, then users should be able to: | ||
| Line 9: | Line 9: | ||
*login | *login | ||
*choose an item from a list | *choose an item from a list | ||
*enter information about a known item | *enter information about a known item | ||
*supply a | *supply information about the place where an item was bought. | ||
*supply a review of an item | |||
*Overview supplied reviews from other users | |||
The | The workspace is available here https://github.com/jacobandresen/ProductReview | ||
= | = [[DataDictionary|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 (Note that attributes like "UserId" in Token implies a index on UserId on Token and a relation to the table "User") | |||
==User== | |||
*UserId (Numeric) | |||
*LoginName (Ascii) | |||
*FirstName (Ascii) | |||
*LastName (Ascii) | |||
*Password (Ascii) | |||
*EmailAddress (Ascii) | |||
*Rights (Ascii) | |||
*StreetAddress (Ascii) | |||
*City (Ascii) | |||
*ZIPCode (Ascii) | |||
*Country (Ascii) | |||
== | ==Token== | ||
*UserId (Numeric) | |||
*TokenValue (Ascii) | |||
*LastAccessed (Date) | |||
==Shop== | |||
*ShopId (Numeric) | |||
*Name (Ascii) | |||
*Type (Numeric) | |||
*Description (Ascii) | |||
*StreetAddress (Ascii) | |||
*City (Ascii) | |||
*ZIPCode (Ascii) | |||
*Country (Ascii) | |||
==Product== | |||
*ProductId (Numeric) | |||
*Name (Ascii) | |||
*Type (Numeric) | |||
*Description (Ascii) | |||
*ShopId (Numeric) | |||
*Price (Numeric) | |||
==Review== | |||
*ReviewId (Numeric) | |||
*ItemId (Numeric) | |||
*UserId (Numeric) | |||
*Rating (Numeric) | |||
*Comment (Ascii) | |||
= Implementation = | |||
[[ProductReview VDF AJAX implementation]] | |||
[[Category: Web Applications]] | |||
[[Category: Data Dictionaries]] | |||