ProsperStack
Explore the interactive ERD
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 | PKFK |
subscription_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
flow_session_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
flow_session_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
subscriber_id | Unknown | PKFK |
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 |