# Appfigures schema ERD

Table and field reference for the Fivetran Appfigures connector.

## Table & Field Reference

### rating

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| iso | String | PK, FK |
| product_id | Unknown | PK, FK |
| average | String |  |
| breakdown | Json |  |
| five_star_percent | String |  |
| four_star_percent | String |  |
| negative | Unknown |  |
| neutral | Unknown |  |
| new_average | String |  |
| new_negative | Unknown |  |
| new_neutral | Unknown |  |
| new_positive | Unknown |  |
| new_ratings | Json |  |
| new_total | Unknown |  |
| one_star_percent | String |  |
| positive | Unknown |  |
| three_star_percent | String |  |
| total | Unknown |  |
| two_star_percent | String |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| iso | String | PK |
| apple_store_no | String |  |
| name | String |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| iso | String | PK |
| storefront | String | PK |
| product_id | Unknown | PK, FK |
| activations | Unknown |  |
| active_discounted_subscriptions | Unknown |  |
| active_free_trials | Unknown |  |
| active_grace | Unknown |  |
| active_subscriptions | Unknown |  |
| active_trials | Unknown |  |
| actual_revenue | Unknown |  |
| all_active_subscriptions | Unknown |  |
| all_subscribers | Unknown |  |
| cancellations | Unknown |  |
| cancelled_subscriptions | Unknown |  |
| churn | Unknown |  |
| first_year_subscribers | Unknown |  |
| grace_drop_off | Unknown |  |
| grace_recovery | Unknown |  |
| gross_monthly_recurring_revenu | Unknown |  |
| gross_revenue | Unknown |  |
| monthly_recurring_revenu | Unknown |  |
| new_grace | Unknown |  |
| new_subscriptions | Unknown |  |
| new_trial_grace | Unknown |  |
| new_trials | Unknown |  |
| non_first_year_subscribers | Unknown |  |
| paying_subscriptions | Unknown |  |
| reactivations | Unknown |  |
| renewals | Unknown |  |
| transitions_in | Unknown |  |
| transitions_out | Unknown |  |
| trial_cancellations | Unknown |  |
| trial_conversion_rate | Unknown |  |
| trial_conversions | Unknown |  |
| trial_grace_drop_off | Unknown |  |
| trial_grace_recovery | Unknown |  |

### ad_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| iso | String | FK |
| product_id | Unknown | FK |
| clicks | Unknown |  |
| ctr | Unknown |  |
| date | LocalDate |  |
| ecpm | Unknown |  |
| fillrate | Unknown |  |
| impressions | Unknown |  |
| network | Unknown |  |
| requests | Unknown |  |
| requests_filled | Unknown |  |
| revenue | Unknown |  |
| storefront | Unknown |  |

### revenue

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| iso | Unknown | PK |
| storefront | Unknown | PK |
| product_id | Unknown | PK, FK |
| ads | Unknown |  |
| business | Unknown |  |
| edu | Unknown |  |
| gross_business | Unknown |  |
| gross_edu | Unknown |  |
| gross_iap | Unknown |  |
| gross_returns | Unknown |  |
| gross_sales | Unknown |  |
| gross_subscriptions | Unknown |  |
| gross_total | Unknown |  |
| iap | Unknown |  |
| returns | Unknown |  |
| sales | Unknown |  |
| store | Unknown |  |
| subscriptions | Unknown |  |
| total | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| iso | String | FK |
| product_id | Unknown | FK |
| author | String |  |
| date | LocalDateTime |  |
| has_response | Boolean |  |
| id | String |  |
| original_review | String |  |
| original_title | String |  |
| predicted_langs | Json |  |
| review | String |  |
| stars | Unknown |  |
| title | String |  |
| version | Unknown |  |
| weight | Unknown |  |

### estimate

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| storefront | Unknown | PK |
| iso | String | PK, FK |
| product_id | Unknown | PK, FK |
| download | String |  |
| revenue | String |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| currency | String | PK |
| symbol | String |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| storefront | Unknown | PK |
| iso | String | PK, FK |
| product_id | Unknown | PK, FK |
| converted_revenue | Unknown |  |
| estimated_revenue | Unknown |  |
| financial_revenue | Unknown |  |
| revenue | Unknown |  |
| type | String |  |

