ProductReview Example: Difference between revisions
m
→Data Dictionaries
mNo edit summary |
|||
Line 18: | Line 18: | ||
= [[DataDictionary|Data Dictionaries]] = | = [[DataDictionary|Data Dictionaries]] = | ||
We want to store information about users, places | 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: | |||
==Address== | |||
*Place_id | |||
*Name | |||
*StreetAddress | |||
*City | |||
*ZIPCode | |||
*Longitude | |||
*latitude | |||
== | ==User== | ||
*User_id | *User_id | ||
*FirstName | *FirstName | ||
*LastName | *LastName | ||
*EmailAddress | *EmailAddress | ||
*Address_id | |||
*Rights (system user?) | |||
== | ==Shop== | ||
* | *Shop_id | ||
* | *Name | ||
* | *Description | ||
* | *Address_id | ||
==Item== | ==Item== | ||
*Item_id | *Item_id | ||
*Name | *Name | ||
*Description | |||
*Manufacturer | *Manufacturer | ||
*Price | *Price | ||
Line 57: | Line 55: | ||
*Item_Id | *Item_Id | ||
*User_id | *User_id | ||
*Rating | *Rating | ||
*Comment | |||
= VDF Ajax implementation = | = VDF Ajax implementation = |