Split author-work into 3 "families":

for writing (writing, translation, adaptation)
for comic/photo/art/picturebooks (inking, illustration, photography)
for other (commissioned, dedicated, copyright)

REVISED

= writing (think "composition" in mb) =

ID 8 {alteration!}
label "Author"
description "This relationship is used to link a work to its author."
link_phrase "wrote"
source_entity_type Author
target_entity_type Work
parent_id
child_order 0
deprecated false
reverse_link_phrase "was written by"

WD: https://www.wikidata.org/wiki/Q36180 or https://www.wikidata.org/wiki/Q36180 dunno which because WD is ANNOYing
BLURB: This is used for the writer of the work, be it non-fiction, story, comic, essay or other.

ID 9 {alteration!}
label "Translator"
description "This relationship links a translated work to its translator."
link_phrase "translated"
source_entity_type Author
target_entity_type Work
parent_id ID 8
child_order 0
deprecated false
reverse_link_phrase "was translated by"

WD: https://www.wikidata.org/wiki/Q333634
BLURB: This is used to link the translator of a work to the translated work - it is a new work becasue it is rewritten in a new or modernised language, sometimes the work is reinterpreted, chiefly for poetry.

ID NEW
label "Adaptor"
description "This links an author to the new work they have adapted."
link_phrase "adapted"
source_entity_type
target_entity_type
parent_id ID 8
child_order 1
deprecated false
reverse_link_phrase "was adapted by"

WD: https://www.wikidata.org/wiki/Q352425
BLURB: This is used to link the person who adapted something to the new resulting worka daptation.

ID 34 {alteration!}
label "Reviser"
description "This links an author to the new work they have revised."
link_phrase "revised"
source_entity_type Author
target_entity_type Work
parent_id ID 8
child_order 2
deprecated false
reverse_link_phrase "was revised by"

WD: https://www.wikidata.org/wiki/Q7318444
BLURB: Indicates that an author revised a work to create a new work.

ID 35 {alteration!}
label "Reconstructor"
description "This links an author to the new work they have reconstructed"
link_phrase "reconstructed"
source_entity_type Author
target_entity_type Work
parent_id ID 8
child_order 3
deprecated false
reverse_link_phrase "was reconstructed by"

WD:
BLURB: Indicates that an author reconstructed a work from fragments of an original, previously lost or incomplete work.

ID 37 {alteration!}
label "Previous Attribution"
description "Links an author with a work they were previously attributed to, before it was discovered they were not the author."
link_phrase "previously had the attribute for"
source_entity_type Author
target_entity_type Work
parent_id ID 8
child_order 4
deprecated false
reverse_link_phrase "was previously attributed to"

WD:
BLURB: This is used for authors that previously had an attribution to a work where it was discovered that this attribution or authorship is incorrect.

ID 1 {alteration!}
label "Worked On"
description "Indicates that an author had some other creative input on a work."
link_phrase "worked on"
source_entity_type Author
target_entity_type Work
parent_id ID 8
child_order 5
deprecated false
reverse_link_phrase "was worked on by"

WD:
BLURB: This is used for miscellaneous, unspecified or small contributions to a work.

ID 31 {alteration!} this should be made deprecated as it's basically the same as "author" (ID 8) any and all using this should be found and changed to ID 8
label "Story"
description "Indicates that an author provided the story for a work (usually a comic book)."
link_phrase "provided story for"
source_entity_type Author
target_entity_type Work
parent_id
child_order
deprecated true
reverse_link_phrase "has story provided by"

= arty (think illustration/design in mb) =

ID 33
label "Artist" {alteration!}
description "Links a visual artist to a particular work."
link_phrase "provided art for"
source_entity_type Author
target_entity_type Work
parent_id
child_order 1
deprecated false
reverse_link_phrase "has art provided by"

WD: https://www.wikidata.org/wiki/Q483501
BLURB: An Artist provides some form of (visual) art for a written work, such as illustration, photography, graphics, comic panels, etc. Importantly, the illustration is a key part of the work, such as in comics, photobooks or illustrated editions. For general illustrations that could differ between editions without creating new works in the process, use [Author]-illustrated-[Edition] instead.

ID 29
label "Illustrator" {alteration!}
description "Indicates a person responsible for illustrating a work."
link_phrase "illustrated"
source_entity_type Author
target_entity_type Work
parent_id ID 33
child_order 0
deprecated false
reverse_link_phrase "was illustrated by"

WD: https://www.wikidata.org/wiki/Q644687
BLURB: This links the person responsible for illustrating a work. Importantly the illustration must be key part of the work, such as in picture books, graphic novels or comics.
For general illustrations that could differ between editions without creating new works in the process, use [Author]-illustrated-[Edition] instead.

