Make Database and Relations between tables,
will use the following tables:
Users table: This table stores information about users who are registered on the platform. It may include fields such as user ID, username, email address, password, and account type (i.e. freelancer or client).
Projects table: This table stores information about the projects that clients post on the platform. It may include fields such as project ID, project title, project description, client ID, budget, and deadline.
Proposals table: This table stores information about the proposals that freelancers submit in response to client projects. It may include fields such as proposal ID, freelancer ID, project ID, proposal description, and bid amount.
Contracts table: This table stores information about the contracts that clients and freelancers enter into after a proposal has been accepted. It may include fields such as contract ID, client ID, freelancer ID, project ID, start date, end date, and payment details.
Reviews table: This table stores information about the reviews that clients and freelancers leave for each other after a project has been completed. It may include fields such as review ID, reviewer ID, reviewee ID, project ID, rating, and review text.
Use: