...
Entities, Relationships and multiplicities of World Insider:
Entities:
* USER: Set of user’s with an account
...
- ACTIVITY: Activities reviewed by users. (Could be a festival, outdoors activity like horse back riding, etc).
- CITY: Set of cities with a
...
- profile
* TRIP REVIEW: Set of reviews written by users. A user can see his reviewA review can refer directly to a country, a city, or activity or location. In the
...
- COUNTRY: A country with a profile in the system. A person should be able to see what cities are in a country
...
...
- LOCATIONS: Locations reviewed by users. (Restaurants, clubs, museums, etc)
- TRIP REVIEW: Set of reviews written by users. A user can see his reviews.
- USER: Set of user’s with an account
Relations* city
- city : city that the trip review refers to
...
- country: the country where the city is located
...
- explores: users browse through cities to explore sites of interests and see their friends' reviews
...
- knows: A users can “add” other users to see their trips and reviews
...
- lived in: users keep track of the cities they have lived in
...
- messages: users can send messages to inquire about reviews / trips
...
- reviews: users add reviews of their trips
