Project Title:FreshFarmMart

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 Name	Data Type	Remark
1	CountryID	Int64	PK
2	CountryName	string
Class Name:State
Sr. No.	Property Name	Data Type	Remark
1	StateID	Int64	PK
2	StateName	string
3	CountryID	Int64	PK
Class Name:City
Sr. No.	Property Name	Data Type	Remark
1	CityID	Int64	PK
2	CityName	string
3	StateID	Int64	FK
Class Name: Admin
Sr. No.	Property Name	Data Type	Remark
1	AdminID	Int64	PK
2	FirstName	string
3	LastName	string
3	EmailID	string
4	Password	string
Class Name:UserTermsCondition
Sr. No.	Property Name	Data Type	Remark
1	UserTermsConditionID	Int64	PK
2	TermsConditionTitle	string
3	TermsConditionDesc	string

Class Name:User
Sr. No.	Property Name	Data Type	Remark
1	UserID	Int64	PK
2	FirstName	string
3	LastName	string
4	Gender	GenderEnum
5	CityID	Int64	fk
6	Address	string
7	PinCode	string
8	Occupation	string

Class Name:TraderFarmer
Sr. No.	Property Name	Data Type	Remark
1	TraderFarmerID	Int64	PK
2	TradeName	string
3	Address	string
4	PinCode	string
5	CityID	Int64	fk
6	ContactPersonName	string
7	RegistrationDate	DateTime
8	ActiveFlag	bit
9	Password	string
10	Email ID	string
11	MobileNo	string

Class Name:	TraderFarmerTermsCondition
Sr. No.	Property Name	Data Type	Remark
1	TraderFarmerTermsConditionID	Int64	PK
2	TermsConditionTitle	string
3	TermsConditionDesc	string

Class Name:Unit
Sr. No.	Property Name	Data Type	Remark
1	UnitID	Int64	PK
2	UnitName	string
3	QtyPerUnit	int

Class Name:MainCategory
Sr. No.	Property Name	Data Type	Remark
1	MainCategoryID	Int64	PK
2	MainCategoryName	string

Class Name:Category
Sr. No.	Property Name	Data Type	Remark
1	CategoryID	Int64	PK
2	CategoryName	string
3	MainCategoryID	Int64	FK
4	PurchaseLimitInQty	int

Class Name:Product
Sr. No.	Property Name	Data Type	Remark
1	ProductID	Int64	PK
2	ProductName	string
3	ProductDesc	string
4	CategoryID	Int64	FK
5	UnitID	Int64	fk
6	Qty	int
7	Price	decimal(10,2)
8	MainPhotoPath	string

Class Name:ProductPhoto
Sr. No.	Property Name	Data Type	Remark
1	ProudctPhotoID	Int64	PK
2	ProductID	Int64	FK
3	PhotoPath	string

Class Name:ProductDiscount
Sr. No.	Property Name	Data Type	Remark
1	ProductDiscountID	Int64	PK
2	ProductID	Int64	FK
3	DiscountName	string
4	DiscountAmount	decimal
5	IsPercentile	bit

Class Name:ProductReview
Sr. No.	Property Name	Data Type	Remark
1	ProductReviewID	Int64	PK
2	ProductID	Int64	FK
3	UserID	Int64	FK
4	ReviewDesc	string
5	Rating	RatingEnum

Class Name:UserOrder
Sr. No.	Property Name	Data Type	Remark
1	UserOrderID	Int64	PK
2	UserID	Int64	FK
3	OrderDate	DateTime
4	IsPaid	bool
5	TraderFarmerID	Int64	fk

Class Name:UserOrderDet
Sr. No.	Property Name	Data Type	Remark
1	UserOrderDetID	Int64	PK
2	UserOrderID	Int64	fk
3	ProductID	Int64
4	Qty	int
5	Price	decimal
6	DiscountName	string
7	DiscountApplied	decimal
8	IsPercentile	bit
9	ActualDiscountAmount	decimal

Class Name:	UserOrderPayment
Sr. No.	Property Name	Data Type	Remark
1	UserOrderPaymentID	Int64	PK
2	UserOrderID	Int64	fk
3	PaymentDate	DateTime
4	Amount	decimal
5	PaymentMode	PaymentModeEnum

Class Name:UserOrderComplaint
GenderEnum	Data Type	Remark
1	UserOrderComplaintID	Int64	PK
2	UserOrderID	Int64	fk
3	ComplaintDate	DateTime
4	ComplaintDesc	string

Class Name:	UserOrderComplaintSolution
Sr. No.	Property Name	Data Type	Remark
1	UserOrderComplaintSolutionID	Int64	PK
2	UserOrderComplaintID	Int64	fk
3	SolutionDate	DateTime
4	SolutionDesc	string

Class Name: WishList
Sr. No.	Property Name	Data Type	Remark
1	WishListID	bigin	PK
2	WhatListDate	DateTime
3	UserOrderID	Int64	FK
4	ProductID	Int64	FK
5	AddedDate	DateTime

Class Name:	ComplaintRefund
Sr. No.	Property Name	Data Type	Remark
1	ComplaintRefundID	Int64	PK
2	UserOrderComplaintSolutionID	Int64	FK
3	RefundAmount	decimal
3	ReundDate	DateTime
4	PaymentMode	PaymentModeEnum