# ProsperStack schema ERD

Table and field reference for the Fivetran ProsperStack connector.

## Table & Field Reference

### property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity | Unknown |  |
| format | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount_off | Unknown |  |
| apply_to | Unknown |  |
| coupon_type | Unknown |  |
| created_at | Unknown |  |
| days | Unknown |  |
| duration | Unknown |  |
| interval | Unknown |  |
| interval_count | Unknown |  |
| metadata | Json |  |
| mode | Unknown |  |
| months | Unknown |  |
| name | Unknown |  |
| pause_at | Unknown |  |
| pause_subscription_metadata | Json |  |
| payment_provider_coupon_id | Unknown |  |
| platform_coupon_id | Unknown |  |
| platform_plan_id | Unknown |  |
| prorate | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### subscription_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| formatted_value | Unknown |  |
| value | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscriber_id | Unknown | FK |
| created_at | Unknown |  |
| mrr | Unknown |  |
| payment_provider_id | Unknown |  |
| platform_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### flow_session_offer_presented

| Column | Type | Keys |
| --- | --- | --- |
| flow_session_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### flow_session_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| flow_session_id | Unknown | PK, FK |
| question_id | Unknown |  |
| question_primary | Unknown |  |
| question_text | Unknown |  |
| question_type | Unknown |  |
| sentiment | Unknown |  |
| value | Json |  |

### flow_session_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| flow_session_id | Unknown | PK, FK |
| completed_at | Unknown |  |
| started_at | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### flow_session_deflected_by_deflection_action

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| flow_session_id | Unknown | PK, FK |
| code | Unknown |  |
| detail_url | Unknown |  |
| type | Unknown |  |

### flow_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| flow_id | Unknown | FK |
| offer_accepted_id | Unknown | FK |
| subscriber_id | Unknown | FK |
| subscription_id | Unknown | FK |
| cancel_reason_code | Unknown |  |
| cancel_reason_text | Unknown |  |
| client_url | Unknown |  |
| client_user_agent | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| deflected_by_action_code | Unknown |  |
| deflected_by_action_detail_url | Unknown |  |
| deflected_by_action_id | Unknown |  |
| deflected_by_action_type | Unknown |  |
| deflected_by_type | Unknown |  |
| offer_groups_presented | Json |  |
| rerouted_from_flow_session_id | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_id | Unknown | FK |
| created_at | Unknown |  |
| event | Unknown |  |

### flow

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

### subscriber_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| subscriber_id | Unknown | PK, FK |
| formatted_value | Unknown |  |
| value | Unknown |  |

### subscriber

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| payment_provider_id | Unknown |  |
| platform_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- subscription_property(id) → property(id)
- subscription_property(subscription_id) → subscription(id)
- subscription(subscriber_id) → subscriber(id)
- flow_session_offer_presented(id) → offer(id)
- flow_session_offer_presented(flow_session_id) → flow_session(id)
- flow_session_answer(flow_session_id) → flow_session(id)
- flow_session_step(flow_session_id) → flow_session(id)
- flow_session_deflected_by_deflection_action(flow_session_id) → flow_session(id)
- flow_session(subscription_id) → subscription(id)
- flow_session(offer_accepted_id) → offer(id)
- flow_session(subscriber_id) → subscriber(id)
- flow_session(flow_id) → flow(id)
- event(data_id) → flow_session(id)
- subscriber_property(id) → property(id)
- subscriber_property(subscriber_id) → subscriber(id)