mysql> DESCRIBE customers;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | int(11)      | NO   | PRI | NULL    | auto_increment |
| category_id  | int(11)      | NO   |     | NULL    |                |
| company_id   | int(11)      | YES  |     | NULL    |                |
| first_name   | varchar(64)  | NO   |     | NULL    |                |
| last_name    | varchar(64)  | NO   |     | NULL    |                |
| id_number    | varchar(15)  | NO   |     | NULL    |                |
| address      | varchar(255) | YES  |     | NULL    |                |
| address_city | varchar(32)  | NO   |     | NULL    |                |
| address_zip  | varchar(6)   | YES  |     | NULL    |                |
| email        | varchar(128) | NO   |     | NULL    |                |
| phone1       | varchar(20)  | NO   |     | NULL    |                |
| phone2       | varchar(20)  | NO   |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

mysql> DESCRIBE customer_companies;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | int(11)      | NO   | PRI | NULL    | auto_increment |
| company_name    | varchar(128) | NO   |     | NULL    |                |
| company_address | varchar(255) | NO   |     | NULL    |                |
| company_reg_id  | varchar(8)   | NO   |     | NULL    |                |
| company_tax_id  | varchar(10)  | NO   |     | NULL    |                |
| company_vat_id  | varchar(12)  | NO   |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)