This Entity relationship diagram provides a comprehensive view of the database structure for an online freelancing platform, illustrating the relationships between core entities, including users, projects, proposals, payments, and reviews. The User entity stores essential details, such as email and role. The Project entity captures critical attributes including title, description, budget, and deadlines.
Proposals submitted by freelancers are managed through the Proposal entity, which includes bid amounts, cover letters, and submission statuses. The Payment entity handles financial transactions. Client feedback and freelancer ratings are recorded in the Review entity, ensuring transparency and trust within the platform.
