Proposed Database Schema

Job Table

Column Name	Typescript Type	PostgreSQL Type
id	number	bigint
job_title	string	character varying(256)
link	string	text
description	string	text
city	string	character varying(256)
state	string	character varying(256)
country	string	character varying(256)
latitude	number	double precision
longitude	number	double precision
company_name	string	character varying(256)
start_date	Date	date
salary_min	number	integer

Other info

• Table name should be "job"
• To get distance between two points, earthdistance extension needs to be added; this can be done with CREATE EXTENSION earthdistance CASCADE

Possible changes

• I think "job_title" is redundant and could be changed to just "title" since it is implied for all the other columns i.e. we have "city" instead of "job_city" because we know it is for the job