json
{
"_id": 1,
"user_id": 123,
"order_date": "2021-01-01",
"products": [
{
"product_id": 1,
"price": 1000
},
{
"product_id": 2,
"price": 2000
}
]
}
json
{
"_id": 1,
"user_id": 123,
"order_date": "2021-01-01",
"product_ids": [1, 2]
}
json
{
"_id": 1,
"price": 1000
}
{
"_id": 2,
"price": 2000
}
script
db.collection.createIndex({ "product_name": 1 })
script
db.createCollection("orders", {
validator: {
$jsonSchema: {
bsonType: "object",
properties: {
products: {
bsonType: "array",
items: {
bsonType: "object",
required: ["product_id", "product_name", "price"],
properties: {
product_id: { bsonType: "int" },
product_name: { bsonType: "string" },
price: { bsonType: "double" }
}
}
}
}
}
}
})
