DB_SCHEME.md 834 B

exec-mcp DB Scheme

Canonical and authoritative.

accounts

  • id
  • display_name
  • venue
  • venue_account_ref
  • description
  • enabled
  • metadata_json
  • created_at
  • updated_at

account_secrets

  • account_id
  • api_key
  • api_secret
  • created_at
  • updated_at

balance_snapshots

  • id
  • account_id
  • asset_code
  • balance
  • balance_value
  • value_currency
  • captured_at

order_records

Single schema only:

  • id
  • account_id
  • market
  • side
  • order_type
  • amount
  • price
  • expire_time
  • status
  • bitstamp_order_id
  • client_order_id
  • raw_json
  • created_at
  • updated_at

api_cache

  • cache_key
  • payload_json
  • fetched_at
  • expires_at

bitstamp_metadata

  • kind
  • item_key
  • payload_json

bitstamp_live_prices

  • market
  • price
  • payload_json
  • captured_at

bitstamp_fx_rates

  • pair
  • buy
  • sell
  • payload_json
  • captured_at