Skip to content

ModeloDB.md

Latest commit

 

History

History
104 lines (97 loc) · 2.69 KB

ModeloDB.md

File metadata and controls

104 lines (97 loc) · 2.69 KB

MODELO DE BASE DE DATOS

Brito Enzo Exequiel

Las Colecciones Creadas:⬇.

USUARIOS

{
    nombre: {type: String,required: true},
    apellido: {type: String,required: true},
    dni: {type: String,required: true},
    email: {type: String,required: true},
    contrasena: {type: String,required: true},
    fotoURL:{type: String,required: true},
    Perfiles [
        {
            tipo: [
                {
                    alumno:{type: Boolean,default: true},
                    profesor:{type: Boolean,default: false},
                    administrados:{type: Boolean,default: false},
                }
            ],
            dataAlumno:[
                {
                    carrera:{type: String}, 
                    analitico: {type: String},
                    certificadoDomicilio: {type: String},
                }
            ],
            dataProfesores:[{datos: {type: String}}
            ],
            dataAdmin:[{datos: {type: String},}
            ]
        }
    ],
    activo: {type: Boolean,default: true}
}

MATERIAS

{
    descripcionMateria: {type: String,require: true,},
    profTitular: {type: mongoose.Schema.Types.ObjectId,ref: 'User'},
    profAux: {type: mongoose.Schema.Types.ObjectId,ref: 'User'},
    carrera: {type: Schema.Types.ObjectId,ref: "Carreras",},
    anio: {type: String,required: true},
    horarioIncio: {type: String,require: true,},
    horarioFinal: {type: String,require: true,},
    notas:[
        {
            Alumno: {type: mongoose.Schema.Types.ObjectId,ref: 'User'},
            parcial1:{type: String,require: true,},
            parcial2:{type: String,require: true,},
            parcial3:{type: String,require: true,},
            recuperatorio:{type: String,require: true,},
            final:{type: String,require: true,},
            estado:{type: String,require: true,},
        }
    ],
    inasistencia: [
    {
      dia: {type: Date,},
      idUser:{type: Schema.Types.ObjectId,ref: "User",},
    },
  ],
    activo: {type: Boolean,default: true}
}

CARRERAS

{
    nombreCarrera: {type: String,required: true,},
    activo: {type: Boolean,default: true,},
},

PUBLICACIONES

{
    autorNombre: {type: Schema.Types.ObjectId,ref: "User",},
    tipo: {type: String,required: true,},
    contenido: {type: String,required: true,},
    fecha: {type: Date,required: true,},
    imagenURL:{type: String,}
}

COMENTARIOS

{
    autor: {type: Schema.Types.ObjectId,ref: "User",},
    descripcion: {type: String,required: true,},
},