Magento Eav Table

query result

attribute_id attribute_code entity_type_id
16 confirmation 1
17 created_at 1
3 created_in 1
13 default_billing 1
14 default_shipping 1
263 disable_auto_group_change 1
11 dob 1
9 email 1
5 firstname 1
18 gender 1
10 group_id 1
7 lastname 1
6 middlename 1
12 password_hash 1
4 prefix 1
142 reward_update_notification 1
143 reward_warning_notification 1
33 rp_token 1
34 rp_token_created_at 1
2 store_id 1
8 suffix 1
15 taxvat 1
1 website_id 1
26 city 2
24 company 2
27 country_id 2
32 fax 2
20 firstname 2
22 lastname 2
21 middlename 2
30 postcode 2
19 prefix 2
28 region 2
29 region_id 2
25 street 2
23 suffix 2
31 telephone 2
264 vat_id 2
265 vat_is_valid 2
267 vat_request_date 2
266 vat_request_id 2
268 vat_request_success 2
331 1800wc_legacy_catid 3
332 1800wc_legacy_cat_name 3
281 additional_description 3
48 all_children 3
59 available_sort_by 3
280 category_nickname 3
50 children 3
58 children_count 3
63 custom_apply_to_products 3
52 custom_design 3
53 custom_design_from 3
54 custom_design_to 3
56 custom_layout_update 3
62 custom_use_parent_settings 3
60 default_sort_by 3
452 default_view_type 3
38 description 3
43 display_mode 3
64 filter_price_range 3
169 home_category 3
170 home_category_order 3
171 home_category_text_area 3
39 image 3
61 include_in_menu 3
36 is_active 3
45 is_anchor 3
279 is_category_list_mode 3
44 landing_page 3
57 level 3
42 meta_description 3
41 meta_keywords 3
40 meta_title 3
35 name 3
55 page_layout 3
46 path 3
49 path_in_store 3
47 position 3
352 redirect_category_id 3
126 thumbnail 3
37 url_key 3
51 url_path 3
409 absorbancy_configurable 4
353 accessory_category 4
330 additional_attribute_1800wc 4
342 additional_options 4
195 additional_product_data 4
138 allow_message 4
128 allow_open_amount 4
375 armrests_configurable 4
361 armrest_style 4
285 armrest_style_configurable 4
376 axles_configurable 4
411 backrest_configurable 4
378 backrest_options_configurable 4
293 back_height 4
369 back_style 4
377 back_type_configurable 4
245 bag_type 4
434 bag_type_filter 4
246 bag_use 4
418 bag_use_filter 4
256 bathroom_absorbancy 4
257 bathroom_size 4
258 bathroom_style 4
310 battery_type 4
311 battery_weight 4
270 brand 4
420 brand_filter 4
414 caster_size_configurable 4
101 category_ids 4
334 center_of_gravity 4
303 center_wheel_size 4
85 color 4
379 color_configurable 4
380 contour_type_configurable 4
313 controller 4
73 cost 4
110 country_of_manufacture 4
381 cover_configurable 4
108 created_at 4
326 cushion_cover 4
238 cushion_depth 4
437 cushion_depth_filter 4
237 cushion_material 4
421 cushion_material_filter 4
382 cushion_size_configurable 4
240 cushion_thickness 4
383 cushion_thickness_configurable 4
422 cushion_thickness_filter 4
325 cushion_type 4
241 cushion_use 4
423 cushion_use_filter 4
239 cushion_width 4
438 cushion_width_filter 4
194 customize_for_purchase 4
96 custom_design 4
97 custom_design_from 4
98 custom_design_to 4
99 custom_layout_update 4
384 depth_configurable 4
66 description 4
412 diameter_configurable 4
309 driving_range 4
136 email_template 4
114 enable_googlecheckout 4
339 fabric 4
406 fabric_configurable 4
173 features 4
386 footrests_configurable 4
362 footrest_options 4
286 footrest_style_configurable 4
385 footrest_width_configurable 4
387 fork_mount_configurable 4
374 frame_colofghr 4
367 frame_color 4
388 frame_color_configurable 4
191 free_shipping_minimum 4
389 front_riggings_configurable 4
302 front_wheel_size 4
88 gallery 4
127 giftcard_amounts 4
131 giftcard_type 4
116 gift_message_available 4
140 gift_wrapping_available 4
141 gift_wrapping_price 4
307 ground_clearance 4
269 group_price 4
104 has_options 4
301 heaviest_piece 4
390 height_configurable 4
451 hubs_configurable 4
79 image 4
105 image_label 4
188 included 4
335 incontinence_absorbancy 4
415 incontinence_absorbancy_filter 4
336 incontinence_size 4
337 incontinence_style 4
430 incontinence_style_filter 4
272 is_best_buy 4
273 is_exclusive 4
277 is_free_gift 4
275 is_free_return 4
271 is_new 4
276 is_onsale 4
93 is_recurring 4
132 is_redeemable 4
163 is_returnable 4
190 item_number 4
192 leave_warehouse_in 4
408 length_configurable 4
134 lifetime 4
322 liftchair_back_angle_range 4
262 liftchair_back_style 4
417 liftchair_back_style_filter 4
323 liftchair_footrest_angle_range 4
260 liftchair_material 4
424 liftchair_material_filter 4
261 liftchair_recline_type 4
259 liftchair_user_size 4
435 liftchair_user_size_filter 4
321 lif_chair_back_style 4
125 links_exist 4
122 links_purchased_separately 4
124 links_title 4
75 manufacturer 4
347 manufacturer_lookup_info 4
350 manufacturer_lookup_more_info 4
316 maximum_handle_height 4
440 maximum_handle_height_filter 4
308 max_climbing_angle 4
306 max_speed 4
82 media_gallery 4
298 medicare_hcpcs_code 4
78 meta_description 4
77 meta_keyword 4
76 meta_title 4
92 minimal_price 4
315 minimum_handle_height 4
439 minimum_handle_height_filter 4
354 model_choice 4
363 model_choice_configurable 4
312 motor 4
340 mounting_option 4
113 msrp 4
112 msrp_display_actual_price_type 4
111 msrp_enabled 4
65 name 4
86 news_from_date 4
87 news_to_date 4
83 old_id 4
130 open_amount_max 4
129 open_amount_min 4
407 options_configurable 4
102 options_container 4
291 overall_height 4
300 overall_length 4
290 overall_width 4
100 page_layout 4
232 powerchair_type 4
432 powerchair_type_filter 4
69 price 4
117 price_type 4
120 price_view 4
453 product_featured 4
328 product_manual_1 4
329 product_manual_2 4
187 product_manual_file 4
282 product_weight 4
341 quantity 4
413 quantity_configurable 4
189 quick_overview 4
242 ramp_length 4
391 ramp_length_configurable 4
441 ramp_length_filter 4
244 ramp_rise 4
442 ramp_rise_filter 4
243 ramp_width 4
450 ramp_width_filter 4
370 rear_wheel_size 4
320 recline_type 4
425 recline_type_filter 4
317 recommended_user_height 4
426 recommended_user_height_filter 4
94 recurring_profile 4
165 related_tgtr_position_behavior 4
164 related_tgtr_position_limit 4
324 required_distance_from_wall 4
103 required_options 4
278 return_policy_cms_id 4
123 samples_title 4
249 scooter_tire_size 4
247 scooter_type 4
433 scooter_type_filter 4
248 scooter_weight 4
443 scooter_weight_filter 4
371 seat_depth 4
392 seat_depth_configurable 4
364 seat_size 4
393 seat_size_configurable 4
372 seat_style 4
373 seat_to_floor_height 4
368 seat_width 4
284 seat_width_configurable 4
121 shipment_type 4
193 shipping_notes 4
297 shipping_weight 4
351 ship_price 4
67 short_description 4
176 showvideofirst 4
343 side 4
283 size 4
366 size_configurable 4
429 size_filter 4
68 sku 4
118 sku_type 4
80 small_image 4
106 small_image_label 4
394 solid_seat_insert_configurable 4
71 special_from_date 4
70 special_price 4
72 special_to_date 4
186 specifications 4
89 status 4
410 style_configurable 4
115 tax_class_id 4
395 thickness_configurable 4
81 thumbnail 4
107 thumbnail_label 4
84 tier_price 4
305 tires 4
396 tires_configurable 4
446 tires_filter 4
235 turning_radius 4
447 turning_radius_filter 4
346 unit_of_measure 4
109 updated_at 4
397 upholstery_color_configurable 4
294 upholstery_material 4
167 upsell_tgtr_position_behavior 4
166 upsell_tgtr_position_limit 4
90 url_key 4
91 url_path 4
139 use_config_allow_message 4
137 use_config_email_template 4
133 use_config_is_redeemable 4
135 use_config_lifetime 4
327 video_code 4
95 visibility 4
253 walker_basket_included 4
419 walker_basket_included_filter 4
255 walker_foldable 4
254 walker_seat_included 4
427 walker_seat_included_filter 4
250 walker_weight 4
448 walker_weight_filter 4
252 walker_wheel_height 4
251 walker_wheel_size 4
299 warranty 4
74 weight 4
179 weight_capacity 4
401 weight_capacity_configurable 4
119 weight_type 4
184 wheelchair_armrest_type 4
416 wheelchair_armrest_type_filter 4
333 wheelchair_capacity 4
185 wheelchair_seat_height 4
444 wheelchair_seat_height_filter 4
234 wheelchair_seat_style 4
428 wheelchair_seat_style_filter 4
182 wheelchair_seat_width 4
445 wheelchair_seat_width_filter 4
233 wheelchair_travel_compact 4
178 wheelchair_type 4
431 wheelchair_type_filter 4
236 wheelchair_weight 4
449 wheelchair_weight_filter 4
314 wheel_size 4
399 wheel_size_configurable 4
436 wheel_size_filter 4
400 width_configurable 4
292 width_folded 4
319 width_inside_back_legs 4
318 width_inside_hand_grips 4
175 wistiavideo 4
153 condition 9
162 is_qty_decimal 9
145 order_item_id 9
159 product_admin_name 9
160 product_admin_sku 9
150 product_name 9
161 product_options 9
151 product_sku 9
148 qty_approved 9
147 qty_authorized 9
146 qty_requested 9
158 qty_returned 9
154 reason 9
155 reason_other 9
152 resolution 9
144 rma_entity_id 9
149 status 9
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s