Scribd
Upload
16 views2 pages

Database Schema for Freelance Platform

The document outlines a database schema for a project management system, detailing entities such as users, projects, proposals, contracts, and messages. Each entity includes various attributes, such as user profiles with personal information, project details including budget and skills required, and proposal specifics like cover letters and proposed rates. The schema is designed to facilitate interactions between clients and freelancers within the platform.

Uploaded by

devadigpriya1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views2 pages

Database Schema for Freelance Platform

The document outlines a database schema for a project management system, detailing entities such as users, projects, proposals, contracts, and messages. Each entity includes various attributes, such as user profiles with personal information, project details including budget and skills required, and proposal specifics like cover letters and proposed rates. The schema is designed to facilitate interactions between clients and freelancers within the platform.

Uploaded by

devadigpriya1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

messages

id integer
*
sender_id integer
profiles
users *
receiver_id integer
id integer 0..1 0..1
id integer
* content text
user_id integer
username varchar reviews
timestamp datetime
fullname varchar
email varchar id integer
bio text *
password varchar contract_id integer
skills text *
role varchar reviewer_id integer
hourly_rate decimal
created_at datetime rating integer
availability varchar
comment text
location varchar
created_at datetime

projects
0..1
id integer proposals
* 0..1
client_id integer id integer
*
title varchar project_id integer
contracts
*
description text freelancer_id integer 0..1
id integer
budget decimal cover_letter text *
proposal_id integer
duration varchar proposed_rate decimal
start_date datetime
skills_required text status varchar
end_date datetime
created_at datetime created_at datetime
status varchar
messages

id integer
*
sender_id integer
profiles
users *
receiver_id integer
id integer 0..1 0..1
id integer
* content text
user_id integer
username varchar reviews
timestamp datetime
fullname varchar
email varchar id integer
bio text *
password varchar contract_id integer
skills text *
role varchar reviewer_id integer
hourly_rate decimal
created_at datetime rating integer
availability varchar
comment text
location varchar
created_at datetime

projects
0..1
id integer proposals
* 0..1
client_id integer id integer
*
title varchar project_id integer
contracts
*
description text freelancer_id integer 0..1
id integer
budget decimal cover_letter text *
proposal_id integer
duration varchar proposed_rate decimal
start_date datetime
skills_required text status varchar
end_date datetime
created_at datetime created_at datetime
status varchar

You might also like