generations are the part of the lifecycle between spores and something that can be inoculated into a nutritional substrate, To wit, spores or clones. to track this we need 2 tables
generations
[x] tracks the plating and liquid substrates used to culture the generation
sources
[x] links the source strain to a generation
[x] may be more than 1 source to a generation, but not more than 2 of type Spore or 1 of type Clone
[x] Spore and Clone sources can't be mixed in a generation
generations are the part of the lifecycle between spores and something that can be inoculated into a nutritional substrate, To wit, spores or clones. to track this we need 2 tables
Sporeor 1 of typeCloneSporeandClonesources can't be mixed in a generation