Skip to content

The open alternative to Salesforce, designed for AI.

502 B
Raw Blame
CREATE TABLE IF NOT EXISTS objectEvent
(
    `event`            LowCardinality(String) NOT NULL,
    `timestamp`        DateTime64(3) NOT NULL,
    `userId`           String DEFAULT '',
    `workspaceId`      String NOT NULL,
    `recordId`         String NOT NULL,
    `objectMetadataId` String NOT NULL,
    `properties`       JSON,
    `isCustom`         Boolean DEFAULT FALSE
)
    ENGINE = MergeTree
    ORDER BY (workspaceId, timestamp, event, userId)
    TTL timestamp + INTERVAL 3 YEAR DELETE;