# Akamai schema ERD

Table and field reference for the Fivetran Akamai connector.

## Table & Field Reference

### entity_optins

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | PK, FK |
| entity_uuid | Unknown | PK, FK |
| optin_creation_date | Unknown |  |
| optin_id | Unknown |  |
| optin_status | Unknown |  |
| custom_** |  |  |

### entity_post_login

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | PK, FK |
| entity_uuid | Unknown | PK, FK |
| privacy_policy_accepted_date | Unknown |  |
| privacy_policy_id | Unknown |  |
| screen_name | Unknown |  |
| custom_** |  |  |

### entity_client

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | PK, FK |
| entity_uuid | Unknown | PK, FK |
| client_id | Unknown |  |
| first_login | Unknown |  |
| last_login | Unknown |  |
| custom_** |  |  |

### entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| about_me | Unknown |  |
| birthday | Unknown |  |
| children | Unknown |  |
| company | Unknown |  |
| consumer_id | Unknown |  |
| created | Unknown |  |
| current_location | Unknown |  |
| deactivate_account | Unknown |  |
| display | Unknown |  |
| display_name | Unknown |  |
| drupal_roles | Unknown |  |
| email | Unknown |  |
| email_verified | Unknown |  |
| family_name | Unknown |  |
| gender | Unknown |  |
| given_name | Unknown |  |
| graduation_year | Unknown |  |
| last_login | Unknown |  |
| last_updated | Unknown |  |
| licensing_state | Unknown |  |
| match_type | Unknown |  |
| middle_name | Unknown |  |
| optin_user | Unknown |  |
| originating_brand | Unknown |  |
| password_created | Unknown |  |
| password_type | Unknown |  |
| practice_name | Unknown |  |
| primary_address_address_1 | Unknown |  |
| primary_address_address_2 | Unknown |  |
| primary_address_address_type | Unknown |  |
| primary_address_city | Unknown |  |
| primary_address_company | Unknown |  |
| primary_address_country | Unknown |  |
| primary_address_mobile | Unknown |  |
| primary_address_phone | Unknown |  |
| primary_address_phone_type | Unknown |  |
| primary_address_state_abbreviation | Unknown |  |
| primary_address_unit | Unknown |  |
| primary_address_zip | Unknown |  |
| primary_address_zip_plus_4 | Unknown |  |
| privacy_policy_id | Unknown |  |
| product_1 | Unknown |  |
| profession | Unknown |  |
| professional_status | Unknown |  |
| promo_1 | Unknown |  |
| promo_code | Unknown |  |
| promotion_source | Unknown |  |
| reason_code | Unknown |  |
| sample_ability | Unknown |  |
| source_id | Unknown |  |
| specialty | Unknown |  |
| state_license_number | Unknown |  |
| tracking_campaign | Unknown |  |
| tracking_medium | Unknown |  |
| tracking_source | Unknown |  |
| type_name | String |  |
| custom_** |  |  |

## Relationships

- entity_optins(entity_id) → entity(id)
- entity_optins(entity_uuid) → entity(uuid)
- entity_post_login(entity_id) → entity(id)
- entity_post_login(entity_uuid) → entity(uuid)
- entity_client(entity_id) → entity(id)
- entity_client(entity_uuid) → entity(uuid)