# Real-time sync schema View the Postgres tables and columns available for real-time syncing. The real-time sync schema maps Stripe API resources to Postgres tables. Expand a category, then expand a table to view its columns and Postgres data types. The `_account_id`, `_updated_at`, and `_raw_data` columns contain sync metadata. The `_raw_data` column contains the complete JSON representation of the Stripe API resource. Real-time sync schema (API version: 2026-03-25.dahlia): Payments: charges (API docs: /api/charges/object) id: text _account_id: text amount: bigint amount_captured: bigint amount_refunded: bigint application: text application_fee: text application_fee_amount: bigint authorization_code: text balance_transaction: text billing_details: jsonb calculated_statement_descriptor: text captured: boolean created: bigint currency: text customer: text description: text disputed: boolean failure_balance_transaction: text failure_code: text failure_message: text fraud_details: jsonb level3: jsonb livemode: boolean metadata: jsonb object: text on_behalf_of: text outcome: jsonb paid: boolean payment_intent: text payment_method: text payment_method_details: jsonb presentment_details: jsonb radar_options: jsonb receipt_email: text receipt_number: text receipt_url: text refunded: boolean refunds: jsonb review: text shipping: jsonb source: jsonb source_transfer: text statement_descriptor: text statement_descriptor_suffix: text status: text transfer: text transfer_data: jsonb transfer_group: text _updated_at: timestamptz _raw_data: jsonb checkout_sessions (API docs: /api/checkout/sessions/object) id: text _account_id: text adaptive_pricing: jsonb after_expiration: jsonb allow_promotion_codes: boolean amount_subtotal: bigint amount_total: bigint automatic_tax: jsonb billing_address_collection: text branding_settings: jsonb cancel_url: text client_reference_id: text client_secret: text collected_information: jsonb consent: jsonb consent_collection: jsonb created: bigint currency: text currency_conversion: jsonb custom_fields: jsonb custom_text: jsonb customer: text customer_account: text customer_creation: text customer_details: jsonb customer_email: text discounts: jsonb excluded_payment_method_types: jsonb expires_at: bigint integration_identifier: text invoice: text invoice_creation: jsonb line_items: jsonb livemode: boolean locale: text metadata: jsonb mode: text name_collection: jsonb object: text optional_items: jsonb origin_context: text payment_intent: text payment_link: text payment_method_collection: text payment_method_configuration_details: jsonb payment_method_options: jsonb payment_method_types: jsonb payment_status: text permissions: jsonb phone_number_collection: jsonb presentment_details: jsonb recovered_from: text redirect_on_completion: text return_url: text saved_payment_method_options: jsonb setup_intent: text shipping_address_collection: jsonb shipping_cost: jsonb shipping_options: jsonb status: text submit_type: text subscription: text success_url: text tax_id_collection: jsonb total_details: jsonb ui_mode: text url: text wallet_options: jsonb _updated_at: timestamptz _raw_data: jsonb payment_intents (API docs: /api/payment_intents/object) id: text _account_id: text amount: bigint amount_capturable: bigint amount_details: jsonb amount_received: bigint application: text application_fee_amount: bigint automatic_payment_methods: jsonb canceled_at: bigint cancellation_reason: text capture_method: text client_secret: text confirmation_method: text created: bigint currency: text customer: text customer_account: text description: text excluded_payment_method_types: jsonb hooks: jsonb last_payment_error: jsonb latest_charge: text livemode: boolean metadata: jsonb next_action: jsonb object: text on_behalf_of: text payment_details: jsonb payment_method: text payment_method_configuration_details: jsonb payment_method_options: jsonb payment_method_types: jsonb presentment_details: jsonb processing: jsonb receipt_email: text review: text setup_future_usage: text shipping: jsonb source: text statement_descriptor: text statement_descriptor_suffix: text status: text transfer_data: jsonb transfer_group: text _updated_at: timestamptz _raw_data: jsonb payment_links (API docs: /api/payment-link/object) id: text _account_id: text active: boolean after_completion: jsonb allow_promotion_codes: boolean application: text application_fee_amount: bigint application_fee_percent: numeric automatic_tax: jsonb billing_address_collection: text consent_collection: jsonb currency: text custom_fields: jsonb custom_text: jsonb customer_creation: text inactive_message: text invoice_creation: jsonb line_items: jsonb livemode: boolean metadata: jsonb name_collection: jsonb object: text on_behalf_of: text optional_items: jsonb payment_intent_data: jsonb payment_method_collection: text payment_method_types: jsonb phone_number_collection: jsonb restrictions: jsonb shipping_address_collection: jsonb shipping_options: jsonb submit_type: text subscription_data: jsonb tax_id_collection: jsonb transfer_data: jsonb url: text _updated_at: timestamptz _raw_data: jsonb payment_methods (API docs: /api/payment_methods/object) id: text _account_id: text acss_debit: jsonb affirm: jsonb afterpay_clearpay: jsonb alipay: jsonb allow_redisplay: text alma: jsonb amazon_pay: jsonb au_becs_debit: jsonb bacs_debit: jsonb bancontact: jsonb billie: jsonb billing_details: jsonb blik: jsonb boleto: jsonb card: jsonb card_present: jsonb cashapp: jsonb created: bigint crypto: jsonb custom: jsonb customer: text customer_account: text customer_balance: jsonb eps: jsonb fpx: jsonb giropay: jsonb grabpay: jsonb ideal: jsonb interac_present: jsonb kakao_pay: jsonb klarna: jsonb konbini: jsonb kr_card: jsonb link: jsonb livemode: boolean mb_way: jsonb metadata: jsonb mobilepay: jsonb multibanco: jsonb naver_pay: jsonb nz_bank_account: jsonb object: text oxxo: jsonb p24: jsonb pay_by_bank: jsonb payco: jsonb paynow: jsonb paypal: jsonb payto: jsonb pix: jsonb promptpay: jsonb radar_options: jsonb revolut_pay: jsonb samsung_pay: jsonb satispay: jsonb sepa_debit: jsonb sofort: jsonb swish: jsonb twint: jsonb type: text upi: jsonb us_bank_account: jsonb wechat_pay: jsonb zip: jsonb _updated_at: timestamptz _raw_data: jsonb refunds (API docs: /api/refunds/object) id: text _account_id: text amount: bigint balance_transaction: text charge: text created: bigint currency: text description: text destination_details: jsonb failure_balance_transaction: text failure_reason: text instructions_email: text metadata: jsonb next_action: jsonb object: text payment_intent: text pending_reason: text presentment_details: jsonb reason: text receipt_number: text source_transfer_reversal: text status: text transfer_reversal: text _updated_at: timestamptz _raw_data: jsonb setup_intents (API docs: /api/setup_intents/object) id: text _account_id: text application: text attach_to_self: boolean automatic_payment_methods: jsonb cancellation_reason: text client_secret: text created: bigint customer: text customer_account: text description: text excluded_payment_method_types: jsonb flow_directions: jsonb last_setup_error: jsonb latest_attempt: text livemode: boolean mandate: text metadata: jsonb next_action: jsonb object: text on_behalf_of: text payment_method: text payment_method_configuration_details: jsonb payment_method_options: jsonb payment_method_types: jsonb single_use_mandate: text status: text usage: text _updated_at: timestamptz _raw_data: jsonb Billing: billing_alerts (API docs: /api/billing/alert/object) id: text _account_id: text alert_type: text livemode: boolean object: text status: text title: text usage_threshold: jsonb _updated_at: timestamptz _raw_data: jsonb billing_credit_grants (API docs: /api/billing/credit-grant/object) id: text _account_id: text amount: jsonb applicability_config: jsonb category: text created: bigint customer: text customer_account: text effective_at: bigint expires_at: bigint livemode: boolean metadata: jsonb name: text object: text priority: bigint test_clock: text updated: bigint voided_at: bigint _updated_at: timestamptz _raw_data: jsonb billing_meters (API docs: /api/billing/meter/object) id: text _account_id: text created: bigint customer_mapping: jsonb default_aggregation: jsonb display_name: text event_name: text event_time_window: text livemode: boolean object: text status: text status_transitions: jsonb updated: bigint value_settings: jsonb _updated_at: timestamptz _raw_data: jsonb billing_portal_configurations (API docs: /api/customer_portal/configurations/object) id: text _account_id: text active: boolean application: text business_profile: jsonb created: bigint default_return_url: text features: jsonb is_default: boolean livemode: boolean login_page: jsonb metadata: jsonb name: text object: text updated: bigint _updated_at: timestamptz _raw_data: jsonb coupons (API docs: /api/coupons/object) id: text _account_id: text amount_off: bigint applies_to: jsonb created: bigint currency: text currency_options: jsonb duration: text duration_in_months: bigint livemode: boolean max_redemptions: bigint metadata: jsonb name: text object: text percent_off: numeric redeem_by: bigint times_redeemed: bigint valid: boolean _updated_at: timestamptz _raw_data: jsonb credit_notes (API docs: /api/credit_notes/object) id: text _account_id: text amount: bigint amount_shipping: bigint created: bigint currency: text customer: text customer_account: text customer_balance_transaction: text discount_amount: bigint discount_amounts: jsonb effective_at: bigint invoice: text lines: jsonb livemode: boolean memo: text metadata: jsonb number: text object: text out_of_band_amount: bigint pdf: text post_payment_amount: bigint pre_payment_amount: bigint pretax_credit_amounts: jsonb reason: text refunds: jsonb shipping_cost: jsonb status: text subtotal: bigint subtotal_excluding_tax: bigint total: bigint total_excluding_tax: bigint total_taxes: jsonb type: text voided_at: bigint _updated_at: timestamptz _raw_data: jsonb invoice_payments (API docs: /api/invoice-payment/object) id: text _account_id: text amount_paid: bigint amount_requested: bigint created: bigint currency: text invoice: text is_default: boolean livemode: boolean object: text payment: jsonb status: text status_transitions: jsonb _updated_at: timestamptz _raw_data: jsonb invoiceitems (API docs: /api/invoiceitems/object) id: text _account_id: text amount: bigint currency: text customer: text customer_account: text date: bigint description: text discountable: boolean discounts: jsonb invoice: text livemode: boolean metadata: jsonb net_amount: bigint object: text parent: jsonb period: jsonb pricing: jsonb proration: boolean proration_details: jsonb quantity: bigint quantity_decimal: text tax_rates: jsonb test_clock: text _updated_at: timestamptz _raw_data: jsonb invoices (API docs: /api/invoices/object) id: text _account_id: text account_country: text account_name: text account_tax_ids: jsonb amount_due: bigint amount_overpaid: bigint amount_paid: bigint amount_remaining: bigint amount_shipping: bigint application: text attempt_count: bigint attempted: boolean auto_advance: boolean automatic_tax: jsonb automatically_finalizes_at: bigint billing_reason: text collection_method: text confirmation_secret: jsonb created: bigint currency: text custom_fields: jsonb customer: text customer_account: text customer_address: jsonb customer_email: text customer_name: text customer_phone: text customer_shipping: jsonb customer_tax_exempt: text customer_tax_ids: jsonb default_payment_method: text default_source: text default_tax_rates: jsonb description: text discounts: jsonb due_date: bigint effective_at: bigint ending_balance: bigint footer: text from_invoice: jsonb hosted_invoice_url: text invoice_pdf: text issuer: jsonb last_finalization_error: jsonb latest_revision: text lines: jsonb livemode: boolean metadata: jsonb next_payment_attempt: bigint number: text object: text on_behalf_of: text parent: jsonb payment_settings: jsonb payments: jsonb period_end: bigint period_start: bigint post_payment_credit_notes_amount: bigint pre_payment_credit_notes_amount: bigint receipt_number: text rendering: jsonb shipping_cost: jsonb shipping_details: jsonb starting_balance: bigint statement_descriptor: text status: text status_transitions: jsonb subscription: text subtotal: bigint subtotal_excluding_tax: bigint test_clock: text threshold_reason: jsonb total: bigint total_discount_amounts: jsonb total_excluding_tax: bigint total_pretax_credit_amounts: jsonb total_taxes: jsonb webhooks_delivered_at: bigint _updated_at: timestamptz _raw_data: jsonb plans (API docs: /api/plans/object) id: text _account_id: text active: boolean amount: bigint amount_decimal: text billing_scheme: text created: bigint currency: text interval: text interval_count: bigint livemode: boolean metadata: jsonb meter: text nickname: text object: text product: text tiers: jsonb tiers_mode: text transform_usage: jsonb trial_period_days: bigint usage_type: text _updated_at: timestamptz _raw_data: jsonb prices (API docs: /api/prices/object) id: text _account_id: text active: boolean billing_scheme: text created: bigint currency: text currency_options: jsonb custom_unit_amount: jsonb livemode: boolean lookup_key: text metadata: jsonb nickname: text object: text product: text recurring: jsonb tax_behavior: text tiers: jsonb tiers_mode: text transform_quantity: jsonb type: text unit_amount: bigint unit_amount_decimal: text _updated_at: timestamptz _raw_data: jsonb products (API docs: /api/products/object) id: text _account_id: text active: boolean created: bigint default_price: text description: text images: jsonb livemode: boolean marketing_features: jsonb metadata: jsonb name: text object: text package_dimensions: jsonb shippable: boolean statement_descriptor: text tax_code: text type: text unit_label: text updated: bigint url: text _updated_at: timestamptz _raw_data: jsonb promotion_codes (API docs: /api/promotion_codes/object) id: text _account_id: text active: boolean code: text created: bigint customer: text customer_account: text expires_at: bigint livemode: boolean max_redemptions: bigint metadata: jsonb object: text promotion: jsonb restrictions: jsonb times_redeemed: bigint _updated_at: timestamptz _raw_data: jsonb quotes (API docs: /api/quotes/object) id: text _account_id: text amount_subtotal: bigint amount_total: bigint application: text application_fee_amount: bigint application_fee_percent: numeric automatic_tax: jsonb collection_method: text computed: jsonb created: bigint currency: text customer: text customer_account: text default_tax_rates: jsonb description: text discounts: jsonb expires_at: bigint footer: text from_quote: jsonb header: text invoice: text invoice_settings: jsonb line_items: jsonb livemode: boolean metadata: jsonb number: text object: text on_behalf_of: text status: text status_transitions: jsonb subscription: text subscription_data: jsonb subscription_schedule: text test_clock: text total_details: jsonb transfer_data: jsonb _updated_at: timestamptz _raw_data: jsonb subscription_schedules (API docs: /api/subscription_schedules/object) id: text _account_id: text application: text billing_mode: jsonb canceled_at: bigint completed_at: bigint created: bigint current_phase: jsonb customer: text customer_account: text default_settings: jsonb end_behavior: text livemode: boolean metadata: jsonb object: text phases: jsonb released_at: bigint released_subscription: text status: text subscription: text test_clock: text _updated_at: timestamptz _raw_data: jsonb subscriptions (API docs: /api/subscriptions/object) id: text _account_id: text application: text application_fee_percent: numeric automatic_tax: jsonb billing_cycle_anchor: bigint billing_cycle_anchor_config: jsonb billing_mode: jsonb billing_thresholds: jsonb cancel_at: bigint cancel_at_period_end: boolean canceled_at: bigint cancellation_details: jsonb collection_method: text created: bigint currency: text customer: text customer_account: text days_until_due: bigint default_payment_method: text default_source: text default_tax_rates: jsonb description: text discounts: jsonb ended_at: bigint invoice_settings: jsonb items: jsonb latest_invoice: text livemode: boolean metadata: jsonb next_pending_invoice_item_invoice: bigint object: text on_behalf_of: text pause_collection: jsonb payment_settings: jsonb pending_invoice_item_interval: jsonb pending_setup_intent: text pending_update: jsonb presentment_details: jsonb schedule: text start_date: bigint status: text test_clock: text transfer_data: jsonb trial_end: bigint trial_settings: jsonb trial_start: bigint _updated_at: timestamptz _raw_data: jsonb Customers: customers (API docs: /api/customers/object) id: text _account_id: text address: jsonb balance: bigint business_name: text cash_balance: jsonb created: bigint currency: text customer_account: text default_source: text delinquent: boolean description: text discount: jsonb email: text individual_name: text invoice_credit_balance: jsonb invoice_prefix: text invoice_settings: jsonb livemode: boolean metadata: jsonb name: text next_invoice_sequence: bigint object: text phone: text preferred_locales: jsonb shipping: jsonb sources: jsonb subscriptions: jsonb tax: jsonb tax_exempt: text tax_ids: jsonb test_clock: text _updated_at: timestamptz _raw_data: jsonb Connect: accounts (API docs: /api/v2/accounts/object) id: text _account_id: text business_profile: jsonb business_type: text capabilities: jsonb charges_enabled: boolean company: jsonb controller: jsonb country: text created: bigint default_currency: text details_submitted: boolean email: text external_accounts: jsonb future_requirements: jsonb groups: jsonb individual: jsonb metadata: jsonb object: text payouts_enabled: boolean requirements: jsonb settings: jsonb tos_acceptance: jsonb type: text _updated_at: timestamptz _raw_data: jsonb application_fees (API docs: /api/application_fees/object) id: text _account_id: text account: text amount: bigint amount_refunded: bigint application: text balance_transaction: text charge: text created: bigint currency: text fee_source: jsonb livemode: boolean object: text originating_transaction: text refunded: boolean refunds: jsonb _updated_at: timestamptz _raw_data: jsonb topups (API docs: /api/topups/object) id: text _account_id: text amount: bigint balance_transaction: text created: bigint currency: text description: text expected_availability_date: bigint failure_code: text failure_message: text livemode: boolean metadata: jsonb object: text source: jsonb statement_descriptor: text status: text transfer_group: text _updated_at: timestamptz _raw_data: jsonb transfers (API docs: /api/transfers/object) id: text _account_id: text amount: bigint amount_reversed: bigint balance_transaction: text created: bigint currency: text description: text destination: text destination_payment: text livemode: boolean metadata: jsonb object: text reversals: jsonb reversed: boolean source_transaction: text source_type: text transfer_group: text _updated_at: timestamptz _raw_data: jsonb Balance & Payouts: balance_transactions (API docs: /api/balance_transactions/object) id: text _account_id: text amount: bigint available_on: bigint balance_type: text created: bigint currency: text description: text exchange_rate: numeric fee: bigint fee_details: jsonb net: bigint object: text reporting_category: text source: text status: text type: text _updated_at: timestamptz _raw_data: jsonb payouts (API docs: /api/payouts/object) id: text _account_id: text amount: bigint application_fee: text application_fee_amount: bigint arrival_date: bigint automatic: boolean balance_transaction: text created: bigint currency: text description: text destination: text failure_balance_transaction: text failure_code: text failure_message: text livemode: boolean metadata: jsonb method: text object: text original_payout: text payout_method: text reconciliation_status: text reversed_by: text source_type: text statement_descriptor: text status: text trace_id: jsonb type: text _updated_at: timestamptz _raw_data: jsonb Issuing: issuing_authorizations (API docs: /api/issuing/authorizations/object) id: text _account_id: text amount: bigint amount_details: jsonb approved: boolean authorization_method: text balance_transactions: jsonb card: jsonb cardholder: text created: bigint currency: text fleet: jsonb fraud_challenges: jsonb fuel: jsonb livemode: boolean merchant_amount: bigint merchant_currency: text merchant_data: jsonb metadata: jsonb network_data: jsonb object: text pending_request: jsonb request_history: jsonb status: text token: text transactions: jsonb treasury: jsonb verification_data: jsonb verified_by_fraud_challenge: boolean wallet: text _updated_at: timestamptz _raw_data: jsonb issuing_cardholders (API docs: /api/issuing/cardholders/object) id: text _account_id: text billing: jsonb company: jsonb created: bigint email: text individual: jsonb livemode: boolean metadata: jsonb name: text object: text phone_number: text preferred_locales: jsonb requirements: jsonb spending_controls: jsonb status: text type: text _updated_at: timestamptz _raw_data: jsonb issuing_cards (API docs: /api/issuing/cards/object) id: text _account_id: text brand: text cancellation_reason: text cardholder: jsonb created: bigint currency: text cvc: text exp_month: bigint exp_year: bigint financial_account: text last4: text latest_fraud_warning: jsonb lifecycle_controls: jsonb livemode: boolean metadata: jsonb number: text object: text personalization_design: text replaced_by: text replacement_for: text replacement_reason: text second_line: text shipping: jsonb spending_controls: jsonb status: text type: text wallets: jsonb _updated_at: timestamptz _raw_data: jsonb issuing_disputes (API docs: /api/issuing/disputes/object) id: text _account_id: text amount: bigint balance_transactions: jsonb created: bigint currency: text evidence: jsonb livemode: boolean loss_reason: text metadata: jsonb object: text status: text transaction: text treasury: jsonb _updated_at: timestamptz _raw_data: jsonb issuing_personalization_designs (API docs: /api/issuing/personalization_designs/object) id: text _account_id: text card_logo: text carrier_text: jsonb created: bigint livemode: boolean lookup_key: text metadata: jsonb name: text object: text physical_bundle: text preferences: jsonb rejection_reasons: jsonb status: text _updated_at: timestamptz _raw_data: jsonb issuing_transactions (API docs: /api/issuing/transactions/object) id: text _account_id: text amount: bigint amount_details: jsonb authorization: text balance_transaction: text card: text cardholder: text created: bigint currency: text dispute: text livemode: boolean merchant_amount: bigint merchant_currency: text merchant_data: jsonb metadata: jsonb network_data: jsonb object: text purchase_details: jsonb token: text treasury: jsonb type: text wallet: text _updated_at: timestamptz _raw_data: jsonb Radar: disputes (API docs: /api/disputes/object) id: text _account_id: text amount: bigint balance_transactions: jsonb charge: text created: bigint currency: text enhanced_eligibility_types: jsonb evidence: jsonb evidence_details: jsonb is_charge_refundable: boolean livemode: boolean metadata: jsonb network_reason_code: text object: text payment_intent: text payment_method_details: jsonb reason: text status: text _updated_at: timestamptz _raw_data: jsonb early_fraud_warnings (API docs: /api/radar/early_fraud_warnings/object) id: text _account_id: text actionable: boolean charge: text created: bigint fraud_type: text livemode: boolean object: text payment_intent: text _updated_at: timestamptz _raw_data: jsonb reviews (API docs: /api/radar/reviews/object) id: text _account_id: text billing_zip: text charge: text closed_reason: text created: bigint ip_address: text ip_address_location: jsonb livemode: boolean object: text open: boolean opened_reason: text payment_intent: text reason: text session: jsonb _updated_at: timestamptz _raw_data: jsonb Terminal: terminal_readers (API docs: /api/terminal/readers/object) id: text _account_id: text action: jsonb device_sw_version: text device_type: text ip_address: text label: text last_seen_at: bigint livemode: boolean location: text metadata: jsonb object: text serial_number: text status: text _updated_at: timestamptz _raw_data: jsonb Tax: tax_ids (API docs: /api/tax_ids/object) id: text _account_id: text country: text created: bigint customer: text customer_account: text livemode: boolean object: text owner: jsonb type: text value: text verification: jsonb _updated_at: timestamptz _raw_data: jsonb tax_rates (API docs: /api/tax_rates/object) id: text _account_id: text active: boolean country: text created: bigint description: text display_name: text effective_percentage: numeric flat_amount: jsonb inclusive: boolean jurisdiction: text jurisdiction_level: text livemode: boolean metadata: jsonb object: text percentage: numeric rate_type: text state: text tax_type: text _updated_at: timestamptz _raw_data: jsonb Identity: identity_verification_sessions (API docs: /api/identity/verification_sessions/object) id: text _account_id: text client_reference_id: text client_secret: text created: bigint last_error: jsonb last_verification_report: text livemode: boolean metadata: jsonb object: text options: jsonb provided_details: jsonb redaction: jsonb related_customer: text related_customer_account: text related_person: jsonb status: text type: text url: text verification_flow: text verified_outputs: jsonb _updated_at: timestamptz _raw_data: jsonb Financial Connections: financial_connections_accounts (API docs: /api/financial_connections/accounts/object) id: text _account_id: text account_holder: jsonb account_numbers: jsonb balance: jsonb balance_refresh: jsonb category: text created: bigint display_name: text institution_name: text last4: text livemode: boolean object: text ownership: text ownership_refresh: jsonb permissions: jsonb status: text subcategory: text subscriptions: jsonb supported_payment_method_types: jsonb transaction_refresh: jsonb _updated_at: timestamptz _raw_data: jsonb Treasury: treasury_financial_accounts (API docs: /api/treasury/financial_accounts/object) id: text _account_id: text active_features: jsonb balance: jsonb country: text created: bigint features: jsonb financial_addresses: jsonb is_default: boolean livemode: boolean metadata: jsonb nickname: text object: text pending_features: jsonb platform_restrictions: jsonb restricted_features: jsonb status: text status_details: jsonb supported_currencies: jsonb _updated_at: timestamptz _raw_data: jsonb Climate: climate_orders (API docs: /api/climate/order/object) id: text _account_id: text amount_fees: bigint amount_subtotal: bigint amount_total: bigint beneficiary: jsonb canceled_at: bigint cancellation_reason: text certificate: text confirmed_at: bigint created: bigint currency: text delayed_at: bigint delivered_at: bigint delivery_details: jsonb expected_delivery_year: bigint livemode: boolean metadata: jsonb metric_tons: text object: text product: text product_substituted_at: bigint status: text _updated_at: timestamptz _raw_data: jsonb climate_products (API docs: /api/climate/product/object) id: text _account_id: text created: bigint current_prices_per_metric_ton: jsonb delivery_year: bigint livemode: boolean metric_tons_available: text name: text object: text suppliers: jsonb _updated_at: timestamptz _raw_data: jsonb Reporting: reporting_report_runs (API docs: /api/reporting/report_run/object) id: text _account_id: text created: bigint error: text livemode: boolean object: text parameters: jsonb report_type: text result: jsonb status: text succeeded_at: bigint _updated_at: timestamptz _raw_data: jsonb reporting_report_types (API docs: /api/reporting/report_type/object) id: text _account_id: text data_available_end: bigint data_available_start: bigint default_columns: jsonb livemode: boolean name: text object: text updated: bigint version: bigint _updated_at: timestamptz _raw_data: jsonb scheduled_query_runs (API docs: /api/sigma/scheduled_queries/object) id: text _account_id: text created: bigint data_load_time: bigint error: jsonb file: jsonb livemode: boolean object: text result_available_until: bigint sql: text status: text title: text _updated_at: timestamptz _raw_data: jsonb Other: files (API docs: /api/files/object) id: text _account_id: text created: bigint expires_at: bigint filename: text links: jsonb object: text purpose: text size: bigint title: text type: text url: text _updated_at: timestamptz _raw_data: jsonb test_helpers_test_clocks (API docs: /api/test_clocks/object) id: text _account_id: text created: bigint deletes_after: bigint frozen_time: bigint livemode: boolean name: text object: text status: text status_details: jsonb _updated_at: timestamptz _raw_data: jsonb v2_core_accounts (API docs: /api/v2/core/accounts/object) id: text _account_id: text applied_configurations: jsonb closed: boolean configuration: jsonb contact_email: text contact_phone: text created: text dashboard: text defaults: jsonb display_name: text future_requirements: jsonb identity: jsonb livemode: boolean metadata: jsonb object: text requirements: jsonb _updated_at: timestamptz _raw_data: jsonb v2_core_event_destinations (API docs: /api/v2/core/event-destinations/object) id: text _account_id: text amazon_eventbridge: jsonb created: text description: text enabled_events: jsonb event_payload: text events_from: jsonb livemode: boolean metadata: jsonb name: text object: text snapshot_api_version: text status: text status_details: jsonb type: text updated: text webhook_endpoint: jsonb _updated_at: timestamptz _raw_data: jsonb ## Next steps [Configure Postgres for real-time sync](https://docs.stripe.com/data/data-pipeline/real-time-sync-to-postgres/configure.md) to prepare your database and connect it to Stripe.