📄️ Relation Definition
By defining relations between multiple sheets, you can retrieve related data with include and filter using relation conditions in where.
📄️ include
Used to retrieve related data together with findMany / findFirst.
📄️ where Relation Filter
Used to filter based on related data within where conditions.
📄️ onDelete
Defines how related records should be handled when records are deleted with deleteMany.
📄️ Nested Write (create)
Used to simultaneously create and associate records in relation targets within the create method.
📄️ onUpdate
Defines how related records should be handled when a record's PK (primary key) is changed with update / updateMany / updateManyAndReturn.
📄️ Nested Write (update)
You can simultaneously operate on related records within the data of the update method.