ALTER TABLE public.duty_duties_activities ADD "date" timestamp NULL;
ALTER TABLE public.duty_duties_activities ADD user_id int NULL;
ALTER TABLE public.duty_duties_activities ADD completed bool NULL;
ALTER TABLE public.duty_duties_activities ADD duty_id int NULL;
ALTER TABLE public.duty_duties_activities ADD meta jsonb NULL;
ALTER TABLE public.duty_duties_activities ADD ord int NULL;
ALTER TABLE public.duty_duties_activities ALTER COLUMN code DROP NOT NULL;

ALTER TABLE public.duty_duties ADD "type" varchar(7) NULL;


CREATE TABLE public.code_list_duty_type (
	code varchar(7) NULL,
	description varchar(255) NULL,
	properties jsonb NULL
);
