taggings

Data license: MIT

30,023 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: taggable_type, source, created_at (date), updated_at (date)

Next page

CREATE TABLE taggings (
  id INTEGER PRIMARY KEY,
  tag_id INTEGER NOT NULL REFERENCES tags(id),
  taggable_type TEXT NOT NULL, -- Artist / Album / Track
  taggable_id INTEGER NOT NULL,
  count INTEGER,
  source TEXT,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);
CREATE UNIQUE INDEX idx_taggings_uniq ON taggings(taggable_type, taggable_id, tag_id);