Hi
I am creating a database which has below fields:
1)Product ID(1001,1002 etc)
2)Product Category(Cycle,Soft Toys)
3)Product Specifications(Height,Weight,Width,Type etc)
Every category has a list of specifications, like a category “cycle” has specifications:
- built material
- height
- weight
- age group
- type size
Soft toys has different specifications:
- stuffed matrial
- age group
- color
Now,every product has a product Id, one category and a set of specifications all of which has a value)
{
1001;
Cycle;
{height:100cm
weight:100gm
}
}
Please let me know how should I structure my database ?
I am thinking of making a datatype “product” with the below fields:
1)Product ID-text
2)Product Category-text
3)Product Specifications-(Now here I want to store this as key-value pair) eg.
{weight-100gm
height-10cm}
But I cannot find how to use key-value pair in bubble database?