mandi_crop_follower

This table holds the data for a user following a combination of mandi & crop. This also holds some anlaytical data to see user behavior.

This table will be used in the future to enhance user experience by providing better recommendations to users based on their mandi-crop usage.

Model

Field	Type	Nullable
id	int4
user_id	int4
mandi_id	int4
crop_id	int4
last_visited_at	timestamp
today_visit_count	int4
total_visit_count	int4
created_at	timestamp
updated_at	timestamp

Description of fields

id

The primary key.

user_id

The id of the user.

mandi_id

The id of the mandi.

crop_id

The id of the crop.

last_visited_at

The datetime value when a user last viewed sale receipts of the corresponding mandi & crop combination.

today_visit_count

The count of visits for that user for the sale receipts of corresponding mandi & crop combination.

total_visit_count

Total visit count for that user for the sale receipts of corresponding mandi & crop combination since the beginning.

created_at

The timestamp when the data is first registered.

updated_at

The timestamp at which the data is last updated.