ProductReview Example: Difference between revisions
m
Changed from Web Programming to Web Applications category
(removing link to deprecated cookbook) |
Hsymington (talk | contribs) m (Changed from Web Programming to Web Applications category) |
||
(59 intermediate revisions by 2 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: | ||
*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 information about the place where an item was bought. | |||
*supply a | *supply a review of an item | ||
*Overview supplied | *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]] | |||