Event Types

Event
├── id                    UUID, PK
├── lead_organization_id  UUID, FK → LeadOrganization
├── source_type           ENUM (external, internal, direct)
├── source                VARCHAR(100) — source identifier
├── event_type            VARCHAR(100) — normalized event type
├── object_id             VARCHAR(255), nullable — internal system ID of the referenced object
├── object_id_ref         VARCHAR(255), nullable — external/provider ID of the referenced object
├── payload               JSONB — normalized and enriched data
├── raw_payload           JSONB, nullable — original untouched payload
├── external_event_id     VARCHAR(255), nullable — original ID for idempotency
├── occurred_at           TIMESTAMPTZ — when the fact happened
└── received_at           TIMESTAMPTZ — when the Lead Domain received it