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
Please sign in to leave a comment.
Hi! These relations are virtual foreign keys. You can disable them with the toolbar button.