A model for reviews and comments

The following figure gives an example of the information that reviews and comments will contain:

Figure 6.1: Reviews and comments

Every review has to be uniquely identified for which we use the _id property. Value for money, comfort, food, and service are all the parameters that have been discussed earlier. The rating has been given on a scale of 1 to 5, assuming 1 to be lowest and 5 to be the highest. In addition to these, we have created_on, which is the timestamp of the creation of the review. Similarly, stayed_on is a timestamp of the day that the reviewer stayed at the hotel. We also capture additional information such as stay_year, stay_month, and stay_day. This will help us with range queries on the time of the year that the review was written.

Comments have _id, which uniquely identifies a comment. The created_on property is the timestamp of when the comment was created. The text is the actual communication that the traveler wants to send across to the...