# Best mapping strategy

**URL:** <https://discuss.elastic.co/t/best-mapping-strategy/132324>\
**Category:** Elasticsearch\
**Created:** [May 17, 2018, 11:33am UTC](https://discuss.elastic.co/t/best-mapping-strategy/132324 "2018-05-17T11:33:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco\_zwaan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/remco_zwaan/32/129991_2.png) [@remco\_zwaan](https://discuss.elastic.co/u/remco_zwaan)\
**Post date:** [May 17, 2018, 11:33am UTC](https://discuss.elastic.co/t/best-mapping-strategy/132324/1 "2018-05-17T11:33:23Z")

</div>

Hi,

I am newby to ES. We have in our DB this setup and we want to setup is to right mapping in ES.

**Accommodation** :

- Each day of the year has a own price
- Each price is/can be diffused by number of adults (1 adult \> 100 per day, 2 adults \> 120 per day ect )
- Each price is/can be diffused by number of adults + children (1 adult + 1 child \> 110 per day, 2 adults + 1 child \> 120 per day ect )

All data we have in our postgres db. Now we want to add the data in the ES index. Can someone guide us in case of data mapping in ES ?

ciao.remco

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 20, 2018, 9:15am UTC](https://discuss.elastic.co/t/best-mapping-strategy/132324/2 "2018-05-20T09:15:18Z")

</div>

Please don't create multiple threads on the same topic, it makes it harder to help you out 🙂

> [@Right mapping?](https://discuss.elastic.co/t/right-mapping/132575/3):
>
> yes it does. Sometimes we lower or higher the price. In case of promotions ect

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 20, 2018, 9:16am UTC](https://discuss.elastic.co/t/best-mapping-strategy/132324/3 "2018-05-20T09:16:00Z")

</div>


