Event-Sourced Aggregate Schema

Design an event-sourced PostgreSQL schema for the [AggregateName] aggregate.

REQUIREMENTS:
  - events table with optimistic concurrency on (stream_id, version).