# 6sense schema ERD

Table and field reference for the Fivetran 6sense connector.

## Table & Field Reference

### company_segment_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_domain | Unknown | PK, FK |
| name | Unknown |  |

### company_score

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_domain | Unknown | FK |
| buying_stage | Unknown |  |
| intent_score | Unknown |  |
| is_6_qa | Unknown |  |
| product | Unknown |  |
| product_display_name | Unknown |  |
| profile_fit | Unknown |  |
| profile_score | Unknown |  |

### company_sub_industry

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_domain | Unknown | FK |
| industry | Unknown |  |
| sub_industry | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| domain | Unknown | PK |
| additional_comment | Unknown |  |
| address | Unknown |  |
| annual_revenue | Unknown |  |
| city | Unknown |  |
| confidence | Unknown |  |
| country | Unknown |  |
| country_iso_code | Unknown |  |
| employee_count | Unknown |  |
| employee_range | Unknown |  |
| geo_ip_city | Unknown |  |
| geo_ip_country | Unknown |  |
| geo_ip_state | Unknown |  |
| industry | Unknown |  |
| is_6_qa | Unknown |  |
| is_blacklisted | Unknown |  |
| match | Unknown |  |
| naics | Unknown |  |
| naics_description | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| region | Unknown |  |
| revenue_range | Unknown |  |
| segment_id | Json |  |
| segment_name | Json |  |
| sic | Unknown |  |
| sic_description | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| zip | Unknown |  |

## Relationships

- company_segment_list(company_domain) → company(domain)
- company_score(company_domain) → company(domain)
- company_sub_industry(company_domain) → company(domain)