FindAPlace

From Katrina Help Info

Table of contents

2.1 Housing description
2.2 Household members
2.3 Communications
2.4 Proximity to Services
2.5 Eventually

Current FindAPlace schema

 CREATE TABLE `find_a_place` (
   `room_type` int(11) NOT NULL default '0',
   `pets` int(11) NOT NULL default '0',
   `household_members` varchar(255) NOT NULL default ,
   `household_types` int(11) NOT NULL default '0',
   `household_children` int(11) NOT NULL default '0',
   `prox_services` varchar(255) NOT NULL default ,
   `public_transportation` text NOT NULL,
   `down_town_dist` varchar(255) NOT NULL default ,
   `comm_options` int(11) NOT NULL default '0',
   `smoking` int(11) NOT NULL default '0',
   `allergies` text NOT NULL,
   `nid` int(11) NOT NULL default '0',
   PRIMARY KEY  (`nid`)
 ) ENGINE=MyISAM;

Proposed Data for spec

Housing description

Room or living room Pets Closest Public Transportation Distance from 'down town' Distance form airports Smoking/ Non-smoking Allergies IT Connection

Household members

Are they a family or roommates? How many people live in the place? Are there any kids?

Communications

I also think communication methods are important. Right now there is a business trip scheduled for LA and they want to go forward with it but the hotels phone is out which doesn't inspire confidence. In any case, besides rooms, people need to know who has phone/fax/IT connection/wifi/phone through IT that they are willing to share.