perusteenosa_projekti

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int8

19

√

null

perusteprojekti_id

int8

19

√

null

ryhmaoid

varchar

255

√

null

tila

varchar

255

√

null

esikatseltavissa

bool

1

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH RECURSIVE vanhemmat AS (
         SELECT pov.id,
            pov.vanhempi_id,
            pov.perusteenosa_id
           FROM perusteenosaviite pov,
            perusteenosa po
          WHERE (pov.perusteenosa_id = po.id)
        UNION ALL
         SELECT pov.id,
            pov.vanhempi_id,
            v.perusteenosa_id
           FROM perusteenosaviite pov,
            vanhemmat v
          WHERE (pov.id = v.vanhempi_id)
        )
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    digitaalinenosaaminen_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    tutkintoonvalmentava_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    vapaasivistystyo_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    tpo_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    suoritustapa s,
    peruste_suoritustapa ps,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_perusteenosaviite_id = v.id) AND (ps.suoritustapa_id = s.id) AND (ps.peruste_id = p.id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    yl_perusop_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    yl_aipe_opetuksensisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    esiop_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    opas_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    yl_lukiokoulutuksen_perusteen_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT v.perusteenosa_id AS id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM vanhemmat v,
    yl_lops2019_sisalto s,
    peruste p,
    perusteprojekti pp
  WHERE ((s.sisalto_id = v.id) AND (p.id = s.peruste_id) AND (pp.peruste_id = p.id))
UNION
 SELECT DISTINCT po.id,
    pp.id AS perusteprojekti_id,
    pp.ryhmaoid,
    pp.tila,
    pp.esikatseltavissa
   FROM perusteenosa po,
    tutkinnonosaviite v,
    suoritustapa s,
    peruste_suoritustapa ps,
    peruste p,
    perusteprojekti pp
  WHERE ((po.id = v.tutkinnonosa_id) AND (v.suoritustapa_id = s.id) AND (ps.suoritustapa_id = s.id) AND (ps.peruste_id = p.id) AND (pp.peruste_id = p.id));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views