This issue seems to be fixed in 1.5, but I'm unable to create multiple many-to-one relationships to the same collection.
https://github.com/appwrite/appwrite/issues/6281
Attribute with the requested key already exists. Attribute keys must be unique, try again with a different key.