How can I get unique track?

development
musicbrainz
Tags: #<Tag:0x00007fcd7e8b0760> #<Tag:0x00007fcd7e8b05f8>

#1

I have local musicbrainz database. Here is the screenshot from track table.
As you can see, there are few tracks with the same name, length, artist_credit etc etc. What are the differents between them? I see differents in gid uuid column. But in fact all other columns are the same.
How can I get unique tracks?


#2

Tracks are each appearance of a recording in a specific medium of a release (as you can see, the medium ID is also different for each track). If you want “unique tracks”, you probably want to look at recordings instead.


#3

You should have a look at this schema, it shows the relations between the different tables:


#4

Thanks I saw that. Just a little bit difficult to understand what does mean some fields. In wiki there are brief explanation for a couple of tables, but not for all of them