# RevenueCat schema ERD

Table and field reference for the Fivetran RevenueCat connector.

## Table & Field Reference

### app

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| amazon_package_name | Unknown |  |
| app_store_bundle_id | Unknown |  |
| created_at | Unknown |  |
| mac_app_store_store_bundle_id | Unknown |  |
| name | Unknown |  |
| play_store_store_bundle_id | Unknown |  |
| type | Unknown |  |

### package_product

| Column | Type | Keys |
| --- | --- | --- |
| offering_id | Unknown | PK, FK |
| package_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| eligibility_criteria | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| offering_id | Unknown | PK, FK |
| project_id | Unknown | FK |
| created_at | Unknown |  |
| display_name | Unknown |  |
| lookup_key | Unknown |  |
| object | Unknown |  |
| position | Unknown |  |

### offering

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| created_at | Unknown |  |
| display_name | Unknown |  |
| is_current | Unknown |  |
| lookup_key | Unknown |  |
| custom_** |  |  |

### project

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

### entitlement_product

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

### entitlement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| created_at | Unknown |  |
| display_name | Unknown |  |
| lookup_key | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_id | Unknown | FK |
| project_id | Unknown | FK |
| created_at | Unknown |  |
| display_name | Unknown |  |
| store_identifier | Unknown |  |
| subscription_duration | Unknown |  |
| subscription_grace_period_duration | Unknown |  |
| subscription_trial_duration | Unknown |  |
| type | Unknown |  |

### metric_overview

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| description | Unknown |  |
| last_updated_at | Unknown |  |
| last_updated_at_iso_8601 | Unknown |  |
| name | Unknown |  |
| period | Unknown |  |
| unit | Unknown |  |
| value | Unknown |  |

## Relationships

- app(project_id) → project(id)
- package_product(product_id) → product(id)
- package_product(package_id) → package(id)
- package_product(offering_id) → package(offering_id)
- package(offering_id) → offering(id)
- package(project_id) → project(id)
- offering(project_id) → project(id)
- entitlement_product(product_id) → product(id)
- entitlement_product(entitlement_id) → entitlement(id)
- entitlement(project_id) → project(id)
- product(app_id) → app(id)
- product(project_id) → project(id)
- metric_overview(project_id) → project(id)