Experimental Sequence 01
Recruitment-focused CRM platform with modular candidate, job, and vendor flows. This in-site documentation includes architecture breakdown, runtime working model, representative endpoint surface, seeded screenshots, and embedded diagrams from the official project documentation package.
Cookie-based authentication unlocks protected CRM routes after login.
Frontend API calls are proxied to Express, which executes parameterized PostgreSQL queries.
Candidate, job, and vendor modules follow dedicated list-form-edit workflows.
Transactional delete flows clean child records first to preserve referential integrity.
Diagram set includes architecture, frontend map, request lifecycle, and ER model.
Vite frontend runs on port 3000 and Express backend runs on port 3002. All /api calls are proxied to the backend for a single frontend origin.
Login validates user credentials, sets session cookie state, and App-level route guards switch from public login to authenticated CRM pages.
Vendor and client masters support downstream job creation. Candidate data writes include nested records such as mobiles, addresses, education, and experience.
List views use GET endpoints, forms load id-specific details for edits, and deletes run dependency cleanup in safe transactional order.
Architecture Overview
Direct architecture view for Sunsea CRM runtime flow from browser action to backend processing and SQL persistence.
ER Diagram
Candidate, job, vendor, and supporting relationship model used by transactional CRM workflows.
Representative API Surface
GET /api/login/:user, PUT /api/login/:user
Login validation and password updates
GET /api/candidate, GET/PUT /api/candidate_form/:id, DELETE /api/candidate/:id
Candidate list, nested profile editing, and safe deletion
GET /api/jobs, GET /api/job_opening/:id, POST /api/insertData, PUT /api/job_opening/update/:id
Job lifecycle management with relational links
GET /api/vendor, GET /api/vendor_form/:id, POST /api/vendorData, PUT /api/vendor_form/:id
Vendor master operations with associated mobile records
GET /api/home, GET /api/home/candidate_status, PUT /api/home/vendor_job, PUT /api/home/client
Dashboard aggregates and relationship helper actions
Embedded Diagrams
Seeded Screenshot Bundle (01-17)
Screens were captured after seeding demo data so dashboard metrics, list views, and mobile layouts reflect actual functional states rather than empty tables.
Source bundle: CRM_Application_Documentation.html with seeded backend captures (01-17).
Screenshots were taken after seeding demo data so dashboards and list modules are populated.
This page intentionally embeds the project explanation directly in-site instead of linking out to HTML/PDF artifacts.