akhilesh: I don't know much about those tables, and haven't used them yet, to be honest. It looks to me like an Edition can have a creator_credit associated to it, whose data is stored in creator_credit_name. I don't have a lot more to say, but do you have specific questions?
Reading the tests is often helpful to figure out how it works
akhilesh
Mr_Monkey: what are the creators count, ref count and begin phrase in creator credit table
aliamo joined the channel
Mr_Monkey
akhilesh: I would suggest reading the MusicBrainz docs for artists credits and playing them on test.musicbrainz.org if you haven't. join phrase will become clearer.
I assume it's the position of one name for credits with multiple names. For example: the credit "Bob, Alice & John" will be composed of three creator credit names each with a potision (Bob 0, Alice 1, John 2) and a join phrase (',' for Alice and '&' for Bob)
akhilesh
ok, I think it requires understand MB things first.
aliamo joined the channel
adhawkins joined the channel
Lotheric has quit
aliamo has quit
aliamo joined the channel
aliamo has quit
BrainzGit joined the channel
reosarevok
akhilesh, Mr_Monkey: ask if you need MB help
yvanzo
Oops, for some reason, BrainzGit got disconnected three days ago and could not recover.
ruaok finally sort of wakes up
ruaok
iliekcomputers: not much better than yesterday, sadly.
So, the artist_credit table is a general "this is an artist credit"
It has the id for the credit (for reference) and the number of artists involved in the credit
And ref_count which I'm honestly not too sure about right now, but I suspect is how many times the credit is used?
Then for each artist in the credit you have an entry in artist_credit_name
Which specifies which artist it is, where in the credit it appears, what the credited name is, and what the join phrase (separating this artist from the next artist in the credit) is
So, basically what Mr_Monkey said, heh
aliamo has quit
aliamo joined the channel
With the inclusion that we always store a credited name, so you can say that on this credit, "Bob" actually appears as "Bobby"
aliamo has quit
pprkut has quit
pprkut joined the channel
aliamo joined the channel
akhilesh
reosarevok: thanks, it is difficult to understand for me but I am trying to grasp.
yvanzo
reosarevok: the ref_count allows to automatically drop artist_credit when it is not used anymore.
This book has two creators, and we don't want to have to add a separate creator called "Terry Pratchett & Neil Gaiman"
That's when creator credits come in - so in this case we'd have the creator credit "Terry Pratchett & Neil Gaiman"
creator_credit would have id 1, creator_count 2 (because there's two creators in here), and ref_count whatever (at first 1, because it's used once)
creator_credit_name would have two entries
One would be position 1, creator_bbid whatever Terry Pratchett's BBID is, name "Terry Pratchett", and join phrase " & " (with the spaces)
The other would be position 2, creator_bbid whatever Neil Gaiman's BBID is, name "Neil Gaiman", and join phrase "" (since there's nothing to be added after "Neil Gaiman"
aliamo joined the channel
By putting the two together, you get "Terry Pratchett & Neil Gaiman", but where both are still separate creators you can link to, etc :)
