From 51354fd19f76c2cbfd31542e9c072b86a90134f0 Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Tue, 21 Jul 2026 15:26:40 -0600 Subject: added education --- sql/tables/resume.education.sql | 7 ++++--- sql/tables/resume.language.sql | 1 + 2 files changed, 5 insertions(+), 3 deletions(-) (limited to 'sql/tables') diff --git a/sql/tables/resume.education.sql b/sql/tables/resume.education.sql index 638a50c..161dbfc 100644 --- a/sql/tables/resume.education.sql +++ b/sql/tables/resume.education.sql @@ -2,11 +2,12 @@ drop table resume.education cascade; create table resume.education ( id serial8 primary key, + user_id bigint not null references auth.users(id), school character varying(255) not null, - start_date timestamp without time zone not null default now(), - end_date timestamp without time zone not null default now(), + start_date character varying(255) not null, + end_date character varying(255) not null, major character varying(255) not null, - minor character varying(255) not null, + minor character varying(255), degree character varying(255) not null, progress character varying(255) not null ); diff --git a/sql/tables/resume.language.sql b/sql/tables/resume.language.sql index 0f5c452..6aaf0d8 100644 --- a/sql/tables/resume.language.sql +++ b/sql/tables/resume.language.sql @@ -2,6 +2,7 @@ drop table resume.language cascade; create table resume.language ( id serial8 primary key, + user_id bigint not null references auth.users(id), name character varying(255) not null, understanding_listening character varying(2) not null, understanding_reading character varying(2) not null, -- cgit v1.3