# 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;
```
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Asignaturas
Corregir la tabla de estructuras_asignatura
Crear la vista
Anexo 3.docx