# Lemlist schema ERD

Table and field reference for the Fivetran Lemlist connector.

## Table & Field Reference

### unsubscribe

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| source | Unknown |  |
| value | Unknown |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| team_id | Unknown | PK, FK |

### team_beta

| Column | Type | Keys |
| --- | --- | --- |
| beta_name | Unknown | PK |
| team_id | Unknown | PK, FK |

### team_invited_user

| Column | Type | Keys |
| --- | --- | --- |
| invited_by | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| email | Unknown |  |
| invited_at | Unknown |  |
| role | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| created_at | Unknown |  |
| custom_domain | Unknown |  |
| name | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| created_by | Unknown | FK |
| send_user_id | Unknown | FK |
| team_id | Unknown | FK |
| campaign_name | Unknown |  |
| clearbit_website_page_signal | Unknown |  |
| company_linkedin_url | Unknown |  |
| company_name | Unknown |  |
| company_size | Unknown |  |
| company_url | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| email_id | Unknown |  |
| email_status | Unknown |  |
| email_template_id | Unknown |  |
| email_template_name | Unknown |  |
| employee | Unknown |  |
| error_message | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| headline | Unknown |  |
| industry | Unknown |  |
| is_first | Unknown |  |
| job_title | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| lead_company_name | Unknown |  |
| lead_email | Unknown |  |
| lead_first_name | Unknown |  |
| lead_id | Unknown |  |
| lead_last_name | Unknown |  |
| lh_id | Unknown |  |
| linkedin_url | Unknown |  |
| location_name | Unknown |  |
| member_id | Unknown |  |
| message_id | Unknown |  |
| name | Unknown |  |
| number_of_employees | Unknown |  |
| profile_link | Unknown |  |
| related_sent_at | Unknown |  |
| segment_signal | Unknown |  |
| send_user_email | Unknown |  |
| send_user_name | Unknown |  |
| sequence_id | Unknown |  |
| sequence_step | Unknown |  |
| sequence_tested | Unknown |  |
| step_tested | Unknown |  |
| stopped | Unknown |  |
| sub_industry | Unknown |  |
| total_sequence_step | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### campaign_label

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| label | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| name | Unknown |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| campaign_id | Unknown | FK |
| company_name | Unknown |  |
| current_company_position | Unknown |  |
| domain | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| industry | Unknown |  |
| is_paused | Unknown |  |
| last_name | Unknown |  |
| linkedin_company_url | Unknown |  |
| linkedin_url | Unknown |  |
| custom_** |  |  |

## Relationships

- team_user(team_id) → team(id)
- team_beta(team_id) → team(id)
- team_invited_user(invited_by) → team_user(user_id)
- team_invited_user(team_id) → team(id)
- team(created_by) → team_user(user_id)
- activity(send_user_id) → team_user(user_id)
- activity(campaign_id) → campaign(id)
- activity(team_id) → team(id)
- activity(created_by) → team_user(user_id)
- campaign_label(campaign_id) → campaign(id)
- lead(campaign_id) → campaign(id)
- lead(id) → activity(lead_id)