I'm eager about it even before seeing any Offer Lists.
I hope there's enough time between announcing the general theme and committing to an Offer List that I can browse some year-end seed sales and make sure I receive such things before I offer them.
(I'm trying to think of a way to tempt people into a swap if we can't see their Wish List before the swap.)
@Dave, I'm just daydreaming here ... and this may not even be relevant to your multi-swap database design, which I literally can't imagine.
< Insert Wizard avatar here, but6 I'm not at the computer that has that image. >
Maybe there would be some value in giving each member a
personal set of trade-related lists that would persist from swap to swap. For example, their personal "Have" and "Wish" lists would logically persist from swap to swap, once the member created them.
That would also motivate members who wanted to include links or descriptive text with seed offers to invest the time. (These personal persistent lists would be separate from, but could interact with, the member's "Offered" list within each swap.)
When a member joins a swap, they would be able to populate THAT swap's "Offered" list by clicking on their personal, persistent Have List. Presumably that would decrement their Have List's number of packets by the number of packets "Offered".
(I'm thinking that would help me avoid offering more seeds than I have!)
Presumably when swaps were over, a member could close out that swap's Offer list by "taking back" any unused packets and restoring them to his personal persistent "Have" list. (Like the "Have" list is a personal inventory and the "Offer" list shows what is committed to that swap. I think of "Accepted Offers" being flagged within the "Offer" list but I bet your design doesn't remotely resemble things I'm familiar with.
These kinds of issues have been haunting me since you said there would be some degree of simultaneous swaps supported. If so, I thought the idea above would reduce the number of simultaneous access conflicts to times when a member transfers packets from his or her Have list to a swap's Offered list. Individual trades within a swap would no longer potentially conflict with trades in other swaps.