Skip to content

Instantly share code, notes, and snippets.

/manytomany.db

Created July 6, 2015 17:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save anonymous/79c2eed2a634777b16ff to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save anonymous/79c2eed2a634777b16ff to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @invalid-email-address Anonymous created this gist Jul 6, 2015.
    28 changes: 28 additions & 0 deletions manytomany.db
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,28 @@
    # For http://stackoverflow.com/a/7296873/396458

    student: student_id, first_name, last_name
    classes: class_id, name, teacher_id
    student_classes: class_id, student_id # the junction table

    students:
    id | first | last
    =====================
    1 | John | Lee
    2 | Jane | Wilson
    3 | Daniel | Gomez

    classes:
    id | name | teacher_id
    ==========================
    1 | Biology | 2
    2 | Physics | 4
    3 | English | 77

    student_classes
    s_id | c_id
    ======================
    1 | 2 # John is taking Physics
    1 | 3 # John is taking English
    2 | 2 # Jane is taking Physics
    3 | 1 # Daniel is taking Biology