ID NEW
label "Photographer"
description "Indicates a photographer for a work"
link_phrase "provided pictures for"
source_entity_type Author
target_entity_type Work
parent_id ID 33
child_order 1
deprecated false
reverse_link_phrase "has pictures by"

WD: https://www.wikidata.org/wiki/Q33231
BLURB: This links the photographer in works were the pictures are an integral part, such as photo-books, art photography and similar.
If the pictures used could differ between editions (or even be removed outright) without this creating new works, use [Author]provided photos for[Edition] instead.

ID NEW
label "Penciller"
description "Indicates the person who pencilled a comic-book work"
link_phrase "pencilled"
source_entity_type Author
target_entity_type Work
parent_id ID 33
child_order 2
deprecated false
reverse_link_phrase "was pencilled by"

WD: https://www.wikidata.org/wiki/Q17098559
BLURB: This links the person who is responsible for drawing the initial line art, layout and often storyboarding of a comic-book work.

ID 30
label "Inker" {alteration!}
description "Indicates a person who inked a comic-book work."
link_phrase "inked"
source_entity_type Author
target_entity_type Work
parent_id ID 33
child_order 3
deprecated false
reverse_link_phrase "was inked by"

WD: https://www.wikidata.org/wiki/Q1153051
BLURB: This links the person who is responsible for inking, embellishing, outlining and finalising the pencilled line art of a comic book work.
The "inking" of the written text is usually done by another person, the "Letterer".

ID NEW
label "Colourist"
description "Indicates a person who coloured a comic book work"
link_phrase "coloured"
source_entity_type
target_entity_type
parent_id ID 33
child_order 4
deprecated false
reverse_link_phrase "was coloured by"

WD: https://www.wikidata.org/wiki/Q1111648
BLURB: This links the person who is responsible for adding colour to the inked line art of a comic book work.
Historically this was done with paints, dyes or prints; nowadays it is mostly done digitally.

ID 32
label "Letterer" {alteration!}
description "Indicates a person who lettered a comic book work"
link_phrase "lettered"
source_entity_type Author
target_entity_type Work
parent_id ID 33
child_order 5
deprecated false
reverse_link_phrase "was lettered by"

WD: https://www.wikidata.org/wiki/Q658404
BLURB: This links the person who is responsible for choosing the typeface, layout and titles and inking the text in a comic book work.

= other (think.. eh, other) =

ID NEW
label "Other"
description "Indicates that an author had some other role on a work"
link_phrase "had a role in"
source_entity_type Author
target_entity_type Work
parent_id
child_order 2
deprecated false
reverse_link_phrase "had a role by"

WD:
BLURB: When a person has some miscellaneous role on a work or a work is linked some other way to an author.

ID NEW
label "Copyright"
description "Indicates that an author has copyright over a work "
link_phrase "copyright ©"
source_entity_type Author
target_entity_type Work
parent_id (Other)
child_order 0
deprecated false
reverse_link_phrase "has copyright by"

WD: https://www.wikidata.org/wiki/Q1297822
BLURB: When a person own copyright over a work. In editions this will often be written as "copyright © [author] [date]"

ID 39
label "Licensor" {alteration!}
description "Indicates that an author licensed a (part of) work"
link_phrase "licensed"
source_entity_type Author
target_entity_type Work
parent_id (Other)
child_order 1
deprecated false
reverse_link_phrase "was licensed by"

WD: https://www.wikidata.org/wiki/Q79719
BLURB: "When a person licences a work (a part of, or a character in, it) they allow a thirdpart to copy and distribute that work, usually it is the original author that does this."

ID 38 {alteration!}
label "Commissioner"
description "Indicates that a work was commissioned by someone."
link_phrase "commissioned"
source_entity_type Author
target_entity_type Work
parent_id (Other)
child_order 2
deprecated false
reverse_link_phrase "was commissioned by"

WD: https://www.wikidata.org/wiki/Q760086
BLURB: When a person commissions a work, they hire someone to write, edit or adapt a work.
ex: Sir Peter Hall commissioned the play "The Devils" (https://bookbrainz.org/work/e8a35985-27c9-40e6-a183-59ed7726aa24)

ID 36 {alteration!}
label "Dedication"
description "Indicates that a work was dedicated to a particular author."
link_phrase "is dedicated to"
source_entity_type Work
target_entity_type Author
parent_id (Other)
child_order 3
deprecated false
reverse_link_phrase "has a dedication in"

WD: https://www.wikidata.org/wiki/Q1898184
BLURB: Use only when a work has a dedication to a specific author or other literature related person.

ID NEW
label "Biography"
description "Indicates that a work was about a particular author."
link_phrase "is about"
source_entity_type Work
target_entity_type Author
parent_id (Other)
child_order 4
deprecated false
reverse_link_phrase "has biography"

WD: https://www.wikidata.org/wiki/Q36279
BLURB: Use only when a work is about a specific author or other literature related person.