Database Schema

Schema

We are using app schema in a Postgres database to keep our objects.

Tables

Companies

Name: companies

Key	Column Name	Type	Constraint Name	References (if a FK)?
PK	id	bigint sequence	companies_pkey
	name	text
	domain	text

Years of experiences

Name: years_of_experiences

Key	Column Name	Type	Constraint Name	References (if a FK)?
PK	id	bigint sequence	years_of_experiences_pkey
	description	text

Users

Name: users

Key	Column Name	Type	Constraint Name	References (if a FK)?
PK	id	bigint sequence	users_pkey
	first_name	text
	last_name	text
	location	text
	company_id	bigint
	company_name	text
	position	text
	school	text
FK	years_of_experience_id	bigint	fk_app_users_years_of_experience	app.years_of_experiences (id)
UQ	email	text	uq_users_email
	password	text
	verified	boolean

Posts

Name: posts

Key	Column Name	Type	Constraint Name	References (if a FK)?
PK	id.	bigint sequence	posts_pkey
FK	user_id	bigint	fk_app_users_posts	app.users (id)
FK	company_id	bigint	fk_app_posts_company	app.companies (id)
	position	text
	message	text
	resume	text
	job link	text
	created_at	timestamp with time zone