MongoDB TGB

bioquimico_mongodb.js

[
    {
        "_id" : ObjectId("5bca202e4bddc2793e6741fb"),
       "CRQ":2118,
       "nome":"Vicente",
       "sobrenome":"Kayser",
       "salario":4200,
       "especialidade":"Fezes",
       "exames":[
        ObjectId("5bca214e4bddc2793e674200") //2
       ], 
       "laboratorio":[ ObjectId("5bca20914bddc2793e6741fe")]
    },
    {
        "_id" : ObjectId("5bca202e4bddc2793e6741fc"),
       "CRQ":4278,
       "nome":"Osvaldo",
       "sobrenome":null,
       "salario":2200,
       "especialidade":"Urina",
       "exames":[
            ObjectId("5bca214e4bddc2793e674200"), //2
            ObjectId("5bca214e4bddc2793e674201")  //3
       ], 
       "laboratorio":[ ObjectId("5bca20914bddc2793e6741fe")]
    },
    {  
        "_id" : ObjectId("5bca202e4bddc2793e6741fd"),
       "CRQ":4465,
       "nome":"Thomas",
       "sobrenome":"Miller",
       "salario":3200,
       "especialidade":"Sangue, Colesterol, Glicose, Albumina",
       "exames":[
            ObjectId("5bca214e4bddc2793e6741ff"), //1
            ObjectId("5bca214e4bddc2793e674201")  //3
       ], 
       "laboratorio":[ ObjectId("5bca20914bddc2793e6741fe")]
    }
 ]

exame_mongodb.js

[
    {
        "_id" : ObjectId("5bca214e4bddc2793e6741ff"),
       "numExame":1,
       "tipos":"Sangue, Colesterol, Glicose, Albumina",
       "CRMmedico":2546,
       "paciente":[
            ObjectId("5bca1e6f4bddc2793e6741f9")
       ],
       "bioquimicos":[
            ObjectId("5bca202e4bddc2793e6741fd") //Thomas
       ]
    },
    {
        "_id" : ObjectId("5bca214e4bddc2793e674200"),
       "numExame":2,
       "tipos":"Urina, Fezes",
       "CRMmedico":2546,
       "paciente":[
            ObjectId("5bca1e6f4bddc2793e6741f9")
        ],
       "bioquimicos":[
            ObjectId("5bca202e4bddc2793e6741fb"), //Vicente
            ObjectId("5bca202e4bddc2793e6741fc") //Osvaldo
       ]
    },
    {
        "_id" : ObjectId("5bca214e4bddc2793e674201"),
       "numExame":3,
       "tipos":"Sangue, Colesterol, Glicose, Urina",
       "CRMmedico":2238,
       "paciente":[
        ObjectId("5bca1e6f4bddc2793e6741fa"),
       ],
       "bioquimicos":[
            ObjectId("5bca202e4bddc2793e6741fc"), //Osvaldo
            ObjectId("5bca202e4bddc2793e6741fd")//Thomas
       ]
    }
 ]

laboratorio_mongodb.js

[
    {
        "_id" : ObjectId("5bca20914bddc2793e6741fe"),
       "id":1,
       "nome":"Laboratório Bom Pastor",
       "cidade":"Taquara",
       "endereco":"Ed Fleming, R. Arnaldo da Costa Bard, 2940 - 101 - Centro",
       "telefone":35421939,
       "bioquimico": [
        ObjectId("5bca202e4bddc2793e6741fb"), //vicente
        ObjectId("5bca202e4bddc2793e6741fc"), //osvaldo
        ObjectId("5bca202e4bddc2793e6741fd"), //Thomas
       ]
    }
 ]

paciente_mongodb.js

[
    {  
      "_id" : ObjectId("5bca1e6f4bddc2793e6741f9"),
      "cpf": 123456789,
      "nome": "Gisela",
      "sobrenome": "Miranda",
      "convenio": "unimed",
      "email": "gisela_difini@hotmail.com",
      "telefone": 984280979,
      "endereco": "Arnaldo da Costa Bard 3129, apto 801"
    },
    { 
      "_id" : ObjectId("5bca1e6f4bddc2793e6741fa"),
      "cpf": 8372013741,
      "nome": "Leonardo",
      "sobrenome": "Felix",
      "email": "leofelix@hotmail.com",
      "endereco": "Universidade do Vale do Rio dos Sinos"
    }
  ]

