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

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

javascript - Replicate keyboard event with html button -

javascript - Web audio api 5.1 surround example not working in firefox -