How mrchocman/matricore works
MatriCore is a Tkinter desktop application for school enrollment management. Users choose an Apoderado or Secretaría login, then use a role-adapted dashboard to view enrollment records; they can submit enrollment requests or, as Secretaría, update or annul records and open institutional reports. The Python DAO connects directly to PostgreSQL, whose documented schema, RBAC procedures, triggers, and report functions implement persistence and business rules. SQL setup scripts are included as product data artifacts. Source excerpts do not show the SQL script contents, so SQL relationships rely on README documentation.
Main entry points: database.py Database manager · ui_login.py Role login · SCRIPTS SQL DE SEGURIDAD.sql Roles and workflows · main.py App orchestrator
Components 12
Desktop application
- App orchestrator
main.py - Role login
ui_login.py - Enrollment dashboard
ui_dashboard.py
Data access
- Connection settings
config.py - Database manager
database.py
Enrollment database
- Relational schema
sql/CREACION DE BD Y TABLAS.sql - Initial records
sql/INSERCION REGISTROS.sql - Roles and workflows
sql/SCRIPTS SQL DE SEGURIDAD.sql
Institutional reporting
- Reports viewer
ui_reportes.py - Report functions
sql/SCRIPTS SQL DE SEGURIDAD.sql
Other components
- School user
- PostgreSQL
Connections 18
- School user → Role login: provides credentials
- App orchestrator → Role login: shows login
main.py - Role login → App orchestrator: reports success
ui_login.py - App orchestrator → Enrollment dashboard: shows dashboard
main.py - Role login → Database manager: authenticates with
ui_login.py - Enrollment dashboard → Database manager: loads and changes
ui_dashboard.py - Enrollment dashboard → Reports viewer: opens reports
ui_dashboard.py - Reports viewer → Database manager: requests reports
ui_reportes.py - Database manager → Connection settings: reads settings
database.py - Database manager → PostgreSQL: queries and calls
database.py - Relational schema → Initial records: precedes loading
README.md - Initial records → Roles and workflows: precedes setup
README.md - Database manager → Roles and workflows: calls stored procedures
database.py - Roles and workflows → Report functions: defines report functions
README.md - Database manager → Report functions: queries report functions
database.py - Relational schema → PostgreSQL: defines database tables
- Initial records → PostgreSQL: loads initial data
- Roles and workflows → PostgreSQL: configures roles and triggers