SAAT saat_model.php

Base: saat_base.db · ✅ saat_base.db · General + anonimizado · Sin id, llave = codigo · FOREIGN KEY con REFERENCES

⬇ Exportar JSON ↩ Ir a saat_instal.php

📊 Resumen — saat_base.db

TablaFilasRegla
sede55 sedes, sin relacion con facultades
facultad55 facultades, sin relacion con sedes
escuela255 por facultad = 25. 1 escuela → 1 facultad
carrera251 por escuela = 25. 1 carrera → 1 escuela
plan251 por carrera = 25. 1 plan → 1 carrera, estado 0/1
plan_sede50Un plan en varias sedes
pidem6010. Solo codigo + estado
matricula65PK (p,pl). Nunca mismo plan en varias sedes
dimension55
variable255 por dimensión = 25
indice55, 1 por dimensión
indice_variable2525 con peso, suman 1.00 por índice
riesgo22
riesgos_indices1010 con peso, suman 1.00 por riesgo

📝 Matrículas

pcplsefi
100001c1p1s1e12021-01-15
100002c2p2s2e22021-02-01
100002c3p3s3e32021-02-10
100003c4p4s4e42022-01-12
100004c5p5s5e52022-01-20
100004c6p6s1e62022-02-05
100005c7p7s2e72023-01-10
100006c10p10s5e102024-01-15
100006c8p8s3e82023-01-18
100006c9p9s4e92023-02-02
100007c11p11s1e112024-02-01
100008c12p12s2e122024-02-10
100009c13p13s3e132024-03-01
100009c14p14s4e142024-03-10
100010c15p15s5e152024-03-20
200001c1p1s1e12024-02-01
200002c1p1s2e12024-02-01
200003c10p10s1e102024-02-01
200004c10p10s5e102024-02-01
200005c11p11s1e112024-02-01
200006c11p11s2e112024-02-01
200007c12p12s2e122024-02-01
200008c12p12s3e122024-02-01
200009c13p13s3e132024-02-01
200010c13p13s4e132024-02-01
200011c14p14s4e142024-02-01
200012c14p14s5e142024-02-01
200013c15p15s1e152024-02-01
200014c15p15s5e152024-02-01
200015c16p16s1e162024-02-01
200016c16p16s2e162024-02-01
200017c17p17s2e172024-02-01
200018c17p17s3e172024-02-01
200019c18p18s3e182024-02-01
200020c18p18s4e182024-02-01
200021c19p19s4e192024-02-01
200022c19p19s5e192024-02-01
200023c2p2s2e22024-02-01
200024c2p2s3e22024-02-01
200025c20p20s1e202024-02-01
200026c20p20s5e202024-02-01
200027c21p21s1e212024-02-01
200028c21p21s2e212024-02-01
200029c22p22s2e222024-02-01
200030c22p22s3e222024-02-01
200031c23p23s3e232024-02-01
200032c23p23s4e232024-02-01
200033c24p24s4e242024-02-01
200034c24p24s5e242024-02-01
200035c25p25s1e252024-02-01
200036c25p25s5e252024-02-01
200037c3p3s3e32024-02-01
200038c3p3s4e32024-02-01
200039c4p4s4e42024-02-01
200040c4p4s5e42024-02-01
200041c5p5s1e52024-02-01
200042c5p5s5e52024-02-01
200043c6p6s1e62024-02-01
200044c6p6s2e62024-02-01
200045c7p7s2e72024-02-01
200046c7p7s3e72024-02-01
200047c8p8s3e82024-02-01
200048c8p8s4e82024-02-01
200049c9p9s4e92024-02-01
200050c9p9s5e92024-02-01