### event_product

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| caption | String |  |
| date | LocalDateTime |  |
| details | String |  |
| origin | String |  |

### installed_sdk

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_id | Unknown | FK |
| active | Boolean |  |
| found_on | LocalDateTime |  |
| last_updated | LocalDateTime |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency | String | FK |
| parent_id | Unknown | FK |
| source_external_account_id | Unknown | FK |
| store_id | Unknown | FK |
| accessible_features | Json |  |
| added_date | LocalDateTime |  |
| children | Json |  |
| developer | String |  |
| devices | Json |  |
| features | Json |  |
| icon | String |  |
| name | String |  |
| price | Unknown |  |
| ref_no | Unknown |  |
| release_date | LocalDateTime |  |
| sku | String |  |
| source_active | Boolean |  |
| source_added_timestamp | LocalDateTime |  |
| source_hidden | Boolean |  |
| source_type | String |  |
| type | String |  |
| updated_date | LocalDateTime |  |
| vendor_identifier | Unknown |  |
| version | Unknown |  |

### languages

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| iso | String | FK |
| name | String |  |

### archive

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_account_id | Unknown | FK |
| import_method | String |  |
| import_timestamp | LocalDateTime |  |
| region | String |  |
| report_timestamp | LocalDateTime |  |
| type | String |  |

### store_supported_feature

| Column | Type | Keys |
| --- | --- | --- |
| supported_feature | String | PK |
| store_id | String | PK, FK |

### store_front

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| store_id | String | PK, FK |
| name | String |  |
| short_name | String |  |
| type | String |  |

### store_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Int | PK, FK |
| store_id | String | PK, FK |

### store_country

| Column | Type | Keys |
| --- | --- | --- |
| iso | String | PK, FK |
| store_id | String | PK, FK |

### store

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | Unknown |  |
| name | String |  |
| short_name | String |  |
| type | String |  |

### user_entitlement

| Column | Type | Keys |
| --- | --- | --- |
| entitlement | String | PK |
| account_id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |

### user_product

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK, FK |
| product_id | String | PK, FK |
| users_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK |
| id | Unknown | PK |
| account_auto_import | Boolean |  |
| account_company | String |  |
| account_is_premium | Boolean |  |
| account_last_import | LocalDateTime |  |
| account_name | String |  |
| account_plan | String |  |
| account_plan_id | Unknown |  |
| active | Boolean |  |
| avatar_url | String |  |
| currency | String |  |
| date_format | String |  |
| email | String |  |
| is_owner | Boolean |  |
| last_login | LocalDateTime |  |
| name | String |  |
| region | String |  |
| role | String |  |
| share_of_profit | Unknown |  |
| timezone | String |  |

### sale

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| device | Unknown | PK |
| storefront | Unknown | PK |
| iso | String | PK, FK |
| product_id | Unknown | PK, FK |
| app_downloads | Unknown |  |
| app_returns | Unknown |  |
| app_returns_amount | Unknown |  |
| app_revenue | Unknown |  |
| business_downloads | Unknown |  |
| business_revenue | Unknown |  |
| downloads | Unknown |  |
| edu_downloads | Unknown |  |
| edu_revenue | Unknown |  |
| gift_redemptions | Unknown |  |
| gifts | Unknown |  |
| gross_app_returns_amount | Unknown |  |
| gross_app_revenue | Unknown |  |
| gross_business_revenue | Unknown |  |
| gross_edu_revenue | Unknown |  |
| gross_iap_returns_amount | Unknown |  |
| gross_iap_revenue | Unknown |  |
| gross_returns_amount | Unknown |  |
| gross_revenue | Unknown |  |
| gross_standard_revenue | Unknown |  |
| gross_subscription_returns_amount | Unknown |  |
| gross_subscription_revenue | Unknown |  |
| iap_amount | Unknown |  |
| iap_returns | Unknown |  |
| iap_returns_amount | Unknown |  |
| iap_revenue | Unknown |  |
| net_downloads | Unknown |  |
| promos | Unknown |  |
| re_downloads | Unknown |  |
| returns | Unknown |  |
| returns_amount | Unknown |  |
| revenue | Unknown |  |
| standard_downloads | Unknown |  |
| standard_revenue | Unknown |  |
| store | Unknown |  |
| subscription_purchases | Unknown |  |
| subscription_returns | Unknown |  |
| subscription_returns_amount | Unknown |  |
| subscription_revenue | Unknown |  |
| uninstalls | Unknown |  |
| updates | Unknown |  |

