diff options
| author | ckonstanski <kostcarl@isu.edu> | 2026-07-21 15:26:40 -0600 |
|---|---|---|
| committer | ckonstanski <kostcarl@isu.edu> | 2026-07-21 15:26:40 -0600 |
| commit | 51354fd19f76c2cbfd31542e9c072b86a90134f0 (patch) | |
| tree | 01e60982cd467d266c70dab68bc3c3e5714b4d53 /sql/tables | |
| parent | 05154d8591bc1d7f31b7d875e6086e81055288c4 (diff) | |
added education
Diffstat (limited to 'sql/tables')
| -rw-r--r-- | sql/tables/resume.education.sql | 7 | ||||
| -rw-r--r-- | sql/tables/resume.language.sql | 1 |
2 files changed, 5 insertions, 3 deletions
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, |