schema_full.txt

CREATE TABLE HTE_issue(count integer, rn_ integer not null, id bigint, positionx float, positiony float, hib_sess_id char(36) not null, bathroom varchar(255), issue varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HT_groups(id bigint not null, hib_sess_id char(36) not null, primary key (id, hib_sess_id));
CREATE TABLE HTE_groups(rn_ integer not null, id bigint, hib_sess_id char(36) not null, name varchar(255), period varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_announcement(rn_ integer not null, id bigint, hib_sess_id char(36) not null, author varchar(255), body varchar(255), tags varchar(255), timestamp varchar(255), title varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_assignment(rn_ integer not null, id bigint, points float, presentation_length bigint, hib_sess_id char(36) not null, assignment_queue varchar(255), description varchar(255), due_date varchar(255), name varchar(255), timestamp varchar(255), type varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_synergy_grade(rn_ integer not null, assignment_id bigint, grade float, id bigint, student_id bigint, hib_sess_id char(36) not null, primary key (rn_, hib_sess_id));
CREATE TABLE HTE_plant(current_stage integer, rn_ integer not null, total_lessons_completed integer, id bigint, hib_sess_id char(36) not null, uid varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_teacher_grading_team_teach(rn_ integer not null, grade float, id bigint, topic_id bigint, hib_sess_id char(36) not null, comment varchar(255), student varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_person_user_mapping(rn_ integer not null, id bigint, person_id bigint, user_id bigint, hib_sess_id char(36) not null, primary key (rn_, hib_sess_id));
CREATE TABLE HTE_student_queue(rn_ integer not null, id bigint, hib_sess_id char(36) not null, people_queue varchar(255), teacher_email varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_hall_pass(checkin date, checkout date, period integer, rn_ integer not null, id bigint, teacher_id bigint, hib_sess_id char(36) not null, activity varchar(255), person_id varchar(255), stats jsonb, primary key (rn_, hib_sess_id));
CREATE TABLE HT_person(id bigint not null, hib_sess_id char(36) not null, primary key (id, hib_sess_id));
CREATE TABLE HTE_person(kasm_server_needed boolean default false, rn_ integer not null, id bigint, name varchar(30), hib_sess_id char(36) not null, email varchar(255), password varchar(255), pfp varchar(255), sid varchar(255), stats jsonb, uid varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_user(enabled boolean, rn_ integer not null, balance float, id bigint, hib_sess_id char(36) not null, password varchar(255), role varchar(255), stonks varchar(255), username varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_note(rn_ integer not null, id bigint, tutorial_id bigint, hib_sess_id char(36) not null, text TEXT, primary key (rn_, hib_sess_id));
CREATE TABLE HTE_comment(rn_ integer not null, id bigint, hib_sess_id char(36) not null, assignment varchar(255), author varchar(255), text varchar(255), timestamp varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_teacher(rn_ integer not null, id bigint, firstname varchar(30), lastname varchar(30), hib_sess_id char(36) not null, stats jsonb, primary key (rn_, hib_sess_id));
CREATE TABLE HTE_resume(rn_ integer not null, id bigint, hib_sess_id char(36) not null, professional_summary varchar(255), username varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_assignment_submission(is_late boolean, rn_ integer not null, assignment_id bigint, assignmentid bigint, grade float, id bigint, submitter_id bigint, hib_sess_id char(36) not null, comment varchar(255), content varchar(255), feedback varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_quiz_scores(rn_ integer not null, score integer, created_at timestamp, id bigint, hib_sess_id char(36) not null, username varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_game(rn_ integer not null, id bigint, person_uid bigint, hib_sess_id char(36) not null, name varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_blackjack(rn_ integer not null, bet_amount float, id bigint, person_id bigint, hib_sess_id char(36) not null, game_state TEXT, status varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_jokes(boohoo integer, haha integer, rn_ integer not null, id bigint, hib_sess_id char(36) not null, joke varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_assignment_queue(completed blob, rn_ integer not null, waiting blob, working blob, id bigint, hib_sess_id char(36) not null, primary key (rn_, hib_sess_id));
CREATE TABLE HTE_gemini(rn_ integer not null, created_at bigint, id bigint, hib_sess_id char(36) not null, answer TEXT, grading_result TEXT, question TEXT, primary key (rn_, hib_sess_id));
CREATE TABLE HTE_synergy_grade_request(rn_ integer not null, status smallint, assignment_id bigint, grade_suggestion float, grader_id bigint, id bigint, student_id bigint, hib_sess_id char(36) not null, explanation varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_tasks(due_date date, rn_ integer not null, assignment_id bigint, id bigint, points bigint, time timestamp, hib_sess_id char(36) not null, description varchar(255), status varchar(255), task_name varchar(255), username varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_user_stocks_table(has_simulated boolean, period1 boolean, rn_ integer not null, id bigint, person_id bigint, hib_sess_id char(36) not null, crypto varchar(255), crypto_history TEXT, email varchar(255), person_name varchar(255), stonks varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_person_role(rn_ integer not null, id bigint, hib_sess_id char(36) not null, name varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_train(in_transit boolean, position float, rn_ integer not null, company_id bigint, id bigint, hib_sess_id char(36) not null, cargo jsonb, train_color varchar(255), train_type varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_bathroom_queue(away integer, rn_ integer not null, id bigint, hib_sess_id char(36) not null, people_queue varchar(255), teacher_email varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_bank(risk_category integer, rn_ integer not null, balance float, daily_interest_rate float, id bigint, loan_amount float, person_id bigint, hib_sess_id char(36) not null, feature_importance jsonb, npc_progress jsonb, profit_map jsonb, uid varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_tinkle(rn_ integer not null, id bigint, person_id bigint, hib_sess_id char(36) not null, person_name varchar(255), sid varchar(255), time_in varchar(255), time_in_out_pairs varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HTE_progress_bar(completed_lessons integer, rn_ integer not null, id bigint, hib_sess_id char(36) not null, user_id varchar(255), primary key (rn_, hib_sess_id));
CREATE TABLE HT_submitter(id bigint not null, hib_sess_id char(36) not null, primary key (id, hib_sess_id));
CREATE TABLE adventure (id integer, answer_content clob, answer_is_correct boolean, balance float, chat_score bigint, choice_id bigint, choice_is_correct boolean, choice_text varchar(255), created_at timestamp, person_id bigint, person_uid varchar(255), question_category varchar(255), question_content clob, question_id bigint, question_points integer, question_title varchar(255), rubric_criteria clob, rubric_ruid varchar(255), details TEXT, primary key (id));
CREATE TABLE announcement (id bigint not null, author varchar(255), body varchar(255), tags varchar(255), timestamp varchar(255), title varchar(255), primary key (id));
CREATE TABLE announcement_seq (next_val bigint);
CREATE TABLE approval_requests (id integer, student_name varchar(255), teacher_email varchar(255), time_in varchar(255), primary key (id));
CREATE TABLE assignment (id bigint not null, assignment_queue varchar(255), description varchar(255), due_date varchar(255) not null, name varchar(255) not null, points float not null, presentation_length bigint, timestamp varchar(255) not null, type varchar(255) not null, primary key (id));
CREATE TABLE assignment_person (assignment_id bigint not null, person_id bigint not null);
CREATE TABLE assignment_queue_seq (next_val bigint);
CREATE TABLE assignment_seq (next_val bigint);
CREATE TABLE assignment_submission_graders (submission_id bigint not null, person_id bigint not null);
CREATE TABLE assignment_submission_seq (next_val bigint);
CREATE TABLE assignment_queue (id bigint not null, completed blob, waiting blob, working blob, primary key (id));
CREATE TABLE assignment_submission (id bigint not null, assignmentid bigint, comment varchar(255), content varchar(255), feedback varchar(255), grade float, is_late boolean, assignment_id bigint, submitter_id bigint, primary key (id));
CREATE TABLE bank (id bigint not null, balance float not null, daily_interest_rate float not null, feature_importance jsonb, loan_amount float not null, npc_progress jsonb, profit_map jsonb, risk_category integer not null, uid varchar(255), person_id bigint unique, primary key (id));
CREATE TABLE bank_seq (next_val bigint);
CREATE TABLE bathroom_queue_seq (next_val bigint);
CREATE TABLE bathroom_queue (id bigint not null, away integer not null, people_queue varchar(255), teacher_email varchar(255), primary key (id));
CREATE TABLE blackjack (id bigint not null, bet_amount float not null, game_state TEXT, status varchar(255), person_id bigint, primary key (id));
CREATE TABLE blackjack_seq (next_val bigint);
CREATE TABLE calendar_events (id integer, date date, description varchar(255), period varchar(255), title varchar(255), type varchar(255), primary key (id));
CREATE TABLE comment (id bigint not null, assignment varchar(255) not null, author varchar(255) not null, text varchar(255) not null, timestamp varchar(255), primary key (id));
CREATE TABLE comment_seq (next_val bigint);
CREATE TABLE energy (id integer, eem float not null, supplier_name varchar(255), primary key (id));
CREATE TABLE game (id bigint not null, name varchar(255), person_uid bigint not null unique, primary key (id));
CREATE TABLE game_seq (next_val bigint);
CREATE TABLE games (id integer, amount float, balance float, bet_amount float, created_at timestamp, details clob, person_id bigint, person_uid varchar(255), result varchar(255), success boolean, tx_id varchar(255), type varchar(255), primary key (id));
CREATE TABLE gemini (id bigint not null, answer TEXT not null, created_at bigint not null, grading_result TEXT, question TEXT not null, primary key (id));
CREATE TABLE gemini_seq (next_val bigint);
CREATE TABLE generated_question (id integer, question varchar(255), primary key (id));
CREATE TABLE generated_question_tags (generated_question_id bigint not null, tags varchar(255));
CREATE TABLE gpu (id integer, available boolean not null, category varchar(255), hash_rate float not null, name varchar(255), power_consumption integer not null, price float not null, temp integer not null, usage_hours integer not null, primary key (id));
CREATE TABLE group_members (group_id bigint not null, person_id bigint not null);
CREATE TABLE groups (name varchar(255), period varchar(255), id bigint not null, primary key (id));
CREATE TABLE hall_pass_seq (next_val bigint);
CREATE TABLE hall_pass (id bigint not null, activity varchar(255), checkin date, checkout date, period integer not null, person_id varchar(255), stats jsonb, teacher_id bigint not null, primary key (id));
CREATE TABLE hard_asset (id integer, file_name varchar(255), local_fileuuid varchar(255), owneruid varchar(255) not null, primary key (id));
CREATE TABLE issue (id bigint not null, bathroom varchar(255), count integer not null, issue varchar(255), positionx float not null, positiony float not null, primary key (id));
CREATE TABLE issue_seq (next_val bigint);
CREATE TABLE jokes (id bigint not null, boohoo integer not null, haha integer not null, joke varchar(255) unique, primary key (id));
CREATE TABLE jokes_seq (next_val bigint);
CREATE TABLE lesson_badges (lesson_progress_id bigint not null, badge_name varchar(255));
CREATE TABLE lesson_progress (id integer, completed boolean not null, created_at timestamp, current_flashcard_index integer, last_visited timestamp, lesson_key varchar(255) not null, reflection_text TEXT, total_time_ms bigint not null, updated_at timestamp, user_id varchar(255) not null, primary key (id));
CREATE TABLE mining_user (id integer, eem float not null, btc_balance float not null, current_hashrate float not null, current_pool varchar(255), daily_revenue float not null, energy_supplier varchar(255), is_mining boolean not null, mining_session_count bigint not null, mining_start_time timestamp, pending_balance float not null, power_cost float not null, shares integer not null, total_btc_earned float not null, total_mining_time_minutes bigint not null, total_shares_mined bigint not null, energy_id bigint unique, person_id bigint unique, primary key (id));
CREATE TABLE mining_user_activegpus (mining_user_id bigint not null, activegpus_id bigint not null);
CREATE TABLE mining_user_gpu_quantities (mining_user_id bigint not null, gpu_quantities integer, gpu_quantities_key bigint not null, primary key (mining_user_id, gpu_quantities_key));
CREATE TABLE mining_user_ownedgpus (mining_user_id bigint not null, ownedgpus_id bigint not null);
CREATE TABLE note (id bigint not null, text TEXT not null, tutorial_id bigint not null, primary key (id));
CREATE TABLE note_seq (next_val bigint);
CREATE TABLE person (email varchar(255) not null unique, kasm_server_needed boolean default false not null, name varchar(30), password varchar(255) not null, pfp varchar(255), sid varchar(255), stats jsonb, uid varchar(255) not null unique, id bigint not null, primary key (id));
CREATE TABLE person_role_seq (next_val bigint);
CREATE TABLE person_roles (person_id bigint not null, roles_id bigint not null);
CREATE TABLE person_user_mapping_seq (next_val bigint);
CREATE TABLE person_role (id bigint not null, name varchar(255) unique, primary key (id));
CREATE TABLE person_user_mapping (id bigint not null, person_id bigint not null, user_id bigint not null, primary key (id));
CREATE TABLE plant (id bigint not null, current_stage integer not null, total_lessons_completed integer not null, uid varchar(255) not null, primary key (id));
CREATE TABLE plant_seq (next_val bigint);
CREATE TABLE progress (id integer, completion_percentage float not null, last_updated timestamp not null, status varchar(255) not null, student_id varchar(255) not null, subject varchar(255) not null, primary key (id));
CREATE TABLE progress_bar_seq (next_val bigint);
CREATE TABLE progress_bar (id bigint not null, completed_lessons integer not null, user_id varchar(255) not null unique, primary key (id));
CREATE TABLE quiz_scores (id bigint not null, created_at timestamp not null, score integer not null, username varchar(255) not null, primary key (id));
CREATE TABLE quiz_scores_seq (next_val bigint);
CREATE TABLE responses (id integer, student_name varchar(255), answer_text varchar(255), primary key (id));
CREATE TABLE resume (id bigint not null, professional_summary varchar(255), username varchar(255) not null, primary key (id));
CREATE TABLE resume_experiences (resume_id bigint not null, company varchar(255), dates varchar(255), description varchar(255), job_title varchar(255));
CREATE TABLE resume_seq (next_val bigint);
CREATE TABLE score (id integer, person_name varchar(255), score integer not null, primary key (id));
CREATE TABLE slack_messages (timestamp timestamp not null, message_blob clob, primary key (timestamp));
CREATE TABLE stats (id integer, finished boolean, grades float, module varchar(255) not null, submodule integer not null, time float not null, username varchar(255) not null, primary key (id));
CREATE TABLE student (id integer, name varchar(255), primary key (id));
CREATE TABLE student_queue_seq (next_val bigint);
CREATE TABLE student_queue (id bigint not null, people_queue varchar(255), teacher_email varchar(255), primary key (id));
CREATE TABLE submitter (id bigint not null, primary key (id));
CREATE TABLE submitter_seq (next_val bigint);
CREATE TABLE synergy_grade_request_seq (next_val bigint);
CREATE TABLE synergy_grade_seq (next_val bigint);
CREATE TABLE synergy_grade (id bigint not null, grade float, assignment_id bigint not null, student_id bigint not null, primary key (id));
CREATE TABLE synergy_grade_request (id bigint not null, explanation varchar(255), grade_suggestion float not null, status smallint not null, assignment_id bigint not null, grader_id bigint not null, student_id bigint not null, primary key (id));
CREATE TABLE tasks (id bigint not null, description varchar(255), due_date date, points bigint, status varchar(255), task_name varchar(255), time timestamp, username varchar(255), assignment_id bigint not null, primary key (id));
CREATE TABLE tasks_seq (next_val bigint);
CREATE TABLE teacher (id bigint not null, firstname varchar(30), lastname varchar(30), stats jsonb, primary key (id));
CREATE TABLE teacher_grading_team_teach_seq (next_val bigint);
CREATE TABLE teacher_seq (next_val bigint);
CREATE TABLE teacher_grading_team_teach (id bigint not null, comment varchar(255), grade float, student varchar(255), topic_id bigint, primary key (id));
CREATE TABLE tinkle (id bigint not null, person_name varchar(255), sid varchar(255) not null unique, time_in varchar(255), time_in_out_pairs varchar(255), person_id bigint unique, primary key (id));
CREATE TABLE tinkle_seq (next_val bigint);
CREATE TABLE topic (id integer, date date, students TEXT, topic_name varchar(255), primary key (id));
CREATE TABLE train (id bigint not null, cargo jsonb, in_transit boolean, position float check ((position>=-10000) and (position<=10000)), train_color varchar(255), train_type varchar(255), company_id bigint, primary key (id));
CREATE TABLE train_seq (next_val bigint);
CREATE TABLE train_company (balance float, company_name varchar(255), owner_id bigint not null, primary key (owner_id));
CREATE TABLE train_station (position float check ((position<=10000) and (position>=-10000)), products jsonb, terrain integer check ((terrain>=0) and (terrain<=10)), company_owner_id bigint not null, primary key (company_owner_id));
CREATE TABLE user (id bigint not null, balance float not null, enabled boolean not null, password varchar(255) not null, role varchar(255), stonks varchar(255), username varchar(255) not null unique, primary key (id));
CREATE TABLE user_seq (next_val bigint);
CREATE TABLE user_stocks_table_seq (next_val bigint);
CREATE TABLE user_stocks_table (id bigint not null, crypto varchar(255), crypto_history TEXT, email varchar(255), has_simulated boolean, period1 boolean, person_name varchar(255), stonks varchar(255), person_id bigint unique, primary key (id));
CREATE TABLE grades (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    uid VARCHAR(255) NOT NULL,
    assignment VARCHAR(255) NOT NULL,
    score REAL NOT NULL,
    class VARCHAR(255)
);
CREATE TABLE sqlite_sequence(name,seq);