ALTER TABLE public.duty_rosters ADD COLUMN duty_post_id uuid REFERENCES public.duty_posts(id) ON DELETE SET NULL;
CREATE INDEX IF NOT EXISTS idx_duty_rosters_duty_post_id ON public.duty_rosters(duty_post_id);