customer address fields in database

[fishvish]

There are three text boxes for Address under Customer Address

In which table can I find these three fields? I want to access this info so I can extend the Sales Order Grid with a column populated with data from the 3rd Address Textbox.

Thanks

[Rakesh Jesadiya]

By Default Customer address is an EAV attribute so any all the field with customer address is saved into one of the below table based on field input type.

customer_address_entity
customer_address_entity_varchar
customer_address_entity_datetime
customer_address_entity_text
customer_address_entity_int
customer_address_entity_decimal

 Main Entry placed inside customer_address_entity table and they related to one of the other varchar,int,datetime,text or decimal table with saved their field value.

So you cant find exact field name with input type in customer address.

[fishvish]

Ok so here is what we're trying to achieve:

We already have a drop down of areas per city for customers to select when they create their account - select a city and then start typing the area and select from a list and save...

now this is visible in the 3rd address textbox under the customer page in admin

is there anyway to retrieve this piece of info as a column in the sales order grid?

does the above make any sense?

[Rakesh Jesadiya · Accepted solution]

Kindly check below links for your query,

https://magento.stackexchange.com/questions/45572/how-to-add-customers-shipping-address-detail-in-ad...

This might be help for you.