Release Notes

October 2024

We have changed the primary keys of the following tables:

For the INVOICE_LINE_ITEM_TAX_RATE table, the new composite is a combination of the invoice_id, invoice_line_item_id, and tax_rate_id columns. Previously, the primary key was a combination of the invoice_id and tax_rate_id columns.
For the CREDIT_NOTE_LINE_ITEM_TAX_RATE table, the new composite is a combination of the credit_note_id, credit_note_line_item_id, and tax_rate_id columns. Previously, the primary key was a combination of the credit_note_line_item_id, and tax_rate_id columns.
For the UPCOMING_INVOICE_LINE_ITEM_TAX_RATE table, the new composite is a combination of the subscription_id, tax_rate_id, and upcoming_invoice_line_item_id columns. Previously, the primary key was a combination of the subscription_id, and tax_rate_id columns.

Stripe has deprecated the tax_info_* column. As a result, we have removed it from the CUSTOMER table and replaced it with a new CUSTOMER_TAX table. For more information, see Stripe's documentation.

July 2024

We now capture data of the archived prices in the PRICE table. Previously, we captured data only for the active prices in this table.

We have added the following new tables to support upcoming invoices:

UPCOMING_INVOICE
UPCOMING_INVOICE_ACCOUNT_TAX_ID
UPCOMING_INVOICE_CUSTOM_FIELD
UPCOMING_INVOICE_LINE_ITEM
UPCOMING_INVOICE_LINE_ITEM_PRORATION_DETAILS_CREDITED_ITEM
UPCOMING_INVOICE_LINE_ITEM_TAX_RATE
UPCOMING_INVOICE_TAX_RATE

We have added the following new tables to support Quote:

QUOTE
QUOTE_LINE_ITEM
QUOTE_COMPUTED_UPFRONT_LINE_ITEM
QUOTE_TAX_RATE

We have added a new table, TAX_AMOUNT, to store data for all Stripe tax amount and categories.

We have added a new table, CREDIT_NOTE_LINE_ITEM_TAX_RATE, to store the tax rate ID applied to the credit note line item.

We have added a new table, INVOICE_ACCOUNT_TAX_ID, to store the account tax ID related to the invoice.

We have added a new table, INVOICE_LINE_ITEM_PRORATION_DETAILS_CREDITED_ITEMS, to store details for the proration credited items.

We have added the following new columns to the CREDIT_NOTE table:

amount_shipping
effective_at
out_of_band_amount
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
subtotal_excluding_tax
total_excluding_tax

We have added two new columns, amount_excluding_tax and unit_amount_excluding_tax, to the CREDIT_NOTE_LINE_ITEM table.

We have added the following new columns to the INVOICE table:

account_country
account_name
amount_shipping
application
automatic_tax_enabled
automatic_tax_status
effective_at
from_invoice_action
from_invoice_invoice
last_finalisation_error_*
latest_revision
on_behalf_of
paid_out_of_band
payment_setting_default_mandate
payment_setting_payment_method_options.*
payment_setting_payment_method_types
rendering_amount_tax_display
rendering_pdf_page_size
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
shipping_details_address_*
shipping_details_name
shipping_details_phone
subtotal_excluding_tax
test_clock
total_excluding_tax

We have added two new columns, amount_excluding_tax and unit_amount_excluding_tax to the INVOICE_LINE_ITEM table.

We have added two new columns, test_clock and unit_amount_decimal, to the INVOICE_ITEM table.

We have removed the following columns from the INVOICE table:

billing
date
finalized_at

We now sync the data of these discontinued columns to other columns in the INVOICE table. Use the following columns:

collection_method for billing
created for date
status_transitions_finalized_at for finalized_at

June 2024

We have changed the data type of the livemode column in the TRANSFER table from STRING to BOOLEAN.

To apply this change, you need to drop the livemode column in your connector's schema. The next sync will update the datatype. If you need historical data for this column, a re-sync is required.

May 2024

We have added three new columns, cancellation_details_comment, cancellation_details_feedback, and cancellation_details_reason to the SUBSCRIPTION_HISTORY table. We will only sync new data from May 19, 2024 into these columns. We will not sync your historical data before May 19, 2024.

