Database Schema :

[Fatmasiam]

Database Schema :

---

our database schema will contain 5 tables :

field table

name	type	constraints
id	serial	primary key
name	varchar	not null

specialization table

name	type	constraints
id	serial	primary key
name	varchar	not null
field_id	integer	foreign key

users table

name	type	constraints
id	serial	primary key
firstname	varchar(20)	not null
lastname	varchar(20)	not null
email	varchar	not null
freelancer_url	varchar	not null
photo_url	varchar	not null
birthday	timestamp
mobile_number	integer	not null
spcalization_id	integer	forign key
city	text
password	integer	not null

proposal table

name	type	constraints
id	serial	primary key
title	varchar(50)	not null
description	varchar	not null
user_id	integer	forign key
specalization_id	integer	forign key
contact_me	varchar	not null

requirement table

name	type	constraints
id	serial	primary key
text	varchar	not null
prop_id	integer	foreign key

[Fatmasiam]