ProductReview Example: Difference between revisions
From DataFlex Wiki
Jump to navigationJump to search
m
Changed from Web Programming to Web Applications category
Hsymington (talk | contribs) m (Changed from Web Programming to Web Applications category) |
|||
(80 intermediate revisions by 3 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 | *enter information about a known item | ||
*supply information about the place where an item was bought. | *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]] | |||