How laurenmbell/directcrm works
DirectCRM is an Express/EJS CRM administration app. A user opens a resource page, the app reads MySQL data and renders a page; submitted forms invoke database queries or stored procedures and redirect to the resource. The tree also shows schema, data, and procedure SQL files, but their contents were not sampled, so their internal relationships are not asserted. The available excerpts confirm several page renders and database calls; other route details may be incomplete.
Main entry points: app.js Routes and CRUD · db-connector.js Connection pool · pages Resource pages · partials Shared page partials
Components 9
Web application
- Routes and CRUD
app.js - Resource pages
pages - Shared page partials
views/partials
Data layer
- Connection pool
db-connector.js - MySQL database
SQL assets
- Schema definition
DDL.sql - Data statements
DML.sql - Stored procedures
PL.SQL
Other components
- CRM user
Connections 6
- CRM user → Routes and CRUD: uses routes
- Routes and CRUD → Connection pool: queries data
app.js - Connection pool → MySQL database: opens pool
db-connector.js - Routes and CRUD → Resource pages: renders pages
app.js - Routes and CRUD → Stored procedures: calls procedures
app.js - Routes and CRUD → Shared page partials