What is an external id, and what is its uses?
Odoo External ID
An External ID (also called XML ID) is a string identifier that uniquely identifies a particular record in Odoo.
They become important when you plan to import data into Odoo.
When you import data, if you supply an External ID, Odoo checks if this record already exists. If it does not, that line of your import file becomes an INSERT. If it does exist, that line of your import file becomes an UPDATE. If you don't supply an External ID (you leave it blank, or just don't supply the field at all), Odoo creates one automatically for you.
They are stored in the ir.model.data model and are not given to records that are created via the Odoo user interface - only for records that are imported (External ID is created or read on import) or exported (External ID is created on export if it doesn't exist already).
You can see the External ID for a record in Developer Mode using the View Metadata option in the Debug Menu.
When you export data, Odoo will ensure External ID's are present for every record in the export file, so you can update the file and import it back into Odoo (using the rules above).
Every record in any model is related to one record on ir.model.data by it's res_id and model field.
To low level query the external ID, example table product_product:
md.name as external_id,
product_prouct as p
ir_model_data md on md.res_id = p.id and md.model = 'product.product'