diff options
Diffstat (limited to 'ustayml/schema.sql')
| -rw-r--r-- | ustayml/schema.sql | 23 |
1 files changed, 17 insertions, 6 deletions
diff --git a/ustayml/schema.sql b/ustayml/schema.sql index 8062be8..e7e3e68 100644 --- a/ustayml/schema.sql +++ b/ustayml/schema.sql @@ -24,6 +24,11 @@ CREATE TABLE post ( -- Students +create table desertion_risk_class ( + id serial primary key, + "name" text +); + create table pucp_unit ( id serial primary key, "name" text @@ -58,9 +63,10 @@ CREATE TABLE student ( current_ppne3 REAL, current_merit REAL, est_study_length INTEGER, - est_dessertion_risk TEXT, + est_desertion_risk_class_id integer, FOREIGN KEY (administrative_division_id) REFERENCES administrative_division (id), - FOREIGN KEY (pucp_unit_id) REFERENCES pucp_unit (id) + FOREIGN KEY (pucp_unit_id) REFERENCES pucp_unit (id), + FOREIGN KEY (est_desertion_risk_class_id) REFERENCES desertion_risk_class (id) ); -- alter table student @@ -80,6 +86,11 @@ INSERT INTO "user" ("username","password","role_id") VALUES ('mitsuo','scrypt:32768:8:1$DNNf1Ah1SwUcFHIU$c0e40293c9ecff498b74e7727a8d9a348371262b85cc880e8c653438b1afa84849adb7230f4fcd995c82de543a7836a5cda2a411a45c17dc653e7036fe3de482',1) ; +INSERT INTO desertion_risk_class ("name") VALUES + ('Alto'), + ('Bajo'), + ('Medio'); + INSERT INTO pucp_unit ("name") VALUES ('Facultad de Ciencias e Ingenieria'), ('Estudios Generales Ciencias'); @@ -138,7 +149,7 @@ INSERT INTO public.administrative_division (country,subdivision1,subdivision2,su ('Peru','Lima','Lima','VILLA MARÍA DEL TRIUNFO ','Lima Sur','150143',404692,21.1,'district'); -INSERT INTO student (pucp_code,first_name,last_name,email,administrative_division_id,pucp_unit_id,tuition_bracket,current_semester,current_attendance,current_craest,current_ppne3,current_merit,est_study_length,est_dessertion_risk) VALUES - (20171234,'Alberto','Alvarez','aalvarez@pucp.edu.pe',40,1,'G5',5,0.8,58.35,55.23,0.1532,10,'L'), - (20171235,'Benito','Bueno','bbueno@pucp.edu.pe',41,2,'G5',5,0.8,58.35,55.23,0.1532,10,'H'), - (20171236,'Carlos','Canto','ccanto@pucp.edu.pe',42,1,'G5',5,0.8,58.35,55.23,0.1532,10,'L');
\ No newline at end of file +INSERT INTO student (pucp_code,first_name,last_name,email,administrative_division_id,pucp_unit_id,tuition_bracket,current_semester,current_attendance,current_craest,current_ppne3,current_merit,est_study_length,est_desertion_risk_class_id) VALUES + (20171234,'Alberto','Alvarez','aalvarez@pucp.edu.pe',40,1,'G5',5,0.8,58.35,55.23,0.1532,10,1), + (20171235,'Benito','Bueno','bbueno@pucp.edu.pe',41,2,'G5',5,0.8,58.35,55.23,0.1532,10,1), + (20171236,'Carlos','Canto','ccanto@pucp.edu.pe',42,1,'G5',5,0.8,58.35,55.23,0.1532,10,2);
\ No newline at end of file |