ProductReview Example: Difference between revisions

m
Line 20: Line 20:


==Address==
==Address==
*Place_id
*PlaceId (Numeric)
*Name
*Name (Ascii)
*StreetAddress
*StreetAddress (Ascii)
*City
*City (Ascii)
*ZIPCode
*Country (Ascii)
*Longitude
*latitude


==User==
==User==
*User_id
*UserId (Numeric)
*LoginName
*LoginName (Ascii)
*FirstName
*FirstName (Ascii)
*LastName
*LastName (Ascii)
*EmailAddress
*EmailAddress (Ascii)
*Address_id
*AddressId (Ascii)
*Rights (system user?)
*Rights (Ascii)
 
==Token==
*UserId (Numeric)
*TokenValue (Ascii)
*LastAccessed (Date)


==Shop==
==Shop==
*Shop_id
*ShopId (Numeric)
*Name
*Name (Ascii)
*Type (Beer , pizza ... )
*Type (Numeric)
*Description
*Description (Ascii)
*Address_id
*AddressId (Numeric)


==Item==
==Item==
*Item_id
*ItemId (Numeric)
*Name
*Name (Ascii)
*Type (Beer, pizza,  ...)
*Type (Numeric)
*Description
*Description (Ascii)
*Manufacturer
*ShopId (Numeric)
*Price
*Price (Numeric)


==Review==
==Review==
*Item_Id
*ItemId (Numeric)
*User_id
*UserId (Numeric)
*Rating
*Rating (Numeric)
*Comment
*Comment (Ascii)


= Implementation =
= Implementation =
1,134

edits