Fonts

[Thorf]

To facilitate my Mystara Font FAQ, I'm going to add a table for fonts, allowing them to be cross-referenced to sources.

mdb_font_family
id
font_family (e.g. Baskerville)

mdb_font_foundry
id
font_foundry
description
url

mdb_font
id
mdb_font_family_id @
font (e.g. Baskerville BT)
characteristics
mdb_font_foundry_id @
url

mdb_font_style
id
style (Regular, Bold, Italic, Bold Italic, etc.)

mdb_font_usage
id
mdb_font_id @
mdb_font_style_id @
mdb_source_id @
mdb_source_series_id @
description (where in the source/series the font in question was used)
sample (a short sample or collection of short samples of actual text that was set in this font)

You can only choose either a source or a series to attach to this last table.

So first we define a specific font, then we can do a write-up for it, showing which source or series it was used in, and for what - very similar to my Font FAQ, but a little more organised.

Any comments? Is my design sound? Is it okay to have an either/or thing with source/series? It would be nice if eventually it could be expanded outside the realm of Mystara to include other D&D products, and even other RPG or completely unrelated products. (But I wouldn't want to pollute the source menu with the latter.)