No, that data is *not* simple

msmemory and I just sat down and sketched out the schema for an East Kingdom Order of Precedence database. Done right, it looks to be 14 tables -- discounting simple enumerations and trivial joins, it's still 10 tables of significant data. Really drives home how complex a model we've evolved.

The real "only in the SCA" moment, though, was realizing that each Person record potentially relates to multiple SCA names *and* multiple mundane names, of arbitrarily different genders...

No, that data is *not* simple

msmemory and I just sat down and sketched out the schema for an East Kingdom Order of Precedence database. Done right, it looks to be 14 tables -- discounting simple enumerations and trivial joins, it's still 10 tables of significant data. Really drives home how complex a model we've evolved.

The real "only in the SCA" moment, though, was realizing that each Person record potentially relates to multiple SCA names *and* multiple mundane names, of arbitrarily different genders...