Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
#----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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment