THIS WIKI NOW DECOMISSIONED! PLEASE USE http://canon.flurf.net
This is the spec for the data structures used in Canon Lore. If you're planning on using the data or writing software to work with it, this should be useful to you. If you're just looking through the site to see what awards people have, this spec is probably overkill.
Tables
canon_alias: Alternative names for SCA branches
canon_award: All the awards that can be given and received
canon_branch: Shires, baronies, kingdoms and so on
canon_event: Events at which royalty presented awards
canon_former: Alternative names for people
canon_hat: Individual royalty
canon_hats: Individual reigns
canon_history: Branch status changes over time
canon_notes: Private notes for Canon Herald about individual entities
canon_op: The pre-calculated Order of Precedence
canon_person: People who have received awards or ruled as royalty
canon_received: Each award received by a person, with dates
canon_resigned: Obsolete
canon_search: The soundex-like search function's precalculated data
Types
BRANCH: A type of branch, from canton to kingdom
ENTITY: An entity that may be edited: person, branch, etc
FUZZYDATE: A date with the ability to be inaccurate (more useful than you'd think!)
HAT: Either sovereign or consort, ie king or queen, basically
ID: A unique ID that gets reference by a foreign key
RANK: An award's fundamental precedence
SEQUENCE: A unique ID for identifying a row
TRACKING: How to handle awards for a person
Other Resources
Canon Lore Public XML Feed: a publicly available feed of most of the Canon Lore database, to allow mashups.
Gratian: the Windows-based database editing software used by Canon Herald and her deputies, developed and maintained by Mortar Herald.
*As of 2pm on Thursday 14 February, this documentation is reasonably complete, and I welcome your feedback.