Database schema

users

column name	data type	details
id	integer	not null, primary key
username	string
firstName	string	not null,
lastName	string	not null,
middleInitial	string
userName	string
email	string	not null, indexed, unique
driversLicense	integer
gitHubUrl	string
allies	boolean
recruiter	boolean
techCategoryId	varchar
imgUrl	string
resumeUrl	string

• index on email, unique: true

showcases

column name	data type	details
id	integer	not null, primary key
description	string	not null
userId	integer	not null, foreign key
created_at	datetime	not null
updated-at	datetime	not null
techCategoryId	varchar
showcaseImgUrl	string
timeStamp	dateTime

• userId references users table (one user to many showcases)
• techCategoryId references users table (?)

skillShowcases

column name	data type	details
id	integer	not null, primary key
showcaseId	string
skillsId	int

• showcaseId references showcases table
• skillsId references skills table

likedShowcases

column name	data type	details
id	integer	not null, primary key
showcaseId	string
userId	integer

• userId references users table
• showcaseId references

opportunities

column name	data type	details
id	integer	not null, primary key
companyId	integer
techCategoryId	varchar
companyImgUrl	varchar
jobSummary	text
timestamp	datetime
recruiterId	int

• companyId references companies table
• techCategoryId references techCategories tables
• recruiterId references users table

opportunitiesSkills

column name	data type	details
id	integer	not null, primary key
opportunitiesId	integer
skillsId	integer

• opportunitiesId references opportunities tables
• skillsId references skills tables

opportunitiesSkills

column name	data type	details
id	integer	not null, primary key
opportunitiesId	integer
skillsId	integer

skills

column name	data type	details
id	integer	not null, primary key
openDescription	integer
techCategoryId	varchar

*techCategoryId references techCategoriesId

userSkills

column name	data type	details
id	integer	not null, primary key
userId	integer
skillsId	integer

• userId references users table
• skillsId references skills table

companies

column name	data type	details
id	integer	not null, primary key
name	string

techCategories

column name	data type	details
id	integer	not null, primary key
name	string

directMessages

column name	data type	details
id	integer	not null, primary key
senderId	integer
recieverId	integer
message	text
viewStatus	varchar
timestamp	datetime

*senderId references users table *recieverId references users table