# 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