Need help creating and organizing my schema:
Here's is what I am trying to achieve:
I am working on app that helps users to improve thier essay writing skills. There are three ways they can create an essay:
1) Blank Essay Page, where they have to manually enter an essay title
2) An essay with an already prepared essay title beforehand, so the user needs to pick one, and start writing its content. The essay also needs to have a list of categories for filtering
3) Similar to 2nd one, but this time, along with the essay title, there is a data chart that is also prepared before hand and also has list of categories like economics, science, tech, and etc.
Additionally, all the essay content should be evaluated by an AI and will be assessed based on a sclae of 1-10.
Here's how my initial schema looks like:
blankEssay: defineTable({
title: v.string(),
userId: v.string(),
isArchived: v.boolean(),
content: v.optional(v.string()),
isPublished: v.optional(v.boolean()),
score: v.optional(v.number()),
}).index("by_user", ["userId"]),
chartEssays: defineTable({
title: v.string(),
userId: v.string(),
isArchived: v.boolean(),
content: v.optional(v.string()),
isPublished: v.optional(v.boolean()),
score: v.optional(v.number()),
// additional table for displaying the charts:
chartData: v.optional(v.string()),
}).index("by_user", ["userId"]),
});
It would be great if I could have one table called essays that has a relation to "blankEssays", "selectEssays", chartEssays", and all of these tables had a relationship to "essayCategories" and "score" table. How to achieve that? Please, anyone help...
I am working on app that helps users to improve thier essay writing skills. There are three ways they can create an essay:
1) Blank Essay Page, where they have to manually enter an essay title
2) An essay with an already prepared essay title beforehand, so the user needs to pick one, and start writing its content. The essay also needs to have a list of categories for filtering
3) Similar to 2nd one, but this time, along with the essay title, there is a data chart that is also prepared before hand and also has list of categories like economics, science, tech, and etc.
Additionally, all the essay content should be evaluated by an AI and will be assessed based on a sclae of 1-10.
Here's how my initial schema looks like:
blankEssay: defineTable({
title: v.string(),
userId: v.string(),
isArchived: v.boolean(),
content: v.optional(v.string()),
isPublished: v.optional(v.boolean()),
score: v.optional(v.number()),
}).index("by_user", ["userId"]),
chartEssays: defineTable({
title: v.string(),
userId: v.string(),
isArchived: v.boolean(),
content: v.optional(v.string()),
isPublished: v.optional(v.boolean()),
score: v.optional(v.number()),
// additional table for displaying the charts:
chartData: v.optional(v.string()),
}).index("by_user", ["userId"]),
});
It would be great if I could have one table called essays that has a relation to "blankEssays", "selectEssays", chartEssays", and all of these tables had a relationship to "essayCategories" and "score" table. How to achieve that? Please, anyone help...
Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.
15,010Members
Resources
Similar Threads
Was this page helpful?
