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
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.
Last updated