I'm having a hard time understanding the relationship of this database to the calendar. I don't see date fields where I expect them. I think you're focusing all date information at the "court" data type, which makes some sense. "Event" feels slim without dates or recurrence number (i.e. GNEW LXVII)... I think name of court should at least be created from the data in the court data type (i.e. "#th Court of Crown1 and Crown2 at Event on Date") so that you have something to select from for the bestowal data type, and something to list in the output.
I would also want dates for the founding/creation/elevation/retirement of SCA branches as well, though you may see that as part of the bestowal concept. Since this is focused on court reports, a way to connect that sort of court business is probably in your mind already. I think it would mean that "recipient" might be the name of an SCA branch.
I use "SCA branch," probably because my work as a cartographer forced me into a too-close reading of the Midrealm Seneschal's handbook. :-) "SCA Branch" helps to separate the standard branch types (Barony, Shire, Canton, etc.) from the many other groups in the SCA (Guilds, Households, etc.). I have no idea if that usage is widespread.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Dates, Bestowal to Branches, and Groups or Branches
Date: 2008-11-22 10:49 pm (UTC)I would also want dates for the founding/creation/elevation/retirement of SCA branches as well, though you may see that as part of the bestowal concept. Since this is focused on court reports, a way to connect that sort of court business is probably in your mind already. I think it would mean that "recipient" might be the name of an SCA branch.
I use "SCA branch," probably because my work as a cartographer forced me into a too-close reading of the Midrealm Seneschal's handbook. :-) "SCA Branch" helps to separate the standard branch types (Barony, Shire, Canton, etc.) from the many other groups in the SCA (Guilds, Households, etc.). I have no idea if that usage is widespread.