How amithm7/web-sis works
Main Components
A. Client Layer:
• Web Browser Interface (HTML/CSS/JS)
• Two main views: Login (login.html) and Main App (app.html)
• Static assets (public folder with css, js, and img)
B. Server Layer:
• Node.js Server (server.js)
• API Endpoints
• Authentication System (evident from login.html)
C. Data Layer:
• MySQL Database (SIS)
• Relational Tables (defined in relations.sql)
┌─────────────────┐
• Presentation │ (Browser Layer)
• ┬────────┘
┌────────┴────────┐
• Application │ (Node.js Server)
• ┬────────┘
┌────────┴────────┐
• Database │ (MySQL)
• ┘
Detailed Component Breakdown
A. Presentation Layer (Top):
• Login Interface
• Main Application Interface
• Static asset containers:
• CSS Files (common.css, login.css, app.css)
• JavaScript (app.js)
• Images
B. Application Layer (Middle):
• Node.js Server
• API Routes
• Authentication Handler
• Session Management
C. Data Layer (Bottom):
• MySQL Database (SIS)
• Relational Tables (from relations.sql)
Connection and Flow Indicators
• HTTP/HTTPS requests between browser and server
• Database queries between server and MySQL
• Authentication flow from login page through server to database
• Static asset delivery paths
Additional Elements
• User session flow
• API endpoint groupings
• Database connection pool
• Static file serving path
Specific Implementation Details
→ HTTP Request
⇢ Database Query
⇄ Two-way Communication
• The separation between static content (in app/public) and dynamic server responses
• The authentication flow from login.html to the main app.html
• The database relationship with the API user 'sisAPI'
• The connection between server.js and the MySQL database