crops

This table contains all the list of crops in the Bolbhav database and their associated attributes.

Model

Field	Type	Nullable	Default Value
id	serial4
is_active_mandi	boolean		True
is_parent_crop	boolean		False
parent_crop_id	int4
crop_name	varchar
crop_name_hi	varchar
crop_name_hing	varchar
name_pb	varchar
name_mt	varchar
image_thumbnail	varchar (255)
created_at	timestamp
updated_at	timestamp
image_basic_info
image_detailed_info
crop_attributes
is_active_basic_info			False
is_active_detailed_info			False
is_input			False
is_produce			False
is_active_gyan
is_active_input
is_active_produce
is_gyan			False
is_mandi			False
whatsapp_code
crop_wa_code

Description

id

Primary key of the table.

is_active_mandi

This store whether we are still using this crop_id. In mandi table it is restricted to delete a row because there might be dependecies in mandi_price table. Hence, a row can be marked inactive instead by making is_active False.

is_parent_crop

If this is true then it means that the crop is the parent crop and there are other varieties in the database. If it is false, it means that the crop does not have any variety added in the Bolbhav Database.

parent_crop_id

If this crop_id is a variety of a crop then this field tells us the crop_id of the parent crop.

image_thumbnail

Captures the url of the crop image.

created_at

The timestamp when the data is first registered.

updated_at

The timestamp at which the data is last updated.

---

crop_name

English name of the crop.

crop_name_hi

Hindi name of the crop.

name_mt

Marathi name of the crop.

name_pb

Punjabi name of the crop.

crop_name_hing

Hinglish name of the crop.

---

Not in user anymore fields that can be deleted to make the table more cleaner

is_active_detailed_info
is_active_basic_info
is_input
is_produce
is_active_gyan
is_active_input
is_active_produce
is_gyan
is_mandi
whatsapp_code
crop_wa_code