April 2024

We have removed the ORDER_HISTORY table and its child tables, ORDER_ITEM and SHIPPING_METHOD because Stripe removed support for this endpoint. We are gradually rolling out this change to all existing connectors.

March 2024

We have changed the sync strategy for the PLAN table. To capture new records and updates, we now re-import this table every time we perform a sync for the connector. Previously, we re-imported this table once a day.

December 2023

We now capture the price and product data in the CHECKOUT_SESSION_LINE_ITEM table and upsert it in the PRICE and PRODUCT tables respectively. Previously, we ignored the price and product data present in the CHECKOUT_SESSION_LINE_ITEM.

We have added a new table, DISCOUNT, to store data for all Stripe discounts and discount categories.

We have now deprecated the following tables that previously stored values for Stripe discounts and discount categories:

CHECKOUT_SESSION_LINE_ITEM_DISCOUNT
CUSTOMER_DISCOUNT
INVOICE_DISCOUNT
SUBSCRIPTION_DISCOUNT

November 2023

Effective November 22, 2023, we have deprecated the ORDER and SUBSCRIPTION tables.

October 2023

We have added two new columns, flat_amount_decimal and unit_amount_decimal, to the TIER table.

The Stripe connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Stripe's priority-first syncs fetch the most recent 30 days' worth of data from the supported tables.

We have rolled out this feature for all active connectors. If a connector is currently paused and if you unpause it within 2 months, the connector will start supporting priority-first sync as soon as you unpause it. However, if you unpause the connector after 2 months from now, we will consider it as a new connector and perform a historical sync on a priority-first basis. To learn more, see our priority-first sync documentation.

July 2023

Stripe's Balance Transaction API now fetches the balance transactions only for the payouts whose reconciliation_status field has changed to completed. To support this change, we have updated our sync strategy and now fetch the balance transactions when the reconciliation_status of a payout changes to completed. This change applies to both Stripe Standard and Connected accounts. You may observe sync delays for the payouts we sync using the /events endpoint.

We have added a new table, INVOICE_CUSTOM_FIELD. If you want to backfill the historical data for this table, you can re-sync the INVOICE table or contact our support team to re-sync it for you.

June 2023

We have added the following fields to the CHECKOUT_SESSION_LINE_ITEM_DISCOUNT table:

checkout_session
coupon_id
customer_id
end
invoice_id
invoice_item_id
promotion_code
start
subscription_id

We have added a new column, reconciliation_status, to the PAYOUT table.

Be sure to re-sync these tables for the latest changes or contact our support team to re-sync it for you.

April 2023

We have added a new table, INVOICE_LINE_ITEM_TAX_RATE, to store the mappings of invoices and their associated invoice line items and tax rates. You can re-sync the INVOICE table to backfill the INVOICE_LINE_ITEM_TAX_RATE table for old invoices.

March 2023

We have changed our sync strategy to handle invalid or deleted connected accounts. We now display a warning on your connector dashboard when we detect invalid or deleted Stripe connected accounts and skip these accounts from the sync. Previously, we didn't skip these accounts, causing the connector to break.

February 2023

We now update the three_d_secure column of the CARD table in the destination as 'attempted' when we receive a JSON response. For more information about three_d_secure fields, see Stripe's documentation.

You can backfill the data for the three_d_secure columns in the CARD and PAYMENT_METHOD_CARD tables. Perform a re-sync for the CARD and PAYMENT_METHOD_CARD tables. This will result in re-syncing the associated parent and child tables.

January 2023

We now sync data from the CUSTOMER endpoint to the PAYMENT_METHOD table. Previously, we synced data only from the PAYMENT_INTENT and SETUP_INTENT endpoints, to the PAYMENT_METHOD table. To sync records from the CUSTOMER endpoint, we recommend that you re-sync the CUSTOMER table.

October 2022

We have added a new column, collection_method, to the INVOICE and SUBSCRIPTION (SUBSCRIPTION_HISTORY for history mode connectors) tables. This column stores the same value as the billing column. Stripe has deprecated the billing column. We will continue to support both columns.

We have added the following new columns to the CARD table:

iin
description
issuer

