Current schema: (output of sqlite3 classes.sql .schema)
CREATE TABLE class(
department char(4), code varchar(4), title tinytext, description text, level tinytext default 'undergrad', credits tinyint(1) default 3, type tinytext default 'lecture');
CREATE TABLE department(
abbr char(4), title tinytext);
CREATE TABLE instructor(
name tinytext, email tinytext);
CREATE TABLE semester(
id char(6), startDate date, endDate date, registrationEnd date);
CREATE TABLE location(
uid smallint, building tinytext, room smallint);
CREATE TABLE section(
uid tinyint(5), department char(4), section tinytext, code varchar(4), semester char(6), campus tinytext default 'Columbia', startTime time, endTime time, days varchar(7), registrationStart date, instructor smallint, location smallint, finalExam dateTime, capacity tinyint, remaining tinyint);
@JamesPC44 will be in charge of making this semi-efficient. @Nesdood007, feel free to comment if there's info here you don't think is useful (or if we're missing useful info).
The schema is created by create_sql.py; you'll want to modify the variable TABLES. The classes are created by parse.py, you might have to dig around a little to modify those.
Current schema: (output of
sqlite3 classes.sql .schema
)@JamesPC44 will be in charge of making this semi-efficient. @Nesdood007, feel free to comment if there's info here you don't think is useful (or if we're missing useful info).
The schema is created by
create_sql.py
; you'll want to modify the variableTABLES
. The classes are created byparse.py
, you might have to dig around a little to modify those.