SQLite format 3@   GNEW_TYPEN"##NAME_PREFIXName PrefixRT DescGENDERGender nMRMrRT DescMRSMrsFEMALEFemale MSMsMRMrMALEMale 0 #Product One#Product Two  !2007-09-28d!2007-09-272!2007-09-27 !2007-09-28!2007-09-27!2007-09-27 Nu++!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 )N++Stablereference_codesreference_codesCREATE TABLE `reference_codes` ( `reference_type_id` int(11) NOT NULL, `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_codesQtableproductsproductsCREATE TABLE `products` ( `id` int(11) NOT NULL PRIMARY KEY, `name` varchar(50) default NULL )/Cindexsqlite_autoindex_products_1products ''N 9B[tabletariffstariffsCREATE 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_1tariffsq++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 9 Itablesuburbssuburbs 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_1suburbsD _tablestreetsstreetsCREATE 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 ) !2007-09-27!2007-09-27!2007-09-27 !2007-09-27!2007-09-27!2007-09-27 %First Suburb'Second Suburb  %First Street'Second Street%First Street 3membership_statuses groups readings articles comments users employees streets #kP ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)_tableusersusersCREATE TABLE `users` ( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(50) NOT NULL ) etablearticlesarticlesCREATE TABLE `articles` ( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(50) NOT NULL )F_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 )}UtablegroupsgroupsCREATE TABLE groups ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name varchar(50) NOT NULL )##ktablemembershipsmembershipsCREATE TABLE memberships ( user_id int NOT NULL, group_id int NOT NULL, PRIMARY KEY (user_id,group_id) )  Dr Nic Santiago #Article One#Article Two  9Composite Primary Keys    Active Owner A_ATtablehackshacksCREATE TABLE hacks ( name varchar(50) NOT NULL PRIMARY KEY ))=indexsqlite_autoindex_hacks_1hacks5I#indexsqlite_autoindex_memberships_1membershipsV33Stablemembership_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 ),##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 )tablecommentscommentsCREATE TABLE comments ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, person_id INTEGER NULL, person_type varchar(100) NULL )    andrewHack User Employee andrew  andrew