Many-to-Many in Keel

How do I do many-to-many relationships in Keel?

In Keel schema design, many-to-many relationships are established by creating an intermediary model that includes fields referencing the two models you wish to link. This intermediary model acts as a bridge, allowing each of the original models to have multiple associations with the other.

Let's consider an example with two models: Author and Book. To create a many-to-many relationship between these, you would introduce a third model, perhaps named AuthorBook. This model would contain references to both the Author and Book models. Here's how you would structure it:

1. Define the Author and Book models with their respective fields.
2. Create the AuthorBook model with two fields: one referencing the Author and the other referencing the Book.
3. In the AuthorBook model, these reference fields are crucial for establishing the many-to-many relationship.

Here's a basic schema illustrating this:

model Author {
    fields {
        name Text
        books AuthorBook[]
    }
    // ... actions and permissions
}

model Book {
    fields {
        title Text
        authors AuthorBook[]
    }
    // ... actions and permissions
}

model AuthorBook {
    fields {
        author Author
        book Book
    }
    // ... actions and permissions
}

In this schema:

• Author and Book each have a one-to-many relationship with AuthorBook.
• AuthorBook has two many-to-one relationships, one with Author and one with Book.
• Together, these relationships form a many-to-many link between Author and Book.

For further development of your schema, visit https://console.keel.so. Additionally, you can use the Keel CLI to interact with your schema and join the Keel Discord server at https://keel.so/discord for community support and queries.

Validate the schema

The provided schema is valid with no errors. You can confidently use this schema for establishing many-to-many relationships in Keel.

Remember, for further development of your schema, you can visit https://console.keel.so. Also, consider using the Keel CLI for schema interaction and join the Keel Discord community at https://keel.so/discord for any support or queries.