primeros_grados_por_modalidad

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

niv_pk

int8

19

√

null

sg_niveles.niv_pk

Implied Constraint

R

cic_pk

int8

19

√

null

sg_ciclos.cic_pk

Implied Constraint

R

mod_pk

int8

19

√

null

sg_modalidades.mod_pk

Implied Constraint

R

gra_pk

int8

19

√

null

sg_grados.gra_pk

Implied Constraint

R

Relationships

Close relationships within degrees of separation

View Definition

SELECT a.niv_pk,
    a.cic_pk,
    a.mod_pk,
    a.gra_pk
   FROM (( SELECT niv.niv_pk,
            cic.cic_pk,
            modedu.mod_pk,
            gra.gra_pk,
            gra.gra_orden
           FROM ((((centros_educativos.sg_grados gra
             JOIN centros_educativos.sg_rel_mod_ed_mod_aten relmodaten ON ((gra.gra_relacion_modalidad_fk = relmodaten.rea_pk)))
             JOIN centros_educativos.sg_modalidades modedu ON ((relmodaten.rea_modalidad_educativa_fk = modedu.mod_pk)))
             JOIN centros_educativos.sg_ciclos cic ON ((modedu.mod_ciclo = cic.cic_pk)))
             JOIN centros_educativos.sg_niveles niv ON ((cic.cic_nivel = niv.niv_pk)))) a
     JOIN ( SELECT niv.niv_pk,
            niv.niv_orden,
            cic.cic_pk,
            cic.cic_orden,
            modedu.mod_pk,
            modedu.mod_orden,
            min(gra.gra_orden) AS min_gra
           FROM ((((centros_educativos.sg_grados gra
             JOIN centros_educativos.sg_rel_mod_ed_mod_aten relmodaten ON ((gra.gra_relacion_modalidad_fk = relmodaten.rea_pk)))
             JOIN centros_educativos.sg_modalidades modedu ON ((relmodaten.rea_modalidad_educativa_fk = modedu.mod_pk)))
             JOIN centros_educativos.sg_ciclos cic ON ((modedu.mod_ciclo = cic.cic_pk)))
             JOIN centros_educativos.sg_niveles niv ON ((cic.cic_nivel = niv.niv_pk)))
          GROUP BY niv.niv_pk, cic.cic_pk, modedu.mod_pk) b ON (((a.niv_pk = b.niv_pk) AND (a.cic_pk = b.cic_pk) AND (a.mod_pk = b.mod_pk) AND (a.gra_orden = b.min_gra))));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views