Given the following two tables:
CREATE TABLE public.task
(
taskid int4 NOT NULL DEFAULT nextval('task_taskid_seq'::regclass),
description varchar,
CONSTRAINT pk_taskid PRIMARY KEY (taskid)
)
public.users
(
userid int4 NOT NULL,
username varchar,
CONSTRAINT pk_userid PRIMARY KEY (userid)
)
I want to record which user "performed the task" and which user "checked the
task", I've come up with a few ideas on this but I would like to know what
the correct way would be to implement this into my table design.
Thanks,
Curtis