tgbcollection.js

{
        "_id" : ObjectId("5bca1e6f4bddc2793e6741f9"),
        "cpf" : 123456789,
        "nome" : "Gisela",
        "sobrenome" : "Miranda",
        "convenio" : "unimed",
        "email" : "gisela_difini@hotmail.com",
        "telefone" : 984280979,
        "endereco" : "Arnaldo da Costa Bard 3129, apto 801"
}
{
        "_id" : ObjectId("5bca1e6f4bddc2793e6741fa"),
        "cpf" : 8372013741,
        "nome" : "Leonardo",
        "sobrenome" : "Felix",
        "email" : "leofelix@hotmail.com",
        "endereco" : "Universidade do Vale do Rio dos Sinos"
}
{
        "_id" : ObjectId("5bca202e4bddc2793e6741fb"),
        "CRQ" : 2118,
        "nome" : "Vicente",
        "sobrenome" : "Kayser",
        "salario" : 4200,
        "especialidade" : "Fezes",
        "exames" : [
                ObjectId("5bca214e4bddc2793e674200")
        ],
        "laboratorio" : [
                ObjectId("5bca20914bddc2793e6741fe")
        ]
}
{
        "_id" : ObjectId("5bca202e4bddc2793e6741fc"),
        "CRQ" : 4278,
        "nome" : "Osvaldo",
        "sobrenome" : null,
        "salario" : 2200,
        "especialidade" : "Urina",
        "exames" : [
                ObjectId("5bca214e4bddc2793e674200"),
                ObjectId("5bca214e4bddc2793e674201")
        ],
        "laboratorio" : [
                ObjectId("5bca20914bddc2793e6741fe")
        ]
}
{
        "_id" : ObjectId("5bca202e4bddc2793e6741fd"),
        "CRQ" : 4465,
        "nome" : "Thomas",
        "sobrenome" : "Miller",
        "salario" : 3200,
        "especialidade" : "Sangue, Colesterol, Glicose, Albumina",
        "exames" : [
                ObjectId("5bca214e4bddc2793e6741ff"),
                ObjectId("5bca214e4bddc2793e674201")
        ],
        "laboratorio" : [
                ObjectId("5bca20914bddc2793e6741fe")
        ]
}
{
        "_id" : ObjectId("5bca20914bddc2793e6741fe"),
        "id" : 1,
        "nome" : "Laboratório Bom Pastor",
        "cidade" : "Taquara",
        "endereco" : "Ed Fleming, R. Arnaldo da Costa Bard, 2940 - 101 - Centro",
        "telefone" : 35421939,
        "bioquimico" : [
                ObjectId("5bca202e4bddc2793e6741fb"),
                ObjectId("5bca202e4bddc2793e6741fc"),
                ObjectId("5bca202e4bddc2793e6741fd")
        ]
}
{
        "_id" : ObjectId("5bca214e4bddc2793e6741ff"),
        "numExame" : 1,
        "tipos" : "Sangue, Colesterol, Glicose, Albumina",
        "CRMmedico" : 2546,
        "paciente" : [
                ObjectId("5bca1e6f4bddc2793e6741f9")
        ],
        "bioquimicos" : [
                ObjectId("5bca202e4bddc2793e6741fd")
        ]
}
{
        "_id" : ObjectId("5bca214e4bddc2793e674200"),
        "numExame" : 2,
        "tipos" : "Urina, Fezes",
        "CRMmedico" : 2546,
        "paciente" : [
                ObjectId("5bca1e6f4bddc2793e6741f9")
        ],
        "bioquimicos" : [
                ObjectId("5bca202e4bddc2793e6741fb"),
                ObjectId("5bca202e4bddc2793e6741fc")
        ]
}
{
        "_id" : ObjectId("5bca214e4bddc2793e674201"),
        "numExame" : 3,
        "tipos" : "Sangue, Colesterol, Glicose, Urina",
        "CRMmedico" : 2238,
        "paciente" : [
                ObjectId("5bca1e6f4bddc2793e6741fa")
        ],
        "bioquimicos" : [
                ObjectId("5bca202e4bddc2793e6741fc"),
                ObjectId("5bca202e4bddc2793e6741fd")
        ]
}