📊 Resumen — saat_base.db
| Tabla | Filas | Regla |
|---|---|---|
| sede | 5 | 5 sedes, sin relacion con facultades |
| facultad | 5 | 5 facultades, sin relacion con sedes |
| escuela | 25 | 5 por facultad = 25. 1 escuela → 1 facultad |
| carrera | 25 | 1 por escuela = 25. 1 carrera → 1 escuela |
| plan | 25 | 1 por carrera = 25. 1 plan → 1 carrera, estado 0/1 |
| plan_sede | 50 | Un plan en varias sedes |
| pidem | 60 | 10. Solo codigo + estado |
| matricula | 65 | PK (p,pl). Nunca mismo plan en varias sedes |
| dimension | 5 | 5 |
| variable | 25 | 5 por dimensión = 25 |
| indice | 5 | 5, 1 por dimensión |
| indice_variable | 25 | 25 con peso, suman 1.00 por índice |
| riesgo | 2 | 2 |
| riesgos_indices | 10 | 10 con peso, suman 1.00 por riesgo |
📝 Matrículas
| p | c | pl | s | e | fi |
|---|---|---|---|---|---|
| 100001 | c1 | p1 | s1 | e1 | 2021-01-15 |
| 100002 | c2 | p2 | s2 | e2 | 2021-02-01 |
| 100002 | c3 | p3 | s3 | e3 | 2021-02-10 |
| 100003 | c4 | p4 | s4 | e4 | 2022-01-12 |
| 100004 | c5 | p5 | s5 | e5 | 2022-01-20 |
| 100004 | c6 | p6 | s1 | e6 | 2022-02-05 |
| 100005 | c7 | p7 | s2 | e7 | 2023-01-10 |
| 100006 | c10 | p10 | s5 | e10 | 2024-01-15 |
| 100006 | c8 | p8 | s3 | e8 | 2023-01-18 |
| 100006 | c9 | p9 | s4 | e9 | 2023-02-02 |
| 100007 | c11 | p11 | s1 | e11 | 2024-02-01 |
| 100008 | c12 | p12 | s2 | e12 | 2024-02-10 |
| 100009 | c13 | p13 | s3 | e13 | 2024-03-01 |
| 100009 | c14 | p14 | s4 | e14 | 2024-03-10 |
| 100010 | c15 | p15 | s5 | e15 | 2024-03-20 |
| 200001 | c1 | p1 | s1 | e1 | 2024-02-01 |
| 200002 | c1 | p1 | s2 | e1 | 2024-02-01 |
| 200003 | c10 | p10 | s1 | e10 | 2024-02-01 |
| 200004 | c10 | p10 | s5 | e10 | 2024-02-01 |
| 200005 | c11 | p11 | s1 | e11 | 2024-02-01 |
| 200006 | c11 | p11 | s2 | e11 | 2024-02-01 |
| 200007 | c12 | p12 | s2 | e12 | 2024-02-01 |
| 200008 | c12 | p12 | s3 | e12 | 2024-02-01 |
| 200009 | c13 | p13 | s3 | e13 | 2024-02-01 |
| 200010 | c13 | p13 | s4 | e13 | 2024-02-01 |
| 200011 | c14 | p14 | s4 | e14 | 2024-02-01 |
| 200012 | c14 | p14 | s5 | e14 | 2024-02-01 |
| 200013 | c15 | p15 | s1 | e15 | 2024-02-01 |
| 200014 | c15 | p15 | s5 | e15 | 2024-02-01 |
| 200015 | c16 | p16 | s1 | e16 | 2024-02-01 |
| 200016 | c16 | p16 | s2 | e16 | 2024-02-01 |
| 200017 | c17 | p17 | s2 | e17 | 2024-02-01 |
| 200018 | c17 | p17 | s3 | e17 | 2024-02-01 |
| 200019 | c18 | p18 | s3 | e18 | 2024-02-01 |
| 200020 | c18 | p18 | s4 | e18 | 2024-02-01 |
| 200021 | c19 | p19 | s4 | e19 | 2024-02-01 |
| 200022 | c19 | p19 | s5 | e19 | 2024-02-01 |
| 200023 | c2 | p2 | s2 | e2 | 2024-02-01 |
| 200024 | c2 | p2 | s3 | e2 | 2024-02-01 |
| 200025 | c20 | p20 | s1 | e20 | 2024-02-01 |
| 200026 | c20 | p20 | s5 | e20 | 2024-02-01 |
| 200027 | c21 | p21 | s1 | e21 | 2024-02-01 |
| 200028 | c21 | p21 | s2 | e21 | 2024-02-01 |
| 200029 | c22 | p22 | s2 | e22 | 2024-02-01 |
| 200030 | c22 | p22 | s3 | e22 | 2024-02-01 |
| 200031 | c23 | p23 | s3 | e23 | 2024-02-01 |
| 200032 | c23 | p23 | s4 | e23 | 2024-02-01 |
| 200033 | c24 | p24 | s4 | e24 | 2024-02-01 |
| 200034 | c24 | p24 | s5 | e24 | 2024-02-01 |
| 200035 | c25 | p25 | s1 | e25 | 2024-02-01 |
| 200036 | c25 | p25 | s5 | e25 | 2024-02-01 |
| 200037 | c3 | p3 | s3 | e3 | 2024-02-01 |
| 200038 | c3 | p3 | s4 | e3 | 2024-02-01 |
| 200039 | c4 | p4 | s4 | e4 | 2024-02-01 |
| 200040 | c4 | p4 | s5 | e4 | 2024-02-01 |
| 200041 | c5 | p5 | s1 | e5 | 2024-02-01 |
| 200042 | c5 | p5 | s5 | e5 | 2024-02-01 |
| 200043 | c6 | p6 | s1 | e6 | 2024-02-01 |
| 200044 | c6 | p6 | s2 | e6 | 2024-02-01 |
| 200045 | c7 | p7 | s2 | e7 | 2024-02-01 |
| 200046 | c7 | p7 | s3 | e7 | 2024-02-01 |
| 200047 | c8 | p8 | s3 | e8 | 2024-02-01 |
| 200048 | c8 | p8 | s4 | e8 | 2024-02-01 |
| 200049 | c9 | p9 | s4 | e9 | 2024-02-01 |
| 200050 | c9 | p9 | s5 | e9 | 2024-02-01 |