| Contact ID | int(11) | Unique ch-aviation created contact ID | Entity Contacts | Primary | | |
| Entity Name | varchar(255) | Entity name | Entity Contacts | | | |
| Entity ch-a Code | varchar(4) | Entity ch-aviation code (assigned by ch-aviation) | Entity Contacts | Foreign | Entities | Entity ch-a Code |
| Legal Name | varchar(255) | Entity legal name | Entity Contacts | | | |
| Entity Type | int(11) | Entity type | Entity Contacts | | | |
| Entity Type Code | char(1) | Entity type code (E: Engine Manufacturer, I: IT Provider, L: Lessor, X: Cargo Customer/Forwarder) | Entity Contacts | | | |
| Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Entity Contacts | | | |
| Location ID | int(11) | Location ID (assigned by ch-aviation) | Entity Contacts | Foreign | Airports | Airport ID |
| Country | varchar(255) | Country name | Entity Contacts | | | |
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Entity Contacts | Foreign | Countries | Country ISO |
| EU Country | char(1) | European Union country: Yes / No / (NULL) | Entity Contacts | | | |
| Title | char(2) | Mr / Ms | Entity Contacts | | | |
| Firstname | varchar(48) | First name | Entity Contacts | | | |
| Lastname | varchar(48) | Last name | Entity Contacts | | | |
| Job Group | varchar(48) | Job Group description (for filtering purposes) | Entity Contacts | | | |
| Job Title | varchar(127) | Job title | Entity Contacts | | | |
| Email | varchar(255) | E-Mail address (masked in sample data) | Entity Contacts | | | |
| Social Media | varchar(255) | Social media URL | Entity Contacts | | | |
