nosql - Data Modeling DynamoDB -
i'm begginer in nosql , i'm making application client need make quotation products , distributor can make value estimate quotation , later client choose 1 value estimate. thinked this:
client:[ { id:"string", name:"string", email:"string", address:[ { name:"string", street:"string" } ], quotations[ { id:"string", date:"date", status: [ { date:"date", status:"string", iddistributor:"string", price:"number" } ] products:[ { name:"string", quantity:"int", unit:"string" } ] } ] } ] distributor:[ { id:"string", name:"string" (...) } ]
my doubt quotation stay in client or "table" separated.
the application need queries (to make data modeling):
- show quotations of client
- show quotations of clients status pending
- show quotations distributor make value estimate
- show client min value estimate of quotation
- show distributor if value estimate chosen
Comments
Post a Comment