| by Achyut Kendre | 12 comments

Project Title:FreshFarmMart

This will be web portal used by Farmers to sell their farm fresh online. Any farmer can register on the portal with his/her details with his/her trade name. He can sell his farm grown vegies / fruits and grains online. Any buyer can purchase it online using this portal. This portal has following stake holders –

  1. Admin
  2. Farmer (Trader)
  3. User

Admin:- Admin manage entire portal , admin can do the following things –

  • Configure – State/ City /Country/ Main Categories/ Categories, Minimum Purchase Limits
  • Define Rules Regulation for Framer and User
  • Activate & DeActivate Farmers / Users
  • Reports

Farmer (Trader):- Farmer can register, login in system and do the following things –

  • Add Farm Produce as Products
  • View Orders / Dispatch Orders
  • View Complaints/ Provide Solutions
  • View Rating and Reviews

User:- who purchase the fram produce online using this portal. User can do the following things –

  • Register, login , logout, profile management.
  • Search, Add To Cart, Checkout, Order, Dispatches
  • Complaints and Solutions
  • Rating/ Review and Feed Back
GenderEnum
Male -1
FeMale -2
Other -3
RatingEnum
Best -1
Good -2
Average -3
Bad -4
PaymentModeEnum
Cash-1
DebitCard-2
CreditCard-3
Cheque -4
UPI -5
Class Name:Country
Sr. No.Property NameData TypeRemark
1CountryIDInt64PK
2CountryNamestring
Class Name:State
Sr. No.Property NameData TypeRemark
1StateIDInt64PK
2StateNamestring
3CountryIDInt64PK
Class Name:City
Sr. No.Property NameData TypeRemark
1CityIDInt64PK
2CityNamestring
3StateIDInt64FK
Class Name: Admin
Sr. No.Property NameData TypeRemark
1AdminIDInt64PK
2FirstNamestring
3LastNamestring
3EmailIDstring
4Passwordstring
Class Name:UserTermsCondition
Sr. No.Property NameData TypeRemark
1UserTermsConditionIDInt64PK
2TermsConditionTitlestring
3TermsConditionDescstring
Class Name:User
Sr. No.Property NameData TypeRemark
1UserIDInt64PK
2FirstNamestring
3LastNamestring
4GenderGenderEnum
5CityIDInt64fk
6Addressstring
7PinCodestring
8Occupationstring
Class Name:TraderFarmer
Sr. No.Property NameData TypeRemark
1TraderFarmerIDInt64PK
2TradeNamestring
3Addressstring
4PinCodestring
5CityIDInt64fk
6ContactPersonNamestring
7RegistrationDateDateTime
8ActiveFlagbit
9 Password string
10 Email ID string
11 MobileNo string

Class Name:TraderFarmerTermsCondition
Sr. No.Property NameData TypeRemark
1TraderFarmerTermsConditionIDInt64PK
2TermsConditionTitlestring
3TermsConditionDescstring
Class Name:Unit 
Sr. No.Property NameData TypeRemark
1UnitIDInt64PK
2UnitNamestring
3QtyPerUnitint
Class Name:MainCategory
Sr. No.Property NameData TypeRemark
1MainCategoryIDInt64PK
2MainCategoryNamestring
Class Name:Category
Sr. No.Property NameData TypeRemark
1CategoryIDInt64PK
2CategoryNamestring
3MainCategoryIDInt64FK
4PurchaseLimitInQtyint
Class Name:Product
Sr. No.Property NameData TypeRemark
1ProductIDInt64PK
2ProductNamestring
3ProductDescstring
4CategoryIDInt64FK
5UnitIDInt64fk
6Qtyint
7Pricedecimal(10,2)
8MainPhotoPathstring
Class Name:ProductPhoto
Sr. No.Property NameData TypeRemark
1ProudctPhotoIDInt64PK
2ProductIDInt64FK
3PhotoPathstring
Class Name:ProductDiscount
Sr. No.Property NameData TypeRemark
1ProductDiscountIDInt64PK
2ProductIDInt64FK
3DiscountNamestring
4DiscountAmountdecimal
5IsPercentilebit
Class Name:ProductReview
Sr. No.Property NameData TypeRemark
1ProductReviewIDInt64PK
2ProductIDInt64FK
3UserIDInt64FK
4ReviewDescstring
5RatingRatingEnum
Class Name:UserOrder
Sr. No.Property NameData TypeRemark
1UserOrderIDInt64PK
2UserIDInt64FK
3OrderDateDateTime
4IsPaidbool
5TraderFarmerIDInt64fk
Class Name:UserOrderDet
Sr. No.Property NameData TypeRemark
1UserOrderDetIDInt64PK
2UserOrderIDInt64fk
3ProductIDInt64
4Qtyint
5Pricedecimal
6DiscountNamestring
7DiscountApplieddecimal
8IsPercentilebit
9ActualDiscountAmountdecimal
Class Name:UserOrderPayment
Sr. No.Property NameData TypeRemark
1UserOrderPaymentIDInt64PK
2UserOrderIDInt64fk
3PaymentDateDateTime
4Amountdecimal
5PaymentModePaymentModeEnum
Class Name:UserOrderComplaint
GenderEnumData TypeRemark
1UserOrderComplaintIDInt64PK
2UserOrderIDInt64fk
3ComplaintDateDateTime
4ComplaintDescstring
Class Name:UserOrderComplaintSolution
Sr. No.Property NameData TypeRemark
1UserOrderComplaintSolutionIDInt64PK
2UserOrderComplaintIDInt64fk
3SolutionDateDateTime
4SolutionDescstring
Class Name: WishList
Sr. No.Property NameData TypeRemark
1WishListIDbiginPK
2WhatListDateDateTime
3UserOrderIDInt64FK
4ProductIDInt64FK
5AddedDateDateTime
Class Name:ComplaintRefund
Sr. No.Property NameData TypeRemark
1ComplaintRefundIDInt64PK
2UserOrderComplaintSolutionIDInt64FK
3RefundAmountdecimal
3ReundDateDateTime
4PaymentModePaymentModeEnum

