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

Field	Type	Nullable	Default Value
id	int4
mandi_id	int4
holiday_date	date
is_holiday	bool
reason	varchar
created_at	timestamp
updated_at	timestamp

Description

id

Primary key of the table.

mandi_id

Id of the mandi.

holiday_date

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.

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.

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.