Moe DeShong
asked on
Database table structure
I'm working on a program to track plants for a nursery and am having an problem structuring the database. For each plant there can be multiple crops each year. Each crop is divided into different descriptors when its entered in inventory. (graft, size1, size2, etc...) As the plant grows it can be shifted from one descriptor to the next.
I need to be able to track by crop number and only use a descriptor once for the plant. For example: Crop1, Crop2, Crop3... Descriptor: size1 I need to be able to get a total count from all the plants that have a specific descriptor regardless of what crop its from.
Right now I have a table for Plants, Crop, Inventory. Each Plant has multiple Crops, each Crop has multiple inventory records. Portions of the crop may be pre-sold so the same descriptor could be used for two different inventory records with one being marked as pre-sold.
I need to be able to track by crop number and only use a descriptor once for the plant. For example: Crop1, Crop2, Crop3... Descriptor: size1 I need to be able to get a total count from all the plants that have a specific descriptor regardless of what crop its from.
Right now I have a table for Plants, Crop, Inventory. Each Plant has multiple Crops, each Crop has multiple inventory records. Portions of the crop may be pre-sold so the same descriptor could be used for two different inventory records with one being marked as pre-sold.
ASKER
Thanks for the comment. I'm going to have to do a bit of research to figure it out. I'll get back.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
create a entity-relationship model from then. The last step is to derive the database model from the ER model.