About This Architecture
Student Accommodation Marketplace ERD models a multi-role platform with USER as a base entity specializing into STUDENT, LANDLORD, and ADMIN roles using disjoint inheritance. LANDLORD entities create PROPERTY listings with attributes like Title, Price, Location, PropertyType, and NumberOfRooms, while STUDENT entities submit INQUIRY records linked to specific properties, enabling communication between renters and landlords. The schema enforces referential integrity through foreign keys, unique email constraints, and identifying relationships (PK/FK) for role-based access control and audit trails. Fork this diagram on Diagrams.so to customize entity attributes, add payment or review entities, or export as .drawio/.sql for your database implementation. This design pattern supports role-based filtering, property search, and inquiry management workflows essential to peer-to-peer accommodation platforms.