SQLite format 3@ R?    bp^L:(tb)20090109102622)20081202093209)20081202073955)20081202073940)20081202030441)20081202030420)20081201052151)20081201051351)20081201051024)20081201045708 )20081127063609 )20081127062100 )20081127015806 )20081127014224 )20081127013928)20081127012727)20081111214601)20081027071020)20081027070851)20081027070757)20081027065215)20081027063007)20081027035528 P  #]]33!aatif84afda@af.comdecfd274a05fb9cd12f2c5fdc41b47239dbdee39bd30fae7fba40d587047a8528c29d0a174cd5db52009-01-06 22:21:562009-01-06 22:21:56Data Admin- '+]]33!adminAdministratoradmin@admin.com66acb2c13603b2dbdcc88fab98cbaeb666d0ee83bc5b3921082878e86248a0a1fbf53d8a47e82f092008-12-09 01:45:212008-12-09 01:45:21SuperAdmin )patient_visits#visit_types users doctors patients pw w! !! 33'!3asdfasdfweas1963-02-181926-03-15Male2009-01-09 10:34:152009-01-09 11:35:59IMAGE_047.jpgimage/jpegHs2009-01-09 11:35:58b !! 33werwasf1951-02-021912-02-04Female2009-01-09 10:31:002009-01-09 10:31:00 !! 33%!3asdfadsf200g! !! 33asdfasdfweas1963-02-181926-03-15Male2009-01-09 10:34:152009-01-09 10:34:15"first_name" varchar(255) DEFAULT '', "middle_name" varchar(255) DEFAULT '', "last_name" varchar(255) DEFAULT '', "arrival_date" date, "date_of_birth" date, "gender" varchar(255) DEFAULT '', "address" varchar(255) DEFAULT '', "city" varchar(255) DEFAULT '', "state" varchar(255) DEFAULT '', "zip" varchar(255) DEFAULT '', "father_first_name" varchar(255) DEFAULT '', "father_last_name" varchar(255) DEFAULT '', "mother_first_name" varchar(255) DEFAULT '', "mother_last_name" varchar(255) DEFAULT '', "telephone" varchar(255) DEFAULT '', "emergency_contact_name" varchar(255) DEFAULT '', "emergency_contact_relationship" varchar(255) DEFAULT '', "emergency_contact_number" varchar(255) DEFAULT '', "patient_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "photo_updated_at" datetime)   zzXq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)h/tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(40), "name" varchar(100) DEFAULT '', "email" varchar(100), "crypted_password" varchar(40), "salt" varchar(40), "created_at" datetime, "updated_at" datetime, "remember_token" varchar(40), "remember_token_expires_at" datetime, "user_type" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)r7tablepatientspatientsCREATE TABLE "patients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, etableallergiesallergiesCREATE TABLE "allergies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "allergen" varchar(255) DEFAULT '', "allergy_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime) #%% tablevaccinationsvaccinationsCREATE TABLE "vaccinations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vaccine_name" varchar(255) DEFAULT '', "vaccine_condition" varchar(255) DEFAULT '', "vaccination_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)p!!+tableconditionsconditions CREATE TABLE "conditions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "condition_name" varchar(255) DEFAULT '', "condition_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)##}tablemedicationsmedications CREATE TABLE "medications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "medicine_name" varchar(255) DEFAULT '', "side_effects" varchar(255) DEFAULT '', "medication_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)   8  33Dr.Asthaan2009-01-06 20:42:252009-01-06 20:42:25 nnA Ytabledoctorsdoctors CREATE TABLE "doctors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "doctor_first_name" varchar(255) DEFAULT '', "doctor_middle_name" varchar(255) DEFAULT '', "doctor_last_name" varchar(255) DEFAULT '', "doctor_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)p ##'tablevisit_typesvisit_typesCREATE TABLE "visit_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "visit_type" varchar(255) DEFAULT '', "visit_type_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)X //_tablepatient_allergiespatient_allergiesCREATE TABLE "patient_allergies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patient_id" integer DEFAULT 0, "allergy_id" integer DEFAULT 0, "allergy_date_recorded" date, "patient_allergy_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime, "reaction" varchar(255)) 5 33Emergency2009-01-09 04:44:202009-01-09 04:44:20   K 559tablepatient_vaccinationspatient_vaccinationsCREATE TABLE "patient_vaccinations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patient_id" integer DEFAULT 0, "vaccination_id" integer DEFAULT 0, "vaccination_date" date, "patient_vaccination_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime). 11tablepatient_conditionspatient_conditionsCREATE TABLE "patient_conditions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "condition_id" integer DEFAULT 0, "patient_visit_id" integer DEFAULT 0, "patient_condition_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)   WW"33ktablepatient_medicationspatient_medicationsCREATE TABLE "patient_medications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patient_condition_id" integer DEFAULT 0, "medication_id" integer DEFAULT 0, "start_date" date, "end_date" date, "dosage" varchar(255) DEFAULT '', "frequency" varchar(255) DEFAULT '', "patient_medication_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime)))=tablepatient_visitspatient_visitsCREATE TABLE "patient_visits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patient_id" integer DEFAULT 0, "visit_type_id" integer DEFAULT 0, "visit_date" date, "doctor_id" integer DEFAULT 0, "height" varchar(255) DEFAULT '', "weight" varchar(255) DEFAULT '', "blood_pressure" varchar(255) DEFAULT '', "pulse" varchar(255) DEFAULT '', "temperature" varchar(255) DEFAULT '', "patient_visit_remarks" text(10000) DEFAULT '', "created_at" datetime, "updated_at" datetime) C! 332009-01-092009-01-09 04:44:242009-01-09 04:44:24 K{hUB/ q^K)20090109102622)20081202093209)20081202073955)20081202073940)20081202030441)20081202030420)20081201052151)20081201051351)20081201051024)20081201045708)20081127063609 )20081127062100 )20081127015806 )20081127014224 )20081127013928 )20081127012727)20081111214601)20081027071020)20081027070851)20081027070757)20081027065215)20081027063007)20081027035528 ve5 indexindex_users_on_loginusersCREATE UNIQUE INDEX "index_users_on_login" ON "users" ("login")=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  admin aatif84