Import value for "Brand" field

I've not found a way to import the value for the "Brand" field - don't see it in a sample export from Hika.
Is there any way to import? Alternatively, where is the value stored in the database.

I tried to find it in the schema, but looking through a bitmap is difficult:
www.hikashop.com/hikashop_database.png
Is this schema available in a text/PDF or other searchable format?

In the developer documentation, there is also the database schema available as a workbench project. If you open it with mysql workbench, you will be able to navigate easily into it.

The brand field can be imported with the "product_manufacturer_id" field. Just enter the name of the brand in that column of your CSV.