backend/migrations/20260101000008_detection_latency.sql

5 lines · sql

CREATE TABLE detection_latency (
    drop_id    BIGINT PRIMARY KEY REFERENCES drops(id) ON DELETE CASCADE,
    latency_ms INTEGER NOT NULL CHECK (latency_ms >= 0)
);
CREATE INDEX idx_latency ON detection_latency(latency_ms);

1	CREATE TABLE detection_latency (
2	drop_id BIGINT PRIMARY KEY REFERENCES drops(id) ON DELETE CASCADE,
3	latency_ms INTEGER NOT NULL CHECK (latency_ms >= 0)
4	);
5	CREATE INDEX idx_latency ON detection_latency(latency_ms);