10
« on: Febrero 05, 2020, 07:15:17 pm »
Una consulta el año pasado elimine fisicamente de varias tablas a un alumno porque se lo habia inscripto equivocadamente. Este año el alumno vuelve a querer preinscribirse y me sale como que ya es alumno de la facultad. La pregunta es en que tabla me faltaria borrar datos? Adjunto las consultas que utilice para borrarlo. Muchas gracias desde ya.
delete from sga_insc_cursada_instancias
where inscripcion in (select inscripcion from sga_insc_cursada sic, sga_alumnos sa
where sic.alumno = sa.alumno
and sa.propuesta = '10'
and legajo = '03033');
delete from sga_insc_cursada
where inscripcion in (select inscripcion from sga_insc_cursada sic, sga_alumnos sa
where sic.alumno = sa.alumno
and sa.propuesta = '10'
and legajo = '03033');
delete FROM sga_alumnos_hist_calidad
WHERE alumno = ( select alumno FROM sga_alumnos
where propuesta = '10'
and legajo = '03033');
delete FROM sga_alumnos_hist_modalidad
WHERE alumno = ( select alumno FROM sga_alumnos
where propuesta = '10'
and legajo = '03033');
delete FROM sga_alumnos_hist_planes
WHERE alumno = ( select alumno FROM sga_alumnos
where propuesta = '10'
and legajo = '03033');
delete FROM sga_alumnos_hist_ubicacion
WHERE alumno = ( select alumno FROM sga_alumnos
where propuesta = '10'
and legajo = '03033');
delete FROM sga_constancias_solicitud
WHERE alumno = ( select alumno FROM sga_alumnos
where propuesta = '10'
and legajo = '03033');
DELETE FROM sga_alumnos
where propuesta = '10'
and legajo = '03033';
--datos censales
delete from mdp_datos_actividades
where dato_censal = (select dato_censal from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218'));
delete from mdp_datos_economicos
where dato_censal = (select dato_censal from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218'));
delete from mdp_datos_personales
where dato_censal = (select dato_censal from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218'));
delete from mdp_eleccion_institucion
where dato_censal = (select dato_censal from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218'));
delete from mdp_eleccion_propuesta
where dato_censal = (select dato_censal from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218'));
delete from mdp_personas_allegados
where dato_censal = (select dato_censal from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218'));
delete from mdp_datos_censales
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218');
--persona
delete from mdp_datos_estudios
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218');
delete from mdp_personas_contactos
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218');
delete from mdp_personas_documentos
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218');
delete from mdp_personas
where persona = (SELECT mp.persona FROM mdp_personas mp, mdp_personas_documentos mpd
WHERE mp.persona = mpd.persona
AND mpd.nro_documento = '43141218');