12 Comments

Slow-cooked carnitas with cilantro

October 4, 2024 at 4:59 am Reply

What a great story! I’m so glad you shared it. The data you supplied was both practical and simple to grasp. Your ability to simplify otherwise difficult ideas is much appreciated. Anyone interested in learning more about this subject would benefit greatly from reading this.

A1 Speaking

October 4, 2024 at 6:35 am Reply

I found this post to be very informative and well-organized. Your detailed analysis and clear explanations make it a pleasure to read. The practical examples you included were particularly helpful. Thank you for sharing your knowledge with us.

buying guest post

October 5, 2024 at 4:14 am Reply

This was a very informative and enjoyable read—thank you.

Business English Lesson Plans

October 5, 2024 at 9:12 am Reply

This is a well-written and insightful article. Your detailed explanations and practical examples make it easy to understand and apply the concepts. I appreciate the effort you put into providing such thorough information. Thank you for sharing your expertise with us.

xxxmundo.com/a/VWx7x5tTWtQn

October 19, 2024 at 8:23 am Reply

May I jhst say what a comfort to finhd an individual whoo genuinely understands wha thdy
are discussing onn the net. Yoou deffinitely know hoow tto bring an issue to light andd maake itt important.
More and moee people must check thi ouut aand understaand this side oof tthe story.
I was surpprised you are not more opular iven thawt yyou certanly possesss the
gift.

free-wap-tube.com/movkB44nrFaTrCC

October 24, 2024 at 1:52 pm Reply

My slouse and I stumblled ovver here fom a differemt wweb address andd thought I
might ceck things out. I lie what I ssee so noow i amm following you.
Loook forward too checking outt you weeb page repeatedly.

mobxvideos.com/id/eMaLLLyCtAQN

October 25, 2024 at 9:59 am Reply

We arre a grop oof vollunteers annd openingg a neww scheme in ouur community.

Youur web sife provided us with valuable informawtion to wor on. You’ve done aan impressive joob and oour whole community wilol be grateful to
you.

gsa verified list

November 9, 2024 at 7:17 am Reply

It’s an awesome post for all the internet
users; they will get benefit from it I am sure.!

eco product

November 11, 2024 at 2:38 pm Reply

Howdy! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get
my website to rank for some targeted keywords but I’m not
seeing very good success. If you know of any please share.
Thanks! You can read similar art here: Eco blankets

Dorene

November 13, 2024 at 9:20 pm Reply

Howdy! Do you know if they make any plugins to help with SEO?
I’m trying to get my website to rank for some targeted
keywords but I’m not seeing very good gains. If you
know of any please share. Many thanks! You can read similar text here:
Eco blankets

hiv nail

November 15, 2024 at 6:36 pm Reply

Patel, Nilay. “Why Movie Theaters Ought to be Extra Like Rock Live shows.” Vox.

sugar defender

November 17, 2024 at 12:24 am Reply

sugar defender Including
Sugar Defender right into my daily regimen general wellness.
As somebody that prioritizes healthy and balanced consuming, I
appreciate the added defense this supplement provides.
Given that starting to take it, I’ve discovered a marked enhancement
in my energy degrees and a significant reduction in my need for harmful snacks such a such a profound influence on my daily life.

Leave a Reply