@rakeshkky , as requested:

Table Schema:

CREATE TABLE team
(
   id                serial         NOT NULL,
   name              varchar(20)    NOT NULL,
   brand_id          int            NOT NULL,
   team_type_id      int            NOT NULL,
   parent_team_id    int,
   owner_employee_id int,
   created_at        timestamptz    DEFAULT NOW(),
   updated_at        timestamptz
);

ALTER TABLE team
   ADD CONSTRAINT team_pkey
   PRIMARY KEY (id);

ALTER TABLE team
   ADD CONSTRAINT team_name_unique
   UNIQUE (name);

ALTER TABLE team
  ADD CONSTRAINT team_brand_id_foreign FOREIGN KEY (brand_id)
  REFERENCES brand (id)
  ON UPDATE NO ACTION
  ON DELETE CASCADE;

ALTER TABLE team
  ADD CONSTRAINT team_team_type_id_foreign FOREIGN KEY (team_type_id)
  REFERENCES team_type (id)
  ON UPDATE NO ACTION
  ON DELETE CASCADE;

ALTER TABLE team
  ADD CONSTRAINT team_parent_team_id_foreign FOREIGN KEY (parent_team_id)
  REFERENCES team (id)
  ON UPDATE NO ACTION
  ON DELETE CASCADE;

ALTER TABLE team
  ADD CONSTRAINT team_owner_employee_id_foreign FOREIGN KEY (owner_employee_id)
  REFERENCES employee (id)
  ON UPDATE NO ACTION
  ON DELETE CASCADE;

Screenshot of Hasura relationships:

Steps to reproduce:

Error:

Issue updating relationship name #1777

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions