CREATE TABLE "torrents"
(
    groupName     TEXT,
    totalSnatched INTEGER,
    artist        TEXT,
    groupYear     INTEGER,
    releaseType   TEXT,
    groupId       INTEGER,
    id            INTEGER
        constraint torrents_pk
            primary key
);
torrents
CREATE TABLE "tags"
(
    "index" INTEGER
        constraint tags_pk
            primary key,
    id      INTEGER
        constraint tags_torrents_id_fk
            references torrents,
    tag     TEXT
);
tags
original_column_name,column_name,column_description,data_format,value_description
index,,index,integer,
id,,release identifier which can be matched with id field in the torrents table,integer,
tag,,tag,text,
tags
original_column_name,column_name,column_description,data_format,value_description
groupName,,release title,text,
totalSnatched,,number of times the release has been downloaded,integer,
artist,,artist / group name,text,
groupYear,,release year,integer,
releaseType,,"release type (e.g., album, single, mixtape)",text,
groupId,,Unique release identifier from What.CD. Used to ensure no releases are duplicates.,integer,
id,,unique identifier (essentially an index),integer,
torrents