Understanding Convex Database Design Patterns
Hello,
I'm new to Convex, and have some questions about design patterns.
I've a listings table (title, category, etc...)
I want to have variants of that specific listing like color, size, other
Should I create a "listingVariants" table? or I can insert in a document property as an array?
I'm not sure if I'm need to work as a relational or non-relational database.
Then each listing variant needs to have multiple files (images) attached.
Should I create another table "listingVariantImages"? (with the listingVariantId of the table mentioned before).
Thank you!
I'm new to Convex, and have some questions about design patterns.
I've a listings table (title, category, etc...)
I want to have variants of that specific listing like color, size, other
Should I create a "listingVariants" table? or I can insert in a document property as an array?
I'm not sure if I'm need to work as a relational or non-relational database.
Then each listing variant needs to have multiple files (images) attached.
Should I create another table "listingVariantImages"? (with the listingVariantId of the table mentioned before).
Thank you!
