This wiki makes use of a database to populate and generate many of the pages. It is hoped that such an approach to this data will make it easier to maintain pages that show subsets of the information per liege, per atlas square, per shire, per hundred, per trade route, or whatever other groupings may be desired.
These tables are located in the sqlite database, harnwiki/data/meta/harndata/start.db.
| sites | This is the master table of every castle, keep, abbey, manor; heck, we may as well throw in every other dot on the map while we're at it. This is mostly drawn from the manor tables in the Kingdom of … articles and the Atlas Hârnica works. |
|---|---|
| sitetypes | This is a menu table that provides values for the sitetype field in sites. Values in csv files are matched to the abbrev column in this table. |
| routes, routes_subsites | These tables group manors from the sites table along different roads, rivers, or the like. The data is drawn from the Atlas Hârnica where possible or other maps. |
| districts | This is data pertaining to shires and hundreds or other administrative districts within kingdoms drawn from tables such as that on page 18 of Kingdom of Kaldor. |
| deathcauses, relations, sexes | These are menu tables that feed columns in the people table below and its subtables. The deathcauses one is based on the information provided in the family trees from many articles and is not intended to be extended with further rows. The relations one, on the other hand, probably will need more added to it. Please don't reorder it, lest the values currently recorded point to something else. And sexes, well, I don't know if canon or fanon requires any more options than the two, but fantasy biology can get pretty speculative. |
|---|---|
| people | This is the mad Census Hârnica table of every person named anywhere in Xanadu, where did Kubla Khan a stately database decree. Heaven only knows if it will ever be complete or all that useful, but there's probably at least a Hârnic name generator to be had. |
| people_subreferences, people_subrelations, people_subroles | These are subtables to allow for multiple entries per person without creating a whole bunch of fields like spouse1, spouse2, … spousen. people_subreferences records the works in which the person is mentioned and information is provided; people_subrelations lists, spouses, affairs, friends, foes, or any other contexts in which one person is mentioned vis-à-vis another; and people_subroles contains titles, occupations, and the like. |