Changes between Version 64 and Version 65 of iPeerDatabaseSchema

Timestamp:

2010-10-22T17:01:55Z (13 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -317 +317 @@
 ||'''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 ==
 Holds the Group Sets created from surveys.
@@ -329 +326 @@
 ||'''date'''||integer||date of creation, but integer format (?)
 ||'''released'''||enum(0,1)||Were these survey groups put into real groups in iPeer yet?
+== survey_groups ==
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''group_set_id'''||integer||The group set that this survey_group belongs to
+||'''group_number'''||integer||The number of the group in the groups set. Just gives the groups an order, I guess.
 == survey_group_members ==
-
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
 == sys_function ==
 == sys_parameters ==