Report for copilotoc3_local_all made in Moon Modeler

Name

ConformidadPlan

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

con_conteo

int

Yes

con_estado

string

Yes

con_num_carta

int

Any type restrictions

"string","null"

asesor_id

string

Yes

con_actualido_el

date

Yes

Indexes

_id_

Create statement

db.ConformidadPlan.createIndex(
{
  "_id": 1
})

Name

Oficio

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

of_numero

int

Any type restrictions

"string","null"

of_num_expediente

int

Any type restrictions

"string","null"

of_estado

string

Yes

of_observacion

string

Any type restrictions

"null","string"

proyecto_id

objectId

Yes

tipo_oficio_id

string

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Oficio.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Name

Usuario

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

us_email

string

Yes

us_password

string

Yes

rol_id

objectId

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Usuario.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Name

Rol

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

ro_nombre

string

Yes

permisos_ids

string

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Rol.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Name

Sustentacion

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

sus_fecha

date

Yes

sus_hora

string

Yes

sus_estado

string

Yes

sus_calificacion

int

proyecto_id

objectId

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Sustentacion.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Sustentacion

Name

Resolucion

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

res_numero

int

Any type restrictions

"string","null"

red_estado

string

Yes

res_observacion

null

of_id

string

Yes

tipo_res_id

string

Yes

facultad_id

string

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Resolucion.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Name

Tesis

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

tes_titulo

string

Yes

Any type restrictions

"null","string"

tes_tipo_inves

string

Yes

Any type restrictions

"null","string"

tes_estado

string

Yes

tes_num

int

Any type restrictions

"string","null"

tes_doc_plan

string

tes_doc_informe

string

tes_revisores

tes_revisores (object)

Yes

estudiante_id

objectId

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Tesis.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Name

Revisor

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

rev_rango

string

Yes

rev_nombre

string

Yes

rev_apellido_paterno

string

Yes

rev_apellido_materno

string

Yes

rev_dni

string

Yes

rev_orcid

string

Yes

rev_celular

string

Yes

rev_firma

string

Yes

rev_num_limite

any

Yes

Any type restrictions

"double","string"

rev_num_tesista

double

Yes

rev_multiple_data

Yes

usuario_id

string

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Revisor.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

tes_revisores (object)

Name

Facultad

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

fa_nombre

string

Yes

fa_siglas

string

Yes

fa_dec_nombre

string

Yes

fa_dec_apellido_paterno

string

Yes

fa_dec_apellido_materno

string

Yes

fa_dec_rango

string

Yes

fa_dec_firma

string

Yes

fa_secre_firma

string

Yes

user_id

string

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Facultad.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Name

Filtro

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

fil_orden

string

Yes

fil_estado

string

Yes

fil_num_constancia

string

fil_porcen_similitud

string

fil_reporte

string

proyecto_id

objectId

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Filtro.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

comentarios_plan (object)

Filtro

Name

Comentario

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

proyecto_id

string

Yes

comentarios_plan

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Comentario.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

his_proyecto_datos (object)

Comentario

Name

Historial

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

his_accion

string

his_fase

string

his_observacion

any

Any type restrictions

"string","null"

his_proyecto_datos

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Historial.createIndex(
{
  "_id": 1
})

Name

Sedes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

se_nombre

string

Yes

se_siglas

string

Yes

References

Name

Source

Target

Name

Permiso

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

pe_nombre

string

Yes

pe_descripcion

string

Yes

updated_at

date

Yes

created_at

date

Yes

Indexes

_id_

Create statement

db.Permiso.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

Permiso

Rol

Name

TipoResolucion

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

tr_nombre

string

Yes

References

Name

Source

Target

TipoResolucion

Name

ConformidadInforme

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

con_conteo

int

Yes

con_estado

string

Yes

con_num_carta

int

Any type restrictions

"string","null"

con_calificacion

int

Yes

asesor_id

string

Yes

con_actualido_el

date

Yes

Indexes

_id_

Create statement

db.ConformidadInforme.createIndex(
{
  "_id": 1
})

Name

TipoOficio

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

to_nombre

string

Yes

References

Name

Source

Target

TipoOficio

Objects

Name

rev_multiple_data

Fields

Name

Data type

Array

Key

Required

ase_es_activo

bool

Yes

ase_es_jurado

bool

Yes

program_id

objectId

Yes

sede_id

objectId

Yes

References

Name

Source

Target

Name

autor

Fields

Name

Data type

Array

Key

Required

displayName

string

Yes

Name

autor

Fields

Name

Data type

Array

Key

Required

nombre

string

Yes

Name

respuestas

Fields

Name

Data type

Array

Key

Required

string

Yes

content

string

Yes

fecha_creacion

date

Yes

autor

autor (object)

Yes

Name

comentarios_plan

Fields

Name

Data type

Array

Key

Required

string

Yes

contenido

string

Yes

fecha_creacion

date

Yes

estado

bool

Yes

respuestas

respuestas (object)

Yes

autor

autor (object)

Yes

Name

tes_revisores

Fields

Name

Data type

Array

Key

Required

pro_rol_asesor

string

Yes

asesor_id

objectId

Yes

References

Name

Source

Target

tes_revisores (object)

Name

his_proyecto_datos

Fields

Name

Data type

Array

Key

Required

pro_titulo

string

updated_at

date

Yes

references

Name

Source

Target

Rol

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

Source

Target

Facultad

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Permiso

Rol

Cardinality type:

Many to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

rev_multiple_data

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Facultad

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

rev_multiple_data

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Facultad

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

Source

Target

TipoResolucion

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

tes_revisores

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

Source

Target

Filtro

Cardinality type:

One to

many

Ordinality:

Mandatory

Name

Source

Target

Sustentacion

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target

TipoOficio

Cardinality type:

One to

one

Ordinality:

Mandatory

Name

Source

Target