> For the complete documentation index, see [llms.txt](https://gramhal.gitbook.io/bolbhav/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gramhal.gitbook.io/bolbhav/chapter-1-database/mandi-and-crop-data/mandi_holidays.md).

# mandi\_holidays

In this table combination of mandi and date are recorded on which there is holiday. Currently data in this is maintained by Bolbhav team by aggregating it from the field staff in the selected markets.

## Model <a href="#modal" id="modal"></a>

<table><thead><tr><th width="239">Field</th><th width="197">Type</th><th data-type="checkbox">Nullable</th><th>Default Value</th></tr></thead><tbody><tr><td>id</td><td>int4</td><td>false</td><td></td></tr><tr><td>mandi_id</td><td>int4</td><td>true</td><td></td></tr><tr><td>holiday_date</td><td>date</td><td>true</td><td></td></tr><tr><td>is_holiday</td><td>bool</td><td>true</td><td></td></tr><tr><td>reason</td><td>varchar</td><td>true</td><td></td></tr><tr><td>created_at</td><td>timestamp</td><td>true</td><td></td></tr><tr><td>updated_at</td><td>timestamp</td><td>true</td><td></td></tr></tbody></table>

### Description <a href="#description" id="description"></a>

### id <a href="#id" id="id"></a>

Primary key of the table.

### mandi\_id <a href="#mandi_id" id="mandi_id"></a>

Id of the mandi.

### holiday\_date <a href="#crop_id" id="crop_id"></a>

Date for which the record is added.

### is\_holiday

If True then mandi is closed on that date. If False, then mandi is not closed on that date.

{% hint style="warning" %}
This might be misleading field as if a date is in this table against a mandi, it's easy to assume that it's a holiday in that mandi. However, the system does not consider a holiday if this field is false. It might be good to reconsider this field and if needed we should rename it.
{% endhint %}

### reason

Short description of why the mandi is closed on that date.

### created\_at

The timestamp when the data is first registered.

### updated\_at

The timestamp at which the data is last updated.<br>