CODEWITHSUNDEEP
mysqlintellij-ideadiagram
farahm
farahm

Reputation: 1326

IntelliJ does not show table relations

create table OP_ORDER (
  ORDER_ID BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  CREATION_DATE DATETIME DEFAULT CURRENT_TIMESTAMP,
  APPROVAL_DATE DATETIME,
  ORDERED_CAR_ID BIGINT,
  DUE_DATE DATETIME not null,
  PROCESS_INSTANCE_ID VARCHAR(64),
  ORDER_STATUS varchar(128) NOT NULL,
  DECLINE_MESSAGE VARCHAR(2048),
  ORDER_TYPE varchar(128),
  APPROVER_ID BIGINT
);    

create table OP_ORDERED_CAR (
  ORDERED_CAR_ID BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  CAR_TYPE VARCHAR(128),
  OFFER_NUMBER VARCHAR(128),
  MAKE VARCHAR(128),
  MODELL VARCHAR(128)
);

alter table OP_ORDER
    add constraint OP_ORDER_OP_ORDERED_CAR_ID_fk
        foreign key (ORDERED_CAR_ID) references OP_ORDERED_CAR(ORDERED_CAR_ID)
            on delete cascade
;

So clearly the two tables have a relationship. But when in IntelliJ I create a diagram of these two tables, it does now show me that relation (like kind of an arrow going from one table to the other):

enter image description here

Upvotes: 1

Views: 234

Answers (1)

diogo
diogo

Reputation: 3977

There seems to be a bug (quite old) that has not yet been addressed.

It happened to me too, it was working and out of a sudden, it wasn't anymore.

Upvotes: 1

Related Questions