Diagrams show connection where there are non in the tables - postgresql

Answered

I have 3 tables with sql create like this 

CREATE TABLE cameras
(
    id                varchar(200) NOT NULL,
    name              varchar(99),
    activate          boolean,
    ip_address        varchar(20),
    port              integer,
    username          varchar(100)

);

CREATE TABLE camera_group_cameras
(
    id              integer
        PRIMARY KEY,
    camera_id       varchar,
    group_camera_id varchar
);

CREATE TABLE group_cameras
(
    id            varchar NOT NULL,
    name          varchar,
    parent_id     varchar,
    created_date  information_schema.time_stamp,
    modified_date information_schema.time_stamp,
    description   varchar
);

But for some reason when i request show diagram, i see relations between tables like in this image and i cant remove the relationships

0
1 comment
Avatar
Dmitrii Suvorov

Hi! These relations are virtual foreign keys. You can disable them with the toolbar button.

0

Please sign in to leave a comment.