1. Paul Ruane
  2. tmsu

Wiki

Clone wiki

tmsu / Database Schema

Tag

A tag that can be applied to files.

Name Type Primary Key Comment
id integer
name text

File

A file that has been tagged.

Name Type Primary Key Comment
id integer
directory text
name text
fingerprint text used to detect moved and duplicate files
mod_time datetime used to detect modified files
size integer used to detect modified files
is_dir boolean

File Tag

An application of a tag upon a file.

Name Type Primary Key Comment
file_id integer
tag_id integer

Implication

Note: this is in the process of being replaced.

Auto-application of a tag when another is applied.

Name Type Primary Key
tag_id integer
implied_tag_id integer

Query

Queries created within the VFS.

Name Type Primary Key Comment
text text the query text (e.g. 'apple and pear')

Setting

Configures TMSU's behaviour.

Name Type Primary Key
name text
value text

Updated