Hotel Scoring

1. Content score

1.1. item

1.1.1. "content_score"

2. Quality test (mystery guest)

2.1. mc_xxx

2.1.1. tables starting with mc_

3. trivago rating Index (tRI)

3.1. item

3.1.1. "overall_liking"

4. Polygons

4.1. polygon_type

4.2. item2polygon

4.3. polygon

4.4. polygon2polygon

5. Semantics

5.1. trustyou_category_review

5.2. trustyou_good_to_know

5.3. trustyou_hotel_type

5.4. trustyou_review

5.5. trustyou_subcategory_review

6. Meta data scoring

6.1. field

6.2. trv._bulk.field_hierarchy

6.2.1. join "field" via field_id/partner_id

6.3. scoring table BI

7. Hotel stars

7.1. item

7.1.1. "category"