NOTE: These columns are not available in standard Stripe API requests. Contact Stripe support to enable them on your account.

September 2022

We have added the following new tables:

CHECKOUT_SESSION
CHECKOUT_SESSION_PAYMENT_METHOD
CHECKOUT_SESSION_TAX_RATE
CHECKOUT_SESSION_SHIPPING_OPTION
CHECKOUT_SESSION_SHIPPING_ADDRESS_ALLOWED_COUNTRIES
CHECKOUT_SESSION_LINE_ITEM
CHECKOUT_SESSION_LINE_ITEM_TAX_RATE
SHIPPING_RATE

August 2022

We have added a new column, invoice_item_id, to the INVOICE_LINE_ITEM table.

February 2022

We have added two new tables, ORDER_HISTORY and SUBSCRIPTION_HISTORY. We automatically sync these tables for connectors created after February 1, 2022.

January 2022

We have deprecated the following tables and no longer sync new data to them:

TAX_RATE_INVOICE_MAPPING
TAX_RATE_INVOICE_ITEM_MAPPING
TAX_RATE_SUBSCRIPTION_MAPPING

In May 2021, we renamed these tables but continued syncing to the old tables as well as to the new tables for existing connectors. Now, the data from these tables syncs only to the following renamed tables:

INVOICE_TAX_RATE
INVOICE_ITEM_TAX_RATE
SUBSCRIPTION_TAX_RATE

If your connector was created before May 3, 2021, be sure to update your queries.

If your connector was created after May 3, 2021, you don't need to do anything.

December 2021

We added a new column, reporting_category, to the BALANCE_TRANSACTION table.

We have added a new table, ISSUING_TRANSACTION, that contains data from Stripe's /issuing/transactions endpoint.

November 2021

We have added a new column, invoice_item_id, to the PRICE table.

October 2021

We have added a new column, invoice_line_item, to the CREDIT_NOTE_LINE_ITEM table.

September 2021

We have added the following new fields to the CHARGE table:

billing_detail_address_city
billing_detail_address_country
billing_detail_address_line1
billing_detail_address_line2
billing_detail_address_postal_code
billing_detail_address_state
billing_detail_email
billing_detail_name
billing_detail_phone

August 2021

We have added a new table, PROMOTION_CODE. See Stripe's promotion code documentation for more details.

We have deprecated the metadata_* columns from the Stripe schema.

We now support the PAYMENT_INTENT table for Stripe Connect accounts. If you'd like to sync data from Stripe connected accounts, contact our support team.

The Stripe connector now supports table-level re-syncs.

We now support table grouping in the Schema tab of your connector details page.

The Stripe connector now supports history mode for the following tables:

ORDER
SUBSCRIPTION
SUBSCRIPTION_ITEM

We are gradually rolling out this improvement to all existing connectors.

July 2021

We have added two new columns, pause_collection_behavior and pause_collection_resumes_at, to the SUBSCRIPTION table.

We have added the following new columns to the PAYMENT_METHOD_CARD table:

three_d_secure_authentication_flow
three_d_secure_result
three_d_secure_result_reason
three_d_secure_version

We have added a new table, SETUP_ATTEMPT. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table. For more information, see Stripe's SetupAttempts documentation.

We have deprecated the three_d_secure_usage_supported column from the PAYMENT_METHOD_CARD and CARD tables.

May 2021

We now support the REFUND and DISPUTE tables for Stripe Connect accounts. If you'd like to sync data from Stripe connected accounts, contact our support team.

We have renamed the following tables:

TAX_RATE_INVOICE_MAPPING to INVOICE_TAX_RATE
TAX_RATE_INVOICE_ITEM_MAPPING to INVOICE_ITEM_TAX_RATE
TAX_RATE_SUBSCRIPTION_MAPPING to SUBSCRIPTION_TAX_RATE

We will continue to sync the TAX_RATE_*_MAPPING tables for existing connectors.

We have added a new column, price_id, to the INVOICE_LINE_ITEM table.

We have added two new columns, price_id and plan_id, to the INVOICE_ITEM table.

We have added a new column, three_d_secure_usage_supported, to the PAYMENT_METHOD_CARD and CARD tables.

April 2021

