Please enable JavaScript.
Coggle requires JavaScript to display documents.
portfolio database schema - Coggle Diagram
portfolio database schema
User Table
Id integer (pk)
Password (hash format)
last login (date)
is_superuser (boolean)
username (unique string)
first_name
last_name
email
is_staff
is_active
date_joined
portfolio strength indicator
portfolio like count
Portfolio table
id (pk)
user id ( foreign key unique) -> one to one :check:
profile_pic
phone number
Theme_id
headline
address
DOB
Gender
about
personal quote
users_liked (many to many) :check: :check:
languages known
email
name
education table
school/ college name/ university
id (pk)
degree
user id (foreign key ) -> many to one :check:
start year
end year
grade
description
certificate table
id (pk)
user id(foreign key) many to one :check:
name
institute/organization
file
url if any
Skills table
id(pk)
user id(foreign key) many to one :check:
name
rate between 1 to 5
Porject table
id
user id(foreign key) many to one :check:
name
project url
project image
description
Blog table
id(pk)
title
user id(foreign key) many to one :check:
slug
image
description
created_at
edited at
bookmarked (many to many) user_id :check: :check:
like(many to many) user_id :check: :check:
comments (many to one)
Social urls
ID(pk)
User ID (Foreign key) one to one (because one user can have only one facebook, github url.)
:check:
Facebook Url
Twitter Url
Github url
Linkedin url
Personal Url