Column Name

Data Type

Notes

Id

Int

Primary Key

CreatedAt

DateTime

UpdatedAt

DateTime

Primary Key

UpdatedBy

Nvarchar

E.g. User Email

CustomerId

Int

Foreign Key to join into Organisations table

Customer

Nvarchar

Organisation Name

CustomerType

Nvarchar

E.g. Grower, Buyer

Season

Nvarchar

Location

Nvarchar

Commodity

Nvarchar

Grade

Nvarchar

Quantity

Decimal

LocationLatitude

Decimal

LocationLongitude

Decimal