CREATE TABLE IF NOT EXISTS notification (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `user_id` INTEGER NOT NULL REFERENCES user(id) ON DELETE CASCADE,
    `title` TEXT NOT NULL,
    `body` TEXT NOT NULL,
    `seen` BOOLEAN NOT NULL DEFAULT 0,
    `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);