Generar documento de Asignaturas #41

Closed
opened 2026-03-02 21:40:40 +00:00 by alexrg · 2 comments
Owner

Asignaturas

Asignaturas
alexrg added the Kind/Enhancement label 2026-03-02 21:40:40 +00:00
roberto.silva was assigned by alexrg 2026-03-02 21:40:40 +00:00
Author
Owner

Corregir la tabla de estructuras_asignatura

  • Le falta el tipo
  • Le sobra el VERSION
  • Le falta el template_id

Crear la vista

create view public.plantilla_asignatura 
WITH (security_invoker = on)
as select
  asignaturas.id as asignatura_id,
  struct.id as estructura_id,
  struct.template_id
from
  asignaturas
  join estructuras_asignatura struct on asignaturas.estructura_id = struct.id;
# Corregir la tabla de estructuras_asignatura - Le falta el tipo - Le sobra el VERSION - Le falta el template_id # Crear la vista ```sql create view public.plantilla_asignatura WITH (security_invoker = on) as select asignaturas.id as asignatura_id, struct.id as estructura_id, struct.template_id from asignaturas join estructuras_asignatura struct on asignaturas.estructura_id = struct.id; ```
Collaborator
[Anexo 3.docx](/attachments/6b0acf52-02a8-46ea-9334-ddf0d349aca4)
alexrg reopened this issue 2026-03-04 15:55:14 +00:00
Sign in to join this conversation.