Hi, I am trying to create my models for a postgre database using gii and everything works great but when I open them there are no relations generated. I have the "Build Relations" checked and there are foreign keys created in my tables. For example:
CREATE TABLE web.material_code
(
material_id integer NOT NULL,
code_id integer NOT NULL,
CONSTRAINT "PK_material_code" PRIMARY KEY (material_id, code_id),
CONSTRAINT material_code_code_id_fkey FOREIGN KEY (code_id)
REFERENCES web.code (code_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT material_code_material_id_fkey FOREIGN KEY (material_id)
REFERENCES web.material (material_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
It’s my first time dealing with postgre, my other projects all run on mysql and there were no such problems.