SQLite format 3@ ""R P ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)B [tablestreetsstreets CREATE TABLE streets ( id integer not null primary key autoincrement, city_id int(11) not null, suburb_id int(11) not null, name varchar(50) not null )5 Atablesuburbssuburbs CREATE TABLE suburbs ( city_id int(11) not null, suburb_id int(11) not null, name varchar(50) not null, primary key (city_id, suburb_id) )- Aindexsqlite_autoindex_suburbs_1suburbs l++tableproduct_tariffsproduct_tariffs CREATE TABLE product_tariffs ( product_id int(11) not null, tariff_id int(11) not null, tariff_start_date date not null, primary key (product_id, tariff_id, tariff_start_date) )= Q+indexsqlite_autoindex_product_tariffs_1product_tariffs >StabletariffstariffsCREATE TABLE tariffs ( tariff_id int(11) not null, start_date date not null, amount integer(11) default null, primary key (tariff_id, start_date) )-Aindexsqlite_autoindex_tariffs_1tariffs}MtableproductsproductsCREATE TABLE products ( id int(11) not null primary key, name varchar(50) default null )/Cindexsqlite_autoindex_products_1productsA++9tablereference_codesreference_codesCREATE TABLE reference_codes ( reference_type_id int(11), reference_code int(11) not null, code_label varchar(50) default null, abbreviation varchar(50) default null, description varchar(50) default null, primary key (reference_type_id, reference_code) )=Q+indexsqlite_autoindex_reference_codes_1reference_codess++tablereference_typesreference_typesCREATE TABLE reference_types ( reference_type_id integer primary key, type_label varchar(50) default null, abbreviation varchar(50) default null, description varchar(50) defa ##NAME_PREFIXName PrefixGENDERGender  MRMrMRSMrsFEMALEFemale MSMsMALEMale  #Product Two#Product One  !2010-02-14d!2010-02-132!2010-02-13 !2010-02-14!2010-02-13!2010-02-13 !2010-02-13!2010-02-13!2010-02-13 !2010-02-13!2010-02-13!2010-02-13 %First Suburb'Second Suburb  'Second Street%First Street%First Street \u\ 3membership_statuses groups comments employees readings users students+room_attributes dorms streets articles  Dr Nic Santiago 47s++tablereference_typesreference_typesCREATE TABLE reference_types ( reference_type_id integer primary key, types++tablereference_typesreference_typesCREATE TABLE reference_types ( reference_type_id integer primary key, type_label varchar(50) default null, abbreviation varchar(50) default null, description varchar(50) default null )A++9tablereference_codesreference_codesCREATE TABLE reference_codes ( reference_type_id int(11), reference_code int(11) not null, code_label varchar(50) default null, abbreviation varchar(50) default null, description varchar(50) default null, primary key (reference_type_id, reference_code) )=Q+indexsqlite_autoindex_reference_codes_1reference_codes}MtableproductsproductsCREATE TABLE products ( id int(11) not null primary key, name varchar(50) default null )/Cindexsqlite_autoindex_products_1products>StabletariffstariffsCREATE TABLE tariffs ( tariff_id int(11) not null, start_date date not null, amount integer(11) default null, primary key (tariff_id, start_date) )-Aindexsqlite_autoindex_tariffs_1tariffsl++tableproduct_tariffsproduct_tariffs CREATE TABLE product_tariffs ( product_id int(11) not null, tariff_id int(11) not null, tariff_start_date date not null, primary key (product_id, tariff_id, tariff_start_date) )= Q+indexsqlite_autoindex_product_tariffs_1product_tariffs 5 Atablesuburbssuburbs CREATE TABLE suburbs ( city_id int(11) not null, suburb_id int(11) not null, name varchar(50) not null, primary key (city_id, suburb_id) )- Aindexsqlite_autoindex_suburbs_1suburbs B [tablestreetsstreets CREATE TABLE streets ( id integer not null primary key autoincrement, city_id int(11) not null, suburb_id int(11) not null, name varchar(50) not null )P ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) #Article One#Article Two &q C"|nn5I#indexsqlite_autoindex_restaurants_1restaurants!atablearticlesarticlesCREATE TABLE articles ( id integer not null primary key autoincrement, name~[tableusersusersCREATE TABLE users ( id integer not null primary key autoincrement, name varchar(50) not null )atablearticlesarticlesCREATE TABLE articles ( id integer not null primary key autoincrement, name varchar(50) not null )D[tablereadingsreadingsCREATE TABLE readings ( id integer not null primary key autoincrement, user_id int(11) not null, article_id int(11) not null, rating int(11) not null )]tablegroupsgroupsCREATE TABLE groups ( id integer not null primary key autoincrement, name varchar(50) not null )##wtablemembershipsmembershipsCREATE TABLE memberships ( user_id int not null, group_id int not null, primary key (user_id, group_id) )5I#indexsqlite_autoindex_memberships_1memberships\33_tablemembership_statusesmembership_statusesCREATE TABLE membership_statuses ( id integer not null primary key autoincrement, user_id int not null, group_id int not null, status varchar(50) not null )2##+tabledepartmentsdepartmentsCREATE TABLE departments ( department_id integer not null, location_id integer not null, primary key (department_id, location_id) )5I#indexsqlite_autoindex_departments_1departments)!tableemployeesemployeesCREATE TABLE employees ( id integer not null primary key autoincrement, department_id integer null, location_id integer null )?QtablecommentscommentsCREATE TABLE comments ( id integer not null primary key autoincrement, person_id varchar(100) null, person_type varchar(100) null, hack_id varchar(100) null )W tablehackshacksCREATE TABLE hacks ( name varchar(50) not null primary key ))=indexsqlite_autoindex_hacks_1hacks  9Composite Primary Keys    Active Owner    andrewHack1Userandrew1Employee andrew  andrew !2010-02-13string  McDonalds   p+[ Ue%tablestudentsstudents)CREATE TABLE students ( id integer not null primary key autoincrement )F$AAtableroom_attribute_assignmentsroom_attribute_assignments(CREATE TABL 'tableseatsseats+CREATE TABLE seats ( flight_number integer not_null, seat integer not_null, customer integer, primary key (flight_number, seat) ))(=indexsqlite_autoindex_seats_1seats,5'')tablekitchen_sinkskitchen_sinksCREATE TABLE kitchen_sinks ( id_1 integer not null, id_2 integer not null, a_date date, a_string varchar(100), primary key (id_1, id_2) )9M'indexsqlite_autoindex_kitchen_sinks_1kitchen_sinks5##1tablerestaurantsrestaurants CREATE TABLE restaurants ( franchise_id integer not null, store_id integer not null, name varchar(100), primary key (franchise_id, store_id) )5I#indexsqlite_autoindex_restaurants_1restaurants!J33;tablerestaurants_suburbsrestaurants_suburbs#CREATE TABLE restaurants_suburbs ( franchise_id integer not null, store_id integer not null, city_id integer not null, suburb_id integer not null )\ tabledormsdorms$CREATE TABLE dorms ( id integer not null primary key autoincrement )!etableroomsrooms%CREATE TABLE rooms ( dorm_id integer not null, room_id integer not null, primary key (dorm_id, room_id) ))"=indexsqlite_autoindex_rooms_1rooms& #++Qtableroom_attributesroom_attributes'CREATE TABLE room_attributes ( id integer not null primary key autoincrement, name varchar(50) )F$AAtableroom_attribute_assignmentsroom_attribute_assignments(CREATE TABLE room_attribute_assignments ( dorm_id integer not null, room_id integer not null, room_attribute_id integer not null )e%tablestudentsstudents)CREATE TABLE students ( id integer not null primary key autoincrement )"&--wtableroom_assignmentsroom_assignments*CREATE TABLE room_assignments ( student_id integer not null, dorm_id integer not null, room_id integer not null )       keg