12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
|
# File 'app/models/caboose_rets/schema.rb', line 12
def self.schema
{
CabooseRets::Agent => [
[ :agent_number , :text ],
[ :cell_phone , :text ],
[ :direct_work_phone , :text ],
[ :email , :text ],
[ :fax_phone , :text ],
[ :first_name , :text ],
[ :full_name , :text ],
[ :generational_name , :text ],
[ :last_name , :text ],
[ :matrix_unique_id , :text ],
[ :matrix_modified_dt , :text ],
[ :middle_name , :text ],
[ :mls , :text ],
[ :mls_id , :text ],
[ :office_mui , :text ],
[ :office_mls_id , :text ],
[ :office_phone , :text ],
[ :other_phone , :text ],
[ :phone_toll_free , :text ],
[ :phone_voice_mail , :text ],
[ :photo_count , :text ],
[ :photo_modification_timestamp , :text ]
],
CabooseRets::AgentMeta => [
[ :la_code , :string ],
[ :hide , :boolean , { :default => false }],
[ :bio , :text ],
[ :contact_info , :text ],
[ :assistant_to , :string ],
[ :designation , :string ],
[ :image_location , :string ],
[ :image , :attachment ]
],
CabooseRets::Office => [
[ :lo_addr1 , :text ],
[ :lo_addr2 , :text ],
[ :lo_city , :text ],
[ :lo_email , :text ],
[ :lo_fax_phone , :text ],
[ :lo_mail_addr , :text ],
[ :lo_mail_care_of , :text ],
[ :lo_mail_city , :text ],
[ :lo_mail_postal_code , :text ],
[ :lo_mail_postal_code_plus4 , :text ],
[ :lo_mail_state_or_province , :text ],
[ :matrix_unique_id , :text ],
[ :lo_matrix_modified_dt , :text ],
[ :lo_mls , :text ],
[ :lo_mls_id , :text ],
[ :lo_office_contact_mui , :text ],
[ :lo_office_contact_mls_id , :text ],
[ :lo_office_long_name , :text ],
[ :lo_office_name , :text ],
[ :lo_phone , :text ],
[ :lo_photo_count , :text ],
[ :photo_modification_timestamp , :text ],
[ :state , :text ],
[ :street_address , :text ],
[ :street_city , :text ],
[ :street_postal_code , :text ],
[ :street_postal_code_plus4 , :text ],
[ :street_state_or_province , :text ],
[ :web_facebook , :text ],
[ :web_linked_in , :text ],
[ :web_page_address , :text ],
[ :web_twitter , :text ],
[ :zip , :text ]
],
CabooseRets::OpenHouse => [
[ :active_yn , :text ],
[ :description , :text ],
[ :end_time , :text ],
[ :entry_order , :text ],
[ :listing_mui , :text ],
[ :matrix_unique_id , :text ],
[ :matrix_modified_dt , :text ],
[ :open_house_date , :text ],
[ :open_house_type , :text ],
[ :provider_key , :text ],
[ :refreshments , :text ],
[ :start_time , :text ]
],
CabooseRets::Property => [
[ :access , :text],
[ :acreage , :decimal],
[ :acreage_source , :text],
[ :active_open_house_count , :text],
[ :adjoining_land_use , :text],
[ :age , :text],
[ :annual_taxes , :text],
[ :appliances , :text],
[ :area , :text],
[ :attic , :text],
[ :available_date , :text],
[ :basement , :text],
[ :basement_yn , :text],
[ :baths_full , :integer],
[ :baths_half , :integer],
[ :baths_total , :decimal],
[ :beds_total , :integer],
[ :book_number , :text],
[ :book_page , :text],
[ :book_type , :text],
[ :building_type , :text],
[ :business_included_yn , :text],
[ :buyer_name , :text],
[ :city , :text],
[ :city_community , :text],
[ :closing , :text],
[ :co_list_agent_mui , :text],
[ :co_list_agent_direct_work_phone , :text],
[ :co_list_agent_full_name , :text],
[ :co_list_agent_email , :text],
[ :co_list_agent_mls_id , :text],
[ :co_list_office_mui , :text],
[ :co_list_office_mls_id , :text],
[ :co_list_office_name , :text],
[ :co_list_office_phone , :text],
[ :completion_date , :text],
[ :comp_tenant_rep , :text],
[ :construction , :text],
[ :construction_status , :text],
[ :cooling , :text],
[ :county_or_parish , :text],
[ :current_price , :text],
[ :date_created , :text],
[ :date_leased , :text],
[ :date_modified , :text],
[ :deposit , :text],
[ :dining_room , :text],
[ :directions , :text],
[ :display_address_on_internet_yn , :text],
[ :dom , :text],
[ :driveway , :text],
[ :elementary_school , :text],
[ :exists_struct , :text],
[ :expenses_association , :text],
[ :expenses_insurance , :text],
[ :expenses_maintenance , :text],
[ :expenses_management , :text],
[ :expenses_other , :text],
[ :expenses_tax , :text],
[ :expenses_utility , :text],
[ :exterior_features , :text],
[ :fireplace , :text],
[ :flood_plain , :text],
[ :flooring , :text],
[ :foreclosure_sale_date , :text],
[ :foreclosure_yn , :text],
[ :fsboyn , :text],
[ :garage , :text],
[ :heating , :text],
[ :high_school , :text],
[ :hoa_amenities , :text],
[ :hoa_fee , :text],
[ :hoa_included_in_rent_yn , :text],
[ :hoa_term , :text],
[ :hoa_term_mandatory_yn , :text],
[ :homestead_yn , :text],
[ :idx_opt_in_yn , :text],
[ :income_other , :text],
[ :income_rental , :text],
[ :interior_features , :text],
[ :land_features_extras , :text],
[ :landscaping , :text],
[ :latitude , :text],
[ :laundry , :text],
[ :legal_description , :text],
[ :legal_lot , :text],
[ :legal_section , :text],
[ :levels , :text],
[ :list_agent_mui , :text],
[ :list_agent_direct_work_phone , :text],
[ :list_agent_email , :text],
[ :list_agent_full_name , :text],
[ :list_agent_mls_id , :text],
[ :listing_contract_date , :text],
[ :list_office_mui , :text],
[ :list_office_mls_id , :text],
[ :list_office_name , :text],
[ :list_office_phone , :text],
[ :list_price , :decimal],
[ :longitude , :text],
[ :lot_description , :text],
[ :lot_dimensions , :text],
[ :lot_dim_source , :text],
[ :management , :text],
[ :master_bed_level , :text],
[ :matrix_unique_id , :text],
[ :matrix_modified_dt , :text],
[ :max_sqft , :text],
[ :middle_school , :text],
[ :mineral_rights , :text],
[ :min_sqft , :text],
[ :misc_indoor_featuresa , :text],
[ :mls , :text],
[ :mls_number , :text],
[ :municipality , :text],
[ :net_op_inc , :text],
[ :open_house_count , :text],
[ :open_house_public_count , :text],
[ :open_house_public_upcoming , :text],
[ :open_house_upcoming , :text],
[ :parcel_number , :text],
[ :pending_date , :text],
[ :pets_allowed_yn , :text],
[ :photo_count , :text],
[ :photo_modification_timestamp , :text],
[ :pool , :text],
[ :porch_patio , :text],
[ :possession , :text],
[ :possible_uses , :text],
[ :postal_code , :text],
[ :postal_code_plus4 , :text],
[ :price_per_acre , :text],
[ :price_sqft , :text],
[ :property_name , :text],
[ :property_subtype , :text],
[ :property_type , :text],
[ :property_use , :text],
[ :prop_mgmt_comp , :text],
[ :public_remarks , :text],
[ :refrigerator_included_yn , :text],
[ :rental_rate_type , :text],
[ :rent_incl , :text],
[ :res_style , :text],
[ :restrictions , :text],
[ :road_frontage , :text],
[ :roof , :text],
[ :roofage , :text],
[ :room_count , :text],
[ :service_type , :text],
[ :sewer , :text],
[ :sold_terms , :text],
[ :sprinkler , :text],
[ :sqft_source , :text],
[ :sqft_total , :decimal],
[ :state_or_province , :text],
[ :status , :text],
[ :status_contractual_search_date , :text],
[ :street_dir_prefix , :text],
[ :street_dir_suffix , :text],
[ :street_name , :text],
[ :street_number , :text],
[ :street_number_numeric , :text],
[ :street_suffix , :text],
[ :street_view_param , :text],
[ :style , :text],
[ :subdivision , :text],
[ :topography , :text],
[ :total_num_units , :text],
[ :total_num_units_occupied , :text],
[ :transaction_type , :text],
[ :unit_count , :text],
[ :unit_number , :text],
[ :utilities , :text],
[ :virtual_tour1 , :text],
[ :vow_allowed_avmyn , :text],
[ :vow_allowed_third_party_comm_yn , :text],
[ :washer_dryer_included , :text],
[ :water , :text],
[ :waterfronts , :text],
[ :waterfront_yn , :text],
[ :water_heater , :text],
[ :windows , :text],
[ :window_treatments , :text],
[ :year_built , :text],
[ :yr_blt_source , :text],
[ :zoning , :text],
[ :zoning_northport , :text],
[ :zoning_tusc , :text]
],
CabooseRets::Media => [
[ :photo_modification_timestamp , :string ],
[ :file_name , :string ],
[ :media_mui , :string ],
[ :media_order , :integer , { :default => 0 }],
[ :media_remarks , :text ],
[ :media_type , :text ],
[ :url , :text ],
[ :image , :attachment ],
[ :file , :attachment ],
[ :media , :bytea ]
],
CabooseRets::SavedProperty => [
[ :user_id , :integer ],
[ :mls_number , :integer ]
],
CabooseRets::SavedSearch => [
[ :user_id , :integer ],
[ :params , :text ],
[ :date_created , :timestamp ],
[ :date_last , :timestamp ],
[ :interval , :integer ],
[ :property_type , :string ],
[ :uri , :text ],
[ :notify , :boolean ]
],
CabooseRets::SearchOption => [
[ :name , :string ],
[ :field , :string ],
[ :value , :string ],
[ :flag_for_delete , :boolean , { :default => false }]
],
Caboose::Site => [
[ :use_rets , :boolean, { :default => false }]
]
}
end
|