# Bitly schema ERD

Table and field reference for the Fivetran Bitly connector.

## Table & Field Reference

### bitlink_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| bitlink_id | Unknown | PK, FK |
| group_guid | Unknown | PK, FK |

### bitlink_launchpad

| Column | Type | Keys |
| --- | --- | --- |
| launchpad_id | Unknown | PK |
| bitlink_id | Unknown | PK, FK |
| group_guid | Unknown | PK, FK |

### bitlink_deep_link

| Column | Type | Keys |
| --- | --- | --- |
| guid | Unknown | PK |
| bitlink_id | Unknown | PK, FK |
| group_guid | Unknown | PK, FK |
| app_guid | Unknown |  |
| app_uri_path | Unknown |  |
| bitlink | Unknown |  |
| brand_guid | Unknown |  |
| created | Unknown |  |
| install_type | Unknown |  |
| install_url | Unknown |  |
| modified | Unknown |  |
| os | Unknown |  |

### bitlink_campaign

| Column | Type | Keys |
| --- | --- | --- |
| bitlink_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| group_guid | Unknown | PK, FK |

### bitlink

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_guid | Unknown | PK, FK |
| archived | Unknown |  |
| client_id | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| custom_bitlinks | Json |  |
| link | Unknown |  |
| long_url | Unknown |  |
| reference | Json |  |
| title | Unknown |  |

### link_click

| Column | Type | Keys |
| --- | --- | --- |
| date | Instant | PK |
| bitlink_id | Unknown | PK, FK |
| clicks | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| guid | Unknown | PK, FK |
| created | Unknown |  |
| group_guid | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| reference | Json |  |

### group_bsds

| Column | Type | Keys |
| --- | --- | --- |
| bsds | Unknown | PK |
| group_guid | Unknown | PK, FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| guid | Unknown | PK |
| organization_guid | Unknown | FK |
| created | Unknown |  |
| is_active | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| reference | Json |  |
| role | Unknown |  |

### user_email

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| user_login | Unknown | PK, FK |
| is_primary | Unknown |  |
| is_verified | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| login | Unknown | PK |
| default_group_guid | Unknown | FK |
| created | Unknown |  |
| is_2_fa_enabled | Unknown |  |
| is_active | Unknown |  |
| is_sso_user | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |

### organization_bsds

| Column | Type | Keys |
| --- | --- | --- |
| bsds | Unknown | PK |
| organization_guid | Unknown | PK, FK |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| guid | Unknown | PK |
| created | Unknown |  |
| is_active | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| reference | Json |  |
| role | Unknown |  |
| tier | Unknown |  |
| tier_display_name | Unknown |  |
| tier_family | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| guid | Unknown | PK |
| created_by | Unknown | FK |
| group_guid | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| reference | Json |  |

### group_preference

| Column | Type | Keys |
| --- | --- | --- |
| group_guid | Unknown | PK, FK |
| domain_preference | Unknown |  |

## Relationships

- bitlink_tag(bitlink_id) → bitlink(id)
- bitlink_tag(group_guid) → bitlink(group_guid)
- bitlink_launchpad(bitlink_id) → bitlink(id)
- bitlink_launchpad(group_guid) → bitlink(group_guid)
- bitlink_deep_link(bitlink_id) → bitlink(id)
- bitlink_deep_link(group_guid) → bitlink(group_guid)
- bitlink_campaign(campaign_id) → campaign(guid)
- bitlink_campaign(bitlink_id) → bitlink(id)
- bitlink_campaign(group_guid) → bitlink(group_guid)
- bitlink(group_guid) → groups(guid)
- link_click(bitlink_id) → bitlink(id)
- channel(guid) → groups(guid)
- group_bsds(group_guid) → groups(guid)
- groups(organization_guid) → organization(guid)
- user_email(user_login) → users(login)
- users(default_group_guid) → groups(guid)
- organization_bsds(organization_guid) → organization(guid)
- campaign(group_guid) → groups(guid)
- campaign(created_by) → users(login)
- group_preference(group_guid) → groups(guid)