diff options
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, |