ProductReview Example: Difference between revisions
m
Changed from Web Programming to Web Applications category
m (→Introduction) |
Hsymington (talk | contribs) m (Changed from Web Programming to Web Applications category) |
||
| (10 intermediate revisions by one other user not shown) | |||
| Line 13: | Line 13: | ||
*supply a review of an item | *supply a review of an item | ||
*Overview supplied reviews from other users | *Overview supplied reviews from other users | ||
The workspace is available here https://github.com/jacobandresen/ProductReview | |||
= [[DataDictionary|Data Dictionaries]] = | = [[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. | 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 | 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) | ||
*StreetAddress | *FirstName (Ascii) | ||
*City | *LastName (Ascii) | ||
*ZIPCode | *Password (Ascii) | ||
* | *EmailAddress (Ascii) | ||
*Rights (Ascii) | |||
*StreetAddress (Ascii) | |||
*City (Ascii) | |||
*ZIPCode (Ascii) | |||
*Country (Ascii) | |||
== | ==Token== | ||
* | *UserId (Numeric) | ||
* | *TokenValue (Ascii) | ||
*LastAccessed (Date) | |||
* | |||
==Shop== | ==Shop== | ||
* | *ShopId (Numeric) | ||
*Name | *Name (Ascii) | ||
*Type ( | *Type (Numeric) | ||
*Description | *Description (Ascii) | ||
* | *StreetAddress (Ascii) | ||
*City (Ascii) | |||
*ZIPCode (Ascii) | |||
*Country (Ascii) | |||
== | ==Product== | ||
* | *ProductId (Numeric) | ||
*Name | *Name (Ascii) | ||
*Type ( | *Type (Numeric) | ||
*Description | *Description (Ascii) | ||
* | *ShopId (Numeric) | ||
*Price | *Price (Numeric) | ||
==Review== | ==Review== | ||
* | *ReviewId (Numeric) | ||
* | *ItemId (Numeric) | ||
*Rating | *UserId (Numeric) | ||
*Comment | *Rating (Numeric) | ||
*Comment (Ascii) | |||
= Implementation = | = Implementation = | ||
| Line 62: | Line 69: | ||
[[ProductReview VDF AJAX implementation]] | [[ProductReview VDF AJAX implementation]] | ||
[[Category: Web | [[Category: Web Applications]] | ||
[[Category: Data Dictionaries]] | |||