DT
Drizzle Team•11mo ago
hacktographer

how to express the "children" relation in parent/child?

I have a table with columns id and parent_id - and I want to setup a parent/child relationship. Using the relations, one, and many I've got this but not sure if it's correct. If I'm able to express my "parent" relationship, shouldn't I also express my "children" relationship as well?
No description
1 Reply
Andrii Sherman
Andrii Sherman•11mo ago
if you need - yes. The only requirement for drizzle relations function is: 1. If you have many relation, you need to defined one as well but you can have just one relation without many if you need
Want results from more Discord servers?
Add your server
More Posts
Too many clients already (!?)Hey guys, been using Drizzle for a few weeks now and I think since last week this issue has started Help, issue that will drop our user tableWe generated and pushed our schemas to a dev branch in planetscale, and then deployed that branch noHow to use a composite primary key in WHERE?I have a table dv360UserProfilesTable which uses a composite key of userId and assignedUserProfileIdHaving statement to compare sql<number> and numberSorry if a dumb question, I'm working on an aggregation query like: ``` const query = await db Select EXISTSHow to query boolean value if row exists or not. In pure sql it will be like this: ```sql SELECT EXIZod schema validation from Drizzle schemaHello i have an issue with zod creating schema from drizzle. I don't understand why my categories wo