OK.
Quote:
|
If 1 farm has 1 to many subfarms. Can I just remove the junction table?
|
Yes
I'm thinking it won't matter if farms can share names, you still want to relate the subfarm to different agreements, contracts, harvest details, products, and tickets.
So here's what you'll need:
One Farms table.
One SubFarms table that has the FarmID as a foreign key.
One Agreements table that has the SubFarmID as a foreign key.
One Contracts table that has the SubFarmID as a foreign key.
One HarvestInfo table that has the SubFarmID as a foreign key.
One Products table that has the SubFarmID as a foreign key.
One Tickets table that has the SubFarmID as a foreign key.
No junction tables would be required.