We have added a new table, TAX_RATE_INVOICE_MAPPING, which stores the tax rates applied to an invoice.

We have added a new table, APPLE_PAY_DOMAIN. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table.

We have added the following new columns to the INVOICE table:

default_payment_method_id
payment_intent_id
post_payment_credit_notes_amount
pre_payment_credit_notes_amount
subscription_id

We have added the following new columns to the SUBSCRIPTION table:

default_payment_method
latest_invoice_id
pending_setup_intent_id

We have added a new column, payment_method_types, to the PAYMENT_INTENT table.

We will deprecate the metadata_* columns from the Stripe schema after August 1, 2021. Be sure to update your queries with the metadata column. We sync metadata as JSON objects. For more information on the metadata column, see our documentation.

March 2021

We have added the following new columns to the ACCOUNT table:

capabilities_afterpay_clearpay_payments
capabilities_au_becs_debit_payments
capabilities_bacs_debit_payments
capabilities_bancontact_payments
capabilities_cartes_bancaires_payments
capabilities_eps_payments
capabilities_fpx_payments
capabilities_giropay_payments
capabilities_grabpay_payments
capabilities_ideal_payments
capabilities_jcb_payments
capabilities_oxxo_payments
capabilities_p24_payments
capabilities_sepa_debit_payments
capabilities_sofort_payments
capabilities_tax_reporting_us_1099_k
capabilities_tax_reporting_us_1099_misc

We have added the following new columns to the tables below:

payment_method_id to the CHARGE table
discount_id to the ORDER_ITEM and ORDER_REFUND_ITEM tables
payment_intent_id to the REFUND table

We have added two new columns, destination_payment_id and source_transaction_id, to the TRANSFER table.

We will deprecate the destination_payment and source_transaction columns of the TRANSFER table after June 20, 2021. Be sure to update your queries.

We have added the following new columns to the CARDHOLDER table:

spending_controls_allowed_categories
spending_controls_blocked_categories
spending_controls_spending_limits
spending_controls_spending_limits_currency

We have added a new column, amount_details_atm_fee, to the AUTHORIZATION and TRANSACTION tables.

We have added a new column, wallet_type, to the CARD table.

February 2021

We have added a new field, calculated_statement_descriptor, to the CHARGE table.

We have added the following new fields to the INVOICE table:

status_transitions_finalized_at
status_transitions_marked_uncollectible_at
status_transitions_paid_at
status_transitions_voided_at

January 2021

We have added a new field, metadata, to the SUBSCRIPTION_SCHEDULE table.

December 2020

We now create empty tables in the destination even if the source tables are empty (contain only Null values).

We have added a new table, CREDIT_NOTE_LINE_ITEM. See Stripe's documentation on the credit note line item object for more information.

We have added a new table, PRICE. See Stripe's documentation on prices for more information.

We have added the following new fields to the CREDIT_NOTE table:

customer_balance_transaction
discount_amount
subtotal
total
voided_at

We now sync the metadata as JSON objects. We have added a new column, metadata, to the following tables:

ACCOUNT
APPLICATIOIN_FEE_REFUND
AUTHORIZATION
BANK_ACCOUNT
CARD
CARDHOLDER
CHARGE
COUPON
CREDIT_NOTE
CUSTOMER
CUSTOMER_BALANCE_TRANSACTION
DISPUTE
FILE_LINK
INVOICE
INVOICE_ITEM
INVOICE_LINE_ITEM
ISSUING_CARD
ISSUING_DISPUTE
ORDER
PAYMENT_INTENT
PAYMENT_METHOD
PAYOUT
PLAN
PRODUCT
REFUND
SETUP_INTENT
SKU
SOURCE
SUBSCRIPTION
SUBSCRIPTION_ITEM
TAX_RATE
TOPUP
TRANSACTION
TRANSFER
TRANSFER_REVERSAL

November 2020

We have added the following new fields to the ACCOUNT table:

requirements_current_deadline
requirements_currently_due
requirements_disabled_reason
requirements_errors
requirements_eventually_due
requirements_past_due
requirements_pending_verification

We now sync the BANK_ACCOUNT and CARD tables' records using the external_accounts field of the ACCOUNT table. See Stripe's documentation on external accounts for more information.

