gistfile1.txt

                                                 Table "public.properties"
              Column               |            Type             |                        Modifiers                        
-----------------------------------+-----------------------------+---------------------------------------------------------
 id                                | integer                     | not null default nextval('properties_id_seq'::regclass)
 name                              | character varying(255)      | 
 latitude                          | double precision            | 
 longitude                         | double precision            | 
 time_zone                         | character varying(255)      | default 'America/Los_Angeles'::character varying
 phone                             | character varying(255)      | 
 state                             | character varying(255)      | default 'unverified'::character varying
Indexes:
    "properties_pkey" PRIMARY KEY, btree (id)
    "index_properties_on_state" btree (state)

                                               Table "public.reservations"
            Column             |            Type             |                         Modifiers                         
-------------------------------+-----------------------------+-----------------------------------------------------------
 id                            | integer                     | not null default nextval('reservations_id_seq'::regclass)
 confirmation_number           | character varying(255)      | 
 first_name                    | character varying(255)      | 
 last_name                     | character varying(255)      | 
 email                         | character varying(255)      | 
 phone                         | character varying(255)      | 
 start_on                      | date                        | 
 end_on                        | date                        | 
 state                         | character varying(255)      | 
 property_id                   | integer                     | 
 guest_id                      | integer                     | 
Indexes:
    "reservations_pkey" PRIMARY KEY, btree (id)
    "index_reservations_on_property_id_and_confirmation_number" UNIQUE, btree (property_id, confirmation_number)
    "index_reservations_on_email" btree (email)
    "index_reservations_on_guest_id" btree (guest_id)
    "index_reservations_on_property_id" btree (property_id)
    "index_reservations_on_start_on" btree (start_on)
    "index_reservations_on_state" btree (state)