ProductReview Example: Difference between revisions
m
Changed from Web Programming to Web Applications category
m (→User) |
Hsymington (talk | contribs) m (Changed from Web Programming to Web Applications category) |
||
(8 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== | ==User== | ||
*UserId (Numeric) | *UserId (Numeric) | ||
*LoginName (Ascii) | *LoginName (Ascii) | ||
*FirstName (Ascii) | *FirstName (Ascii) | ||
Line 33: | Line 29: | ||
*Password (Ascii) | *Password (Ascii) | ||
*EmailAddress (Ascii) | *EmailAddress (Ascii) | ||
*Rights (Ascii) | *Rights (Ascii) | ||
*StreetAddress (Ascii) | |||
*City (Ascii) | |||
*ZIPCode (Ascii) | |||
*Country (Ascii) | |||
==Token== | ==Token== | ||
Line 46: | Line 45: | ||
*Type (Numeric) | *Type (Numeric) | ||
*Description (Ascii) | *Description (Ascii) | ||
* | *StreetAddress (Ascii) | ||
*City (Ascii) | |||
*ZIPCode (Ascii) | |||
*Country (Ascii) | |||
== | ==Product== | ||
* | *ProductId (Numeric) | ||
*Name (Ascii) | *Name (Ascii) | ||
*Type (Numeric) | *Type (Numeric) | ||
Line 57: | Line 59: | ||
==Review== | ==Review== | ||
*ReviewId (Numeric) | |||
*ItemId (Numeric) | *ItemId (Numeric) | ||
*UserId (Numeric) | *UserId (Numeric) | ||
Line 66: | Line 69: | ||
[[ProductReview VDF AJAX implementation]] | [[ProductReview VDF AJAX implementation]] | ||
[[Category: Web | [[Category: Web Applications]] | ||
[[Category: Data Dictionaries]] |