Comprehensive entity-relationship diagram for an AI-powered academic platform integrating user management, course structure, collaborative messaging, and a legacy vector system on OCI infrastructure. The schema spans 13 core tables—Semester, Subject, User, Material, Activity, Conversation, Message, Document_File, Feedback, and supporting entities—with foreign key relationships enabling role-based access control and audit trails. This architecture supports instructor-student enrollment, material versioning, AI-driven conversations with document context, and message feedback loops, addressing the need for scalable, auditable learning environments. Fork and customize this ERD on Diagrams.so to adapt table structures, add indexes, or integrate additional OCI services like Autonomous Database or Object Storage. The legacy vector system section indicates planned migration or coexistence with embedding-based retrieval, a common pattern for AI-enhanced educational platforms.