Page 1 of 1

[Mystara Database] Tagging

Posted: Mon Jul 07, 2008 6:59 pm
by Andaire
With all that talk of a Mystara DB, and seeing how detailed it is going to be, it resurrects my old dream of assigning keywords to everything Mystaran, notable every article we ever wrote. Today, we'd call that tagging.

Re: Tagging

Posted: Tue Jul 08, 2008 2:32 am
by Thorf
Yes, absolutely! :D

We are already talking about including Vaults articles as sources, so the framework is already mostly in place. All we would need to do is work out what the tags are, and implement them in a series of tables. Probably something like this:

mdb_source_tag
id
tag_name
description

mdb_source_tag_linkage
id
mdb_source_id @
mdb_source_tag_id @

That would probably be enough - just define the tags and link them to sources.

On the other hand, we could also make it a little more flexible by having tag hierarchies, such as:

mdb_source_tag
id
tag_name
mdb_source_tag_id @
description

The self-reference allows us to define a parent tag, so we could have Outer World containing Known World, rather than having both separate. Then you just add the most detailed tag, and it automatically implies all the parent tags too.

Actually, this is how I sort my photos, my maps, and my fantasy art database. There's an excellent program called IMatch with some very powerful functions built around this.