Database Schema & ER Architecture
Explore the complete relational data model powering the National Institute of Technology Hamirpur portal. Featuring interactive Mermaid ER diagrams, a comprehensive searchable data dictionary, and dual-persistence synchronization specifications.
Cataloged Tables
24
Core & Satellite Entities
Schema Columns
175
Fully Typed Attributes
Foreign Keys
30
Relational Constraints
Audit Security
100%
Automated Triggers
High-Level Core Entity-Relationship Diagram
Interactive SVGRendering Entity Relationships...
Normalized 3NF Entities
Eliminates transitive anomalies. Faculty CVs are separated into distinct satellite tables (qualifications, experiences, honors, exposures) referencing a single immutable faculty.id.
M:N Multi-Author Joins
Publications, patents, and projects link to multiple faculty members via junction tables (publication_authors, project_members) preserving author order.
Cascade & Soft Deletes
Referential integrity enforced with ON DELETE CASCADE for dependent children and deleted_at timestamps for reversible auditing.