Number of topics per tag

You could pore through files I suppose, but IMHO it is more efficient to use the menu on the plugins admin page. You should be able to see many tables that when selected display field names and schema info.

I’m not at my desktop, but the model has

# == Schema Information
#
# Table name: topic_tags
#
#  id         :integer          not null, primary key
#  topic_id   :integer          not null
#  tag_id     :integer          not null
#  created_at :datetime         not null
#  updated_at :datetime         not null
#
# Indexes
#
#  index_topic_tags_on_topic_id_and_tag_id  (topic_id,tag_id) UNIQUE 

Note the “topic_id” and “tag_id” it suggests the names are “table name, underscore, field name”.

The tag table has

# == Schema Information
#
# Table name: tags
#
#  id             :integer          not null, primary key
#  name           :string           not null
#  topic_count    :integer          default(0), not null
#  created_at     :datetime         not null
#  updated_at     :datetime         not null
#  pm_topic_count :integer          default(0), not null
#  target_tag_id  :integer
#
# Indexes
#
#  index_tags_on_lower_name  (lower((name)::text)) UNIQUE
#  index_tags_on_name        (name) UNIQUE

and I’ll leave it to you to look at the topic tables fields.

But that’s probably getting ahead of things. Have you been able to run a very simple query against one of those tables as a kind of “Hello Data Explorer”? What is it?