ProductReview Example: Difference between revisions

m
Denormalizing
m (Denormalizing)
Line 21: Line 21:


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")
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")
==Address==
*AddressId (Numeric)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


==User==
==User==
*UserId (Numeric)
*UserId (Numeric)
*LoginName (Ascii)
*LoginName (Ascii)
*FirstName (Ascii)
*FirstName (Ascii)
Line 36: Line 29:
*Password (Ascii)
*Password (Ascii)
*EmailAddress (Ascii)
*EmailAddress (Ascii)
*AddressId (Ascii)
*Rights (Ascii)
*Rights (Ascii)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


==Token==
==Token==
Line 49: Line 45:
*Type (Numeric)
*Type (Numeric)
*Description (Ascii)
*Description (Ascii)
*AddressId (Numeric)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


==Product==
==Product==
1,134

edits