I’m having some trouble figuring out how to structure a section of my database dealing with mating:
On any given date, we set up one or more groups of bees to mate. Each group is checked every X minutes, and the behaviour of each bee in each group is recorded (ideally, at least… not always possible, which is why Datetime and Behaviour are optional).
The section I’m having difficulty with is the bee table: some bees in each group are female (gynes) and some are male (males). For gynes, I’d like this to be linked to an existing table of gyne information; however, males have no such table. Even if I did make a table for males, you can’t have a reference column that links to multiple different columns.
I feel like I might be overthinking here – anyone got any ideas?