In Progress

Insect Farm sql database

We need a database to assist with the maintinance of an insect farm

Fators to track are


Need to be able to create bin types

Uniques ID for each bin with barcode

Active Bin Flag


- common name and Latin names

- Life cycle length in days

- Multistage life cycle (Y/N)

- if yes how many and how long is each

- photograph of each life stage

broods - tracking of broods from birth to death


- death counts

- feeding schedules tracked by date and volume

- population counts

- harvest counts

- Hatcher source ID

- current bin ID

Hatchers - Bins

- species

- Brood source

- tracking of seed date and estimated hatch date

- Population esitimates

- populations actual (determined when the insects are transfered to a brood bin

- form to split Mature hatchers into broods

- Last fed date

- total protien to date

- total Produce to date

Dashboard displaying - populations of each species by age in weeks

- breeder population

- Harvested today

-harvested to Date

- report displaying bins requiring feeding

- hathchers To be proccessed

- feed log entry (by bin)

- Death log entry

- Harvest log entry

links to forms for brood. bin and hatchers creation and maintenance

All work is logged via BIN id but i need the data linked to each brood. I need the ability to retire broods and hatchers. This is allow us to create work reports and track estimated population and feed use as well as track harvests

We intecd to quickly need to integrate this into a customer database allowing us to track feed requirements and allow us to determine our daily harvest requirents

I hope that is clear

Skills: Database Administration, Database Programming, MySQL, PHP, SQL

See more: sql database to web, query form sql database to show in textboxs c, query form sql database to show in textboxs c#, php, mysql, microsoft sql server, hire someone to build asp net 4 with sql database website, sql database schema stored procedure, web page sql database input, web front end sql database, deploy sql database sql express, repair wordpress sql database, dynamic link php sql database, net backup sql database, recieve sms text mesages sql database, import sql database web developer, javascript sql database, news scroller sql database

About the Employer:
( 0 reviews ) calgary, Canada

Project ID: #16169241

Awarded to:


I have more than 5 years experience in PHP programming and well versed in android and in open-sources / Framework like Codeigniter , OpenCart, Wordpress and other Web solutions . My strengths are web development, PHP, More

$155 CAD in 3 days
(16 Reviews)

13 freelancers are bidding on average $201 for this job

$155 CAD in 3 days
(64 Reviews)

Hi there, a. Need to integrate this into a customer database. b. Allowing us to track feed requirements. c. Allow us to determine our daily harvest requirements. d. Need a database to assist with the maintenanc More

$200 CAD in 3 days
(39 Reviews)

Hello, i seen that you are looking for a centralized management system for your farm. we can design a panel for you that will have following capabilities: ->Adding Bins with barcode , editing , deleting ->Adding sp More

$944 CAD in 3 days
(26 Reviews)

Hi there i read your request to build insect farm db and website. I am here to help you make it. Feel free to replay we can discuss further. Regards:[login to view URL] ------------------------------------------------------ More

$155 CAD in 3 days
(20 Reviews)

I'll be happy to help in creating the database, however I have a basic question. Will you enter the data manually? Please share more details about the tasks. ******************** Your project will be secured, More

$35 CAD in 3 days
(3 Reviews)

Sir i read your initial requirements and i have some question regarding to your database [login to view URL] we discuss it on chat ?

$155 CAD in 3 days
(6 Reviews)

Hello, I have 4+ years of experience working as a web developer, I produce quality code in no time. Please check my previous projects and let me know if you are interested. Have a nice day.

$89 CAD in 1 day
(14 Reviews)

Websmartiz Have Experience To Develop Dynamic Websites and Plugins By Use Of Codeigniter(PHP Framework) and MySql(Backend Database). [login to view URL]

$155 CAD in 3 days
(9 Reviews)

A proposal has not yet been provided

$120 CAD in 3 days
(2 Reviews)
$150 CAD in 5 days
(6 Reviews)

A proposal has not yet been provided

$45 CAD in 5 days
(1 Review)

Your task is clear enough. I am a relational database analyst and programmer. I'll create relational tables for you.

$250 CAD in 7 days
(0 Reviews)