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