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
2019-03-15 07457, 2019
akhilesh
Mr_Monkey: what are the creators count, ref count and begin phrase in creator credit table
2019-03-15 07415, 2019
aliamo joined the channel
2019-03-15 07432, 2019
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)
2019-03-15 07412, 2019
akhilesh
ok, I think it requires understand MB things first.
2019-03-15 07415, 2019
aliamo joined the channel
2019-03-15 07424, 2019
adhawkins joined the channel
2019-03-15 07404, 2019
Lotheric has quit
2019-03-15 07400, 2019
aliamo has quit
2019-03-15 07411, 2019
aliamo joined the channel
2019-03-15 07456, 2019
aliamo has quit
2019-03-15 07425, 2019
BrainzGit joined the channel
2019-03-15 07444, 2019
reosarevok
akhilesh, Mr_Monkey: ask if you need MB help
2019-03-15 07451, 2019
yvanzo
Oops, for some reason, BrainzGit got disconnected three days ago and could not recover.
2019-03-15 07421, 2019
ruaok finally sort of wakes up
2019-03-15 07437, 2019
ruaok
iliekcomputers: not much better than yesterday, sadly.
So, the artist_credit table is a general "this is an artist credit"
2019-03-15 07408, 2019
reosarevok
It has the id for the credit (for reference) and the number of artists involved in the credit
2019-03-15 07427, 2019
reosarevok
And ref_count which I'm honestly not too sure about right now, but I suspect is how many times the credit is used?
2019-03-15 07448, 2019
reosarevok
Then for each artist in the credit you have an entry in artist_credit_name
2019-03-15 07436, 2019
reosarevok
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
2019-03-15 07446, 2019
reosarevok
So, basically what Mr_Monkey said, heh
2019-03-15 07401, 2019
aliamo has quit
2019-03-15 07427, 2019
aliamo joined the channel
2019-03-15 07435, 2019
reosarevok
With the inclusion that we always store a credited name, so you can say that on this credit, "Bob" actually appears as "Bobby"
2019-03-15 07436, 2019
aliamo has quit
2019-03-15 07453, 2019
pprkut has quit
2019-03-15 07400, 2019
pprkut joined the channel
2019-03-15 07455, 2019
aliamo joined the channel
2019-03-15 07427, 2019
akhilesh
reosarevok: thanks, it is difficult to understand for me but I am trying to grasp.
2019-03-15 07443, 2019
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"
2019-03-15 07428, 2019
reosarevok
That's when creator credits come in - so in this case we'd have the creator credit "Terry Pratchett & Neil Gaiman"
2019-03-15 07407, 2019
reosarevok
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)
2019-03-15 07423, 2019
reosarevok
creator_credit_name would have two entries
2019-03-15 07409, 2019
reosarevok
One would be position 1, creator_bbid whatever Terry Pratchett's BBID is, name "Terry Pratchett", and join phrase " & " (with the spaces)
2019-03-15 07438, 2019
reosarevok
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"
2019-03-15 07400, 2019
aliamo joined the channel
2019-03-15 07401, 2019
reosarevok
By putting the two together, you get "Terry Pratchett & Neil Gaiman", but where both are still separate creators you can link to, etc :)
