SQLite format 3@ - 3 9 d  nqd''tablesurvey_imagessurvey_imagesCREATE TABLE "survey_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "imageable_id" integer, "imageable_type" varchar(255), "position" integer, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "caption" varchar(255), "created_at" datetime, "updated_at" datetime)i!tablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text, "active" boolean, "position" integer, "created_at" datetime, "updated_at" datetime, "questionnaire_id" integer) E)indexindex_questionnaires_on_namequestionnairesCREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name") ))gtablequestionnairesquestionnaires CREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL) K%)indexindex_user_answers_on_answer_iduser_answers CREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id") G%!indexindex_user_answers_on_user_iduser_answers CREATE INDEX "index_user_answers_on_user_id" ON "user_answers" ("user_id")Z %%wtableuser_answersuser_answers CREATE TABLE "user_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "answer_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)rCtableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))RtablescoresscoresCREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "survey_property_id" integer, "value" integer, "created_at" datetime, "updated_at" datetime)D//7tablesurvey_propertiessurvey_propertiesCREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)^tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "details" text, "active" boolean, "position" integer, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>itablequestionsquestionsCREATE TABLE "questions"S9indexindex_questions_on_questionnaire_idquestionsCREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id")=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) ^p^ )20111213185612)20111211180011)20111211175604)20111211175518)20111010112000)20111208181449)20111208181429)20111208181414)20111208181247 U{hU)20111213185612 )20111211180011)20111211175604)20111211175518)20111010112000)20111208181449)20111208181429)20111208181414)20111208181247 L)AATest 1, 2 , 3?2011-12-09 18:20:17.2230732011-12-13 19:59:20.639857 'survey_images)questionnaires scores/survey_properties answers questions ]A]DAAtest2f2011-12-13 20:54:52.1739002011-12-13 20:54:52.173900CAAtestf2011-12-13 20:46:43.4749112011-12-13 20:46:43.474911W=AADo you like the picture?f2011-12-13 20:41:39.2948652011-12-13 20:41:39.294865^KAAMy second answer in position 1.t2011-12-10 17:20:34.0070512011-12-10 18:01:23.414393]IAAMy first answer in position 2.t2011-12-10 17:10:51.3566532011-12-10 17:11:21.682678 s2D#AATraditional2011-12-10 21:46:00.5275622011-12-10 21:46:00.527562?AATrendy2011-12-10 21:45:41.5128552011-12-10 21:45:41.512855D#AADark Colors2011-12-10 21:45:19.8170112011-12-10 21:45:19.817011E%AALight Colors2011-12-10 21:44:10.1304802011-12-10 21:44:10.130480 @>AA 2011-12-13 20:46:43.4769802011-12-13 20:46:43.476980>AA2011-12-13 20:42:30.5803812011-12-13 20:42:30.580381>AA2011-12-11 04:44:15.7149722011-12-11 04:44:15.714972>AA2011-12-11 04:44:15.7101372011-12-11 04:44:15.710137>AA2011-12-10 21:51:56.9790612011-12-10 21:51:56.979061>AA 2011-12-10 21:51:56.9779522011-12-10 21:51:56.977952     test test  33f !!AAAnswerdelete.pngimage/pngugly image2011-12-13 20:54:52.1766962011-12-13 20:54:52.176696c #!AAAnswerimage01.jpgimage/jpegtest2011-12-13 20:42:30.5824782011-12-13 20:42:30.582478