erDiagram User { ObjectId _id PK string role string email UK string fullname string password number graduationYear string major string skills string avatar string bio string company string position string location ObjectId college FK string refreshToken date createdAt date updatedAt } College { ObjectId _id PK string collegeName UK string phoneNumber string collegeEmail string location string majors string logo date createdAt date updatedAt } Job { ObjectId _id PK ObjectId postedBy FK ObjectId college FK string title string company string description string requiredSkills string type string location ObjectId applicants FK date createdAt date updatedAt } JobApplication { ObjectId _id PK ObjectId job FK ObjectId appliedBy FK ObjectId college FK string status string coverLetter string resumeUrl date createdAt date updatedAt } Post { ObjectId _id PK string content ObjectId college FK string media string category ObjectId author FK ObjectId likes FK date createdAt date updatedAt } Comment { ObjectId _id PK ObjectId postedBy FK string content ObjectId post FK date createdAt date updatedAt } Fundraiser { ObjectId _id PK ObjectId college FK string title string description string coverImage string category number targetAmount number currentAmount date createdAt date updatedAt } Donation { ObjectId _id PK number amount ObjectId donor FK ObjectId fundraiser FK ObjectId college FK string paymentIntentId date createdAt date updatedAt } User ||--|| College : belongs_to User ||--o{ Job : posts User ||--o{ JobApplication : applies User ||--o{ Post : creates User ||--o{ Comment : writes User ||--o{ Donation : makes College ||--o{ User : has_members College ||--o{ Job : contains College ||--o{ Post : contains College ||--o{ Fundraiser : creates Job ||--o{ JobApplication : receives Job }o--o{ User : has_applicants Post ||--o{ Comment : has Post }o--o{ User : liked_by Fundraiser ||--o{ Donation : receives 

flowchart TD %% User Entry A[👤 User] --> B[🔑 Login/Register] B --> I1[📧 Welcome Email on Register] B --> C[📊 Dashboard] %% Core Features C --> D[👥 Networking] C --> E[💼 Jobs] C --> F[📱 Social] C --> G[💰 Fundraising] %% Networking Features D --> D1[📝 Complete Profile] D --> D2[🌐 Browse Alumni Network] D2 --> D2A[🔎 Search by Name] D2 --> D2B[🎓 Search by Grad Year] D2 --> D2C[📚 Search by Major] D2 --> D2D[🏢 Search by Company] %% Job Features E --> E1[🔍 Browse Job Listings] E --> E2[📄 Apply to Jobs] E --> E3{Alumni?} E3 -->|Yes| E4[📝 Post Job Opportunities] E3 -->|Yes| E5[📊 Manage Applications] E3 -->|Yes| E6[✅ Accept/Reject Candidates] %% Email Notifications for Jobs E2 --> I2[📧 Skills-Matched Job Alerts] E4 --> I3[📧 Application Received Alert] %% Social Features F --> F1[✍️ Create Posts] F --> F2[💬 Comment on Posts] F --> F3[❤️ Like Posts] F --> F4[📸 Share Media] %% Fundraising Features G --> G2[💳 Donate to Campaigns] G --> G3[📊 Track Campaign Progress] %% Styling classDef user fill:#e3f2fd,stroke:#1976d2 classDef feature fill:#f3e5f5,stroke:#7b1fa2 classDef alumni fill:#fff3e0,stroke:#f57c00 classDef email fill:#e8f5e8,stroke:#4caf50 class A,B,C user class D,E,F,G feature class D2A,D2B,D2C,D2D feature class E4,E5,E6 alumni class I1,I2,I3 email