schema.bash

#----SCHEMA----#

sqlite> .schema myapp_course
CREATE TABLE "myapp_course" (
    "id" integer NOT NULL PRIMARY KEY,
    "name" varchar(30) NOT NULL
);

sqlite> .schema myapp_student
CREATE TABLE "myapp_student" (
    "id" integer NOT NULL PRIMARY KEY,
    "name" varchar(30) NOT NULL
);

sqlite> .schema myapp_student_courses
CREATE TABLE "myapp_student_courses" (
    "id" integer NOT NULL PRIMARY KEY,
    "student_id" integer NOT NULL,
    "course_id" integer NOT NULL,
    UNIQUE ("student_id", "course_id")
);
CREATE INDEX "myapp_student_courses_6234103b" ON "myapp_student_courses" ("course_id");
CREATE INDEX "myapp_student_courses_94741166" ON "myapp_student_courses" ("student_id");

#----DATA----#

sqlite> select * from myapp_course;
1|Math
2|Science
3|English

sqlite> select * from myapp_student;
1|John
2|Carl

sqlite> select * from myapp_student_courses;
1|1|1
2|1|2
3|2|3