-- Add career_id column to notifications table
ALTER TABLE notifications ADD COLUMN career_id INT NULL AFTER user_id;
ALTER TABLE notifications ADD CONSTRAINT fk_notifications_career FOREIGN KEY (career_id) REFERENCES careers(id) ON DELETE SET NULL;

-- Add index for better performance
CREATE INDEX idx_notifications_career ON notifications(career_id);