We have added a new table, CUSTOMER_DISCOUNT, which stores information about customer discounts. See Stripe's documentation on discounts for more information.

We have removed the _fivetran_id field from the INVOICE_DISCOUNT and SUBSCRIPTION_DISCOUNT tables.

September 2020

We have added the following new columns to the tables below:

is_deleted and capabilities_platform_payments to the ACCOUNT table
verification_data_expiry_check to the AUTHORIZATION table
livemode to the ORDER_RETURN table
id to the SUBSCRIPTION_DISCOUNT table

We now support metadata_* columns in the AUTHORIZATION table.

August 2020

We have released pre-built, dbt Core-compatible data models for Stripe. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have added three new tables:

TAX_RATE stores the tax rates that can be applied to either a subscription or an invoice item.
TAX_RATE_SUBSCRIPTION_MAPPING stores the tax rates applied to a subscription.
TAX_RATE_INVOICE_ITEM_MAPPING stores the tax rates applied to an invoice item.

We have renamed the following fields in the AUTHORIZATION table:

authorized_amount to amount
authorized_currency to currency

We have moved the following fields from the TRANSACTION table to the AUTHORIZATION table:

merchant_data_network_id
merchant_data_postal_code
merchant_data_state
merchant_data_category
merchant_data_city
merchant_data_name
merchant_data_country

We have added the following columns to the ISSUING_CARD table:

cancellation_reason
number
replaced_by
replacement_for
replacement_reason
shipping_eta
shipping_service
shipping_status
shipping_tracking_url
shipping_type

We have removed the following columns from the ISSUING_CARD table:

authorization_controls_currency
authorization_controls_max_amount
authorization_controls_max_approvals
shipping_phone

We have removed the is_deleted column from the PAYMENT_METHOD table.

We have removed the client_secret column from the SETUP_INTENT table.

July 2020

We now capture deletes for the INVOICE, INVOICE_ITEM, and PERSON tables. Deletes from these tables are captured in the is_deleted column.

You can now select the PAYMENT_METHOD and CUSTOMER_BALANCE_TRANSACTION tables to sync from the Schema tab on your connector details page.

We have added a new column, is_deleted, to the PERSON table.

We have added a new table, SETUP_INTENT. Read Stripe's documentation for more information.

June 2020

We can now enable support for your Stripe Connected Accounts on your connector. Contact our Support team to enable this feature on your connector.

We have added a new table, USAGE_RECORD. This table stores the usage records of a subscription.

May 2020

We have added the following columns to the CUSTOMER table:

address_*
balance
name
phone

April 2020

You can now select the tables you want to sync from the Schema tab on your connector details page.

March 2020

We have added a new field, tax_exempt, to the CUSTOMER table.

We have added a new table, PAYMENT_METHOD, which stores customer payment method details. We have also added the following child tables to support the various payment types:

AU_BECS_DEBIT stores details about the AU_BECS_DEBIT payment method.
FPX stores details about the FPX payment method.
IDEAL stores details about the IDEAL payment method.
PAYMENT_METHOD_CARD stores details about the CARD payment method.
SEPA_DEBIT stores details about the SEPA_DEBIT payment method.

We have updated the ACCOUNT table to support the latest Stripe API version. We have deprecated the following fields from the ACCOUNT table:

business_name
business_url
debit_negative_balances
decline_charge_on_avs_failure
decline_charge_on_cvc_failure
display_name
legal_entity
payout_schedule_delay_days
payout_schedule_interval
payout_schedule_monthly_anchor
payout_schedule_weekly_anchor
payout_statement_descriptor
product_description
statement_descriptor
support_address
support_email
support_phone
timezone
verification

See the Stripe ERD to learn more about the fields we support in the ACCOUNT table.

February 2020

You can now configure your Stripe connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.

We have added a new field, start_date, to the SUBSCRIPTION table. This field stores the actual subscription start date, while the start field in the same table stores the last modified date of the subscription.

We have added a new table, SUBSCRIPTION_SCHEDULE, which stores the historical change data of a subscription.

We have added a new table, PHASE, which stores the details about phases in the subscription schedule life cycle.

