Harmonise.it schema

schema.txt

# Schema V1 #

user(id, name)
--------------
1, petros
2, eva

themes(id, difficulty, description, theme_data)
--------------
1, hard, { stave: ... }
2, super hard, foobaz

theme_solution(user_id, theme_id, solution_data)
--------------------------
1,2, { ...... }
2,1, { ... }
2,2, {..}


# Schema V2 #

user(id, name)
--------------
1, petros
2, eva
3, bob

teacher_teaches_student(teacher_id, student_id, approved)
---------------------------
2, 1, false

themes(id, user_id, is_public, difficulty, description, theme_data)
--------------
1, NULL, true, hard, {}
2, NULL, true, super hard, {}
3, 2, false, super duper hard, {}

theme_solution(user_id, theme_id, solution_data)
--------------------------
1,2, {}
2,1, {}
2,2, {}
1,3, {}

Schema V1: themes table require an extra column called given_voice defining weather the given voice is soprano or bass