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