### external_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| store_id | Unknown | FK |
| auto_import | Boolean |  |
| nickname | String |  |
| username | String |  |
| vendor_id | Unknown |  |

### advertisement_spend

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| iso | String | FK |
| product_id | Unknown | FK |
| clicks | Unknown |  |
| cost | Unknown |  |
| cpa | Unknown |  |
| cpc | Unknown |  |
| ctr | Unknown |  |
| date | LocalDate |  |
| impressions | Unknown |  |
| installs | Unknown |  |
| network | Unknown |  |
| storefront | Unknown |  |

### sdk_external_link

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| sdk_id | String | FK |
| type | String |  |
| value | String |  |

### sdk_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| sdk_id | String | PK, FK |

### sdk_platform

| Column | Type | Keys |
| --- | --- | --- |
| platform | String | PK |
| sdk_id | String | PK, FK |

### sdk_tracked_platform

| Column | Type | Keys |
| --- | --- | --- |
| tracked_platform | String | PK |
| sdk_id | String | PK, FK |

### sdk

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| active | Boolean |  |
| code | Unknown |  |
| description | String |  |
| developer_links | Json |  |
| developer_name | String |  |
| name | String |  |
| notes | String |  |
| release_date | LocalDateTime |  |
| started_tracking | LocalDateTime |  |

### sub_category

| Column | Type | Keys |
| --- | --- | --- |
| sub_category | String | PK |
| category_id | Unknown | PK, FK |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| store_id | String | FK |
| active | Boolean |  |
| device | String |  |
| hidden | Boolean |  |
| name | String |  |
| store_front | String |  |

## Relationships

- rating(iso) → country(iso)
- rating(product_id) → product(id)
- subscription(product_id) → product(id)
- ad_report(iso) → country(iso)
- ad_report(product_id) → product(id)
- revenue(product_id) → product(id)
- review(iso) → country(iso)
- review(product_id) → product(id)
- estimate(product_id) → product(id)
- estimate(iso) → country(iso)
- payment(iso) → country(iso)
- payment(product_id) → product(id)
- event_product(product_id) → product(id)
- event_product(event_id) → event(id)
- installed_sdk(product_id) → product(id)
- product(currency) → currency(currency)
- product(store_id) → store(id)
- product(parent_id) → product(id)
- product(source_external_account_id) → external_account(account_id)
- languages(iso) → country(iso)
- archive(external_account_id) → external_account(account_id)
- store_supported_feature(store_id) → store(id)
- store_front(store_id) → store(id)
- store_category(category_id) → category(id)
- store_category(store_id) → store(id)
- store_country(iso) → country(iso)
- store_country(store_id) → store(id)
- user_entitlement(users_id) → users(id)
- user_entitlement(account_id) → users(account_id)
- user_product(product_id) → product(id)
- user_product(users_id) → users(id)
- user_product(account_id) → users(account_id)
- sale(iso) → country(iso)
- sale(product_id) → product(id)
- external_account(account_id) → users(account_id)
- external_account(store_id) → store(id)
- advertisement_spend(iso) → country(iso)
- advertisement_spend(product_id) → product(id)
- sdk_external_link(sdk_id) → sdk(id)
- sdk_tag(sdk_id) → sdk(id)
- sdk_platform(sdk_id) → sdk(id)
- sdk_tracked_platform(sdk_id) → sdk(id)
- sub_category(category_id) → category(id)
- category(store_id) → store(id)
- category(parent_id) → category(id)