We have added a new table, PHASE_PLAN, which stores the subscription plan details during a specific phase.

We have added the following fields to the BALANCE_TRANSACTION table:

payout_id. This field stores the automatic payout ID in which the balance transaction was paid out.
exchange_rate. This field stores the exchange rate used for a transaction.

January 2020

We have added a new column, unique_id, to the INVOICE_LINE_ITEM table. This fix resolves the pagination break issue for invoice line items, which was introduced by the Stripe API update.

December 2019

We have added a new table, EARLY_FRAUD_WARNING, which contains the following fields:

id
charge_id
actionable
created
fraud_type
livemode

November 2019

We have added a new column, network, to the CARD table.

October 2019

For version 2 of the Stripe connector, we have added a new column, invoice_id, to the CHARGE table to support mapping between the CHARGE and INVOICE tables.

September 2019

We have added a new column, customer_id, to the INVOICE_ITEM table.

August 2019

We have made the subscription_id column a primary key.

The SUBSCRIPTION_ITEM table now holds only existing subscription items. We will delete subscription items which are not related to any subscription. For example, when a subscription item is removed from a subscription, it does not belong to any subscription, so we delete that subscription item from the table.

July 2019

We have deprecated the OAuth 2.0 authentication mechanism for creating a new connector. Going forward, you need to use the restricted API key to create a new connector. We will continue to run existing connectors set up using the OAuth 2.0 mechanism. We encourage you to move to the new authentication for greater security.

April 2019

We have added a new table, CREDIT_NOTE with the following columns:

id
amount
created
currency
customer
invoice_id
livemode
memo
number
pdf
reason
refund_id
status
type

March 2019

We have released a new version of the Stripe connector, version 1. The new version contains changed, added, and deprecated tables. In the existing tables, we have added new fields and removed the deprecated ones. See the schema for details.

Added Tables
- ATTRIBUTE
- AUTHORIZATION
- CARDHOLDER
- DISPUTE_BALANCE_TRANSACTION
- FILE
- INVOICE_DISCOUNT
- ISSUING_CARD
- ISSUING_DISPUTE
- PAYMENT_INTENT
- PAYOUT
- PRODUCT
- SHIPPING_METHOD
- SUBSCRIPTION_DISCOUNT
- SUBSCRIPTION_ITEM
- TIER
- TRANSACTION
- TRANSFER_REVERSAL
Renamed Tables
- _ACCOUNT to ACCOUNT
- _APPLICATION_FEES to APPLICATION_FEE
- _APPLICATION_FEE_REFUNDS to APPLICATION_FEE_REFUND
- _BALANCE_TRANSACTIONS to BALANCE_TRANSACTION
- _BANK_ACCOUNTS to BANK_ACCOUNT
- _CARDS to CARD
- _CHARGES to CHARGE
- _COUPONS to COUPON
- _CUSTOMERS to CUSTOMER
- _DISPUTES to DISPUTE
- _FEES to FEE
- _INVOICES to INVOICE
- _INVOICE_ITEMS to INVOICE_ITEM
- _ORDER to ORDER
- _ORDER_ITEM to ORDER_ITEM
- _ORDER_RETURNED to ORDER_RETURN
- _ORDER_RETURNED_ITEM to ORDER_RETURNED_ITEM
- _PLANS to PLAN
- _REFUNDS to REFUND
- _REVIEWS to REVIEW
- _SKU to SKU
- _SOURCE to SOURCE
- _SUBSCRIPTIONS to SUBSCRIPTION
- _TOPUP to TOPUP
- _TRANSFERS to TRANSFER
Deprecated Tables
- _RECIPIENTS
- _SUBSCRIPTION_PLAN

The sunset date for version 0 is June 15, 2019. Connect to the new Stripe v1 connector.

January 2019

We have added a new column, outcome_risk_score, to the CHARGES table.

December 2018

The Stripe connector now supports top-up objects. This data appears in the TOPUP table.

May 2018

We have added a new table, FILE_UPLOAD.

We have added the following new columns to the tables below:

TABLE NAME	NEW COLUMN NAME
`CHARGE`	status
`INVOICES`	amount_paid
`PLANS`	nickname