jducoeur: (Default)
jducoeur ([personal profile] jducoeur) wrote2008-06-21 12:01 am
Entry tags:

No, that data is *not* simple

[livejournal.com profile] 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...