Changes between Version 61 and Version 62 of iPeerDatabaseSchema

Timestamp:

2010-10-22T16:31:29Z (15 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -302 +302 @@
 ||'''modified'''||date||the last time of modification
 == survey_questions ==
-Conects the surveys table to the questions table (Many-to-many relationship). Also, gives the questions a number.
-||__Column__||__Type__||__Description__||__Foreign Key to table...__||
-||'''id'''||integer||Primary_Key
-||'''survey_id'''||integer||The survey this question belongs||''surveys''
+Connects the surveys table to the questions table (Many-to-many relationship). Also, gives the questions a number.
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''survey_id'''||integer||The survey this question belongs to.||''surveys''
 ||'''number'''||integer||The question number in the survey.
 ||'''question_id'''||integer||The question ID to put into survey||''questions''
 == survey_inputs ==
-== survey_groups == 
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''survey_id'''||integer||The survey this answer belongs to.||''surveys''
+||'''user_id'''||integer||The ID of the user thats responding.
+||'''question_id'''||integer||The question ID being answered.||''questions''
+||'''sub_id''||integer|| unused (?)
+||'''response_text'''||string||If this was a text question, the answer is recoded here
+||'''response_id'''||integer||Non-text responses are recorded here||''responses''
+== survey_groups ==
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+
 == survey_group_sets ==
 == survey_group_members ==