vw_user_tt_ch_cr_total_comp_cursados

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id_discente

int4

10

√

null

discente.id_discente

Implied Constraint R

ano

int2

5

√

null

periodo

int2

5

√

null

ch_total

int8

19

√

null

cr_total

int8

19

√

null

text

2147483647

√

null

Table contained 0 rows

Relationships

Close relationships within degrees of separation

View Definition

SELECT x.id_discente, x.ano, x.periodo, x.ch_total, x.cr_total, x.text FROM (((SELECT mc.id_discente, mc.ano, mc.periodo, COALESCE(sum(cd.ch_total), (0)::bigint) AS ch_total, ((COALESCE(sum(cd.cr_aula), (0)::bigint) + COALESCE(sum(cd.cr_laboratorio), (0)::bigint)) + COALESCE(sum(cd.cr_estagio), (0)::bigint)) AS cr_total, 'DISCIPLINAS_OBRIGATORIAS_CURSADAS'::text AS text FROM ((ensino.matricula_componente mc JOIN ensino.componente_curricular cc ON ((cc.id_disciplina = mc.id_componente_curricular))) JOIN ensino.componente_curricular_detalhes cd ON ((cd.id_componente_detalhes = cc.id_detalhe))) WHERE ((((((1 = 1) AND (cc.id_tipo_componente <> 4)) AND ((mc.tipo_integralizacao)::text = ANY (ARRAY[('OB'::character varying)::text, ('QB'::character varying)::text]))) AND (cc.id_tipo_componente = 2)) AND (mc.id_situacao_matricula = ANY (ARRAY[4, 21, 22, 23]))) AND (mc.periodo = ANY (ARRAY[1, 2]))) GROUP BY mc.id_discente, mc.ano, mc.periodo ORDER BY mc.id_discente, mc.ano, mc.periodo) UNION ALL (SELECT mc.id_discente, mc.ano, mc.periodo, COALESCE(sum(cd.ch_total), (0)::bigint) AS ch_total, ((COALESCE(sum(cd.cr_aula), (0)::bigint) + COALESCE(sum(cd.cr_laboratorio), (0)::bigint)) + COALESCE(sum(cd.cr_estagio), (0)::bigint)) AS cr_total, 'DISCIPLINAS_COMPLEMENTARES_CURSADAS'::text AS text FROM ((ensino.matricula_componente mc JOIN ensino.componente_curricular cc ON ((cc.id_disciplina = mc.id_componente_curricular))) JOIN ensino.componente_curricular_detalhes cd ON ((cd.id_componente_detalhes = cc.id_detalhe))) WHERE ((((((1 = 1) AND (cc.id_tipo_componente <> 4)) AND ((mc.tipo_integralizacao)::text = 'EC'::text)) AND (mc.id_situacao_matricula = ANY (ARRAY[4, 21, 22, 23]))) AND (cc.id_tipo_componente = 2)) AND (mc.periodo = ANY (ARRAY[1, 2]))) GROUP BY mc.id_discente, mc.ano, mc.periodo ORDER BY mc.id_discente, mc.ano, mc.periodo)) UNION ALL (SELECT mc.id_discente, mc.ano, mc.periodo, COALESCE(sum(cd.ch_total), (0)::bigint) AS ch_total, ((COALESCE(sum(cd.cr_aula), (0)::bigint) + COALESCE(sum(cd.cr_laboratorio), (0)::bigint)) + COALESCE(sum(cd.cr_estagio), (0)::bigint)) AS cr_total, 'ATIVIDADES_CURSADAS'::text AS text FROM ((ensino.matricula_componente mc JOIN ensino.componente_curricular cc ON ((cc.id_disciplina = mc.id_componente_curricular))) JOIN ensino.componente_curricular_detalhes cd ON ((cd.id_componente_detalhes = cc.id_detalhe))) WHERE (((((1 = 1) AND (cc.id_tipo_componente <> 4)) AND ((mc.tipo_integralizacao)::text = 'EC'::text)) AND (mc.id_situacao_matricula = ANY (ARRAY[4, 21, 22, 23]))) AND (cc.id_tipo_componente = 1)) GROUP BY mc.id_discente, mc.ano, mc.periodo ORDER BY mc.id_discente, mc.ano, mc.periodo)) x;

vw_user_tt_ch_cr_total_comp_cursados

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views