rss-reader/migrations/20240320000005_create_feed_entries.sql

CREATE TABLE feed_entries (
    id TEXT PRIMARY KEY,
    feed_id TEXT NOT NULL,
    entry_id TEXT NOT NULL,
    title TEXT NOT NULL,
    published TIMESTAMP,
    updated TIMESTAMP,
    summary TEXT NOT NULL,
    content TEXT,
    link TEXT,
    created_at TIMESTAMP NOT NULL,
    FOREIGN KEY (feed_id) REFERENCES feeds(feed_id) ON DELETE CASCADE,
    UNIQUE(feed_id, id)
);