diff options
| author |  Peter McGoron
| 2021-07-23 23:42:23 -0400 |
|---|---|---|
| committer |  -
| 2021-07-26 22:55:38 -0400 |
| commit | 11e0249f849c76d25d11f9cb2451c668cb537d3c (patch) | |
| tree | 3f5726450768665a95af452637417d4613fa82f9 /example/tables.md | |
| parent | add more documentation cards (diff) | |
add renaming
Diffstat (limited to 'example/tables.md')
| -rw-r--r-- | example/tables.md | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/example/tables.md b/example/tables.md new file mode 100644 index 0000000..a43b806 --- /dev/null +++ b/example/tables.md @@ -0,0 +1,14 @@ +Underwriter uses SQLite to store tag information. The database structure +is based off of the ["Toxi"][1] schema. + +[1]: http://howto.philippkeller.com/2005/04/24/Tags-Database-schemas/ + +The three tables used are + +* `cards`, containing the name and creation date +* `tags`, containing an ID of the tag and the name +* `tagmap`, where each row matches a card with a tag + +The `tagmap` is many-to-many. For instance, if `X` is a member of +`cards`, and `Y`, `Z` are members of tags, then `(X,Y)` and +`(X,Z)` can be members of `tagmap`. |