CREATE TABLE informe_anual(
    id_informe_pk int not null primary key auto_increment,
    id_organizacion_fk int UNSIGNED not null,
    periodo year null,
    numero_beneficiario int not null,
    numero_voluntario int not null,
    programas_realizados text null,
    directorio varchar(200) null,
    nombre_documento varchar(200) null,
    extension varchar(50) null,
    ruta_relativa varchar(200) null,
    estado_informe int null,
    FOREIGN KEY (id_organizacion_fk) REFERENCES organizations(id_organization_pk) on delete cascade on update cascade
);