diff options
Diffstat (limited to 'sql/tables/resume.education.sql')
| -rw-r--r-- | sql/tables/resume.education.sql | 7 |
1 files changed, 4 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 ); |
