Assits with relationships
How can i get projects which for members in which thier id is the projectmembers table
projects: defineTable({
title: v.string(),
description: v.string(),
url: v.optional(v.string()),
github: v.optional(v.string()),
deadline: v.string(),
startTime: v.string(),
creator: v.id("users"),
isCompleted: v.boolean(),
coverImage:v.optional(v.string()),
}),
projectMembers: defineTable({
projectId: v.id("projects"),
userId: v.id("users"),
role: v.string(),
})
.index("by_projectId", ["projectId"])
.index("by_userId", ["userId"]),
projects: defineTable({
title: v.string(),
description: v.string(),
url: v.optional(v.string()),
github: v.optional(v.string()),
deadline: v.string(),
startTime: v.string(),
creator: v.id("users"),
isCompleted: v.boolean(),
coverImage:v.optional(v.string()),
}),
projectMembers: defineTable({
projectId: v.id("projects"),
userId: v.id("users"),
role: v.string(),
})
.index("by_projectId", ["projectId"])
.index("by_userId", ["userId"]),
