backend/migrations/20260101000009_cross_source_links.sql

10 lines · sql

CREATE TABLE cross_source_links (
    cluster_id    BIGSERIAL PRIMARY KEY,
    event_id      BIGINT NOT NULL REFERENCES events(id) ON DELETE CASCADE,
    confidence    REAL NOT NULL CHECK (confidence BETWEEN 0 AND 1),
    match_basis   TEXT NOT NULL,
    created_at    TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    UNIQUE (cluster_id, event_id)
);
CREATE INDEX idx_xsrc_event     ON cross_source_links(event_id);
CREATE INDEX idx_xsrc_cluster   ON cross_source_links(cluster_id);

1	CREATE TABLE cross_source_links (
2	cluster_id BIGSERIAL PRIMARY KEY,
3	event_id BIGINT NOT NULL REFERENCES events(id) ON DELETE CASCADE,
4	confidence REAL NOT NULL CHECK (confidence BETWEEN 0 AND 1),
5	match_basis TEXT NOT NULL,
6	created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
7	UNIQUE (cluster_id, event_id)
8	);
9	CREATE INDEX idx_xsrc_event ON cross_source_links(event_id);
10	CREATE INDEX idx_xsrc_cluster ON cross_source_links(cluster_id);