dhis2-users team mailing list archive

[Mithilesh Kumar Thakur <mithilesh.hisp@xxxxxxxxx>]

Hi,Team

while i am checking database structure of version 2.29 i am see the
following  discrepancy

in programstageusergroupaccesses table there is two columns  programid  and
usergroupaccessid and  column programid is reference to table  programstage
(programstageid)

please see below the structure of table programstageusergroupaccesses

CREATE TABLE public.programstageusergroupaccesses
(
  programid integer NOT NULL,
  usergroupaccessid integer NOT NULL,
  CONSTRAINT programstageusergroupaccesses_pkey PRIMARY KEY (programid,
usergroupaccessid),
  CONSTRAINT fkbm0pqhdj9xudinnssoxjdgq6b FOREIGN KEY (programid)
      REFERENCES public.programstage (programstageid) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fkhrmc5b26i4fv714agdvwm2tly FOREIGN KEY (usergroupaccessid)
      REFERENCES public.usergroupaccess (usergroupaccessid) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT uk_tcggvcb1rsd9tlnd1ub7mt0e0 UNIQUE (usergroupaccessid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.programstageusergroupaccesses
  OWNER TO dhis;
-- 

Thanks and Regards

Mithilesh Kumar Thakur